We track financial inventory by Site & Batch number; Inventory model is weighted avg. with include physical value.
In the above screenshot, the original production order was still in production (multiple batch numbers) and could not be ended before month's end inventory closing. But this particular batch number was shipped and subsequent returned for rework - the rework production order ended before month's end - we have a lot of rework in our industry.
We use BOM journals to convert an item to a different item number (ATD -> ATD-RW) for it to be included in the BOM of the rework production order.
During inventory recalculation, we set the maximum throughputs to 5 and the minimum throughput adjustment to be 10, and result returns many unwanted and large adjustments. From my observation, it seems that the larger the max. throughputs, the larger the adjustment values.
We are currently in our 7th month since going live with AX 2012 R3, and have not been able to figure out a solution to this; our inventory value reports are a big mess right now due to large number of unwanted adjustments
I'm guessing the rework process creates a circular BOM and that's what causing the wrong adjustment values. Does anyone have any insight on how to fix & avoid this issue?
Thanks very much ~
