Hi,
How to find relation between tables in business central. Example: Posted sales invoice line table: 113 and posted sales shipment lines-111
In Page-- Posted sales invoice line, i able to see related posted sales shipments lines, but using which field the 2 pages/tables related?
Regards
C Rao
That is as expected. The order no. will not cover 100% of the transactions. But it is to my experience the most reliable link there is.
And when the posting is done from sales invoice you will not have any sales orders to refer to.
Thanks, actually i am not finding entry for this filed for few entries, reason i found that those posted sales invoice documents created from sales invoice
There are no direct relations between those tables.
So the most reliable link is the order no. field
field(65; "Order No."; Code[20])
You will find that on the shipment lines and on the Sales invoice lines.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,104 Most Valuable Professional
nmaenpaa 101,156