Sage 100

Please refresh my memory on the difference between the inventory valuation by period report and the inventory trial balance report. I always use the inventory valuation by period report to print the valuation and agree the balance to the GL. I did an upgrade last April. I always print key reports in both the ""old"" Sage 100 and the ""new"" Sage 100 to verify the conversion. I agreed the inventory valuation by period before and after the conversion. Now, six months later the client is saying the inventory trial balance report tied to the GL on 4/21 but doesn't tie on 4/24 the weekend I did the upgrade. Its off by $25K.

I use the IM TB for tying to GL. While the valuation by period may agree, I'm not sure that the users are consistent in posting to the correct accounting periods.

I always use the IM Trial Balance to reconcile to the GL; if that means anything. My experience with the ""by period"" report is not consistent; probably because of the date issue @MoiraGoggin mentions.

@MadelineStefanou The TB agrees at 4/21 and doesn't agree at 4/24. What is the most efficient method to reconcile the difference?

I found the reconciling issue and all is well. I used the Detail Transaction Report and found some items that weren't in the GL.

Thanks Moira and Madeline!