Salam emre.
For V4 is there solution for profit report without making inventory purchase?
Even we installed the “custom reports” from samba market?
These reports are only available in v5. V4 lacks the options to build this report.
You cannot generate a Profit/Loss Report without a Cost, which is determined by making an Inventory Purchase.
Thanks kendash. Sad to hear that
Why sad? Just upgrade to v5. You can backup your v4 database and try v5 for free unrestricted for 500 tickets see if you like it. V5 has soo much more capability its worth it. For the price you also get all previous paid modules included as well.
Because currently I’m using v4. I have to study about v5 before upgrading it. I’m worried if i make a mistake and lost all data.
Btw, thanks a lot for your advice. Will try to study v5 in this few days
If you backup you won’t lose anything and if you make mistake you can roll back
I see, the backup module from samba market
You don’t have to use the module you can use mssms to do it as well
Or just install backup in trial mode before upgrading…
Thanks Kendash & JTRTech.
Just now i already tried v5 sambapos.
My question are :
- If i just set the cost of product in Inventory, without making the purchase can sambapos calculate
the profit margin from the cost ? - In the report i attached here, can i add total amount of ‘PM’?
No it can’t. What cost were you referring to? The fixed cost on items is not cost that’s an extra amount.
I’m referring to this cost. Default cost in Inventory Items.
2)My intention for report with total of profit margin so we can actually know our gross profit daily,
do we have to calculate it manually? can we set profit coffee + profit tea = total
No you still have to make purchases that just fills it on for you when you do the purchase. You have to calculate profit. Not everyone’s profit is same so it’s up to you how you calculate it with reports.
Got it. Thanks a lot
So if the cost is fixed and you won’t purchase why you track inventory? You may not need inventory at all.
For example:
Create a Cost Tag for your products and Enter Fixed Costs there.
… and create a report like that.
[REPORT:2,1, 1, 1, 1]
>Name|Quantity|Sold|Cost|Rate
{REPORT ORDER DETAILS:O.MenuItemName,
O.Quantity.sum,
O.ExactTotal.sum,
([MT.Cost]*[O.Quantity]).sum,
[($3-$4)/$3];%##.00;-%##.00}
>>{REPORT ORDER DETAILS:='Total',O.Quantity.sum,O.ExactTotal.sum,([MT.Cost]*[O.Quantity]).sum,[($3-$4)/$3];%##.00;-%##.00}
MT.Cost
is the fixed cost amount you’ve configured as Product Tag.
Some product i will need to use inventory such as pepsi, coke(by bottle).
Example product that wont use inventory is Fried Rice(i already calculate the cost).
So at the end of the day i want to know how much exactly my profit.
why mine wont show the cost?
Because that was a custom product tag which you did not make yet
You need to create a Custom Product Tag in Manage > Settings > Program Settings > Product Tag Captions
and then in Products > Product Tag Editor
you can set the value for the Custom Tags Costs …