Open bobintetley opened 8 years ago
the stock tables have existed for years at this point, it's the sales recording that we're missing. A sales stockusage record should be created for each item sold and that stockusage should have a link to a salesreceiptdetail ID. I have no idea what I was thinking of with the salesshop table - this issue is about 5 years old.
ASM should have an electronic point of sale interface. New tables
stockitem (name, stockitemcategoryid, description, price, barcode (string)) stockitemcategory (name, description) salesreceipt (salesshopid, date, total) salesreceiptdetail (salesreceiptid, date, stockitem, price) salesshop (name, description)
Have a till type interface (needs investigation) to select/scan items and produce a total
android barcode scanning? can call a custom url so we could have a service call submit barcode data with the current receipt