How to get Sales Price for the item on Customer/Item Sales report

sag74m

Dear all,

I've trying to get the sales price for the items on the Customer /Item Sales (P113).
First i've made another report with the data from Report 113 and add the Record Sales Price in the globals.

But i'm not able to get the correct Sales Price for the Item. What am i doing wrong?

I've attached the code where i guess the error occurs

sag74m

Slawek_Guzek, thanks, i'll give a try.

Slawek_Guzek

You should read the prices from T113 Sales Invoice Line. This reflects the actual unit price at the time of posting

Table Sales Prices includes current item prices - which may be different to the unit price used on particular sales invoice.

THe best approach would be to use average Item price in a given period. To get it calculated you need to summarize all quantities of a given item sold to the customer in a given period of time, summarize total sales amount for all sold items (both pieces of information taken from Sales Invoice Line) and divide one number by another.

sag74m

Slawek_Guzek, thanks, i'll give a try.