We experienced a drastic inventory drop in value in one day of over $38,000. While it would be wonderful to have shipped that much, that is not the case.
 
I am going through inventory transactions trying to find the culprit.
 
1. Is there any other place I should be looking besides Adjustments, Finished work orders and values?
 
2. Is there a quicker report to run to look through for what must be an error.
 
3. Is there anything else that might cause such a change?

Have you compared your inventory value report(s) to last known good one(s) for big changes?

Quote from LJ   on 12/13/06 at 10:08:06:

 
What report(s) are you looking at? WIP is not included in IN-F.  Try JC-E, JC-M or JC-P

Quote from LJ   on 12/13/06 at 12:29:02:

 
Yes, IN-F excludes Work In Process (Labor, Material Issued and Loads)

JC-M will provide a summary of Work In Process activity (material, labor, load, extra costs, outside processes, and show the value of goods transferred to finished production, but the remaining WIP value is not a pure material inventory value.  It includes labor, loads, extra costs and outside processes.
 
JC-P will provide a summary of material issued to WIP by component by work order.  However, if a subassembly has been issued to a higher level work order, the material value of this subassembly will also include labor, load, etc. and is not a pure material number.
 
I use JC-P for evaluating material remaining in Work In Process, since it is the best report available and has proven to be reliable.  I just review it for negative value inventory and $0 value inventory, and make adjustments as required.
 
Hope this helps.

Okay now I'm confused!  I too thought that IN-F would include the total inventory value.  I also thought I should subtract the WIP total found in JC-M if I wanted the value of inventory other than WIP.
 
What report(s) do I use if I want to get a snap shot of the inventory values on a given date (including WIP)?  
 
I want the WIP value to include all of the materials, labor, overhead, etc that has been accrued to the outstanding WOs.   I also want a report of all the materials and finished goods in inventory that are not currently on WO's (WIP).

In-F has an as of date, as does JC-M and JC-R for materials in WIP.  
IN-F does not have materials issued to work in process(WIP) only materials (and labor) included in finished product (no longer in WIP).  
According to other posts on JC-R, that program has been fixed so that materials number is only materials and not labor  parts (I think- I don't use that program much).  
On the JC-M or JC-R, enter an as of date and leave everything else to DBA.  The program fills in the appropriate dates.
So you can run IN-F for all inventory (raws, assemblies, finished goods) as of a given date, and run JC-R for materials and/or labor in WIP (after you get the patch for JC-R).

What are the differences in numbers from JC-R vs JC-M??