Can you look at your GL by part type and compare it to the IN-F report by GL account  to see which of the three types are off the most? YOu might find that manufactured product is off more than your raws.  To do this you need different GL accounts for R-type, A-type and F-type.  
Do you make an adjustment every month to make the numbers in GL match the inventory?  We did not for a long time, and could not track any real problems because we never knew where we stood.  Now we make an adjustment every month, and it is rarely over $100 total, and if it is, we know there is a problem!  
 
I know if you finish product at actual cost and have a lot of inventory, there is a possibly of being way off because the batches have been finished at different cost for one reason or another, but come out at the current average.  In other words they go into the GL inventory account at one cost and come out at another.

Lenette,
Do you recalculate inventory book value? (System Manager UT-K-G.) I do this several times during the month and my month-end adjustments are usually under $20.00.  
Ragine

Well, this is interesting. I missed my March adjustments, and started on April's yesterday. I had made adjustments of $28 & $82 to my two inventory class accounts in February. When I ran the numbers for yesterday, I came up with differences of $20,996 & $4,773. If I try going back in time to February 28, I now see differences of $15,405 & $4,365. Can I not run the numbers for a previous date, or did something happen? And in any case, I can't think of any reason why I'm so far off now - I can't think of anything we've changed system wise.

Everyone, are you sure when you run your reports that all transactions that could affect the GL balances for inventory accounts have been posted in the GL?  Those would be PO receipts, Ajsutments, and WO transactions.  THis has happened to me before since I am not the one to post PO receipts in the GL.

Well, gee, there must be something in the air.  I checked my balances this morning and they are off, both finished goods and wip.  But I know why.  ON Friday I was finishing a product in WO-I, and I recalculated actual costs, entered 1 in the quantity field and then noticed that the estimated cost was not accurate.  So I exited, before I pressed "enter" but after I put a "1" in quantity good completed.  ( If I had pressed enter I would have had to assign a serial number.) I went back to the work order, which showed 0 finished, and fixed the estimated costs.  Then I finished the work order.  My work order now says 1 was finished, my inventory quantity in the value report  is correct, but my GL account has two entries for finished product for that work order.  So GL is too high by $7000+ and WIP is too low by same amount.  I know we have exited at that same point in WO-I in the past.  This time it didn't work.  This could be a problem for you if your people finishing product stop in the middle of the process.
We have had lots of problems in the past with backing out of inventory transactions, so we do negatives instead, which are not 100% either, but less of a mess. SEE my post under inventory or problem reports- I can't remember which-  probably both! Actually just found one of the threads, under manufacturing-  
Can't close WO - Says Not all Items Issued
« on: Feb 21st, 2005, 7:50am »
 
Another thing I thought of that we have had trouble in the past with is type N parts that use inventory asset accounts instead of expense accounts.  Since they are non counted, they don't show up on the value report, but if you are using the same asset account as raws when you purchase them, your balances won't match.

No doubt.

Quote from aricon   on 05/02/05 at 14:05:48:

I guess I did. What's it say?
 
Even though we're not perfect, we expect you to be. That way if there's a problem you'll know it's our mistake, not yours.