Hi RobertWAC

To answer your questions:
- To the best of my knowledge, I see no problem to recalculate the provisional cost every time before recording

- You can run the provisional cost calculation upon WO change using the parameter value CLCWOCAUT (GPA / COS) = "In WO creation and modification".

OR

- You can batch the Calculated Expected Cost function using a WO filter (accessible as anoption on the Order no field) to select several Work order (all WO not closed for instance):

But using AVC to value stock, the Provisional cost will never match the actual (or very rarely). Indeed, I expect the AVC to change every day (at each receipt to be accurate), so if a WO lasts sereval days the same component can be consumed at different times (hence different AVC values). In addition, any variation in term of quantity of time tracked, will create a change on the overall cost.

RobertWAC said:

COGS is inaccurate for sales made while the work order is open.

 Well this is true, until the WO closure the amount of quantity / time tracked is not final so it's impossible to know the actual cost before. 

RobertWAC said:

1. If production occurs over several financial periods or years when the work order is closed the adjusting GL entry is made to the time that the work order was created (or maybe when the provisional cost  was initially calculated). He thinks this ids bad.

If a work order overlap on 2 periods of FY, the date of the stock entry (producton delcarion) will drive the period to impact regarding the stock value. So if you created stock on both periods (partial production entry) then the stock balance on both periods will be impacted (if not closed). I think the logic is great. What do you expect?

Hi -

Thanks for the response.  The game changer for me is the ability to change the WO filter.  Now the next step is to see if I can configure it as a recurring task.