Hey there

Ok, I know this has come up before but I'm now having this problem again. I could never figure out exactly why my inventory valuation reports were a bit off from the inventory Gl Account. I thought I had it licked when I only posted inventory adjustments in Adagio Inventory after all the day ends were done. Well it appears that is still not the case. Since we do continually have data integrity errors in PO's (Wrong po quanities displayed, and The Steif Group is working on this) I thought this maybe part of the problem. Well finally no, it's obvious now it has nothing to do with Purple PO's and I believe it's a glitch in Adagio Inventory or something is wrong at my end, maybe in the settings. Since I have never had any data integrity problems with Any Adagio programs, I honestly don't believe it's my system but you never know. Note however, we lost the use of ACCPAC inventory after the last Adagio updates since they were not compatible with the ACCPAC inventory version we had and we were not going to upgrade ACCPAC Inventory module.

I've seen this question asked before by others in this forum so I really believe that it needs to be looked into again at your end why the inventory item account balance doesn't match the Inventory Gl account. If you have an answer how to fix, I'd appreciate it.

Senerio was this:

I did an adjustment to make an inventory item and costs negitive. Yes our system allows negitives.

Adjustment was made for -900 ea = -679.30 total cost. I posted this adjustment after all the Day ends were done.

The inventory valuation then showed up as -900 ea = -675.00. (calculated the units at the recent unit cost of .75 instead of what I posted) The Transaction history was correct as posted showing -900 = -679.30 and also that is what was posted to the inventory GL account. The Adagio inventory item however displayed at -900 ea with a total cost of -675.00. Yes, I know what you're thinking, and yes inventory item balance was zero to start with, there was not a residual balance in this item. I checked before I posted the adjustment.

So it appears there is a still a problem with adjustments being posted in inventory incorrectly. I sure hope this can be corrected.

If you don't have an immediate answer that is fine, Just as long as it is looked into. Thanks for your help.

ps: While I'm here, I'd also like to know the exact order the Day Ends should be done. I've always done Day ends in OE, Then Inventory, then PO's, did my inventory adjustments in Adagio Inventory, then Day end in inventory again, Retrieve to GL.

Thanks