The End of Day Record isn’t making sense to me. Am I missing something here?
I bought a Carton (10 packs) of Belmont and a Carton (10 packs) of Marlboro.
I sold 1 pack Belmont, and 1 pack Marlboro.
I have 1-to-1 Recipes for these Items.
You purchased it from the warehouse Tobacco Marlboro and Tobacco Belmont and put it into Warehouse Shop… so consumption on the Tobacco Marlboro and Tobacco Belmont will show 1 since you consumed those from that warehouse into another one. It looks like your Department is set to use GENERIC:Warehouse as its default warehouse for transactions.
Inventory Prediction would be -1 since you had no starting inventory before you purchased them out of that warehouse.
Its not showing a purchase because you purchased it for warehouse Shop.
EDIT: It looks like your using Source Warehouse kind of like your supplier? But its not really a warehouse on your site?
I was going to do the same thing… until I realized source warehouse is not built to act like this. It is built as another warehouse on site… Like a storage warehouse and then your Target would be a production warehouse.
That’s correct. I set it up this way so that I could filter product by Supplier Entity, which is really filtering by the Warehouse that is assigned to the Entity. The Entity Name and the Warehouse are linked together: each Entity has a Warehouse mapped to it, with the same name.
Ok, I get what you’re saying, and sure enough, here are the purchases, in the SHOP Warehouse.
You’re correct again, my Department is set to use GENERIC Warehouse. Thanks for pointing me in the right direction. I’ll change it to use SHOP Warehouse, and it should make sense.
NP>> I ran into this SAME issue while designing mine haha. I am attempting to use mine the same way. We just have to ignore Consumption and imagine it says something else lol. It works it just looks funny on warehouse.
So this brings up something else that I want to do, and now I realize it won’t be difficult, since I already have Inventory purchases working in PHP. And the controls are already in place to do this:
I have items that I purchase, and by default, they land at SHOP Warehouse (from whichever Supplier Warehouse). So far so good. I already have all of this built.
Frequently, I can’t hold all the Inventory at my Shop, so I move a good deal of it to my house storage, which I call BODEGA. So now I just need to create Inventory Documents and Transactions to transfer from SHOP to BODEGA. This should be simple enough to do - it’s just a matter of changing Source and Target and executing the transaction!
I just realized a potential issue here. In my implementation using mySQL, I have 3 unit types, rather than only 2 as in SambaPOS. @emre, I don’t suppose we could get a third unit type for Inventory Items?
This actually applies to many products, like:
Ham: Case, Package (6), Slice (30)
Sauce: Case, Can (6) , mL (2000)
Croissant: Case, Flat/Tray (6), Piece (8)
So for Croissant, there are 8 pieces per Tray, and 6 Trays per Case; in total 48 pieces.