ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> Inventory Difference Between GL and IN-F
http://www.istechforum.com/YaBB.pl?num=1156797783

Message started by alphadave on 08/28/06 at 12:43:03

Title: Inventory Difference Between GL and IN-F
Post by alphadave on 08/28/06 at 12:43:03

We are using Version 2005.1 3/25/06 update. We are behind a few updates.
We run IN-F for "all except 0 value parts" for our purchased parts several times a week and compare it to our raw inventory GL account to make sure things are working OK. Occasionally if the $s are not the same we will print out the GL transactions and IN-N-A for the same period of time and cross reference them until we find the transaction that doesn't have a match and correct the problem.
Several weeks ago we had a difference of about $12,000 that we can't figure out. When we compare all of the transactions in the GL (GL-C) to the transactions from IN-N-A we have a match for them all, but still are off the $12,000. ANY ideas on how we can find this difference?

Thanks

Dave

Title: Re: Inventory Difference Between GL and IN-F
Post by JNAPIER on 08/28/06 at 13:46:31

Print a Detailed Trial Balance on your inventory account for the period in question. See if their are any GL type entries. IN-F goes off of Average cost for the Items. You can print an Inventory Exceptions report IN-L-K and see if you have any average costs varying from Std or last.

John

Title: Re: Inventory Difference Between GL and IN-F
Post by lmk223a on 08/29/06 at 04:51:18

Just a thought, but you may want to inquire whether any purchased part numbers were changed during the period from a type "R" to a type "N" or to type "F". N (non-inventory) types do not appear on IN-F, and "F" types appear on IN-F list for finished goods, rather than purchased parts.

Title: Re: Inventory Difference Between GL and IN-F
Post by cathyh on 08/29/06 at 06:57:47

You definitely want to look for N types with class codes that assign an asset account instead of an expense account to Inventory asset/expense. We had lots of issues with this when we first set up our part numbers.

I generally print IN-F by asset account and compare the number with that particular asset account. We have different asset accounts for Purchased Parts, Accessories, and Finished Goods. If you print them together be sure to add all the asset accounts together to have an accurate total.