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

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

s8f0klv91nk7.jpg

Best Answer

  • sag74msag74m Member Posts: 2
    Answer ✓
    Slawek_Guzek, thanks, i'll give a try.

Answers

  • Slawek_GuzekSlawek_Guzek Member Posts: 1,690
    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.
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • sag74msag74m Member Posts: 2
    Answer ✓
    Slawek_Guzek, thanks, i'll give a try.
Sign In or Register to comment.