Custom on Demand Inventory Reports for Toast POS based on SKU of items

Job ID: 38332398

Budget: $250 – $750 USD

I'm in need of a skilled developer to set up a custom reporting system for my Toast POS system. I need an inventory reports generated in format based on the SKU of items, this report will be ran on demand.

This is going to be used for a lottery system integration, the POS will have normal buttons, but will have the SKU for the pull tab integration to distinguish sales vs paid.

More Details Please Review. ***You will have to tell us how to get access to the database as it is a toast owned database**
We have gambling pull tab tickets each cost $1 per ticket. This is a lottery style, so the tickets will pay out "x" amount of dollars per bag/sn/sku. They come in bags of 1000s+, each has its on sn/sku number. I am wanting the ability to see exactly how many sku/pull tabs have been sold/paid out. They will have 2 buttons on the POS menu for Jar 1 Sold (+1.00) & Jar 1 Paid (-1.00). The bags sometimes go out in a day sometimes 7 days, so we will need the ability to run the report based on the SKU/SN of the bag. Then show a report of how many sold vs paid out amount. Then provided a grand total at the end of the report saying
tickets sold qty = $xxx.xx
tickets paid qty = $xxx.xx
total profit = $xxx.xx
Related categories: PHP JavaScript SQL Software Architecture MySQL