web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Table link between Sal...
Small and medium business | Business Central, N...
Answered

Table link between Sales Shipment and Sales Invoice

(0) ShareShare
ReportReport
Posted on by Samantha73 3,315

Hi Guys

I thought this was easy - to create a link between posted sales shipment and posted sales Invoice but couldn't find a link that provide unique values.

For example:

  Sales Order      Sales Shipment  Sales Invoice

SO1 Line 1         SS1                      IN1

                           SS2                      IN2

Now I want to report:

SS1      IN1

SS2      IN2

You cannot use the Sales order line link since you have multiple shipments, and invoices per SO line.  What am I missing?

thanks

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 157 on at

    Can you not use the header? If the shipment and invoice were made from the order you will get the “Order No.” populated. If you’re using the combine shipments routine this won’t be valid or if you create a manual sales invoice and do “get shipment lines.

    Depending on your process, Date may play as a valid way of creating the link too. Do you Ship & Invoice at the same time? Also an aggregated total of “Quantity” and “Line Amount” would be valid links.

  • Samantha73 Profile Picture
    Samantha73 3,315 on at

    If you look at the structure I cannot user the header as SS1, SS2, IN1, IN2 all have the same order and line so when you link you are duplicating results in the row set. I'm curious how others solve this ..maybe there is a 3rd table...

    Sales process is Sales Order---WH shipment--Sales Shipment--Sales Invoice

  • Verified answer
    TWBlaisdell Profile Picture
    TWBlaisdell Microsoft Employee on at

    Hi,

    You could possibly use the Document Number in Table 5802 Value Entries.  The Shipment will be the first Value Entry associated with the ILE and the Invoicing will be the second Document No. and Value Entry linked to the Sales ILE.

    I'm not sure if this will work for you, but it is worth looking into.

    Thanks

    Tom  

  • Samantha73 Profile Picture
    Samantha73 3,315 on at

    Thanks Thomas that worked :) awesome

  • MichaelZ Profile Picture
    MichaelZ 2 on at

    I must be completely missing something because when I do the table id of 5802 it returns:  LedgerPeriodAllocationCategoryEntity  

  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,189 Moderator on at
    [quote user="MichaelZ"]

    I must be completely missing something because when I do the table id of 5802 it returns:  LedgerPeriodAllocationCategoryEntity  

    [/quote]

    5802 is the correct number. The name you are referring to is not a table that is part of the BC base application.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,216 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,471 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,369

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans