([INV ITEM Qty On Order] + [INV ITEM Qty On Hand])) THEN [INV ITEM Reorder Qty] - ([INV ITEM Qty On Order] + [INV ITEM Qty On Hand]) ELSE 0 END AS AOrder, [SYS COM Company Name] FROM [INV Items], [SYS Company]"!>
Purchase Advice
Item ID
Description
Qty On Order
Qty On Hand
Qty Available
Reorder Qty
Order
Vendor ID
Total Items: