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.

OK, all joking aside, this seems a real problem. I thought we were doing all right this year, and a $28k debit to my Absorbed Labor and Overhead account is something I'm going to do only while kicking and screaming.
 
My biggest question is what could have happened so that what was good on Feb 28 is now off by $20k?

I had installed the 022205 update in early April and had strange numbers for end of April. Tried to install the fixed IN-F from the website, but wouldn't work (license issues). I think you may need to be on the 032505 update to use it. Anyhow, I went back to the BKINF.run dated 100404 and IN-F matches my GL.  Also re-ran today with 033105 dates and these match reports I ran before the 022205 update was installed.
 
YMMV

I do re-set the period end close every month, but not so that it would prevent this type of thing.  I run the reports (IN-F value vs GL value) a day or two before the end of the month, and at the end of the month set the close date for one month before, because there are always things that trickle in for at least two weeks after the end of the month. Maybe I'm doing this wrong, but as I recall, the ability to select a previous date in IN-F is only a recent improvement, so it originally had to be done "as of now".
 
The point is that theoretically there shouldn't be any adjustments. I realize that because of the way DBA does stuff there will be some small ones. Ten or twenty dollars here and there, or even a hundred once in a while would not seem unreasonable to me. The fact that there may be a few transactions backdated should have an extremely small effect, I should think.
 
Or tell me I'm all wet, just tell me something.

I will take a very close look at the latest IN-F.  The only thing we changed (supposedly) was add filters for from/thru Primary Vendor and Customer so if you leave them blank, you should get everything but stranger things have happened.

Cross another one off the list...  Thanks David.  For anybody else following this thread, the file is at www.istechsupport.com/dl/inf.zip
 
If anybody continues to have problems using this latest IN-F, please let me know.

My BKINF.RUN.BAD file is dated 3/31/05/12:32 PM. The updated (good) one is 4/4/05/10:53 AM.

The only time I see real differences in my GL account balances and my inventory Value report by GL account is when( and I may be repeating myself):
 Purchases are posted to the wrong asset account either because the part purchased is a N type with the wrong class code or more recently the wrong GL account in the PO line item This past month we had problems with this at the end of the month. (before the last update 11/18 we were having errors with PO's putting the wrong account in the line item but it's been fixed) I find these by doing a detailed trial balance of the asset account in question for RP types and check the purchased parts to make sure they belong to the particular GL asset account I am looking at.
Issues , for one reason or another are done at $0 cost and the value report reflects that they are gone but the GL had no post since the total was $0.  I find these by printing all WO issues for a time period in JC-E and look for issues with $0 cost.
In Assembly ( what we call Accessories asset) and Finished Goods asset accounts, the work order has been finished and shipped but not invoiced ( or the invoice has not been posted).  Or the Finished Good cost posted to the asset account is way different from the average cost it comes out at.
We make adjustments ever month of under $30 dollars, and last month we were off by over $1000 in our Raw Materials Asset account.  It was all about Purchases not going where they should.  Thank goodness that is fixed.
Hope this helps.