I was able to correct this issue by taking
@Doug Higgs advice.
1. Export the Trial Balance by Period (we were trying to correct as of end of previous year) to Excel (create a custom version that is flat for exporting)
2. Filter Excel to isolate Items where QOH = 0 and Item Value <> 0, separate by warehouse and valuation method (I had both Std and Avg items)
3. Import Standard Cost items to Item Valuation Change Utility changing them to Average Cost, update
4. Import all items by warehouse to Transaction Entry Adjustment with a Qty of 1 and a cost of 0, update
5. Import all items by warehouse to Transaction Entry Adjustments with a Qty of -1 and the cost set to the Item Value from the Valuation Export, update
6. Import Standard Cost Items to Item Valuation Change changing them back to Standard Cost, update
I believe the root cause of this issue was the end user tried to "remove" inventory by changing the Standard Cost of these items to zero instead of zeroing the quantity.
Thanks everyone.
------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------
Original Message:
Sent: 02-05-2022 11:33
From: Doug Higgs
Subject: Is there a repair utility to fix IM_PeriodPostingHistory
See the attached VI jobs. The first import needs 1 column, the item code. The second import needs 2 columns, the item code and the orphaned cost amount. Both imports use a tab separated values file.
------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------