2,437
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 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.
Thanks Thomas that worked :) awesome
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
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (