Sage 100

100 v4.5 Advanced. Client is puzzle why there are differences with the inventory valuation report and the inventory valuation report for the current period. See attached. Valuation by period is $4,258K, the inventory valuation is $3,930K and the Excel valuation of the IM_cost table is $3,926K. I can somewhat understand the difference between the valuation report and excel (ONLY 4K), but why the big difference between the valuation report by period and the valuation report. I am using the current standard, it is set for the current period and I ran the two report dearly simultaneously. Thoughts. Client has that ""look"" in his eyes.

Because the valuation by period has never worked. Sage claims it should in 2013 but I haven't tested.

What @RobertWood said. :-)

I thought that was just the trial balance that was hosed......

Nope...in fact I had to peek at the thread because I thought I was missing something.(I couldn't believe you thought the by period valuation MIGHT match!)

Jeff, as Robert said, that report has never worked or at least worked consistently. It's too bad because it would be extremely useful.

@DebThomas - How is vacation going?

Sadly...coming to an end. Sun every day save one....leaving Sat. for Paris...then next Wed., back home. Sigh....the food and wine have been superb, the beauty of the Sagrada Familia beyond words, and life in Provence....priceless.

Any openings for the X3 work force????

I have been chased a bit to get certified on X3....might be worth it if work happened in Europe ;)

This is a rather embarrassing issue for a mid-market ERP system whose niche is wholesale distribution. I ran into this a couple weeks ago. What a crock to have to tell a roomful of people that their $7,000/year ERP ""just doesn't produce a critical valuation report"".

Here's something fun to try, run the valuation report once with ""Print Zero Balances"" on and again with it off and see if those numbers change. I've had the pleasure of running into that issue with that report....

Oh, yeah, @NicoleRonchetti - I've had that, too. For my clients, it's always had to do with Lots that are missing the Type field in the IM_ItemCost file - don't know how they get that way.

Sorry, not looking for more work...... Been down that road before with the valuation report. Also important to run the adjustment report to flush out negative tiers that net to zero.

I've had that Print Zero Balances discrepancy too with serialized items. Never knew it could be a blank TierType in IM3 thanks @BethBowers