• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Reverse Inventory Issue - Wt. Avg costing

malaia

Active Member
List,

We have wt. avg. cost for an item and we didn't expect the qty to go negative for that item. Unfortunatly there was one version of issue program that was allowing negatives and the on hand is negative now. This messed up the unit cost. There are about 4000 transaction for that item with wrong unit cost for last month.

Option that I was considering was:

1. Get a dump from F4111 with account # to spreadsheet
2. Create another transaction using Z file to reverse the original with the wrong cost (so this will zero out the transaction cost and qty)
3. Create another transaction using Z file to create the entry with right cost.

Is there any other easy way to fix this issue?

Malai Annamalai
Deloitte
OneWorld Xe U7
 
Top