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

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 133 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,247 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 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,247 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
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,105 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

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans