The default cost report gives me the cost of each product. But does not allow me to calculate the profit margin. I would like to use the custom report so I could create this report. However, I have no idea as to how can I get the cost of the product from the SQL.
Any pointers or info would be much appreciated.
Depends on what kind of cost your talking about. There are many ways to calculate cost in a restaurant.
Samba calculates cost based on portions.
Thanks for your reply. I am looking for something like the attached image. I am aware that Samba calculates cost based on portions.
I am trying to figure our as to how I can create a custom report like shown in the image.