Under Accounting Preferences (Global Setting), With Average Cost Completion Unit Cost set to ‘Average’ (Not ‘Open WIP’) the system will the system will:
• Value any unit built (WOCOM) at the same amount as current Location Average Cost.
• When WO is closed, system will create WIP Variance that equals the difference between the Value of Units Created in WOCOM vs. Actual TOTAL WIP for WO.
The two main issues with this configuration are:
• Items need to have a Location Average Cost established (not null) by WOCOM, otherwise the system looks at Last Purchase Price (last inventory adding transaction) but then will use $0.
• If the Location Average Cost is not established correctly, an Inventory Adjustment is needed to “adjust” the value (not the quantity).