I've worked with Microsoft support on this several times and here are my notes:
Situation:
Total quantity is zero, total cost is not zero. Costing Method is not Average.
Solution:
You will enter and post a positive adjustment and a negative adjustment to offset the residual balance. With the process, we override the cost of the entries to force the balance offset. Then fixed data to stop additional cost postings.
- Set Automatic Cost Adjustment to Never
- If a negative balance exists, post a positive adjustment with quantity of 1 for the cost of the residual in the location. Then post a negative adjustment with quantity of 1 with an override on the cost of $0.00. This will close the quantity out and force a zeroing out of the balance.
- If the inventory value balance is positive with no quantity, you will enter the positive adjustment for a quantity of 1 and $0.00 unit cost and post the negative adjustment with a quantity of 1 override the cost for the residual.
- After posting the entries, you set Cost is Adjust to true in table 5804
- Deselect the applied Entry to Adjust (set to False) for the positive item ledger entries in Table 32.
- Run table 339 and set the Outbound Entry is Updated to True.
Steps 4,5,6 prevent adjust cost from running against the entries and changing the override cost amounts.
- Once finished and all is set as desired, you may return setting for Automatic Cost Adjustment to its former setting
This process works, if you have any problems, I'm happy to help.
