ran consolidate inv transactiona through 9/30/04 and the system process ran ok but did not consolidate? Any ideas?

That is correct, it skips any transactions with Lot or Serial numbers because that is the file used for the Lot and Serial History reports.

TFay,  
 
What transaction types did you request for it to do? After thinking about it, I remembered that I entered all types except S, because I wanted to retain look-up capability for shipments.

What version of DBA are you on?  THere was a problem that was fixed that made the date of the consolidation 1904 instead of 2004.  The only way to see them is to pick transactions with no date ie 00/00/00 to 00/00/00.  They show up before 2002.  Do a search for consolidate inventory transactions to read about it.  I still have transactions out there with a 1902 date; have never gotten around to fixing them!

My copy of the Help file has this paragraph :
 
A balance forward per month will be created for each transaction type that rolls up the net units and average cost into a single record.  This enables records to be purged without affecting the inventory transaction file's monthly total net units and costs, which are needed by the SM-J-C  Reconcile Inventory On-Hand program to balance the totals in the inventory transaction file with the on-hand quantity in the inventory master record and by the monthly Usage button in IN-A  Inventory Inquiry.