Is it possible to track the cost of standard items without having to track the inventory and add purchase orders etc.
Could it be done using price definitions or product tags?
I would just like to see a rough gross profit on all sales.
EDIT: This can be done using recipies without the need to track stock
Gross profit can be calculated by
>Gross Profit|{REPORT COST DETAILS:[([C.AvgPrice]*[C.Quantity]).Sum]-[([C.Cost]*[C.Quantity]).Sum]}
So did you answer your own question?
I don’t think you can derive the Cost without making an Inventory Purchase… it has no way of knowing the cost without buying the product.
Whether or not you set up Recipes to track Consumption is another matter. This would come into play if you want SambaPOS to derive the Cost/Profit automatically for you based on Average Cost and Average Sell Price.
Your Report should work, so long as you Purchase the Inventory at least once so that it has a set base cost.
EDIT: thinking about it a little more, I do not think this will work without basic Recipes. The Consumption/Cost tables in the DB will not be populated unless there is a link between the Inventory Item you Purchase and the Product you Sell. A Recipe creates this link so that the appropriate tables are populated with data.
The C.* criteria in your Report comes from the [PeriodicConsumptionItems] table. If it has no data (which is derived via Recipes), then you won’t get any results in your Report.
Another method is to simply do it 100% manually and use an expression with your manual numbers. This would be a lot of work and require you to do some creative things with how you want to store the values. I dont see the value in doing this vs just using the built in system.
I just went to Recipes, Create Recipes and selected everything.
In each individual recipe i then added cost under “Fixed Cost”
It seems to be doing what I need it to do.
I have added no inventory purchases so the inventory report shows all negative values.
Fixed cost is not cost. It’s an amount to add extra to product recipe. That might work for what your doing but if you ever do any purchases it will not be accurate. It also won’t show you a cost on items in the recipe but if your not concerned about that then it might work for you. I just wanted you to know what fixed cost in recipe really does.
Its not for a restaurant environment so there is only one item in each recipe.
I don’t need to track inventory so I don’t want to have to enter inventory purchases on every product to activate the product cost. The recipe fixed cost works without this.
Is there a better method to achieve what I’m trying to do anyone can see?
The only alternative and it’s the preferred method is to use inventory and purchases or the not preferred method manually store some numbers and call them into a report expression.