Inventory Reports

[Debbie Luter]

It would be great to get a report that gives you a "Quantity on Hand" at a specific point in time.  If you do a physical count on a specific date, let's say April 30th, you can print a report as to what you have on that date.  However, if you get an invoice on May 5th dated April 29th, it should update the report as at April 30th showing the additional items in the inventory.  However, you can't choose a date so if you run the report on May 5th, it will include everything that you entered dated in May.  As this is a control account, I feel you should be able to have a report for a specific point in time.  I find that Sage 100 has a lot of these kinds of issues with date specific information which is very problematic for our business.  Just a suggestion.