Welcome, Guest. Please Login.
05/30/25 at 23:22:46
News:
Home Help Search Login


Pages: 1
Send Topic Print
Inventory Difference Between GL and IN-F (Read 552 times)
alphadave
Browser
*


I love YaBB 1G -
SP1!

Posts: 15
Inventory Difference Between GL and IN-F
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
Back to top
 
 
  IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: Inventory Difference Between GL and IN-F
Reply #1 - 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
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: Inventory Difference Between GL and IN-F
Reply #2 - 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.
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: Inventory Difference Between GL and IN-F
Reply #3 - 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.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Pages: 1
Send Topic Print