Sage 100

I have a client that is in process of upgrading Mas 3.71 to Sage 100. The process was going well after eliminating some initial bumps in the road. The issue we are now experiencing is still in 3.71. The client recently closed the inventory module in one of the companies. After closing, when they run the Inventory Trial Balance (1/31/2018) the beginning balance has jumped from $1,469,343.17 which was the balance at the close of Dec 2017 to $1,575,033.02 as a beg balance on the report. Has anyone seen that before and do you know how to fix on 3.71? Any input will be greatly appreciated.

@ThereseLogeais - Didn't you have a recent migration/upgrade from v3.71? Is there a utility to rebuild beginning balance based on transactions in v3.71. What is ending balance if you run the TB as of the end of December. Is the TB reliable in v3.71 or am I thinking of the trend report? I never found those reports to be reliable. What does the valuation report balance to? Does it agree with the TB today?

Jeff, I was wondering the same regarding a utility in 3.71 but I can't remember if there is or not. The inventory valuation report doesn't agree with the Trail Balance but after the close, it remains the same balance at the start of January 2018 as it was at the end of Dec 2017. No mysterious jump. I haven't had a recent 3.71 migration this is the same one but the client just wouldn't let go. We are very close to finalizing the migration but just ran into this recent issue.

Remember the IMWIM5 utility? If no one else has the programs, I may have them saved on an old computer. Let me know, and I'll look.

This KB reads like it is the solution

Barbara, That definitely helped. Thank you so much for your awesome memory!! After running the IMWIM5 utility the difference was reduced to only $20k!!. This is definitely a better position than what we were in. Thanks again Barbara!!