Sorry for sounding like an idiot but I’m new to BAQ’s. I’ve written a BAQ for WIP comparing my Actual costs to Estimated costs and I want to pull in the Order Sales Price. I’ve linked the JobHead, and JobAsmbl to JobProd (because it pulls in the order num linked to the job) and OrderDtl to get the extended price detail. Problem is we may have several line items in an order linked to a single job. Trying to create a calculated field to sum the order line item extended price by job number. When I just pull in the ExtPriceDtl into my already great report, it duplicates the JobAsmbl detail for each sales order line linked to that job number. I’ve tried creating a calculated field to sum the ExtPriceDtl but the syntax check pulled an error on Job Num? What am I missing?
You’ll probably need to use a Subquery in which you sum the order line prices by job, then bring that subquery to the top level and link by jobnum to JobHead, etc.
Can you export a copy of your BAQ and post it here?
I might be able to help if you can include a screenshot. Your version is higher than mine so i cannot open the BAQ
1 Like