Sage 100

Throwing this out there for some input. When balancing inventory to GL I always used the IM val report. I never trusted the IM TB. I have a client that is insistent that the GL, IM TB and Val report match. Right now after taking a physical and they did some cost adjustments through Dec. the GL is higher than the val report and the IM TB is higher than GL. I recommended balancing to Val report, and see no possible way to change the IM TB? Thoughts?

First, go to General Ledger and print the Daily Transaction Register. IF any transactions were found there, run the reports again before doing any adjusting balancing jounral entries. I always recommend balancing to the Inventory TRIAL BALANCE. (now, at any point in time, as long as the IM module is in the current period, the two should balance. However, any future dated transactions would be in the Valuation report, and NOT on the Trial Balance Report. The problem with the valuation report is that you can't balance a particular ""period in time""; just as of right now. (again; assuming there are no future dated transactions). Run the Inventory Detail Transaction Report for all ""dates"" from tomorrow 12/31/2015 through a date in the future 12/31/2020; to see if there are any future dated transactions.

Copy to test company and recalc inventory history to see results? That should update the trial balances.

I agree, reconcile to the VAL. Depending on the version and history of the Sage100 / MAS system.. the TB vs VAL vs Stock Status reports would not all agree. In principle they should. There is a utility in the File, Run *utl that would look for differences between the reports and use the VAL to force the TB to agree by creating IZ transactions (that is, transaction code IZ). So, I would agree in principal with your client's insistence. However, there could always be exceptions too many to list here (i.e., valuation method used, negative tiers, other corruption in the file that can be fixed using other utilities, etc.).

They just finished physical inventory so no future transactions (verified) and no one in system. So confident of quantities from val report (67 pages), but started looking through pages of val report and saw some negative costs, so client will continue to see if any more items are that way and proceed when all identified on course of action, that also would cause the 2 to be OOB. Thanks for all the input. Could not find my doc on hidden utilities to run those. They are on v5.2.3