Share
ReportHi All,
How can I find the Sales Order which my assembly order is linked to?
*This post is locked for comments
You’re offline. This is a read only version of the page.
Hi All,
How can I find the Sales Order which my assembly order is linked to?
*This post is locked for comments
Hi, Microsoft does not publish all tables in BC. If you need to add data, you need to use one of the following two functions, but please note that the performance of the API page will be higher than that of the Web Service.
Web Service:
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/web-services
API page:
Hope this helps.
Thanks.
ZHU
In Business Central online - I need to get this table on web services in order to get the data in powerbi.
I can see the Assemble to order Link table in 'table information' as table 904.
But in web services i cannot find this table. Please assist.
In Business Central online - I need to get this table on web services in order to get the data in powerbi.
I can see the Assemble to order Link table in 'table information' as table 904.
But in web services i cannot find this table. Please assist.
As Ansari mentioned you need to find the 904 (Asemmbly-to Order Link) for that particular Sales line using Document Type, Document No. and Line No. and once you find the Assembly to order Link for that particular Sales Line you need to use the Assembly document type and Assembly Document No. on the 904 to find the Assembly line table.
Check the function ShowAsmToOrderLines in the table 904 for the Logic.
The printed report "Assembly Order" (902) should show the related sales document. Also, backwards, from the lines of the sales order from lines action you can get the information about assembly orders.
Table 904 (Assemble-to-Order Link) will show you the link between an ongoing Sales Order and the Assembly Order when the Qty. to Assemble to Order has a value in it (i.e., the Assembly is linked to the Sales Order).
For posted transactions, you can find it in Table 914 (Posted Assemble-to-Order Link).
If you need to display the information from these tables in the NAV client, you will need to make your own List pages for it as there are no prebuilt pages for these Tables.
I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"
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
All responses (
Answers (