Reviewing Operations Control Summary (FLSH)

Purpose: Use the Operations Control Summary screens to review order and merchandising summary information for a selected date; you can review the flow of orders from entry through shipment to determine the health of your business. This menu option provides a high-level overview of the fulfillment process, identifies potential bottlenecks or problem areas, and delivers an audit trail of order activity.

Quotes: This menu option does not include information on quotes; see Entering Pre-Order Quotes.

In this chapter:

Defining Thresholds

Updating Operations and Merchandising Summary Totals

Display Operations Control Summary Screen

First Operations Control Summary Screen

Second Operations Control Summary Screen

You can review the number, units, and amount totals for the following information:

• orders:

- entered

- cancelled

- soldout

- shipped

- returned

- exchanged

- held

- suspended; also the number of suspended batches

- open backordered

- held backordered

- open printed

- held printed

- open reserved

- held reserved

• pending pick slips

• pending RA:

- receipts

- credits

• pending refunds

• backordered items

• purchase orders:

- open

- held

- docked

- open past due

- held past due

- docked past due

• inventory in:

- suspense receipt

- pending putaway

- staging warehouse

Screen flow: The screen that opens when you first enter the Operations Control Summary menu option varies, depending on whether the Batch Order Control job was submitted for the day. See Updating Operations and Merchandising Summary Totals for more information on the Batch Order Control job.

• If the Batch Order Control job has not yet been submitted for the day, the Display Operations Control Summary Screen opens when you first enter the Operations Control Summary menu option.

• If the Batch Order Control job has already been submitted for the day, the First Operations Control Summary Screen opens when you first enter the Operations Control Summary menu option.

Defining Thresholds

You can define thresholds to monitor the numbers and/or amounts of operational and merchandising summary totals. The system compares the actual number and/or amount for the threshold against the threshold number and/or amount you defined; if the threshold you have defined is breached, the system generates the Threshold Monitor Breach Email.

Example: One of the system delivered thresholds is Backorders (BO). This threshold monitors the number of open orders and held orders that contain at least one unit on backorder and/or the merchandise amounts of backordered units on open or held orders. You can set this threshold to send an email to the warehouse supervisor when the number of open and held orders that contain at least one unit on backorder is greater than 100. Once the actual number of open and held orders containing a backordered item is 101, the system sends an email to the warehouse supervisor.

For more information: See Working with Threshold Values (WTHR) for more information on system delivered thresholds and how to define your own thresholds.

Updating Operations and Merchandising Summary Totals

Updating order activity totals for the selected date and accounting period: The system updates the information on the top part of the First Operations Control Summary Screen (order activity by date and accounting period) as changes occur in order activity and are processed through the Order Async and Billing Async. You can select Refresh screen to update the order activity totals displayed on the screen with any changes that may have occurred since you first entered the screen.

The system interactively updates the number, units, and amounts totals of the following order activity information:

orders:

• entered

• cancelled

• soldout

• shipped

• returned

• exchanged

Totals display for the selected date and accounting period.

Note:

Drop ship items update the order activity totals as well as items that you ship from your warehouse.

Non-inventory items: The setting of the Demand Update for Non-Inventoried Items (E59) system control value does not affect how the system calculates the order activity totals; non-inventory items update each total regardless of this setting.

Update demand for order maintenance: The setting of the Update Demand for Order Maintenance Transactions (C72) system control value does not affect how the system calculates the order activity totals.

Updating operations control summary totals: The Batch Order Control job (ORD_CONTRL) updates the operations and merchandising summary totals. You can review operations totals on the bottom part of the First Operations Control Summary Screen and the Second Operations Control Summary Screen.

The Batch Order Control job updates the number, units, and amounts totals of the following operations and merchandising information:

• orders:

- open

- held

- suspended (also the number of suspended batches)

- open backordered

- held backordered

- open printed

- held printed

- open reserved

- held reserved

• pending pick slips

• pending RA:

- receipts

- credits

• pending refunds

• backordered items

• purchase orders:

- open

- held

- docked

- open past due

- held past due

- docked past due

• inventory in:

- suspense receipt

- pending putaway

- staging warehouse

Submitting the Batch Order Control job: The system submits the Batch Order Control job when:

• you select Update current totals on the First Operations Control Summary Screen, Second Operations Control Summary Screen, or Display Operations Control Summary Screen in the Operations Control Summary (FLSH) menu option.

• you submit a periodic process that:

- includes the Order Summary (ORDSUM) periodic function (program name PFR0062), OR

- includes the Threshold (THRESHD) periodic function (program name PFTHRESHMO).

Note: You can schedule a periodic process to run at a specified time; see Executing Periodic Processes (EPRO) for more information on defining a job schedule for a periodic process.

Batch Order Control processing: The Batch Order Control job:

• updates all of the fields in the Order Control Summary table for the current transaction date.

• generates the Operations Control Report, which displays the most recent operations and merchandising summary totals; the system generates the report only if you submit the Batch Order Control job from the Operations Control Summary menu option.

• updates the actual value fields and Last updated fields in the Threshold Values table; see Updating Threshold Actual Values for more information on the updates the batch order control job performs for threshold values.

Note: The system does not update or use the Flash Report table to capture operations and merchandising summary information; instead, the system updates and uses the Order Control Summary table.

Display Operations Control Summary Screen

Updates to this screen: This screen displays operations control summary information for the dates when:

• you have executed order, cancellation, sold out, shipping, return or exchange transactions, or

• you have run the Batch Order Control job; see Updating Operations and Merchandising Summary Totals.

Order Control Report: When you update current totals by selecting Update current totals, or execute the periodic function ORDSUM (program name PFR0062), the system prints the Operations Control Report for the current (today’s) date.

How to display this screen:

• select Display All Days at the First Operations Control Summary Screen, or

• If you have not yet run the Batch Order Control job or processed information through the Order Async or Billing Async for the current day:

- enter FLSH in the Fast path field or select this option from a menu.

- Select Dsp Flash Rpt at the Streamlined Pick Slip Generation Screen.

Field

Description

Date

The date when the displayed order activity took place.

Numeric, 6 positions, in user date format; display-only.

The totals listed on the Display Operations Control Summary screen are accurate as of the time you refreshed the screen for the current date.

Ordered

The number of orders and merchandise amounts for orders entered for the selected date and accounting period.

Note: The order totals reflect initial order entry only and do not include order lines added to an existing order through order maintenance, regardless of the setting of the Update Demand for Order Maintenance Transactions (C72) system control value.

Orders

The number of orders entered, including:

• the total number of ship-to addresses for orders with multiple ship-to’s. For example, an order with two ship-to addresses updates the number of orders total by 2.

• orders which include only sold out items or non-inventory items.

• returns processed by negative quantities in order entry.

This does not include batch orders that have not yet been accepted.

This is the Orders entered number in the Order Control Summary table. The system adds the Orders entered number value for each transaction date in the accounting period to determine the number of orders entered for the accounting period.

 

Amount

The merchandise amount total of orders entered, including merchandise amount total of sold out items or non-inventory items.

This does not include:

• merchandise amounts for items returned during order entry.

• merchandise amounts for batch orders that have not yet been accepted.

This is the Orders entered dollars in the Order Control Summary table. The system totals the Orders entered dollars value for each transaction date in the accounting period to determine the merchandise amount total of orders entered for the accounting period.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

Cancelled

The number of orders and merchandise amounts for orders cancelled for the selected date and accounting period.

Note: These totals include orders, items, or merchandise amount only if the Reduce demand? flag for the cancel reason is unselected.

Orders

The number of orders cancelled (orders in Cancelled status; all order lines have been cancelled).

This is the Orders cancelled number in the Order Control Summary table. The system totals the Orders cancelled number value for each transaction date in the accounting period to determine the total number of orders cancelled for the accounting period.

Amount

The merchandise amount total of cancelled items. This total updates when you cancel an entire order or one or more lines on an order.

This is the Orders cancelled dollars in the Order Control Summary table. The system totals the Orders cancelled dollars value for each transaction date in the accounting period to determine the merchandise amount total of cancelled items for the accounting period.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

Soldout

The number of orders and merchandise amounts for orders soldout for the selected date and accounting period.

The system considers an order line sold out if:

• you process soldout order lines in order entry, order maintenance, or the Processing Auto Soldout Cancellations (MASO) menu option.

• you cancel order lines with a cancel reason whose Reduce demand? flag is selected. However, the system updates only soldout orders and does not update soldout units, soldout amounts, cancelled orders, cancelled units, or cancelled amounts for these order lines.

Orders

The total number of soldout orders, including orders for which all order lines are sold out, or at least one order line is sold out and all other order lines have been cancelled using any cancel reason code.

This does not include order lines that are sold out if other order lines exist on the order that are not sold out or cancelled.

• This is the Orders soldout/closed number in the Order Control Summary table. The system totals the Orders soldout/closed number value for each transaction date in the accounting period to determine the total number of soldout orders for the accounting period.

 

Amount

The merchandise amount total of soldout items.

This is the Orders soldout dollars in the Order Control Summary table. The system totals the Orders soldout dollars value for each transaction date in the accounting period to determine the merchandise amount total of soldout items for the accounting period.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

Shipped

The number of orders and merchandise amounts for orders shipped for the selected date and accounting period.

These totals are not decreased by returns or exchanges.

Orders

The total number of shipped orders.

This is the Orders shipped number in the Order Control Summary table. The setting of the Order Control Summary Shipment Update Method (I55) system control value determines how the system updates the # Orders shipped field in the Order Control Summary table.

The system totals the # Orders shipped value for each transaction date in the accounting period to determine the total number of shipped orders for the accounting period.

 

Amount

The merchandise amount total of shipped items.

This is the Orders shipped dollars in the Order Control Summary table. The system adds the Orders shipped dollars value for each transaction date in the accounting period to determine the merchandise amount total of shipped items for the accounting period.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

Returned

The number of orders and merchandise amounts for orders returned for the selected date and accounting period.

You can enter a return in:

• order entry (via negative quantity ordered)

• order maintenance, or

• Work with Return Authorizations (these totals increase only when you process the credit)

These totals include simple returns only, as opposed to exchanges. See Returning and Exchanging Items in Order Maintenance.

Orders

The total number of return transactions processed and credited, regardless of whether the returns are on the same order. For example, an order with 2 returned order lines processed separately updates this total by 2; however, if the same 2 returned order lines on a single order are processed in the same transaction, the total updates by 1.

This is the Invoices credited number in the Order Control Summary table. The system totals the Invoices credited number value for each transaction date in the accounting period to determine the total number of return transactions processed and credited for the accounting period.

 

Amount

The merchandise amount total of returned items.

This is the Invoices credited dollars in the Order Control Summary table. The system totals the Invoices credited dollars value for each transaction date in the accounting period to determine the merchandise amount total of returned items for the accounting period.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

Screen Option

Procedure

Display operations control summary information for a selected date.

Select Display for a date to advance to the First Operations Control Summary Screen, which displays information for the selected date.

Update totals for order recap information on the Operations Control Summary screen and print the Order Control Report for the current date.

Select Update current totals to submit the ORD_CONTRL job, which updates the information in the lower part of the First Operations Control Summary Screen.

After the batch job is completed, you must exit the screen and re-display it to view the changes.

This batch job also prints the Operations Control Report for the current date.

First Operations Control Summary Screen

Purpose: Use this screen to review:

• order activity information for the selected date and accounting period, such as the number, quantity, and amount totals of orders entered, cancelled, soldout, shipped, returned, and exchanged. The top half of the screen displays order activity information.

• order summary information as of the selected date, such as the number, quantity, and amount totals of orders open, held, suspended, open backordered, held backordered, open printed, held printed, open reserved, and held reserved. Operations summary information is on the lower half of the screen.

Updating totals: See Updating Operations and Merchandising Summary Totals for more information on how the system updates the totals on this screen.

Note: If you advance to this screen for a date when you did not update the totals, the bottom half of the screen does not display any information.

Additional operations summary information: Select OK to advance to the Second Operations Control Summary Screen.

How to display this screen:

• Select a date at the Display Operations Control Summary Screen to display information for a selected date, or

• If the batch order control job has already run for today’s date, or the Order Async is active and you have processed order information for the current day:

- enter FLSH in the Fast path field or select Display Operations Control Summary from a menu.

- select Dsp Flash Rpt at the Streamlined Pick Slip Generation Screen.

Field

Description

Information for selected date and accounting period:

Date

(Unlabeled field at top left of screen)

The current date, or the date you have selected at the Display Operations Control Summary Screen.

The order activity information displayed below this date reflects total ongoing activity for the date.

Numeric, 6 positions, in user date format; display-only.

Accounting period and year

(Unlabeled field at top right of screen)

The accounting period which includes the date displayed in the Date field.

The order activity information displayed below the month and year reflects total activity for the accounting period up to the selected date.

Alphanumeric, 7 positions; display-only.

Ord (Orders)

The number of orders, number of units, and merchandise amounts for orders entered for the selected date and accounting period as of the time you refreshed the screen.

Note: The order totals reflect initial order entry only. These totals do not include order lines added to an existing order through order maintenance, regardless of the setting of the Update Demand for Order Maintenance Transactions (C72) system control value.

Orders

The number of orders entered, including:

• the total number of ship-to addresses for orders with multiple ship-to’s. For example, an order with two ship-to addresses updates the number of orders total by 2.

• orders which include only sold out items or non-inventory items.

• returns processed by negative quantities in order entry.

This does not include batch orders that have not yet been accepted.

This is the Orders entered number in the Order Control Summary table. The system adds the Orders entered number value for each transaction date in the accounting period to determine the number of orders entered for the accounting period.

 

Units

The number of units ordered, including:

• the main set item as well as each component item.

• units of sold out items or non-inventory items.

This does not include:

• units returned by entering negative quantities in order entry.

• units on batch orders that have not yet been accepted.

This is the Quantity ordered in the Order Control Summary table. The system totals the Quantity ordered value for each transaction date in the accounting period to determine the number of units ordered for the accounting period.

 

Amount

The merchandise amount total of orders entered, including merchandise amount total of sold out items or non-inventory items.

This does not include:

• merchandise amounts for items returned during order entry.

• merchandise amounts for batch orders that have not yet been accepted.

This is the Orders entered dollars in the Order Control Summary table. The system totals the Orders entered dollars value for each transaction date in the accounting period to determine the merchandise amount total of orders entered for the accounting period.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

The following fields display totals for transactions processed on the selected date, or in the selected accounting period, regardless of whether the original order was processed on the selected date or in the selected accounting period.

Can (Cancelled)

The number of orders, number of units, and merchandise amounts for orders cancelled for the selected date and accounting period as of the time you refreshed the screen.

Note: These totals include orders, items, or merchandise amount only if the Reduce demand? flag for the cancel reason is unselected.

Orders

The number of orders cancelled (orders in Cancelled status; all order lines have been cancelled).

This is the Orders cancelled number in the Order Control Summary table. The system adds the Orders cancelled number value for each transaction date in the accounting period to determine the total number of orders cancelled for the accounting period.

Units

The total number of units cancelled. This total updates when you cancel an entire order or one or more lines on an order.

This is the Quantity cancelled in the Order Control Summary table. The system adds the Quantity cancelled value for each transaction date in the accounting period to determine the total number of units cancelled for the accounting period.

 

Amount

The merchandise amount total of cancelled items. This total updates when you cancel an entire order or one or more lines on an order.

This is the Orders cancelled dollars in the Order Control Summary table. The system adds the Orders cancelled dollars value for each transaction date in the accounting period to determine the merchandise amount total of cancelled items for the accounting period.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

S/O (Sold out)

The number of orders, number of units, and merchandise amounts for orders soldout for the selected date and accounting period as of the time you refreshed the screen.

The system considers an order line sold out if:

• you process soldout order lines in order entry, order maintenance, or the Processing Auto Soldout Cancellations (MASO) menu option.

• you cancel order lines with a cancel reason whose Reduce demand? flag is selected. However, the system updates only soldout orders and does not update soldout units, soldout amounts, cancelled orders, cancelled units, or cancelled amounts for these order lines.

Orders

The total number of soldout orders, including orders for which all order lines are sold out, or at least one order line is sold out and all other order lines have been cancelled using any cancel reason code.

This does not include order lines that are sold out if other order lines exist on the order that are not sold out or cancelled.

This is the Orders soldout/closed number in the Order Control Summary table. The system adds the Orders soldout/closed number value for each transaction date in the accounting period to determine the total number of soldout orders for the accounting period.

 

Units

The total number of soldout units.

This is the Quantity soldout in the Order Control Summary table. The system adds the Quantity soldout value for each transaction date in the accounting period to determine the total number of soldout units for the accounting period.

Amount

The merchandise amount total of soldout items.

This is the Orders soldout dollars adds in the Order Control Summary table. The system adds the Orders soldout dollars value for each transaction date in the accounting period to determine the merchandise amount total of soldout items for the accounting period.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

Shp (Shipped)

The number of orders, number of units, and merchandise amounts for orders shipped for the selected date and accounting period as of the time you refreshed the screen.

These totals are not decreased by returns or exchanges.

Orders

The total number of shipped orders.

This is the # Orders shipped in the Order Control Summary table. The setting of the Order Control Summary Shipment Update Method (I55) system control value determines how the system updates the # Orders shipped field in the Order Control Summary table:

ORDERS = The system updates the # Orders shipped field when the Billing Async updates the status of an order to closed; see ORDERS Order Control Summary Shipment Update Method for more information on how the system updates by ORDERS.

INVOICES = The system updates the # Orders shipped field when the Billing Async creates an invoice for an order, excluding credit invoices; see INVOICES Order Control Summary Shipment Update Method for more information on how the system updates by INVOICES.

PICKS = The system updates the # Orders shipped field when the Billing Async processes a pick control number for an order; see PICKS Order Control Summary Shipment Update Method for more information on how the system updates by PICKS.

The system totals the # Orders shipped value for each transaction date in the accounting period to determine the total number of shipped orders for the accounting period.

 

Units

The total number of shipped units, including:

• shipped units confirmed; the system updates the units total as each unit is confirmed.

• non-inventory items confirmed during billing.

• For set items, the system updates the Quantity shipped by the number of components, plus the master set item. For example, if shipped master set item A101 includes 2 components, the system updates the Quantity shipped by 3.

This total does not include:

• units for returns processed in order entry.

• units on orders that are express billed if the Order Control Summary Shipment Update Method (I55) system control value is set to PICKS.

• memberships or virtual stored value cards processed at pick slip generation if the Order Control Summary Shipment Update Method (I55) system control value is set to PICKS.

This is the Quantity shipped in the Order Control Summary table. The system adds the Quantity shipped value for each transaction date in the accounting period to determine the total number of shipped units for the accounting period.

 

Amount

The merchandise amount total of shipped items, including:

• shipments confirmed; the system updates the amount total as each unit is confirmed.

• non-inventory items confirmed during billing

This total does not include:

• amounts for returns processed in order entry.

• amounts on orders that are expressed billed if the Order Control Summary Shipment Update Method (I55) system control value is set to PICKS.

• amounts for memberships or virtual stored value cards processed at pick slip generation if the Order Control Summary Shipment Update Method (I55) system control value is set to PICKS.

This is the Orders shipped dollars in the Order Control Summary table. The system totals the Orders shipped dollars value for each transaction date in the accounting period to determine the merchandise amount total of shipped items for the accounting period.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

Rtn (Returns)

The number of orders, number of units, and merchandise amounts for orders returned for the selected date and accounting period as of the time you refreshed the screen.

You can enter a return in:

• order entry (via negative quantity ordered)

• order maintenance, or

• Work with Return Authorizations (these totals increase only when you process the credit)

These totals include simple returns only, as opposed to exchanges. See Returning and Exchanging Items in Order Maintenance.

Orders

The total number of return transactions processed and credited, regardless of whether the returns are on the same order. For example, an order with 2 returned order lines processed separately updates this total by 2; however, if the same 2 returned order lines on a single order are processed in the same transaction, the total updates by 1.

This is the Invoices credited number in the Order Control Summary table. The system totals the Invoices credited number value for each transaction date in the accounting period to determine the total number of return transactions processed and credited for the accounting period.

 

Units

The total number of returned units.

This is the Quantity credited in the Order Control Summary table. The system totals the Quantity credited value for each transaction date in the accounting period to determine the total number of returned units for the accounting period.

Amount

The merchandise amount total of returned items.

This is the Invoices credited dollars in the Order Control Summary table. The system totals the Invoices credited dollars value for each transaction date in the accounting period to determine the merchandise amount total of returned items for the accounting period.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

Exc (Exchanges)

The number of orders, number of units, and merchandise amounts for items returned in exchange transactions for the selected date and accounting period as of the time you refreshed the screen.

These totals include quantities and merchandise amount of the items returned in exchange transactions, not units and merchandise amount of items ordered in exchange. See Returning and Exchanging Items in Order Maintenance.

You can enter an exchange in:

• order maintenance

• Work with Return Authorizations (these totals increase only when you process the credit)

Orders

The total number of exchange transactions processed, regardless of whether the exchanges are on the same order. For example, an order with 2 exchanged order lines processed separately updates this total by 2; however, if the same 2 exchanged order lines on a single order are processed in the same transaction, the total updates by 1.

This is the Exchanges number in the Order Control Summary table. The system totals the Exchange number value for each transaction date in the accounting period to determine the total number of exchange transactions processed for the accounting period.

 

Units

The total number of units returned in exchange transactions.

This is the Quantity exchanged in the Order Control Summary table. The system totals the Quantity exchanged value for each transaction date in the accounting period to determine the total number of units returned in exchange transactions for the accounting period.

Amount

The merchandise amount total of returned items in exchange transactions.

This is the Exchanged dollars in the Order Control Summary table. The system totals the Exchanged dollars value for each transaction date in the accounting period to determine the merchandise amount total of returned items in exchanged transactions for the accounting period.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

Information for order recap totals:

Totals display only if you have run the Batch Order Control job; these totals are cumulative up to the date and time of the last update.

Opn (Open)

Total number of open orders, open units, and total amount of open order lines.

Orders

The total number of open orders; this is the number of orders in an open status.

This is the Open orders number in the Order Control Summary table for the most recent transaction date.

Units

The total number of open units; this is the total number of units on open order lines, including units on backorder and regardless if the units are printed or unprinted. This also includes units on order lines that are in a held status.

This is the total of the Open backordered quantity, Open printed quantity, and Open unprinted quantity in the Order Control Summary table for the most recent transaction date.

 

Amount

The merchandise amount total of open order lines, including open order lines containing backordered units and regardless if the units are printed or unprinted. This also includes the merchandise amount for order lines that are in a held status.

This is the total of the Open backordered dollars, Open printed dollars, and Open unprinted dollars in the Order Control Summary table for the most recent transaction date.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

Hld (Held)

Total number of held orders, held units, and total amount of order lines on held orders.

Orders

The total number of held orders; this is the number of orders in a held status.

This is the Held orders number in the Order Control Summary table for the most recent transaction date.

Units

The total number of held units; this is the total number of units on held orders, including units on backorder and regardless if the units are printed or unprinted. This does not include units on held order lines if the order is not held.

This is the total of the Held backordered quantity, Held printed quantity, and Held Unprinted quantity in the Order Control Summary table for the most recent transaction date.

 

Amount

The merchandise amount total of held orders, including order lines containing backordered units and regardless if the units are printed or unprinted. This does not include merchandise amounts for held order lines if the order is not held.

This is the total of the Held backordered dollars, Held printed dollars, and Held unprinted dollars in the Order Control Summary table for the most recent transaction date.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

Sus (Suspended)

Total number of suspended orders, suspended units, and total amount of suspended orders, regardless if the order is batched.

Orders

The total number of suspended orders; this is the number of orders in a suspended status or error status as defined in the Order Header table.

This is the Orders suspended number in the Order Control Summary table for the most recent transaction date.

Units

The total number of units on suspended orders, including orders in a suspended status and error status. The system uses this calculation over the Order Detail table to determine the suspended units: quantity ordered - quantity cancelled - quantity shipped - quantity soldout = suspended units.

This is the Orders suspended quantity in the Order Control Summary table for the most recent transaction date.

 

Amount

The merchandise amount total of suspended orders, including orders in a suspended status and error status. This is the sum of the merchandise amounts for suspended and orders in error in the Order Ship To table.

This is the Orders suspended dollars in the Order Control Summary table for the most recent transaction date.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

OBO (Open/backordered)

Total number of open backordered orders, open backordered units, and total merchandise amount of open backordered units.

The system determines if an item is on backorder using this calculation: open quantity on order line - reserved quantity on order line = backorder quantity. The system uses this calculation to determine the open quantity: order quantity - shipped quantity - cancelled quantity - soldout quantity = open quantity.

Orders

The total number of open orders that contain at least one unit on backorder, including the total number of ship-to addresses for orders with multiple ship-to’s. For example, an order with two ship-to addresses updates the number of orders total by 2.

This is the Future use 1 number in the Order Control Summary table for the most recent transaction date.

Units

The total number of backordered units on open orders.

This is the Quantity backordered in the Order Control Summary table for the most recent transaction date.

 

Amount

The total merchandise amounts of backordered units on open orders.

This is the Open backordered dollars in the Order Control Summary table for the most recent transaction date.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

HBO (Held/backordered)

Total number of held backordered orders, held backordered units, and total merchandise amount of held backordered units.

The system determines if an item is on backorder using this calculation: open quantity on order line - reserved quantity on order line = backorder quantity. The system uses this calculation to determine the open quantity: order quantity - shipped quantity - cancelled quantity - soldout quantity = open quantity.

Orders

The total number of held orders that contain at least one unit on backorder, including the total number of ship-to addresses for orders with multiple ship-to’s. For example, an order with two ship-to addresses updates the number of orders total by 2.

This is the Future use 2 number in the Order Control Summary table for the most recent transaction date.

Units

The total number of backordered units on held orders.

This is the Quantity held backordered in the Order Control Summary table for the most recent transaction date.

 

Amount

The total merchandise amount of backordered units on held orders.

This is the Held backordered dollars in the Order Control Summary table for the most recent transaction date.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

Opn/Prt (Open/Printed)

Total number of units on open orders for which pick slips have been printed and total merchandise amount of units on open orders for which pick slips have been printed.

Units

The total number of printed units on open orders.

The total number of open printed units is the Open printed quantity in the Order Control Summary table for the most recent transaction date.

Amount

The total merchandise amount of printed units on open orders.

This is the Open printed dollars in the Order Control Summary table for the most recent transaction date.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

Hld/Prt (Held/printed)

Total number of units on held orders for which pick slips have been printed and total merchandise amount of units on held orders for which pick slips have been printed.

Units

The total number of printed units on held orders.

This is the Held printed quantity in the Order Control Summary table for the most recent transaction date.

Amount

The total merchandise amount of printed units on held orders.

This is the Held printed dollars in the Order Control Summary table for the most recent transaction date.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

Opn/Rsv (Open/reserved)

Total number of units on open orders which are reserved and total merchandise amount of units on open orders which are reserved.

Units

The total number of reserved units on open orders.

This is the Open unprinted quantity in the Order Control Summary table for the most recent transaction date.

Amount

The total merchandise amount of reserved units on open orders.

This is the Open unprinted dollars in the Order Control Summary table for the most recent transaction date.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

Hld/Rsv (Held/reserved)

Total number of units on held orders which are reserved and total merchandise amount of units on held orders which are reserved.

Units

The total number of reserved units on held orders.

This is the Held unprinted quantity in the Order Control Summary table.

Amount

The total merchandise amount of reserved units on held orders.

This is the Held unprinted dollars in the Order Control Summary table.

Number fields: numeric, 9 positions; display-only.

Amount fields: numeric, 11 positions with a 2-place decimal; display-only.

General information

Last updated on/at

The date and time when the Batch Order Control job was last run, updating the operations and merchandising totals.

Date: numeric, 6 positions, in user date format; display-only.

Time: numeric, 6 positions, HH:MM:SS format; display-only.

Suspended batches

The total number of order batches that are in a suspended status.

The system determines the number of order batches in a suspended status by totaling the number of orders in the Order Batch table whose Batch suspended field is selected.

This is the Batches suspended number in the Order Control Summary table.

Numeric, 9 positions; display-only.

Screen Option

Procedure

Review operations summary information on the second Operations Control Summary screen.

Select OK to advance to the Second Operations Control Summary Screen.

Update the operation totals on the screen

Select Refresh screen to update the operations totals.

Review order summary information by date or select a date for which you want to view detailed order summary information

Select Display all days to advance to the Display Operations Control Summary Screen.

Update current totals for open/held order recap information and print the Order Control Report for the current date.

Select Update current totals to submit the batch job ORD_CONTRL, which will update the information in the lower part of the screen (Order Recap information).

After the batch job is completed, you must select Refresh screen to view the changes.

This batch job will also print the Operations Control Report for the current date.

Note: This option is not available when you display this screen for dates other than the current date. If you try to use this option for past dates, the screen displays the following error message: Update cannot be submitted for a prior date.

Review merchandising summary information for the date you are currently reviewing

Select Merchandising to advance to the Merchandising Control Summary screen.

Second Operations Control Summary Screen

Purpose: Use this screen to review operations control summary information, such as the number, quantity, and amount total of pending pick slips, pending RA receipts, pending RA credits, and pending refunds.

Updating totals: See Updating Operations and Merchandising Summary Totals for more information on how the system updates the totals on this screen.

If you display this screen for a date when you did not update the totals, there is no information on this screen.

How to display this screen: Select OK at the First Operations Control Summary Screen.

Field

Description

Date (unlabeled field at the center top of the screen)

The current date, or the date you have selected at the Display Operations Control Summary Screen.

The operations summary information displayed below this date reflects total ongoing activity for the date.

Numeric, 6 positions, in user date format; display-only.

Totals display only if you have run the Batch Order Control job; these totals are cumulative up to the date and time of the last update.

Pick slips

The number of pending pick slips, number of units on pending pick slips, and merchandise amounts for pending pick slips.

Pending pick slips are pick slips that have been printed but not yet billed, not including pick slips voided, waiting for authorizations, or suspended.

The system increases the pending pick slip number, units, and amounts for drop ship orders if the drop ship output defined for the vendor is drop ship pick slip; if the drop ship output defined for the vendor is drop ship purchase order or collaborative shipping, the system only increases the total units and total amounts pending and does not increase the total number pending.

Number

The total number of pick slips pending. This is the Pending picks number in the Order Control Summary table.

Units

The total number of units on pending pick slips. This is the total of the Open printed quantity and Held printed quantity in the Order Control Summary table for the most recent transaction date.

 

Amount

The merchandise amount total of items on pending pick slips.

This is the total of the Open printed dollars and Held printed dollars in the Order Control Summary table.

Number fields: numeric, 9 positions; display-only.

Amount field: numeric, 11 positions with a 2-place decimal; display-only.

RA receipts

The number of pending return authorization receipts, number of units on pending return authorization receipts, and merchandise amounts for pending return authorization receipts.

Pending return authorization receipts are return authorizations that have been entered, but not yet received. You can only enter a pending RA receipt using non-streamlined return authorizations (the Use Streamlined Return Authorizations (F44) system control value is selected.

These totals include quantities and merchandise amount of the items returned in return transactions and items returned in exchange transactions, not units and merchandise amount of items ordered in exchange. See Returning and Exchanging Items in Order Maintenance.

 

Number

The total number of pending return authorization receipts, regardless of whether the returns are on the same order. For example, an order with 2 pending RA receipt order lines processed separately updates this total by 2; however, if the same 2 pending RA receipt order lines on a single order are processed in the same transaction, the total updates by 1.

The system determines the number of pending RA receipts by totaling the number of RA header records whose date received is 0.

This is the Pending RA receipt number in the Order Control Summary table.

Units

The total number of units on pending return authorization receipts.

The system determines the number of units on pending RA receipts by looking at the RA detail records whose quantity returned is less than the quantity to return and totaling the unreceived quantity.

This is the Pending RA receipt quantity in the Order Control Summary table.

 

Amount

The merchandise amount total of items on pending return authorization receipts.

The system determines the merchandise amounts of items on pending RA receipts by multiplying the unreceived quantity by the order detail price.

This is the Pending RA receipt dollars in the Order Control Summary table.

Number fields: numeric, 9 positions; display-only.

Amount field: numeric, 11 positions with a 2-place decimal; display-only.

RA credits

The number of pending return authorization credits, number of units on pending return authorization credits, and merchandise amounts for pending return authorization credits.

Pending return authorization credits are return authorizations that have been received, but not yet credited. You can only enter a pending RA credit using non-streamlined return authorizations (the Use Streamlined Return Authorizations (F44) system control value is selected).

These totals include quantities and merchandise amount of the items returned in return transactions and items returned in exchange transactions, not units and merchandise amount of items ordered in exchange. See Returning and Exchanging Items in Order Maintenance.

 

Number

The total number of pending return authorization credits, regardless of whether the returns are on the same order. For example, an order with 2 pending RA credit order lines processed separately updates this total by 2; however, if the same 2 pending RA credit order lines on a single order are processed in the same transaction, the total updates by 1.

The system determines the number of pending RA credits by totaling the number of RA header records whose date received is greater than 0 and date credited is 0.

This is the Pending RA credit number in the Order Control Summary table.

Units

The total number of units on pending return authorization credits.

The system determines the number of units on pending RA credits by looking at the RA detail records whose quantity credited is less than the quantity to credit and totaling the uncredited quantity.

This is the Pending RA credit quantity in the Order Control Summary table.

 

Amount

The merchandise amount total of items on pending return authorization credits.

The system determines the merchandise amounts of items on pending RA credits by multiplying the uncredited quantity by the order detail price.

This is the Pending RA credit dollars in the Order Control Summary table.

Number fields: numeric, 9 positions; display-only.

Amount field: numeric, 11 positions with a 2-place decimal; display-only.

Refunds

The number of pending refunds, number of units on pending refunds, and merchandise amounts for pending refunds.

Pending refunds are refunds in an open or held status that have not yet been processed; these totals do not include refunds that are in a pending cancelled, cancelled, pending write off, write off, or processed status.

Number

The total number of unprocessed refunds.

This is the Refunds pending number in the Order Control Summary table.

Amount

The merchandise amount total of items on unprocessed refunds.

This is the Refunds pending dollars in the Order Control Summary table.

Number field: numeric, 9 positions; display-only.

Amount field: numeric, 11 positions with a 2-place decimal; display-only.

Last updated on/at

The date and time when the Batch Order Control job was last run, updating the operations and merchandising totals.

Date: numeric, 6 positions, in user date format; display-only.

Time: numeric, 6 positions, HH:MM:SS format; display-only.

Screen Option

Procedure

Review operations summary information on the first Operations Control Summary screen.

Press Page Up to advance to the First Operations Control Summary Screen.

Update the operation totals on the screen

Select Update current totals.

Review order summary information by date or select a date for which you want to view detailed order summary information

Select Display all days to advance to the Display Operations Control Summary Screen.

Update current totals for open/held order recap information and print the Order Control Report for the current date.

Select Update current totals to submit the batch job ORD_CONTRL, which will update the information in the lower part of the screen (Order Recap information).

After the batch job is completed, you must select Refresh screen to view the changes.

This batch job will also print the Operations Control Report for the current date.

Note: This option is not available when you display this screen for dates other than the current date. If you try to use this option for past dates, the screen displays the following error message: Update cannot be submitted for a prior date.

FLSH OMSCS 18.1 April 2019 OTN