Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Linking Posted Sales Shipment number to Posted Sales Invoices on Microsoft Dynamics NAV 2017

(0) ShareShare
ReportReport
Posted on by 30

Hi Everyone, 

     Is there a way I can link the Posted Sales Shipments number to a Posted Sales Invoices on NAV 2017 apart from using the Order No.

Thanks

*This post is locked for comments

  • Verified answer
    Agazziz Profile Picture
    201 on at
    RE: Linking Posted Sales Shipment number to Posted Sales Invoices on Microsoft Dynamics NAV 2017

    Is there a way to create a Web Services link to get the information to link Posted Sales Shipments to Posted Sales Invoices?  When viewing Table 110 (Sales Shipment Header) within business central, there's a column Posting Description that references the Invoice or Order number.  But I can't create a Web Services link on a Table - it has to be a Page or Query, and I can't find a Page or Query that contains this information.

    pastedimage1584027890118v1.png

  • Community Member Profile Picture
    on at
    RE: Linking Posted Sales Shipment number to Posted Sales Invoices on Microsoft Dynamics NAV 2017

    In which case, how does an Intrastat Journal get its values? 

    Most of the info on the intrastat journal can be found on the Sales Shipment or Item but where to the values come from if not the invoice?

    Thanks

  • Suggested answer
    nav.mukesh Profile Picture
    619 on at
    RE: Linking Posted Sales Shipment number to Posted Sales Invoices on Microsoft Dynamics NAV 2017

    Hi,

    There is no one to one relation between Sales Shipment and Sales Invoice as there could be multiple invoices for one shipment and one invoice for multiple shipments. 

    There is a action on Sales Shipment Line to show the related Sales Invoice Line -

    5140.Code.png

    This calls GetSalesInvLines in Table 111 Sales Shipment Line which can help you find related Sales Invoice Line.

    5140.Code.png

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