How can I get a true work order shortage report that shows only purchased parts and not sub assy shortages, and also calculates the item # shortage amount.  The one with DBA is worthless.

Can you email approx. cost of an access application for this type of report. Thanks.

No this report list on hand, on so, allocated and on order
without regard to type of item, and then does not give a quantity short - ie what quantity am I short.  It also does not create one listing, but does each wo separately - so if I want one listing with all part numbers on it that are short, I have to export to excel and resort - everyday.  It's an ok report if you are looking at only one wo, but if you are trying to get an overall assessment of parts you are missing - it's an ugly and useless report.