Sales profitability analysis reports - Documentation of calculations
Hello,
I can find no documentation on the sales profitability reports calculations.
Is there any documentation on what costs are included in the calculations?
This is specifically being asked in a manufacturing environment.
This is the specific request “I really need to understand is the sources of inputs to equal the cost field when then determining the customer margin value in the system. ”
I could not find any specific documentation either on it.
Hi @ltussing03
Also, if you look at the actual GI for that, it may help you decipher some of the actual reporting:
Thanks Kandy!
I always appreciate your responses!
Unfortunately, the GI seems to just report ARTRAN.MARGIN and ARTRAN.MARGINPERCENT. I’m unsure how these are calculated so I don’t know what is included in the costs. Labor, materials, overhead, commissions, etc….
I really do appreciate your response. I think I’ll need to open a support ticket on this one to see if support has any documentation I can use.
Hi @ltussing03
I’m a little surprised there isn’t anything. I also checked the training materials and could not find it.
Please let us know if you get a response. You could also suggest that information is updated. :)
I will certainly reply back when I have more information and will share it here.
ACU support responded. I cannot put the entire response in one post due to size so I am splitting it up.
1. The Net Sale amount on the Sales Profitability Analysis is equal to the Amount value from the Sales Order line:
2. The Cost value on the Sales Profitability Analysis is equal to the cost from the IN Issue transaction created from the shipment document originated from the Sales Order:
Next, if you want to make sure that Ext. Cost is calculated correctly, check valuation method on the item.
For example, the item from my example has Average valuation method:
So, the item unit cost in all IN Issue transactions is calculated as an average value = Total Cost / Qty at the moment of releasing the issued transaction.
If you run the Inventory Valuation report, you can check the unit cost by simple calculation: