Ledger/Frozen Invt Not matching

[dmrVA]

For the past few months, our ledger raw materials and finished goods has been higher than the frozen inventory.
I have looked at everything I can think of (zero costs, missing invoices, etc.) I do not see anything strange.

If you have a checklist for this problem, I would appreciate you passing it along.

Thanks

Donna

 

[kscheeler]

What costing method are you using.

Kevin Scheeler

 

[dmrVA]

Standard

 

[dgillz]

Donna,

Just the past few months or has this been a long time thing?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[dmrVA]

Jan - current. I upgraded to 7.6.4 SPA after closing in Dec. Been happening ever since. Thought it might be a "bug", Macola support is looking into it.

 

[NEmacGuy]

Same amount each month, growing , or varies + / - ?

A few possible things to check, Inventory Location Audit Trail - changes in cost, qty. Unposted Credit memos, had one client that entered credit memo's and left them on file until the goods were returned, and did not realize that if you enter a qty in return to stock, it increases your onhand inventory while enetering the CR. Run your inventory distribution to GL report, change in inventory should be the change in one months frozen stock value to the next (assuming good cutoffs, in a perfect world).
Review the debits and credits are being accounted for correctly. If things were working for a long time, and since updating they have go out of control, then your idea about a bug is plausible.
I have had similiar cases, and it can be a real pain to correctly diagnose the issue. The smaller you can make the set of data you need to analyze the better. Can you interface inventory at the end of each day, and compare your GL balance to you stock status ? Then you only will have one day of transactions actions to look thru.

Best of Luck

 

[dgillz]

Some other things to check,all of which will cause an out of balance situation in either Progression or ES

*Cost to use when posting in OE setup should be A-Actual and not L-Line Item.

*An AP voucher is entered directly to an inventory account.

*a Stocked item is mapped to a non-inventory account; or a non-stocked item is mapped to an inventory account

*in POP Setup, the create wip flag is set to W. You can override this at time of POP order release so you should also never release an order with this flag set to W.

*An inventory qty adjustment, cost adjustment, issue or receipt is made to an inventory account.

*A manual journal entry is made to an inventory account.

*Any variance accounts in any setup files are mapped to an inventory account.
*



Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[dgillz]

NEmacGuy,

Unposted Credit memos, had one client that entered credit memo's and left them on file until the goods were returned, and did not realize that if you enter a qty in return to stock, it increases your onhand inventory while enetering the CR.

I was not aware of this. Does Exact consider this a bug? I do.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[NEmacGuy]

This is not considered a bug. This is standard code both for ES and progression. Note a credit memo also hits your IM accumulators upon entry. Our lesson, don't enter credit memo's and leave them unposted.