Sage 100

• Run the inventory rebalancing utility in *UTL
• Then recalculate item history.
• Compare results after that.

• Run the inventory rebalancing utility in *UTL
• Then recalculate item history.
• Compare results after that.

• Run the inventory rebalancing utility in *UTL
• Then recalculate item history.
• Compare results after that.

Valuation does not match the Trial Balance
Unfortunately, I have this problem more frequently than you would expect.  Always do in Backup Test company first.  My steps to resolve include:

And when doing it live, always have a fresh backup before beginning.  It does not always return the results you expect.

1. Copy from \\..\MAAS90\Utility  folder to the \\..\MAS90\IM  folder:

• IM_ClearCommitDataEntry_utl
• IM_CommitCheckClear_utl
• And the associated PDF Files. The PDF Files give the instructions.

2. Update all inventory transactions. Sales Order Invoices, PO Receipt of Goods, PO Return of Goods, Inventory Transactions, JobOps Parts Usage, everything.  Even print and update the Inventory Negative Tier Adjustment Register.
3. Print to PDF an Inventory Valuation Report. Be sure to turn on the check mark to Print Zero Quantity Cost Tiers.
4. Print to PDF the Inventory Valuation report by Period for the current calendar period. (not the current Inventory Period, the period that includes today's date).
5. Print to PDF the Inventory Trial Balance Report for the current calendar periods. (not the current Inventory Period, the period that includes today's date),
6. These three reports are the "before" numbers. And these steps work when the Valuation does not match the Trial Balance.  In most cases, the Valuation will not change or will change less than the trial balance will change.
7. Using SYZCON, run the Utility IM_CommitCheckClear_utl (follow direction in PDF)
8. Using SYZCON, run the Utility IM_ClearCommitDataEntry_utl
9. Using File/Run, *Info, run the Balance Inventory Quantity and Cost Utility.
10. As prompted, run the IM Utility to recalculate Inventory Item History
11. Print all three reports for AFTER to PDF again. Inventory Valuation (with same check mark on); Inventory Valuation by Period and Inventory Trial Balance.  They should all match now within a few pennies (4-decimal costs can cause some rounding between IM Valuation and IM Trial Balance, but should not be significant, if any discrepancy at all.
12. Look at the Inventory Detail Transaction Report for today, and focus only on the IZ Transactions created. Sage added quantity where needed or added zero quantity and "dollars" where needed to reconcile the inventory. 
13. I always tell my client to do a "inventory cycle count" of those items to correct anything that was added to inventory that is not really on hand.

Step 12 (as well as the files created in the process); will show you the problematic items.  the IZ Transactions are created as a method to balance Warehouse Counts to Inventory Costs.  Prior to these utilities, we had IMZBL1 Utility, which allowed you to choose Warehouse Counts were right or Cost Records are right.  Now Sage assumes Cost records are right and may actually "add to inventory" counts with the IZ Transaction.  I always get "sign off from client" before doing in live company after they confirm in test company the results.  And if when I do it in live and I still have a problem; I restore from my backup. 

Let me know if you have follow up questions.