We have a serious problem with our inventory. Here are a few (of many) examples:
 
Item one:
IN-A/F say on-hand today is 391, but it's actually 1151. This led me to discover that,
IN-E from the beginning of time shows net transaction of 1151 (exact match).
IN-F as-of 12/31/05 says -321.
PI-F as-of 12/31/05 shows frozen 391, counted 439, difference 48.
 
Item two:
IN-A/F say on-hand today is 1077, but it's actually about 40.
IN-E from the beginning of time shows net transaction of 106 - within the bounds of normal fluctuation
IN-F as-of 12/31/05 says 2083.
PI-F as-of 12/31/05 shows frozen 1004, counted 1112, difference 108.
 
Item three:
IN-A/F say on-hand today is 0, but it's actually 455.  
IN-E from the beginning of time shows net transaction of 455 - exact match.
IN-F as-of 12/31/05 says -455.
PI-F as-of 12/31/05 shows frozen 0, counted 0, difference 0.
 
Nothing makes sense. It would be one thing if everything was at least off the same way, but what is especially puzzling is that IN-F and PI-F don't agree.
 
I haven't done anything with DBA recently. The only thing I did is a System Restore on my workstation last Friday. Yesterday is the first time anyone has noticed a problem, but I have no idea when it actually started.
 
HELP!!!

No, I've never consolidated inventory.
 
In the mean time I've figured out that I can get today's figures right by SM-J-C Transaction Method B. But it doesn't tell me what happened, and there are pages of "$" adjustments on the report....

I'm not sure how to check for null date, but I opened INVTXN in Maintain Database, sorted by date, and the first and last dates are all valid.

When we started using multiple locations, I tried in my test Co. UT-K-E to move all our inventory to a new location. It had a problem with serialized items when you tried to release them on an order. I had the bright idea to use MDB to enter the new location name in the existing records. In theory it worked fine, but if I run reconcile inventory B it has 50 pages of bad location records and crazy UOH differences all showing $. I have never ran it other than in report mode only! Now my transaction reports always have screwy #'s?
 
John