web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Suggested answer
    nav.mukesh Profile Picture
    619 on at

    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

  • Community Member Profile Picture
    on at

    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

  • Verified answer
    Agazziz Profile Picture
    213 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans