New features added, version 7.5.2, 7.5.3, 8.1
Program OEII, Recent Orders by Item, is used to display sales orders for individual inventory items with the most recent orders listed first.
When the Exclude Zero Shipped Invoices flag is set to on, invoices for which nothing was shipped for the item will not be displayed. When the Exclude Invoiced flag is set to on, orders that have been invoiced will not be displayed. Otherwise, all invoices will be displayed. Incomplete, open, and partially shipped sales order will be displayed regardless of the setting of these flags.
Sales orders are created using the following programs:
* OQEM, Sales Order Quotation Entry/Maintenance
* OEXP, Fast Order Entry
* OEOE, Sales Order Entry/Maintenance
* ARIE, One-Step Invoice Entry
The information in this program includes the item number and description, maintain on hand flag, stock unit of measure, on hand quantity, sales allocations, manufacturing allocations, and quantity available. For each sales order line, the information includes the customer number, customer name, ship to code, sales order number and suffix, sales order line, sales order status, plant, hold code, sales quantity, sales unit of measure, shipped quantity, stock quantity and sales order line due date.
1. The program opens in query mode.
2. In the Item No field, enter the item number for which you wish to view recent sales orders.
3. Set the Exclude Zero Shipped Invoices flag to on to prevent invoices for which nothing was shipped from being displayed.
4. Set the Exclude Invoiced flag to on to prevent invoiced orders from being displayed.
5. Set the Sort By pop-list to the desired setting. The orders displayed in the lower block will be sorted by the field selected here. Choices are:
* Order No descending
* Due Date descending/Order No
* Customer / Order No descending
* Order Status / Order No descending
6. Press [Execute Query].
1. The program opens in query mode. Exit query mode.
2. In the Query NonStock field, enter the non stocked item number for which you wish to view recent sales orders.
3. Tab out of the Query NonStock field. The program will query the sales orders on which the non-stocked item was entered.