I am trying to understand the expected behavior and effect of Recalculate Estimated Cost on Creation of Linked Transactions Preference set to Always
We use Average Costing Method and have Items' Cost Estimate Types set to various types (Average Cost, Last Purchase Price and Derived from Member Items). So as you may expect, Product Cost (estimates) on Sales Reporting does not tie to General Ledger Cost of Sales. We understand this; but would like to minimize the variance and understand what we are seeing in transactions.
I'll phrase my question using an example:
Sales Order is entered for 1 Qty Item "Widget" with Cost Estimate Type = Last Purchase Price
Last Purchase Price is 1.00 at time Sales Order is created
Sales Order is fulfilled by Item Fulfillment set to Shipped when Last Purchase Price is 1.25 does the creation of Item Fulfillment trigger update of Estimated Cost in the Sales Order from 1.00 to 1.25? I assume that Est. Cost field is irrelevant for Item Fulfillment?
Sales Order is Invoiced when Last Purchase Price is 1.50 does the creation of Invoice trigger update of Estimated Cost in Sales Order to 1.50? OR is ONLY the new linked Transaction Invoice Estimated Cost updated to Last Purchase Price value at the time Invoice is created, that is 1.50?
In summary, my basic question is does the preference being set to Always trigger Estimated Cost recalculation update on ONLY the new created linked transaction (Invoice in above example) or also the Sales Order? Does the recalculation looks at value to use per Cost Estimate Type in item record or the Cost Estimate Type in Sales Order transaction?
If so, then what happens if Item Record Cost Estimate Type is changed from Last Purchase Price to Average Cost after Sales Order was created; before Invoice was created. Would the Estimated Cost on Invoice be recalculated to Average Cost at point in time Invoice was created and no change to Sales Order Estimate Cost? OR Does the Cost Estimate Type set in Sales Order override Item Record for this Invoice?
Thank you!