Hello - We recently switched from standard cost to average weighted cost as our inventory valuation method. We are trying to figure out if there is a way to have one of the cost sets accurately reflect the average cost of purchased materials instead of using estimated material cost.
One example to help explain what we are looking for is is that we are starting to put tariff expenses directly tied to a part on the purchase order line as an “additional cost”. We don’t want to change the base estimated material cost, but want the average cost of that part to be reflected accurately in one of the cost sets so we can use that for quoting and analysis purposes. Currently, those additional tariff costs would not be reflected in any of the cost sets for that part. Additionally, beyond tariffs if we are sourcing something from a temporary supplier at a different cost than normal we would like a cost set to reflect the average purchase price.
We’ve tested/tried a variety of different things and can only seem to get the estimated material cost to pull into the cost sets.
Thanks in advance for any advice!
