How to Calculate Sales Analysis based on Item

[Former Member]

Hi All,

I have a problem in calculating the Total Sales,GrosProfit%, TotalOpen,Paid for generating the SalesAnalysisReport based on Items.

Please tell me how the above fields are calculated(Please post the formulae if u can).

Thanks & Regards

Guru.

[Former Member]

Hi.

From what I know, the Total Sales and Gross Profit are taken from the Marketing Document. You can click the Gross Profit button to check and confirm.

It will take the Base Price Origin as specified in the Document Setting as the default Cost to calculate Gross Profit. But you can always overwrite it in the Marketing Document.

In SBO 2004, you need to run the Item Revaluation to ensure correct Last Evaluation Price for Items with Moving Average costing method. In SBO 2005, you have the option of using the Item Cost. There is no need to run Item Revaluation.

Total Open should be the outstanding while the Total Paid is the amount paid and reconciled.

[Former Member]

Hi Yuen,

Thanks for reply Yuen.

I'm not able to understand how TotalSales field is calculated.Could u please give me clear information(Any formula if required) for calculating totalSales.

Thanks & Regards

Guru.

[Former Member]

Sorry for the late reply.

Total Sales = sum of [qty * (price - row discount) for every row] - document discount