Hello, I’m looking to determine how this report calculates margin by item and if there is a better report that could be run. I’m told it pulls the weighted average cost of the item but the margin seems off. When you break down the bom costs the margin is positive but in the report the calculation is negative.
Answer
Sales Profitability Analysis Report
Best answer by nhatnghetinh
Hi
This report calculates margin based on Average Cost/Unit Price. If it is only relative, this report is correct. There may also be other costs as you mentioned (bom costs) you need to create a new report to have the full bom costs as you want.
Best Regards,
NNT
+11Hi
This report calculates margin based on Average Cost/Unit Price. If it is only relative, this report is correct. There may also be other costs as you mentioned (bom costs) you need to create a new report to have the full bom costs as you want.
Best Regards,
NNT
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.