Sales Analysis reporting in 8.82

[Former Member]

Hello,

Can anyone provide the specific details regarding the revenue and gross profit calculations in the Sales Analysis Report?  What specific criteria is used to determine the revenue of each customer, as well as the GP?  I am trying to match a custom report to the figures given in the Sales Analysis and need to be 100% certain on the formulas that are used.

Thanks,

Jonathan

[kothandaraman_nagarajan]

Hi,

Please refer thread

Thanks & Regards,

Nagarajan

[Former Member]

Thank you for your feedback.  I have solved my issues now.  Thanks again!

[kothandaraman_nagarajan]

Hi,

Please close this thread by marking correct/helpful answer.

Thanks & Regards,

Nagarajan

[Former Member]

Hi Jonathan,

B1 system report for Sales Analysis is coming from AR invoice table if you have not selected delivery.

All calculations are formula pre-built based on the values from Gross Profit related fields. If you are not sure why you get such results, better query the table by yourself to understand.

Thanks,

Gordon

[Former Member]

Gordon,

Thank you for your feedback.  So you are saying that the Gross Profit formulas use the gross profit fields that are in the invoice (OINV) table?  If so, then I will play around with the calculations based on OINV. 

If I have selected delivery, then are these same calculations pulled from ODLN instead?

Thanks,

Jonathan

[Former Member]

You have right assumption. Delivery is based on ODLN.

[Former Member]

This helped immensely.  Thank you!