Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Link Invoice No. with ...
Microsoft Dynamics NAV (Archived)

Link Invoice No. with Customer item sales in report NAV 2009

(0) ShareShare
ReportReport
Posted on by Shaxted 84

Hi,

I need help.  I have modified the Item /Customer Sales report in Nav to include Invoice number but get the same INV no. on all items for each customer group.

When i run this in Classic (2009) I currently get what items i have sold to what customer with invoice qty and invoice amount.  When i try to add invoice number to the report (value entry; document no.) i get the same number on all items.

I found in this forum a similar question with the answer to use a lookup, GET/FIND command but i do not know how to implement this.

Any ideas would be great

Thanks

Mark 

*This post is locked for comments

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: Link Invoice No. with Customer item sales in report NAV 2009

    hi,

    if you talk about the report 113 Customer / Item Sales

    this report is made to group and totalize data, it uses temporary tables for putting down the calculations of nav flowfileds.

    If you enter the value of the field "Document No." in the section on value and checks the entry field the system will display the first invoice recorded. (one to many lookup .. only the first extracted)

    How-To:

    > Duplicate the report and add a new dataitem "Value Entry 2" under section dell'integer to display the parameter definition in Article documents, should be indented from the dataitem all'integer

    > Then go on dataitem just created and write:

    OnAfterGetRecord

    SETRANGE ("Item No.", "Value Entry". "Item No.");  > filter by cod. cuurentrcord current article from the value of the entry dataitem

    other filters can be set ...

    ex:

    SETRANGE("Posting Date", Value Entry "." Posting Date ") etc.. etc..

    Setfilter ("Posting Date" .. if you need more data filters ..)

    (in this case you are setting filters such as the standard links sections.. but you have integer dataitem whitout links availables)

    > Create a new section Value "Entry Body 2" and fill in the field "Document No." them in > you can extract all documents related to current item printed on first value entry section.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans