I have a BAQ that creates the Inventory Value of QOH, with the GL acct used for that inventory
I originally just used the Part.CostMethod to determine which fields of PartCost to sum up to get the unit cost.
But this fails when different sites use different part cost methods. It’s not that we use different methods per site (all sites use AVG), but that some get inadvertently set to a different cost method.
So I tweaked my BAQ to make it pull the cost related to the plant the Bin belongs to. This required adding tables 9 and 10 and the realtion ships circled in red (in the pict below).
But this slows the query significantly. Which I’m guessing is mostly do to that loop of relationships between tables 1, 9, & 10.
Is there a more efficient way to get the partcost associated with a specific warehouse bin?
Luckily we have only one cost file…