Sage MAS 90 and 200 Extended Enterprise Suite

[tbourgeois]

Our inventory valuation report never matches GL - we DO NOT post anything to our inventory GL accounts unless it's thru SO, PO Receipt of Goods - i haven't been able to fix this problem for years!  Anyone have any thoughts?

Tina

[Heather]

Have you confirmed all of your GL account assignments?  For example, maybe a misc item or the special item is hitting an inventory account.  Or maybe you have a product line that isn't hitting an inventory account. 

I would suggest that after you update everything, you note the discrepancy between GL & IM and then monitor both daily, keeping an eye out for major changes.  That should help you narrow it down.

Also, it's generally considered better to use the trial balance report instead of the inventory valuation report to reconcile with the gl, so you might try switching reports. 

[BigLouie]

Tina, it is clearly spelled out in all inventory documentation that the Inventory Valuation is NOT designed to tie to the GL. The Trial Balance is.  This is because the Valuation uses future dated transactions while the Trial Balance does not.  If this has been going on for years it is probably because someone was using the valuatation report and then making GL entries at period end closing time to attempt to balance. My advise is to have a qualified MAS reseller/consultant work with you on site to resolve this issue.

[lhidri]

The trial balance report doesn't match with G/L.  Will physical inventory correct it?

[Heather]

---

lhidri wrote:

The trial balance report doesn't match with G/L.  Will physical inventory correct it?

---

No, it won't.

How big is the discrepancy?  If it's significant, my first guess is that someone has made some inappropriate postings against an inventory gl account.  (Maybe something like a general journal entry or an AP invoice.)  You should research your gl postings to see if you can find anything that looks suspicious.  If you can't find the source of the problem, you might need to make an adjusting entry to the gl and then monitor the situation closely going forward.  (Confirm this with your accountant first, though.)

The issue of the IM trial balance not matching the gl has come up a lot, so you should also search the forums for other suggestions.

Welcome to the forums lhidri!