On the inventory list the user can highlight any number of items and click ‘Requisition’. The usual method is to sort by the column called “Suggested Order Qty” and requisition the required items. The suggested quantity is (BackOrder+Committed+ReOrderPoint) – OnOrder and then rounded up to the suppliers minimum order quantity for that item.
In this example a filter has been created called “Needs Ordering”. It has one filter selection – >> ‘Suggested Order Qty is not 0.00 and only the columns pertaining to the inventory quantities are selected. Therefore the displayed items on the list need to be ordered.
Thanks for your feedback.