120
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.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (