I am tracking a product which uses grams in the inventory. The product is coffee. An example, the total grams in a pound are 453 grams.
So I add a purchase document for 453 grams of coffee. Example, total cost is 1.71 meaning cost per unit is 0.003
However, if I enter the cost per unit as 0.003, it calculates the total cost and then sets unit cost back to 0 and vice versa.
When I go into warehouse it shows the cost as 0. It seems it won’t track the price properly because it’s 0.003
I need to track grams though since coffee uses grams and if I put purchase as pounds, then the product won’t discount grams properly in the recepie.
Yes SambaPOS does not support three digit decimals for inventory numbers. It is easy to support however I don’t know if it is a good idea to track cost for something costs 0.3 cent. Even coffee prices doubles in a year your cup cost won’t increase more than a few cents.
Like all POS software does this inventory tracking method migrated from factories but kitchen works different than factories. For this reason we implemented updating physical inventory by hand on end of day records and distribute cost difference to all portions that contains updated inventory item. That solves a lot of problems but of course we can improve it more for real life needs. I don’t think what we need to do is supporting 3 decimal digits. You need to know how much a cup of coffee costs and how many cups you can produce with items on hand. We need to find a way to track it without dealing with half grams or cents.
To solve your problem you can think changing coffee transaction unit to kilograms.