Important steps before proceeding

• Create a backup of your company data
• Before running the IM Balance Utility, adjust Negative Tiers and run the Remove Zero Quantity Tiers utility
• You need a signed Pre-Release Agreement (PRA) to get and install the Generic Average Cost Fix Utility
  • Include your contact name and email in the PRA. Contact Sage Customer Support to request it
• Once Sage's Legal team confirms they got and recorded the signed PRA, you're good to proceed

Run the IM Generic Average Cost Utility

1. Copy these files into the ..\MAS90\IM folder.
   • IM_GenAverageCost_utl.m4p
   • IM_GenAverageCost_utl.pvc
   • IM_GenAverageCost_utl.M4L
2. Open Library Master, Main, Company Maintenance.
3. Create a new Company Code (like TST), and copy the live company into it.
4. In the TEST company, run these utilities to clear stranded values.
   • IM_CommitCheckClear_utl
   • IM_ClearCommitDataEntry_utl
5. Open the Inventory module for the TEST company.
6. Enter the module date for the CLEAR CST transactions. Corrected entries will use this date.
7. Go to File, Run, type syzcon, and click OK.
8. At the prompt, type: run IM_GenAverageCost_utl.m4p.
9. Select the TEST Company Code.
10. In the IM Generic Average Cost Utility window, choose a range of items and/or warehouse codes to process.
11. Click Proceed.
12. When asked, "Do you want to open the Spreadsheet and Update the Items?", click Yes.
13. Review the spreadsheet that opens automatically. It shows.
    • ItemCode, WarehouseCode
    • Extended cost from IM_ItemCost and IM_ItemTransactionHistory
    • Cost Difference column
    • Quantity comparison and Qty Difference column
14. Close the spreadsheet to launch the next process.
15. If you want to save the spreadsheet, use Excel's File, Save As before closing it.
16. After saving, close the spreadsheet to continue.
17. Answer Yes to "Do you want to Update these records?"
18. Click OK when you see the message "Done."
19. When the utility finishes, go to Utilities, Recalculate Item History, and click Proceed.
20. After recalculation, run reports to verify the changes.
21. To view the changes, open the IM_GenAverageCostXXX.csv file in the \MAS90Home\Textout folder.

Review data changes and run reports

1. Check the IM_ItemTransactionHistory table for records where the system created IZ transactions.
2. Review changes in the IM_ItemWarehouse table.
   • TotalWarehouseValue
   • QuantityOnHand
   • AverageCost
3. Review changes in the CI_Item table.
   • TotalInventoryValue
   • TotalQuantityOnHand
   • AverageUnitCost
4. Run these reports to compare and verify the results.
   • Valuation Report
   • Trial Balance Report
   • Valuation By Period Report

Utility Logic Processing

Tiered items (FIFO, LIFO, Lot, and serial)

• The utility trusts IM ItemCost are correct
• It recalculates Qty, Value, Average Cost in CI Item, IM ItemWarehouse
• It creates adjustments in IM ItemTransactionHistory for LIFO, FIFO, LOT, SERIAL items
• It syncs all four tables with IM ItemCost
• It adds "RECALC CST" to EntryNo
• It adds "IM_BalanceInvQtyCost_utl" to TransactionEntryComment

Standard Cost and Average Cost items

• The utility trusts IM_ItemTransactionHistory values
• It updates CI_Item, IM_ItemWarehouse to match IM_ItemTransactionHistory when needed

Helpful Information

Inventory, Utilities, Recalculate, Item History

1. Run Inventory, Utilities, Recalculate Item History after the utility finishes.
2. This corrects the following:
   • PeriodPostingHistory
   •  ItemWarehouseHistoryByPeriod
   •  ItemCustomerHistoryByPeriod
   •  ItemVendorHistoryByPeriod
   •  ItemTransactionRecalc
3. The system uses ItemTransactionHistory to repopulate these history tables.

Trial Balance and Valuation by Period reports

• These reports use PeriodPostingHistory
• PeriodPostingHistory includes
  • Beginning Balance
  • PeriodChangeQty
  •  PeriodChangeDollarAmts
• These values match the Detail Transaction Report for the same period

Valuation Report

• This report uses ItemWarehouse TotalQuantityOnHand and UnitCost
• It multiplies them to calculate ExtendedCost

Run the IM_CommitCheckClear_utl and IM_ClearCommitDataEntry_utl utilities