Yes, others have that issue. As to the report, you would need to create this in either Crystal or MS Access.

I have a crystal report we use to balance inventory against G/L.
I am home with a sick kid today, but I will find it tomorrow and share it.

I'm just getting started with DBA and I already see that this is a huge balancing act.  Could you share that report program with me as well.  I do not like to re-invent if I don't need to.  In advance, thanks for you help.
 
Rod

Everyone,
Please accept my sincere apologies for not responding to these requests.
I have been totally immersed in a firmware project for one of  
our products and have not had time to check into this as I had promised.
 
What I have is a small php script that allows the accountant to get a quick value
of each of our Inventory asset accounts so that we then adjust the GL to it.
 
We use this script instead of the value reports because we usually do not want the individual
item detail.  Instead, we just want current values for the inventory asset accounts.
 
Again, I apologize for not responding in a timely fashion.
 

We also have a huge problem with this each month.  Part of our problem seems to stem from working on work orders after finished production has been posted.  We have to post finished production to post sales.  Backing the figures in and out of work orders once the sale has been posted creates its own set of problems with inventory.  
 
For us, these adjustments have become the norm, which is disturbing.  Our previous system we could balance wip & inventory to the penny.   With DBA we have wild swings.  Sometimes the WIP & inventory swings cancel each other out, sometimes not.
 
The shear number of transactions prohibits figuring out where the breakdown exists each month.