Purpose: The following information displays on the Operations Summary page:
• Activity Summary Tile Fields
Also, see the Order Control Summary Shipment Update Method (I55) for more information on how shipment totals are updated.
For more information:
• Operations Summary for an overview of the Operations Summary page.
• Operations Summary Options for step-by-step instructions on the actions you can perform on the Operations Summary page.
The following activities for the current date are each tracked in a separate tile:
• Entered: Tracks the merchandise value of order lines that were entered or created on the current date.
• This total increases for each order line entered on the current date, regardless of the original order date.
• This total also includes items added to the order as part of an exchange.
• This total also includes units added to an existing order line that was originally created on a prior date.
• This total is also decreased when you apply a post-shipment discount.
• Cancellations that take place using a cancel reason flagged to Reduce demand are subtracted from the Entered totals. For example, you might use a cancel reason flagged to reduce demand if the order line was created through an error, and the customer did not actually want to order the item.
• Cancelled: Tracks the merchandise value of order lines that were canceled on the current date. A cancellation increases this total, rather than decreasing the Entered total, when the cancellation reason used is not flagged to Reduce demand.
• Exchanged: Tracks the merchandise value of order lines that were exchanged on the current date.
• Soldout: Tracks the merchandise value of order lines that were sold out on the current date.
• Shipped: Tracks the merchandise value of order lines that were shipped and billed on the current date.
Note: The Order Control Summary Shipment Update Method (I55) system control value defines how to update the Shipped totals. See below for more information.
• Returned: Tracks the merchandise value of order lines that were returned on the current date.
Activity date vs. order date: The totals are based on activities that took place on the current date, regardless of when the order was created. For example, an order was created on April 2, and an order line was added on April 9. The order line’s merchandise total is included on April 9.
Excluded from totals: Retail pickup and delivery orders that fulfill orders originating in Order Management System and submitted to Order Broker for assignment are excluded from these totals. These are orders whose Alternate Order Number indicates an originating order number, and whose Broker Delivery Type is Delivery or Retail Pickup.
Each activity tile displays the following totals:
• Merchandise Value: The total merchandise amount related to the activity on the current date. For example, indicates the total merchandise value of order lines created, canceled, or exchanged on the current date. See:
• Cancelled (Merchandise Value)
• Exchanged (Merchandise Value)
• Returned (Merchandise Value)
• Currency: From the Default Location Currency Code (A55) system control value. All merchandise values are displayed in this currency.
• Average Value: The total Merchandise Value divided by the total number of units related to the activity on the current date. For example, if the total Merchandise Value entered so far today is 5,000 for a total of 200 units, the Average Value is 25.00.
Each bar chart illustrates the percentage that each activity represents in the total of the following for the current date:
• Unit Count: Indicates the percentage represented by each tracked activity in the total number of units for all tracked activities.
For example, there has been a total of 300 units involved in activities so far today, including:
• 150 units entered on order lines
• 20 units canceled on order lines
• 10 units sold out on order lines
• 100 units shipped on order lines
• 20 units returned on order lines
The units entered represent 50.00% of the unit count so far for the current date. When you position your cursor over the Entered portion of the bar chart, a window displays:
Status: Entered
Percent of Activity: 50.00
• Order Count: Indicates the percentage represented by each tracked activity in the total number of orders for all tracked activities. Only activities that affect the entire order are tracked in the order count, regardless of whether other activities have taken place related to the lines on the order. However, based on the setting of the Order Control Summary Shipment Update Method (I55), activities that create invoice records (shipments and returns) can also be included in the order count, regardless of whether the status of the order itself has changed.
For example, so far today:
• 40 orders were entered
• 10 orders had shipments, including partial shipments
• 10 orders had returns, including partial returns
The orders entered represent 66.67%, or two thirds of the orders included in the total. When you position your cursor over the Entered portion of the bar chart, a window displays:
Status: Entered
Percent of Activity: 66.67
Multi-recipient orders: Each ship-to on a multi-recipient order increases the total order count. For example, when you create an order that includes two additional recipients, it increases the total by three.
• Merchandise Value: Indicates the percentage represented by each tracked activity in total merchandise value. For example, the total merchandise value across all activities so far today is $2300, including:
• $800 entered
• $200 canceled
• $100 sold out
• $1000 shipped
• $200 returned
The merchandise value of orders entered represents 34.87% of the total. When you position your cursor over the Entered portion of the bar chart, a window displays:
Status: Entered
Percent of Activity: 34.87
The percentage of each of the following activities are displayed in a different color. Position your cursor over each activity to display the percentage that the activity represents of the total count or value, broken out to 2 decimal positions. See Activity Summary Tile Fields, above, for a list of the possible activities.
If a particular activity has not taken place for the current date, it is not included in the bar chart.
The summary table lists the following totals for each activity for the current date:
• Unit Count. See:
• Order Count. See:
• Merchandise Value: Displayed as whole numbers without decimals. See:
• Cancelled (Merchandise Value)
• Exchanged (Merchandise Value)
All possible activities are listed in the summary table, regardless of whether the activity has taken place on the current date. If the activity has not taken place on the current date, the totals listed are zero.
Order Control Summary Shipment Update Method (I55)
This system control value defines how to update shipment totals for the Order Control Summary table, displayed on the Operations Control Summary page. Possible settings for this system control value are ORDERS, INVOICES, and PICKS. Each is described below.
ORDERS
When the Order Control Summary Shipment Update Method (I55) system control value is set to ORDERS or blank, the Billing Async updates the # Orders shipped field when the status of an order changes to closed.
The Orders shipped total includes:
• Shipped orders, including drop ship orders, confirmed; the system does not update the # Orders shipped until all of the units on the order are confirmed, soldout, or cancelled.
• A single order with multiple pick slips (for example, for ship alone items) updates the # Orders shipped by 1.
• An order with multiple recipients updates the # Orders shipped by the number of recipients. For example, an order with 2 ship-to customers updates the total by 2.
• Orders which include only non-inventory items, membership items, or virtual stored value card items; the system updates the total once the order is processed through billing.
• Express bill orders.
The Orders shipped total does not include:
• Orders which include only soldout items.
• Returns processed as negative quantities in order entry. Note: If the order also includes a regular item, the system includes the order in the Orders shipped total once all of the regular items on the order are confirmed.
INVOICES
When the Order Control Summary Shipment Update Method (I55) system control value is set to INVOICES, the system updates the # Orders shipped field when the Billing Async creates an invoice for an order, excluding credit invoices.
The Orders shipped total includes:
• Invoices for an order, excluding credit invoices.
• A single order with multiple invoices updates the # Orders shipped by the number of invoices created. For example, an order with 2 invoices updates the total by 2.
• An order with multiple recipients updates the # Orders shipped by the number of invoices created for each ship to. For example, an order with 2 ship-to customers, each ship to containing 2 invoices, updates the total by 4.
• If you use Consolidated Invoice (B49), the system counts a consolidated invoice as one invoice, regardless of how many separate shipments are processed through billing.
• Express bill orders and drop ship orders since an invoice is still created.
• Orders which include only non-inventory items, membership items or virtual stored value card items since an invoice is still created.
The Orders shipped total does not include:
• Orders which include only soldout items since an invoice is never created.
• Returns processed as negative quantities in order entry, since the invoice created is a credit. Note: If the order also includes a regular item, the system includes the order in the Orders shipped total once an invoice is created for the regular item.
PICKS
When the Order Control Summary Shipment Update Method (I55) system control value is set to PICKS, the system updates the # Orders shipped field when the Billing Async processes a pick control number for an order.
The Orders shipped total includes:
• Pick control numbers confirmed for an order.
• A single order with multiple pick control numbers updates the # Orders shipped by the number of pick control numbers confirmed through billing. For example, a pick was generated for a ship alone item and another pick was generated for all other items. The system generates a separate pick control number whenever an order is split into several pick slips.
• An order with multiple recipients updates the # Orders shipped by the number of pick control numbers generated and confirmed for each ship to. For example, an order with 2 ship-to customers, each ship to has 2 pick control numbers confirmed, updates the total by 4.
• Orders which include only non-inventory items or drop ship items on drop ship picks, since a pick control number is still generated.
The Orders shipped total does not include:
• Pick labels that are scanned and sent to billing since they do not contain any detail lines.
• Express bill orders since a pick control number is not generated.
• Returns processed as negative quantities in order entry since a pick control number is not generated. Note: If the order also includes any regular item, the system includes the order in the Orders shipped total once the pick control number(s) associated with the regular item(s) is processed by billing.
Orders which include only sold out items, membership items, drop ship items on drop ship purchase orders, or virtual stored value card items since a pick control number is not generated.
________________________________
Copyright © 2020, Oracle and/or its affiliates. All rights reserved.
Legal Notices