Hi guys,
I need a bit of help to figure out if I made a mistake in thinking how the inventory works..let me explain the current set-up…
We have different Warehouses (which are basically our store rooms and the final outlets) let’s just take 2 in this case… the Main Store Room and the Beach Bar.
We have created all inventory items and also all recipes for everything we sell from these inventory items with the correct measurements. So far so good…
Our processes are to purchase items from our suppliers and once they arrive, they are first stored in the Main Store Room, let’s say for example Beer we buy 5 cases and once they arrive, they are stored in the Main Store room. For this we make a purchase in Samba to the Main Store room of 5 cases (24 bottles) let’s say at 1,000 Baht per case, which we record.
Now it shows me 120 bottles of beer at 41.66 Baht cost in the Main Store room… which is correct, as the inventory items are set-up with different multipliers to the base unit of bottle.
So far so good…
If I do the same purchase transaction directly to my Beach Bar, the same happens it all works and shows the correct costs.
However, as I said we do not have enough storage at the beach bar, so we transfer daily only a certain amount of beer from the Main Store Room to the Beach Bar… For this we create a transaction Type STORE transfer, where we move items from 1 Warehouse to the other, in our case from Main Sore Room to the Beach Bar. However, as that is done without the invoice, no price is entered during this transfer…
Now my question, if we do this transfer, does Samba take the original purchase price from these items over to the new Warehouse (Beach Bar) or do we have to always enter the price even for the internal transfer?
It seems it does not take the price (cost) with it, as if we just transfer the items from the Main Store Room to the Beach Bar it shows the correct quantity and deducts as well sales properly from the inventory based on our recipes, but the costs show always 0.00
However, if I use the purchase with the price into the Beach Bar direct, then it shows the correct costs for these items.
If it does not take the costs (from the original purchase) with it during the internal transfer, can somebody give me a tip or advice to record the correct costs, as my stock boys do not know the prices of items when they move things from the store room to the bar etc.. and we cannot always start searching for the invoices for something we may have purchased 2 weeks ago and transfer only today…
Any help and advice would be appreciated.
Thank you,
Max