Assembly-to-order link table in Power BI

(1) Share

Report

Posted on by MA-06041858-0

Hello everyone,

I am trying to create a report on active assembly jobs for our workshop facility. However, I am unable to display the sales order & associated customer details for the assembly job in power bi (PBI).

I am aware that business central has a table with ID 904 (Table Name: Assemble-to-Order Link) that can help me establish a relationship between open sales orders and assembly order via document no. but I am unable to view this field in PBI. Page with ID 904 also do not have the document no. field in PBI,

What method can I use to display at least customer details or just the sales order number for an assembly order?

Please note: I would be unable to generate a customized query from my end as the platform is managed by third-party developers.

Looking forward to some guidance.

Thanks,

Madeeha

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Teagen Boll 1,487 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

These should also be creating reservations in your system. So the reservation entry table will be updated. I would try the following:

In your web services you can create a web service for reservation entries:

Should see two entries in the reservation table for the assemble-to-order line:

You could pull this data set into Power BI twice, one for the assembly orders and another for the sales order lines and then link them in power bi by reservation entry no. There are a few ways you could manipulate the data after that.

Best,

Teagen

Catapult ERP

Was this reply helpful? Yes No