I am wondering if there is any way to do a BOM cost roll using Average Cost. For example, we need to be able to provide pricing to customers before we publish the new pricing but need a way to find out the new BOM cost with a pending price. Since we have not purchased anything at the “new/pending” cost, it is difficult for us to accurately provide new pricing for finished goods from a BOM.
Is there any way that we can do this in Acumatica?
Thanks