Project to orders BAQ

Hi all,

I really need some help. I am building a BAQ to retrieve all orders for a project, similar to the project entry form:

However, it seems it’s not so easy to do (at least for me), as there is no direct reference from the order-related tables to the project. I tried to use JobProd → JobHead, QuoteDtl, and OrderRel → ProjPhase to retrieve the project ID, but in each case, something was missing…

Also, I don’t believe that Erp.BO.ProjectSvc.TrackerGetByID does some mad things to fill that ProjectOrderLine data table…

Maybe someone can advise how TrackerGetByID retrieves all orders?

Thanks.

OrderDtl.ProjectID exists, so I believe that’s what you’re looking for.

2 Likes

Thanks, it seems I didn’t notice it