([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: