Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

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

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
    Agazziz 195 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
    Community Member Microsoft Employee 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
    nav.mukesh 617 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans