I would like to build a PBI report which takes me from Sales order to works order to the ability to view the associated BOM breakdown & standard cost variances for that works order.
I did find a way to view the prod calc table associated with a given works order but I have discovered it doesn’t’t always have the most up to date view of the standard cost.
The BOMcalc table contains the most up to date view of the standard cost but I’m unsure
a) how I need to join it to other tables to get the works order
b) how I can see the detail of the BOM variances (actual vs standard cost)
ultimately enabling me to tie back to the GL postings.
any help will be appreciated
many thanks

Report
All responses (
Answers (