8 Orders Menu

Order Inquiry

Purpose: Use the Order Inquiry screen to search for and review Order Orchestration orders sent from an integrated system, such as Xstore or Order Administration, for fulfillment by another integrated system.

Used for the Routing Engine module.

How to display this screen: Select Order Inquiry from the Home Screen or the Orders Menu.

Note:

Available if Use Routing Engine is selected at the Tenant screen. This screen is accessible to users with Order Inquiry authority. See Roles for more information.

How to display orders on this screen

When you first advance to the Order Inquiry screen, your Default Organization defined through the Users screen is selected by default, but no orders are displayed. Click Search to retrieve the last 50 orders in your organization, or select additional search criteria.

Sort order: The orders are sorted based on Request ID. The Request ID is a unique number assigned by the Routing Engine when an integrated system assigns an order or order line to Order Orchestration for fulfillment.

How to view order updates? Click Search to refresh the screen.

Note:

This screen functions only after you have created at least one order in Order Orchestration.

Customer name anonymized? If the customer data on an order has been anonymized (deleted and replaced with asterisks), the customer name is displayed as:

*** ***

***

In this case, searching by customer name or company name is not supported.

An order is eligible to be anonymized only if it is no longer open.

See Anonymizing Data for background.

Options at this screen

Option Procedure
search for orders

When you first advance to this screen, no orders are displayed and your Default Organization defined through the Users screen is selected by default. Use any combination of the fields at the top of the screen to restrict the search results.

Case? All the enterable fields on this screen are case-insensitive for searching; for example, an entry of a or A matches a name of Adams.

review the reasons why the Routing Engine eliminated individual locations from sourcing the order

Click the Trace Log icon (Illustrates the Trace Log icon.) to advance to the Trace Shopping Log screen, where you can review the reasons why the Routing Engine filtered each possible location from sourcing the order.

  • The Routing Engine traces shopping logic only if the Trace Shopping Logic field is set to Detailed at the Event Logging screen. Typically, you would select to trace shopping logic only to research why certain locations are or aren’t selected to fulfill orders.

  • These history records are retained only for the number of Trace Log History days specified at the Tenant-Admin screen; after that number of days, the daily cleanup job automatically deletes the records.

  • If the Trace Shopping Logic screen is already open in another tab, you advance to that screen, where the previously-selected order is displayed.

view order details or update an order

Click the Edit/Display icon (Illustrates the edit/display icon.) to advance to the Order screen, where you can view order details and history or update an order if you have Order Maintenance authority.

Note: If the Order screen is already open in another tab, you advance to that screen, where the previously-selected order is displayed.

Fields at this screen

Fields Description
Search fields

Case? All the enterable fields on this screen support case-insensitive searching; for example, an entry of a or A matches a name of Adams.

Organization

See organization. From the Default Organization defined through the Users screen, but you can override it.

Request ID

A unique number to identify the order within Order Orchestration. Assigned by the Routing Engine when it creates the order. Depending on your integration and the type of order, each individual order line might create a separate order in Order Orchestration, or might be included with other lines from the originating order in the external system.

Note: The numbers might not always be in sequential order.

Order Number

The number or code identifying the order in the originating system. From the order id passed in the submit order message. Can be up to 30 positions.

Case: If the originating system includes any lowercase letters in the order number, Order Orchestration converts them to uppercase when creating the order.

Not case-sensitive for searching; an entry of A or a matches an order number of A12345.

Placed Location

The location where the order originated; see placed location for a discussion.

Sourced Location

The location supplying the inventory for a ship-for-pickup order.

Multiple locations? If an order includes lines assigned to multiple sourcing locations, searching based on a sourcing location produces a list of orders that include lines assigned to the specified location.

Pickup Location

The location where the customer picks up a pickup order or ship-for-pickup order.

Date Ordered

The transaction date passed in the submit order message. Might not be the same as the date when the order was created.

Order Status

The order-level status, which can be different from the various line-level statuses if the Allow Split Order preference is selected. See Order and Line Statuses.

Under Review? The words Under Review follow the order status in parentheses if the order’s Under Review flag is selected. You might need to adjust the column widths to display these words.

Order Type

Possible order types are:

  • Delivery = The order is shipped to the customer from the fulfilling location. See Delivery Order for a discussion.

    Pickup = The customer goes to the fulfilling location, where the merchandise is already in stock, to pick up the order, See Pickup Order for a discussion.

    Ship For Pickup = The customer wants to pick up the order in a store location, and the inventory can be sourced from a location that differs from the pickup location and the originating location.

 

Customer name anonymized? If the customer data on an order has been anonymized (deleted and replaced with asterisks), searching by the original company name, first name, or last name is not supported. See Anonymizing Data for background.

Company Name

The sold-to customer’s company name, if it was passed in the submit order message.

Not case-sensitive for searching; an entry of A or a matches a company name of Acme.

First Name

The sold-to customer’s first name, if it was passed in the submit order message.

Not case-sensitive for searching; an entry of A or a matches a first name of Alice.

Last Name

The sold-to customer’s last name, if it was passed in the submit order message.

Not case-sensitive for searching; an entry of A or a matches a last name of Allen.

Postal Code

The sold-to customer’s postal or zip code from the submit order message.

Case: If the originating system includes any lowercase letters in the postal code, Order Orchestration converts them to uppercase when creating the order.

Not case-sensitive for searching; an entry of A or a matches a postal code of A1A OB1.

Result fields
Request ID

The screen sorts by Request ID.

Order Number

See Order Number.

Customer

The sold-to customer’s first and last name, followed by the customer’s company name. Based on the information passed in the submit order message for the customer.

Customer name anonymized? If the customer data on an order has been anonymized (deleted and replaced with asterisks), the customer name is displayed as:

*** ***

***

See Anonymizing Data for background.

Placed Location

The location that originated the order.

Sourced Location

The location supplying the inventory for the order. A location of Multiple is listed if Split Order is enabled and the order is split across sourcing locations.

Pickup Location

The location where the customer picks up the order. Blank for a delivery order.

Date Ordered

The transaction date passed in the submit order message. Might not be the same as the date when the order was created.

Order Status

See Order and Line Statuses.

Under Review? If the order is currently flagged as Under Review, meaning that the fulfilling system needs to delay shipping or fulfilling the order, the message (Under Review) is listed next to the order status.

Depending on your browser settings, you might need to broaden the column to read this message.

See the Under Review field at the Order screen for more information.

Order Type

See Order Type, above.

Postal Code

The sold-to customer’s Postal Code or zip code.

Trace Log

Click the Trace Log icon (Illustrates the Trace Log icon.) to advance to the Trace Shopping Log screen, where you can review the reasons why the Routing Engine eliminated each possible location from sourcing the order.

  • The Routing Engine traces shopping logic only if the Trace Shopping Logic field is set to Detailed at the Event Logging screen. Typically, you would select to trace shopping logic only to research why certain locations are or aren’t selected to fulfill orders.

    These history records are retained only for the number of Trace Log History days specified at the Tenant-Admin screen; after that number of days, the daily cleanup job automatically deletes the records.

    If the Trace Shopping Logic screen is already open in another tab, you advance to that screen, where the previously-selected order is displayed.

Edit

Click the Edit/Display icon (Illustrates the edit/display icon.) to advance to the Order screen, where you can view order details and history or update an order if you have Order Maintenance authority.

If the Order screen is already open in another tab, you advance to that screen, where the previously-selected order is displayed.

Trace Shopping Log

Purpose: Use the Trace Shopping Log screen to view the existing product locations that the Routing Engine considered for placement of an order or line for sourcing, and the reason why each location was filtered from selection.

Simple trace example: A simple shopping logic trace for a product with four product location records might include the Routing Engine evaluating the locations as follows:

  1. Initial list: The Routing Engine identifies each of the four product location for the requested item.
  2. The Routing Engine filters out location A because it does not support the order type, based on the Fulfillment settings at the Preferences screen.
  3. The Routing Engine filters out location B because it does not have sufficient inventory of the requested item(s).
  4. The Routing Engine filters out location C because it is the requesting location.

The shopping trace entries displayed for the order might include:

  • First, all product locations that for the product:

    • Initial List / Location A

    • Initial List / Location B

    • Initial List / Location C

    • Initial List / Location D

  • Next, location A is filtered because it does not support the order type, for example:

    • Does not support Order Type / Location A

  • Next, location B is filtered because it does not have sufficient inventory, for example:

    • Location has insufficient inventory / Location B

  • Next, location C is filtered because it was the requesting location, for example:

    • Requesting Location / Location C

Location D is selected for the order; however, there is no entry at the Trace Shopping Log screen for the selected location. You can review the selected location at the Order screen.

See Trace Log Elimination Reasons, below, for a list of possible reasons why the Routing Engine might filter out a location.

When the Routing Engine takes multiple passes through possible locations: There are situations when the Routing Engine evaluates potential locations more than once and writes trace records for filtering a location each time, although one or more of the locations might ultimately be selected to fulfill or source the order.

  • If order must be split and split order is supported: For example, an order includes two items. The Routing Engine first looks for a single location that can fulfill both order lines, but does not find a single location for both.Then, if splitting orders is selected, the Routing Engine checks whether the order can be fulfilled by splitting the lines across location A and location B.

    In this type of scenario, a shopping trace entry might first indicate a reason that location A and location B are filtered; however, these two locations are ultimately selected in a subsequent pass.

  • If zone fulfillment is in use: For example, the shipping address is within a fulfillment zone that includes both primary and alternate locations. The Routing Engine first evaluates the primary locations but does not find one or more primary locations that can fulfill the order. The Routing Engine then evaluates the alternate locations. If the order cannot be fulfilled in one or more alternate locations, the Routing Engine then evaluates whether the order can be fulfilled by splitting across any primary and alternate locations.

    In these scenarios, a trace log can indicate a reason for filtering a location, although the location might ultimately be selected in a subsequent pass. For example, location A and location B are eliminated separately in the first pass, but are ultimately selected to fulfill individual order lines in a subsequent pass.

Note:

The Routing Engine evaluates multiple locations only if your organization supports splitting orders.

Demonstrates filtering rather than selection: Use the Trace Shopping Log screen to determine how locations are filtered from shopping, rather than how the remaining eligible locations are selected. Once the Routing Engine has determined the remaining locations after ineligible locations are filtered, the Routing Engine or the Science Engine selects the sourcing location based on the Standard Brokering or Weighted Brokering settings at the Preferences screen.

Enabling shopping logic tracing: Shopping log records are created only when Trace Shopping Logic at the Event Logging screen is set to Detailed.

Note:

Oracle recommends that you turn on shopping logic tracing to research questions related to how the Routing Engine is selected locations, but to otherwise keep tracing turned off in order to enhance system performance.

Shopping logic records created when? You can use trace shopping log records to track how the Routing Engine eliminates potential locations for sourcing a delivery or ship-for-pickup order after:

  • A submit order message is received.

  • A status update request is received, rejected the order or line.

  • A store associate rejects the order or line in Store Connect.

  • You change the status of an order to rejected through the Order screen, if splitting orders is not enabled.

  • You change the status of an order line to rejected through the Edit Order Item window, if splitting orders is enabled.

The above scenarios related to rejecting an order line include the possibility of rejecting a partial quantity of the line if the Allow Partial Updates preference is selected.

Not created? Trace log records are not created when:

  • The Routing Engine or the Science Engine selects the sourcing location. The screen displays only reasons for eliminating a location, not reasons for selecting a location.

  • There are no product locations for the item.

  • The pickup location rejects a pickup or ship-for-pickup order.

  • You select a different location at the Order screen or the Edit Order Item window.

  • A locate items or product availability search request is received.

  • The order or line is put in Unfulfillable status because the Search Retries specified at the Preferences screen has been met.

Purging trace log records: The daily cleanup job purges trace log records for closed, completed, canceled, and unfulfillable orders when the shopping date is older than number of days specified in the Trace Log History setting at the Tenant-Admin screen.

Used for the Routing Engine module.

How to display this screen: Click the Trace Log icon (Illustrates the attribute icon.) at the Order Inquiry screen. Available if Use Routing Engine is selected at the Tenant screen, regardless of whether Trace Shopping Logic is currently enabled.

Note:

If the Trace Shopping Log screen was already open in another tab when you clicked the edit/display icon, you advance to this screen with the previously-selected order data displayed.

Options at this screen

Option Procedure
Filter the Shopping Trace Records Displayed
Filter the displayed shopping trace records based on criteria such as trace type, item, reason, location code or name, or associated system

See the Search and Filter Options, below.

Fields at this screen

Fields Description
Order Number

See Order Number.

Request ID

See Request ID.

Search and Filter Options

Optionally, use one or more of the following search options to restrict the displayed shopping trace records to those that match your entries or selections.

Trace Type

Select a trace type and click Search to display shopping trace records created during that trace type. Possible types include:

  • Initial Routing: The Routing Engine identifies all possible product location records.

  • Initial Routing (Primary Locations): The Routing Engine identifies all possible primary locations for the zone when zone fulfillment is in effect and the customer’s address is within the zone.

  • Initial Routing (Alternate Locations): The Routing Engine identifies all possible alternate locations for the zone when zone fulfillment is in effect, the customer’s address is within the zone, and one or more locations were not found in the list of primary locations.

  • Initial Routing (Primary and Alternate Locations): The Routing Engine identifies all possible primary and alternate locations when zone fulfillment is in effect, the customer’s address is within the zone, and one or more locations were not found in the list of primary locations or the list of alternate locations, so the combination of primary and alternate locations are now evaluated.

  • Reshop - N (Location Zone Type): The Routing Engine begins the routing process again because the fulfilling or sourcing location has rejected the order, where:

    • The N indicates the pass for reshopping, and,

    • The Location Zone Type indicates the type(s) of location zones being evaluated. Possible types are Primary Locations, Alternate Locations, and Primary and Alternate Locations.

Example: The Trace Type for the second pass over primary and alternate locations is Reshop - 2 (Primary and Alternate Locations).

Note:

The Routing Engine evaluates multiple locations only if your organization supports splitting orders.
Item

Enter a full or partial item code and click Search to display shopping trace records for items that start with your entry or match it completely.

Reason

Select a reason why the location was eliminated, or select Initial List, and click Search to display shopping trace records that match your entry. See Trace Log Elimination Reasons, below, for information on possible reasons.

Location

Enter a complete, valid location code and click Search to display shopping trace records for that location.

Name

Enter a full or partial location name and click Search to display shopping trace records for locations whose names include your entry.

Note:

This is the name at the time the trace history record was created. If you have changed the name of the location since that time, searching based on the new name may not succeed.
System

Select a system and click Search to display shopping trace records for locations associated with the selected system. Only systems associated with the organization related to the order are available for selection.

Results

Reason

The reason why the location was eliminated from selection; otherwise, set to Initial List. See Trace Log Elimination Reasons, below.

Note:

If the entire reason is not displayed, you can drag the Reason heading to the right to widen the displayed information.
Reason Value

The value related to the reason. Included only when related to zone, distance, attribute, or probability rule. If related to:

  • Zone: Indicates the zone name.

  • Proximity distance: Indicates 50 - miles, where 50 is the Default Distance and miles is the unit of measure; confirm with ship-for-pickup)

  • Attribute: Indicates the attribute name.

  • Probability rule: Indicates the probability rule name.

Otherwise, this field is blank.

Location

The code identifying the location.

Note:

The name and address for the location displayed here, as well as the available quantity of the item, is based on the information from when the shopping trace record was written, and may differ from the current information if the location record has been edited or the available quantity has changed.
Name

The name of the location at the time when the shopping took place.

City

The city for the location at the time when the shopping took place.

State/Province

The state or province for the location at the time when the shopping took place.

Postal

The postal or zip code for the location at the time when the shopping took place.

System

The system associated with the location.

Available Qty

The available to promise quantity of the item in the location at the time when the shopping took place.

Date/Time

The date and time when the shopping took place.

Trace Log Elimination Reasons

The following table lists possible reasons why a potential sourcing location was filtered from eligibility.

Reason Description (Reason Why Location was Filtered from Eligibility)

Disallow shopping within same System

The Disallow shopping within same system flag was selected at the System screen, and the location is associated with the same system as the requesting location.

Does not support Order Type

The location was not eligible to fulfill the order based on the Fulfillment settings at the Preferences screen.

Does not support Sourcing orders

Ship-for-pickup orders are supported, and the location was not eligible to source the order based on the Fulfillment settings at the Preferences screen.

Initial list

The location was included in the initial list of potential locations for the Trace Type because there was a product location record. Initial list trace records are listed before the subsequent trace records indicating why each location is eliminated from eligibility.

If no availability? If you use standard brokering, only product locations with an available to promise quantity, or that are flagged as Backorder Available at the Preferences screen, are included in the initial list. Otherwise, if you use weighted brokering, product locations with no availability are included in the initial list, but then eliminated afterward with the Zero Availability reason.

Location at Maximum Daily Order Count

Use Maximum Order Limits was selected at the Preferences screen, and the location was filtered because it had already met the Maximum Daily Orders.

Location cannot be fulfilled from Alternate Search Locations for Zone

Fulfillment Zones were in use and the location was not assigned as an alternate location to the zone for the shipping address.

In this case, the fulfillment zone name is indicated as the Reason Value.

Location cannot be fulfilled from Combined Primary and Alternate Search Locations for Zone

Fulfillment Zones were in use and the location was not assigned to the zone for the shipping address as either a primary or alternate location.

In this case, the fulfillment zone name is indicated as the Reason Value.

Location cannot be fulfilled from Primary Search Locations for Zone

Fulfillment Zones were in use and the location was not assigned as a primary location to the zone for the shipping address.

In this case, the fulfillment zone name is indicated as the Reason Value.

Location does not match Location Attribute

Use Attribute Rules was selected at the Preferences screen, the requesting location had a location attribute assigned with a use of originating, and the location was filtered because it was not assigned the same attribute with a use of sourcing. For example, the requesting location supports originating orders for brands A, but the location does not support sourcing orders for brand A.

In this case, the attribute name is indicated as the Reason Value.

Location does not match Product and Location Attribute

Use Attribute Rules was selected at the Preferences screen, the item had a product and location attribute assigned, and the location was filtered because it was not assigned the same attribute. For example, the item requires engraving, but the location does not support engraving.

In this case, the attribute name is indicated as the Reason Value.

Location does not support Gift Wrap

Use Attribute Rules was selected at the Preferences screen, the order required gift wrap, and the location was filtered because its Gift Wrap flag was not selected.

Location has insufficient inventory

The requested quantity was more than the available to promise quantity for the location.

Note: There may be subsequent shopping trace entries if splitting lines is supported, because the Routing Engine attempts to fulfill the line by splitting against eligible locations.

Location is not common for all products

Allow Split Order was not selected at the Preferences screen, the order included more than one order line, and there was not a product location record for this item at this location, although there was a product location for one or more other items on the order.

Location is not eligible to source Product Attribute

The submit order request specified an attribute for the product that was not associated with the location. For example, the submit order request specified brand A for the product, but the location does not support sourcing orders for brand A.

Previously Assigned Location not Eligible

The location was previously assigned as a fulfilling or sourcing location and the order or line was rejected.

Probability Rule

The location was filtered based on a probability rule. For example, a probability rule was set to exclude the location or lower the available quantity.

In this case, the probability rule name is indicated as the Reason Value.

Proximity distance

The location’s distance from the customer’s address is more than:

Note: This reason can occur even if the location is included in a fulfillment zone for the shipping address.

Requesting Location

This is the location where the order originated.

Shopping by common location. Location has insufficient inventory

Allow Split Order was selected at the Preferences screen, the order included more than one order line, this was a common location for the items, and the requested quantity of this item was not available at this location.

Split Line Off - Location has insufficient inventory

Allow Split Line was not selected at the Preferences screen and there was a product location for the item at this location, but not enough to fulfill the full line quantity.

Split Line On - Location has insufficient inventory

Allow Split Line was selected at the Preferences screen and there was a product location for the item at this location, but not enough to fulfill the full line quantity.

This shopping trace entry comes after the Location has insufficient inventory entry.

Split Order On - Location has insufficient inventory

Allow Split Order was selected at the Preferences screen, the order included more than one order line, and the requested quantity of this item was not available at this location.

This shopping trace entry comes after the Location has insufficient inventory entry.

Un-Requested Location

A different location was specified as the fulfilling or sourcing location for the order.

Zero Availability

Exclude Locations with Zero Availability was selected at the Preferences screen, and the location was filtered because the available to promise quantity for the product in the location is zero or less and the location does not allow backorders.

Note: This reason can apply only when weighted brokering is in use.

Order

Purpose: Use the Order screen to view the details and activity of an order, or update the order’s status, or sourcing location, if you do not split orders (If you do split orders, you can use the Edit Order Item window to update an item’s status, or sourcing location). This screen is accessible to users with Order Inquiry authority; however, all fields are display-only if the user does not have Order Maintenance authority. See Roles for more information.

Used for the Routing Engine module.

Customer name anonymized? If the customer data on an order has been anonymized (deleted and replaced with asterisks), the customer name is displayed as:


Illustrates the sold-to name and address with the information replaced by asterisks.

See Anonymizing Data for background.

How to display this screen: Click the edit/display icon (Illustrates the edit/display icon.) at the Order Inquiry screen. Available if Use Routing Engine is selected at the Tenant screen.

Note:

If the Order screen was already open in another tab when you clicked the edit/display icon, you advance to this screen with the previously-selected order displayed.

Options at this screen

Option Procedure
Viewing Options
view order totals, addresses, and summary information

Click the Header tab. This tab is selected by default.

view the items on the order

Click the Details tab.

view the activity that has taken place for each item on the order

Click the History tab.

view the existing system products for an item on the order

Click the system products icon (Illustrates the system products icon.) for an item on the Details tab to advance to the System Products window.

Line split? If the line is split, this icon is available only after you click the plus sign for the requesting system line number to display additional fields and options:


Illustrates the plus sign next to the requesting system line number if the line has split.

See the Details tab, below, for a discussion.

view additional information about an item, including the description, price and tax, and polled count, in a single window

Click the edit/display icon (Illustrates the edit/display icon.) for an item on the Details tab to advance to the Edit Order Item window if you have Order Maintenance authority and the Allow Split Order preference is selected; otherwise, the Browse Order Item window opens. See below for a discussion of maintenance options.

Line split? If the line is split, this icon is available only after you click the plus sign for the requesting system line number to display additional fields and options:


Illustrates the plus sign for a line.

See the Details tab, below, for a discussion.

view the updated ship to address associated with the item

Click the display icon (Illustrates the display icon.) for an item on the History tab to advance to the Order History Detail - Address Change Window.

See the History tab, below, for a discussion.

Maintaining an order

Authority to maintain an order: You can update an order as described below if you have Order Maintenance authority. See Roles for more information.

Maintenance at the order level or at the line level? If the Allow Split Order preference for an organization is:

  • Unselected: an order’s status, and fulfilling location or sourced location, are set at the order level.

  • Selected: an order’s status, and fulfilling location or sourced location, are set at the line level.

    Important:

    When you have Order Maintenance authority and the Allow Split Order preference is selected, you use the Edit Order Item window, rather than the Order screen, to maintain an order line’s status or sourcing location.

Cannot change both status and sourced location: You cannot change both the status and any location for an order or an order line at the same time. To change more than one field, first apply one change and click Save, then return to the Order screen and apply the other change.

Caution: Updating an order or line’s status, fulfilling location, or sourced location is a means to correct occasional issues that may occur, and not recommended for routine processing. Except for the restrictions noted below, the screen does not prohibit most status or location updates.

Note:

Before updating an order, you can use other screens in Order Orchestration or contact a potential fulfilling, sourced, or pickup location directly to ensure that the update does not produce subsequent issues, such as fulfilling an order twice, reopening a shipped or canceled order, sourcing an order twice, or not fulfilling an order at all.
update the status of an order

If you have authority to Order Maintenance and the Allow Split Order preference for the organization is unselected, you can update the status of an order:

  • Select the new status from the Order Status field.

  • Click Save.

You cannot change the status of an order to Complete or Open, since these are statuses that Order Orchestration applies to an order only when the individual lines have different statuses.

You can change the status of a canceled order here regardless of whether the Restrict Reassignment of Canceled Line preference is selected.

Restrictions:

  • When you select a status from the Order Status field for a delivery order, the corresponding fulfilling location field (Shipment or Sourced) becomes display-only. Similarly, when you select a status from the Order Status field for a ship-for-pickup order, the corresponding Sourced location field becomes display-only. In order to change both the order’s status and its fulfilling or sourced location, complete one update and then return to the Order screen to complete the other update.

Updates:

  • When you change the order status to new_order, canceled, or fulfilled, the Polled Count for the order lines are reset to 0.

  • When you change the order status to rejected:

    • delivery order: The Routing Engine reassigns the order and changes the status to new_order if another eligible location exists and if the Search Retries limit hasn’t been reached; otherwise, the Routing Engine changes its status to unfulfillable. There may be a brief delay before the update is applied.

    • When you use RICS order fulfillment, changing the order status to rejected also triggers a new fulfillment order request to RICS. See Order Fulfillment through RICS Integration for more information.

    • pickup order: The Routing Engine changes its status to unfulfillable.

    • ship-for-pickup order: The Routing Engine reassigns the order to a different sourcing location, and changes the status to new_order if another eligible sourcing location exists and if the Search Retries limit hasn’t been reached. For a ship-for-pickup order, a rejected status update generally indicates that the inventory was not received from the sourced location, or that it was defective. There may be a brief delay before the update is applied.

A status change can update the reserved quantity for the product location, depending on the system’s Include Reserved setting and any Reserved Statuses for the system. See the System page for more information.

Order Orchestration tracks the activity in status history. See the History tab, below.

For more information: See Order and Line Statuses (Splitting Preference Turned Off) for more information on automatic status updates for orders fulfilled through Store Connect.

update the fulfilling location for a delivery order

If you have authority to Order Maintenance and the Allow Split Order preference for the organization is unselected, you can update the fulfilling location for an order:

Select the new fulfilling location from the field labeled Shipment for a delivery order and Click Save.

Which locations are available for selection? The dropdown list includes each location that supports the type of order:

  • For a delivery order, the location must be flagged as Delivery Available.

You cannot select:

  • Any location where the order was previously assigned, even if it no longer supports the type of order.

  • The IN PROCESS location. See the Acknowledge Order Before Brokering preference for background.

    Note:

    The window does not prevent you from selecting a location:
    • where the item(s) are not available. If you do so, and if the Include Reserved flag is selected at the System screen, Order Orchestration creates a new record of the product location(s).

    • that is not associated with the zone for the order’s shipping location if you use zone fulfillment.

When you use RICS order fulfillment, changing the fulfilling location for a delivery order triggers a release reservation request for the prior location and a new fulfillment order request for the new location to RICS. See Order Fulfillment through RICS Integration for more information.

For more information: See below for Restrictions.

update the sourcing location for a ship-for-pickup order

If you have authority to Order Maintenance and the Allow Split Order preference for the organization is unselected, you can update the fulfilling location for an order:

Which locations are available for selection? The dropdown list includes each location that is flagged as Ship For Pickup Sourcing Available.

  • You cannot select:

  • Any location where the order was previously assigned.

  • The IN PROCESS location. See the Acknowledge Order Before Brokering preference for background.

    Note:

    The window does not prevent you from selecting a location:
    • where the item(s) are not available. If you do so, and if the Include Reserved flag is selected at the System screen, Order Orchestration creates a new record of the product location(s).

    • that is not associated with the zone for the order’s shipping location if you use zone fulfillment.

For more information: See Ship For Pickup Order for background.

Restrictions

  • You cannot change the fulfilling location for a pickup order.

  • You cannot change the pickup location for a ship-for-pickup order.

  • When you select a location from the fulfilling location field (Shipment) for a delivery order, the Order Status field becomes display-only. In order to change both the order’s status and its fulfilling location, complete one update and then return to the Order screen to complete the other update.

  • When you select a status from the Order Status field for a ship-for-pickup order, the corresponding Sourced location field becomes display-only. In order to change both the order’s status and its sourced location, complete one update and then return to the Order screen to complete the other update.

Updates:

  • If you select the default unfulfillable location, the status of the order changes to unfulfillable.

  • Order Orchestration tracks the location assignment history. See the History tab, below.

  • If the system is configured to track reserved quantity and the line is in an applicable status, Order Orchestration updates the reserved quantity for the product location or creates the product location if it does not already exist. Otherwise, Order Orchestration does not create or update a product location.

change an order line’s status or fulfilling location, and view additional information about an item, including the description, price and tax, and polled count, in a single window

Click the edit/display icon (Illustrates the edit/display icon.) for an item on the Details tab to advance to the Edit Order Item window if you have Order Maintenance authority and the Allow Split Order preference is selected; otherwise, the Browse Order Item window opens.

Line split? If the line is split, this icon is available only after you click the plus sign for the requesting system line number to display additional fields and options:


Illustrates the plus sign for a line number.

See the Details tab, below, for a discussion.

Fields at this screen

Fields Description
Request ID

See Request ID.

Order Number

See Order Number.

Header tab

Order Type

See Order Type.

Customer Number

The customer number, if passed as the customer_no in the submit order message, identifying the customer in the originating system.

Order Date

The transaction date and time passed in the submit order message. Might not be the same as the date when the order was created. If no time was specified in the message, the time displayed here indicates midnight (for example, 12:00 AM).

(Field labels vary depending on the type of order)

Placed = The location that originated a delivery orderor ship-for-pickup order.

Pickup = The location a customer selected to pick up a pickup order or ship-for-pickup order.

Shipment = The location shipping a delivery order. This location might have been specified by the placed (originating) location, or selected by the Routing Engine based on the rules set up at the Preferences screen.

Sourced = The location that transfers the inventory for a ship-for-pickup order to the pickup location. This location might have been specified by the placed (originating) location, or selected by the Routing Engine based on the rules set up at the Preferences screen.

Multiple locations? If the Allow Split Order preference is selected, a delivery order can be assigned to multiple locations for fulfillment, and a ship-for-pickup order can be assigned to multiple locations for sourcing. In this case, this field displays the word Multiple and information on each assigned location is displayed under the Details tab. See Selecting a Location for a Delivery Order or Selecting a Sourcing Location for a Ship-for-Pickup Order for an overview.

Update? You can update the fulfilling location for a delivery order, or the sourcing location for a ship-for-pickup order, if the Order Maintenance flag for a role assigned to your user profile is selected and the Allow Split Order preference for an organization is unselected. See Options at this screen, above, for more information.

Note: An integrated system might use different terms for these locations.

Order Status

See Order and Line Statuses for possible statuses.

Update? You can update the order status if the Order Maintenance flag in your user profile is selected and the Allow Split Order preference for an organization is unselected. See Options at this screen, above, for more information.

Under Review

A selected setting indicates that the fulfilling system needs to delay shipping or fulfilling the order until the flag is cleared.

Note:

  • It is the responsibility of the integrating systems to prevent fulfillment of an order that is under review. Order Orchestration does not prevent fulfillment based on this setting.

  • The items on orders that are under review are still included in the reserved quantity calculation.

Updates: You can select this flag through the initial submit order message, and can also update this flag:

The History tab displays a record of each time you change the setting of this flag.

Hold under review? If the order is fulfilled through Order Fulfillment through RICS Integration and the Hold Under Review Orders flag for the system is selected, the order is submitted for fulfillment when you clear this flag. See Order Fulfillment through RICS Integration for background.

Effect of the Under Review indicator in Store Connect:

  • The order is still eligible to be accepted and picked

  • The associate can generate the packing slip and the pick list pull sheet for the order

  • The order is not eligible for shipping or pickup

  • When the associate picks a pickup order, no email notification is sent to the customer until the setting of the Under Review indicator changes

  • A delivery order is not eligible to be shipped, and a pickup order is not eligible to be picked up

How the associate can tell if an order is under review:

  • The words Under Review, in red, are is displayed next to the order number on Store Connect screens.

  • The option to ship a delivery order or pick up a pickup order is greyed out.

Sold To

Any of the following information on the customer placing the order, if it is passed in the submit order message:

  • first name, middle initial, last name

  • company name

  • first through fourth address lines, including any apartment or suite

  • city, state, Postal Code, and country

  • first phone number (prefixed by Day:)

  • second phone number (prefixed by Eve:)

  • email address

Note: When submitting a pickup or ship-for-pickup order, Xstore uses the location’s address from Order Orchestration, while Order Administration uses the address from its own Store Cross Reference table.

Customer anonymized? If the customer data on an order has been anonymized, asterisks are displayed for the sold-to information. See Anonymizing Data for background.

Ship To

Any of the following information on the customer to receive a delivery order, or the address and contact information for the store where a customer picks up a ship-for-pickup order.

  • first name, middle initial, last name

  • company name

  • attention line (can be used for the name of the person to alert at the shipping destination)

  • first through fourth address lines, including any apartment or suite

  • city, state, Postal Code, and country

  • first phone number (prefixed by Day:)

  • second phone number (prefixed by Eve:)

  • email address

Note:Order Orchestration does not support a ship-to address for a pickup order.

Customer anonymized? If the customer data on an order has been anonymized, asterisks are displayed for the ship-to information. See Anonymizing Data for background.

If the address has been updated through the Edit Ship To Details window in Store Connect at any store location assigned to ship one or more items on the order, the most recently updated address is displayed here.

Summary

Currency

The description or ISO 4217 alphabetical code of the currency on the order. From the currency specified in the submit order message. If the currency is a valid alphabetical ISO 4217 code, the related currency symbol can be displayed for all order values. The default is the U.S. dollar (USD).

Note:

  • The currency code must be all capitals to match the ISO 4217 code.

  • Not all currency symbols can be displayed on the screen.

Sub Total

The subtotal of merchandise on the order, and preceded by the symbol of the currency on the order. The screen displays a 2-position decimal, although the database stores 4 positions. If no amount was passed from the originating system, the amount indicated is 0.

Special Instructions

Any special instructions for handling the order. Integrated systems might use this field to store other information about the order. The instructions can be up to 4000 positions.

Total

The total amount of merchandise, tax, freight, and other charges on the order, preceded by the symbol of the currency on the order. The screen displays a 2-position decimal, although the database stores 4 positions. If no amount was passed from the originating system, the amount indicated is 0.

Tax

The total amount of tax on the order, preceded by the symbol of the currency on the order. The screen displays a 2-position decimal, although the database stores 4 positions. If no amount was passed from the originating system, the tax indicated is 0.

Ship Via

The ship via code and ship via description designated for the order from the ship_via and ship_via_description. Formatted as 12 - UPS Ground where:

  • 12 is the ship via

  • UPS Ground is the ship via description

Different from carrier description? The description displayed here is from the SubmitOrder message and saved in the xom_order table, but this description does not update the carrier description displayed at the Carriers screen in Modern View. The description from the Carrier record is used elsewhere in the application, including Store Connect screens, Store Connect printed output, and the shipment notification email generated for orders shipped through Store Connect.

If no ship via specified in the SubmitOrder message:

  • For a delivery or ship-for-pickup order, the Default Carrier specified at the Preferences screen is used.

  • The default PICKUP carrier is used for a pickup order. If the default PICKUP carrier does not exist, Order Orchestration creates it.

Balance Due

The total balance due on the order, preceded by the symbol of the currency on the order. The screen displays a 2-position decimal, although the database stores 4 positions. If no amount was passed from the originating system, the amount indicated is 0.

Freight

The total amount of freight on the order, preceded by the symbol of the currency on the order. The screen displays a 2-position decimal, although the database stores 4 positions. If no amount was passed from the originating system, the freight indicated is 0.

Gift

Set to Y or N, if passed in the submit order message; otherwise, blank.

Details tab

Is line split? Provided the Allow Split Order preference is selected, a line can split if:

  • the Allow Split Line preference is selected, and the Routing Engine split a line when initially creating a delivery order, or after the line was rejected by an assigned location; or,

  • the Allow Partial Updates preference is selected, and the Routing Engine received a status update for a quantity lower than the current line quantity.

Even if your preferences support splitting lines or partial status update, this does not necessarily mean that the lines on an order will split.

Split lines at Detail tab: If any line on the order is split, you need to expand the requesting system line number at the Details tab in order to see and work with the details for all lines and see additional options:


Illustrates a split line at the Detail tab.

Non-split lines at Detail tab: If none of the lines on the order are not split, the details and options are displayed when you open the Detail tab:


Illustrates two non-split lines at the Detail tab.

For more information: See Selecting a Location for a Delivery Order for some of the different scenarios that are possible in creating or updating detail lines on delivery orders if you have Order Orchestration configured to split orders or order lines. Also, see Updating Order Status at the Line or Unit Level for an overview on processing partial status updates for order lines.

Req. Sys. Line # (Requesting system line number)

The line number identifying the order line in the requesting location. From the line_item_no passed in the submit order message. A single line from the requesting system can create multiple order lines in Order Orchestration if the Allow Split Line preference is selected. Also, a line can split as the result of a partial status update if the Allow Partial Updates preference is selected.

Even if a line is not split in Order Orchestration, the requesting system line number can be different from the line number in Order Orchestration. For example, this situation can occur if the placed (originating) location sends only the third line on a multi-line order to Order Orchestration; in this case, the line number in Order Orchestration is #1.

If split: If any lines on the order are split, you need to expand the line to see additional details and options. Click the plus sign next to the requesting system line number to expand:


Illustrates the plus sign next to the requesting system line number for a split line.
Line #

The order line number assigned by Order Orchestration. May be different from the requesting system’s line number if the system did not send all of the order lines to Order Orchestration for fulfillment and the version specified in the submit order message was lower than 3.0, or if an order line is split.

If split: If any of the lines on the order are split, the Item # is before the Order Orchestration Line # and is always displayed, even if you have not expanded the line by clicking the plus sign next to the Req. Sys. Line # (Requesting system line number); however, the Line # and other fields are not displayed until you click the plus sign.

Examples of line splitting:

  • Split by the Routing Engine:

    • The Routing Engine assigns the order to location A, and then Location A rejects the order

    • The Routing Engine then assigns half the quantity to location B, and half to location C. Result: the quantity in location B is now line #1; the quantity in location C is now line #2

  • Partial status update: The entire quantity of 5 was originally assigned to location A, but location A rejected 3 units. Result: the quantity in location A is now line #1; the rejected quantity, now reassigned or unfulfillable, is now line #2

 
Illustrates a split line, with the original quantity, original line number and current quantity, and line number created when split and the quantity on this line.
 

Different line numbers even if not split: It is possible for the Order Orchestration line number and requesting system line number to differ if, for example, the requesting system sends line 3 of a multi-line order to Order Orchestration (requesting system line number); when the Routing Engine creates the order, it assigns a line number of 1 because it is the only order line received from the requesting system.

Line numbers might not be consecutive: If the Routing Engine splits a line or receives a partial status update, the line numbers assigned in Order Orchestration to the resulting split lines might not be consecutive. For example, a system sends 3 lines, which produce lines 1, 2, and 3. Subsequently, the Routing Engine receives a partial update for line 1 and creates line 4 for the quantity in the updated status.

If not split: If none of the lines on the order are split, just a single line number is displayed.

Item #

The system product code for the user’s Default Organization. If the user’s Default Organization is not the same as the organization associated with the order, the system product code for the fulfilling location is displayed. Up to 26 positions.

If split: If any of the lines on the order are split, the Item # is before the Order Orchestration Line # and is always displayed, even if you have not expanded the line by clicking the plus sign next to the Req. Sys. Line # (Requesting system line number).

No item #? If your user ID is not assigned a Default Organization through the Users screen, the Item # might not be displayed here.

Note: You can display the item description by moving your cursor over the item code.

Quantity

Original quantity: If the line is split, the quantity displayed on the first line without a current line number is the quantity of the item that was originally assigned to the Fulfilling Location or Sourced Location. This quantity might differ from the quantity originally submitted to Order Orchestration if the Allow Split Line preference is selected, and the Routing Engine initially split the line across multiple fulfilling or sourcing locations. Also, the original quantity in Order Orchestration might subsequently be split across multiple order lines in Order Orchestration if the original fulfilling or sourcing location rejects the assignment and the Routing Engine splits the line when it reassigns it, or if a location submits a partial status update.

Current quantity: The quantity that is currently assigned to the fulfilling, sourcing, or pickup location. This quantity might be different from the original quantity if the Allow Split Line preference is selected, and the Routing Engine split the line across multiple fulfilling or sourcing locations after it was initially rejected by the first location, or if a location submits a partial status update.

Not split: If the line is not split, the original and current quantities are the same. If none of the lines on the order are split, then just a single quantity is displayed.

 
Illustrates the original quantity for an order line and the current quantities for each of the current lines.
Fulfilled Quantity

The quantity of the item shipped to the customer (delivery order) or picked up by the customer pickup order, ship-for-pickup order). Updated when the Routing Engine receives a status update message indicating that the new order, line, or quantity status is fulfilled.

If split: The total fulfilled quantity is displayed at the summary level for the line, and the fulfilled quantity for each current line number is listed below with the current line.

 
Illustrates the fulfilled quantity of the original line as well as the two current lines that exist through splitting.
Fulfilling Location

The fulfilling location that was most currently assigned to fulfill the item. Displayed only if the order is not a ship-for-pickup order.

If split: If the line is currently split across multiple fulfilling locations, the word Multiple is displayed at the summary level. You can expand the line to review all assigned locations by clicking the plus sign to the left.

Update? You can update the fulfilling location for a line if the Order Maintenance flag in your user profile is selected and the Allow Split Order preference is selected. See Edit Order Item for more information.

Sourced Location

The sourcing location that was most currently assigned to source the item for a ship-for-pickup order order.

If split: If the line is currently split across multiple sourcing locations, the word Multiple is displayed at the summary level. You can expand the line to review all assigned locations by clicking the plus sign to the left.

Update? You can update the sourcing location for a line if the Order Maintenance flag in your user profile is selected and the Allow Split Order preference is selected. See Edit Order Item for more information.

Pickup Location

The pickup location for a ship-for-pickup order order.

Line Status

See Order and Line Statuses.

Update? You can update the line status if the Order Maintenance flag in your user profile is selected and the Allow Split Order preference for an organization is selected. If the Allow Partial Updates preference is selected, you can also specify a partial quantity to update with the new status. See Edit Order Item for more information.

Status Date

The last date and time when the status of the order changed.

System Products

Click the system products icon (Illustrates the system products icon.) to open the System Products window, listing the system products for the item.

Display/Edit

Click the display/edit icon (Illustrates the display/edit icon.) to open the Edit Order Item window if you have Order Maintenance authority and the Allow Split Order preference is selected; otherwise, the Browse Order Item window opens. These windows list additional information about the item, such as pricing and poll count, and the Edit Order Item provides the ability to edit the item’s fulfilling location or status.

History tab

This tab displays the status history for each line on the order, created whenever a line is:

  • created, or

  • assigned or reassigned to a fulfilling or sourcing location, or

  • when its status changes for any other reason, or

  • when its shipping address is updated, or

  • when there is an update to the Under Review indicator

  • when the Pickup By Date is assigned, changed, or removed

  • when the customer data is anonymized through the Completed Order Private Data Purge job or through the ForgetPrivateData web service request

The History tab lists records for each item in reverse chronological order (newest to oldest). A single transaction can create multiple history records if the transaction splits the line due to a partial status update or reassignment of a rejected order to multiple fulfilling locations. Optionally, you can collapse the history for an item by clicking the box next to the line number.


Illustrates when the line number is collapsed.

Note:

Status history and changes to the Under Review indicator are tracked at the line level even if the organization does not split orders or order lines.

Illustrates the history of a line. The line was created; the location polled for orders, and the order was included in the response; units were picked; a partial quantity was fulfilled; the remaining quantity was fulfilled.
Item #

The system product code and item description for the user’s Default Organization defined through the Users screen. If the user’s Default Organization is not the organization associated with the order, the system product code and item description for the fulfilling or sourcing location is displayed. Up to 26 positions.

Line #

The current line number at the time the activity took place. This number might differ from the current line number if the Routing Engine split the line after initial creation in Order Orchestration because the original fulfilling location rejected it.

Which line number? The status history entry always lists the line number referenced in the status update request, even if the status update creates a new line number.

Example: Line 10 currently includes 5 units in picked status. A partial status update indicates to change the status of 3 units on the line to fulfilled status. This update changes the quantity of line 10 to 2, and creates a new line, line 11, for 3 units in fulfilled status. However, both status history entries list line number 10, since that was the line number referenced in the status update request. The Routing Engine does not write a separate status history record for the creation of line 11.

Under Review update: An update to the Under Review indicator creates a history record for each line on the order.

Pickup By Date update: An update to the Pickup By Date creates a history record.

Requesting System Line Number

The line number identifying the order line in the requesting location. From the line_item_no passed in the submit order message. A single line from the requesting system can create multiple order lines in Order Orchestration if the Allow Split Line preference is selected.

Quantity

The order line quantity at the time the activity took place. Might differ from the current quantity if the line was rejected by the original fulfilling or sourcing location and split by the Routing Engine at reassignment, or if the transaction was a partial status update.

Status

The status as a result of the activity indicated. See Order and Line Statuses.

Note:

When an order is rejected and it cannot be reassigned and, as a result, the Routing Engine changes its status to unfulfillable, 2 history records are written: 1 for the rejected status, and 1 for the unfulfillable status.

Under Review update: An update to the Under Review indicator creates a history record using the order-level status, even if the status of an individual line is different; however, this update does not affect the actual status of individual lines.

Example: An order includes a line in polled status and a line in new order status, so the status of the order is open. You update the Under Review indicator for the order. The history record indicates a status of open on both lines, although the status of the polled and new order lines does not change.

Location

The code and description of the location where the change occurred, or which requested the status change.

Under Review update: An update to the Under Review indicator creates a history record using the current fulfilling location for the order, regardless of the location that submitted the update.

Locations for ship-for-pickup order: The location listed when a ship-for-pickup order is intransit (and then immediately to intransit polled) is the sourcing location, while the location listed when a ship-for-pickup order is received or fulfilled is the pickup location. If the pickup location receives a partial quantity, splitting the order line, the pickup location is listed for the received quantity and the quantity that is still in transit. See Ship For Pickup Order for background.

Location for auto-cancellation: The location listed when the order line is automatically canceled because the customer did not pick up the order is the pickup location.

Date/Time

The date and the time when the activity occurred, such as the status changed; see Require Status Update for Assigned Orders? for a discussion.

User

Indicates the user who performed the activity, such as creating the order or updating the status of the order or line:

Note:

  • The employee ID specified in an inbound message might not be a valid user ID in Order Orchestration.

  • The user ID is truncated if it exceeds 10 positions.

Source

Indicates how the order was created or updated:

Transaction Notes

Possible transaction notes from the xom_status_history table:

  • Address Change Applied: Click the details icon (Illustrates the details icon.) to advance to the Order History Detail - Address Change Window where you can review the old and new ship to address.

  • Accepted Status Update Restricted (where Accepted is the status specified in the order status update request message: An order status update request message indicated a status change for a canceled line, but the Restrict Reassignment of Canceled Line preference was selected. A similar message is also written if the order line status was Fulfilled. You can use the Status Restricted Report to review order lines whose status updates were restricted through the Order Status Update request message.

    Note:

    Even if the status update was restricted, if the order status update request indicated shipping details such as the shipper or tracking number, this information is also displayed in the Transaction Notes, although the shipping information is not saved elsewhere in the database.
  • Auto-canceled: auto-cancel reason: Indicates the auto-cancel reason code used by the auto-cancel unclaimed orders job to cancel an unclaimed pickup order line.

  • Carrier: The carrier (shipping agent), if any, passed in the status update message from the assigned fulfilling location, or specified through Store Connect.

  • Carton #: The carton number, if any, passed in the status update message from the placed (originating) location when it changes the order or line status of a ship for pickup order to Intransit, or when the status is set to Fulfilled.

  • Note: The status reason note, if any, passed in the status update message.

  • Pickup By Date: Indicates the Pickup By Date assigned, either automatically when the order is eligible for pickup, or when the existing date is changed by a user or web service update.

  • Pickup By Date Removed: Indicates that the Pickup By Date has been removed due to a status change, such as when the line is fulfilled. rejected, or canceled.

  • Posted to RICS: The order was submitted to RICS if you use Order Fulfillment through RICS Integration.

  • Private Data Anonymized: The order has been anonymized, either through the Completed Order Private Data Purge job, or through the ForgetPrivateData web service request.

  • Reason Code: The status reason code, if any, passed in the status update message.

  • Reason description: The description of the cancellation reason selected when an associate canceled the line in Store Connect.

  • Reject - reason description: The description of the reject reason selected when an associate rejected the line in Store Connect.

  • RICS Release Reservation Message Sent: Order Orchestration: A message was posted to RICS to release the reservation for an order because it has been canceled or rejected. Occurs if you use Order Fulfillment through RICS Integration.

  • [Status] Status Update Restricted. Requested by Location [Loc]:

    • A status update request message attempted to change the status of an order or line in canceled status, but the Restrict Reassignment of Canceled Line preference was selected. The requested status and requesting location are indicated in the history message. See the related preference for a discussion.

    • A status update request message attempted to change the status of an order or line in fulfilled status. Changing the status of a fulfilled order or line is supported only through the Order screen or the Edit Order Item window, but not through the status update request message. However, if the request message specified a shipper and/or tracking number, this information is displayed here.

  • Tracking #: The tracking number, if any, passed in the status update message from the assigned fulfilling location, or specified through Store Connect.

  • Unable to create RICS message: There was an unrecoverable error in the information to be submitted through RICS, such as alphabetical characters in a numeric field. Occurs if you use Order Fulfillment through RICS Integration.

  • Under Review: The current setting of the Under Review indicator, indicating:

    • Yes = the fulfilling system needs to delay shipping or fulfilling the order until the flag is cleared

    • No = the order is eligible for fulfillment

      If an open order was submitted through the RICS integration and the setting of the Under Review flag changes, the message for an order line assigned to a RICS location indicates: Under Review: No; RICS Under Review Message Sent, where No is the new setting of the Under Review flag.

Science Engine responses: If you use weighted brokering, responses from the Science Engine can produce the following Transaction Notes:

  • Exceed Maximum Number of Splits: The Science Engine returned a code indicating that the entire order could not be fulfilled without exceeding the Maximum Order Splits, so the entire order is unfulfillable. This response can occur for a single-line order that could have been fulfilled by splitting the line, but split line is not enabled.

    A reason code of 1000 is stored as the UNFULFILLABLE_REASON_CODE in the XOM_STATUS_HISTORY table.

  • Not Enough Inventory and No Backorder Location: The Science Engine returned a code indicating that the entire order, or a line on the order, could not be fulfilled because there was not sufficient inventory on-hand, and there was not an eligible location that supported backorders.

    A reason code of 2000 is stored as the UNFULFILLABLE_REASON_CODE in the XOM_STATUS_HISTORY table if the entire order was unfulfillable, and a reason code of 3000 is stored for an individual line that was unfulfillable while other line(s) could be fulfilled.

  • Not Fulfilled due to Split Not Allowed: The Science Engine returned a code indicating that the entire order could not be fulfilled without splitting one or more order lines, and Allow Split Line was not selected. The same message is displayed if the order could not be fulfilled without splitting the order, and Allow Split Order was not selected.

    A reason code of 7000 is stored as the UNFULFILLABLE_REASON_CODE in the XOM_STATUS_HISTORY table if the entire order was unfulfillable, and a reason code of 6000 is stored for an individual line that was unfulfillable while other line(s) could be fulfilled.

Additional Science Engine reason codes: The following reason codes are stored in the UNFULFILLABLE_REASON_CODE in the XOM_STATUS_HISTORY table, but no Transaction Notes are displayed, based on responses from the Science Engine:

  • 4000: An order or line had to be assigned to a backorder location that was currently without sufficient inventory, because the entire order could not be assigned to locations with sufficient inventory without exceeding the Maximum Order Splits. For example, an order includes a line for 1 unit of item A, and another line for 2 units of item B. Location 100 can fulfill the line for item A. Locations 200 and 300 each have 1 unit item B. The Maximum Order Splits is set to 2. If location 200 supports backorders, the line with 2 units of item B is assigned there.

  • 5000: An order or line had to be assigned to a backorder location that was currently without sufficient inventory, because there were no locations that had the inventory on-hand; however, this was not the result of the Maximum Order Splits setting being exceeded.

  • 8000: An order or line could have been assigned to locations with inventory if split order or line were allowed; but since the order or line could not be split, it was assigned to a backorder location that was currently without sufficient inventory.

About status reason codes and notes: The assigned fulfilling or sourcing location might pass a status code or note, or both, indicating why it rejects an order or line; or a location might pass a status code or note, or both, indicating why to cancel an order or line.

About rejection and cancellation reason codes: Defined through the Reason Codes screen in Modern View, and available for the store associate to use when rejecting or canceling an order or item if the code is flagged as Active.

Multiple lines: The Transaction Notes can run to more than one line if multiple types of information need to be displayed. For example, if the status update request included a carrier, tracking number, carton number, and Pickup By Date assignment, the first line includes the carrier, tracking number, and carton number, and the second line indicates the Pickup By Date.

Contents too long? If the contents of any one line are too long for the allotted space, an ellipsis (...) indicates that there is more content. This might occur if, for example, the reason notes are too long to be displayed. However, you can drag the Transaction Notes field to the right at the column heading to lengthen the displayed information.

Details

If the ship to address changed, click the details icon (Illustrates the details icon.) to advance to the Order History Detail - Address Change Window where you can review the details of a shipping address change, including the address before and after the change.

RICS Log tab

This tab displays the history for each communication between Order Orchestration and Oracle Retail Integration Cloud Service (RICS).

This tab is displayed only if the Online flag is selected at the RICS Integration tab of the System screen for at least one system in the organization.

These records are stored in the RICS_LOG table in the database. The daily cleanup job automatically deletes these records based on the number of days specified in the RICS Log History field at the Tenant-Admin screen; however, if the record has a Retry Status of Failed it is not eligible to be purged.

For more information: See Order Fulfillment through RICS Integration for background and more information.

Date/Time

The date and time when the message activity took place.

Retry Status

Possible statuses are:

  • Failed = The message failed to be sent to RICS, typically through some sort of communication failure. In the case of an outbound message,

    RICS log records with a Retry Status of Failed are not eligible to be purged. Instead, a cleanup job attempts to re-send these messages every hour, in case RICS was temporarily down when they were initially sent. Messages are sent in first-in first-out (oldest first) order.

  • Reprocessed = Order Orchestration re-sent the outbound message to RICS.

  • Success:

    • The message was successfully sent or received, or,

    • The message failed due to invalid data, such as an alphabetical character in a numeric field; in this case, the message is not eligible to be re-sent and the RICS log entry is eligible for purge.

Location

The code and description of the fulfilling location for the order.

Response Code

The response code identified for the success or failure. Possible response codes include:

  • Success = The message was successfully posted to RICS.

  • 303 = Might indicate a connection problem.

  • 500 = Might indicate that the URL was incorrect or temporarily unavailable.

  • 502 = Might indicate that the connection timed out.

Message Type

The type of message:

  • Create Fulfillment Order: The order or line was posted to RICS for fulfillment in a warehouse or store location.

  • Release Order Reservation: The order or line was canceled or rejected, or reassigned to a different location for fulfillment, so inventory can be be released for other orders.

  • Status Update: The status of the order or line has changed.

  • Send Under Review: The setting of the Under Review flag for an open order that was previously submitted as changed.

Request

Click the display icon (Illustrates the display icon.) to display the request message in the RICS Log Message window.

Response

Click the display icon (Illustrates the display icon.) to display the response message in the RICS Log Message window.

Order History Detail - Address Change Window

Purpose: Use the Order History Detail - Address Change window to review the changes made to the shipping address on a delivery order. The old ship to address is on the left side of the window and the new updated ship to address is on the right side of the window with the changes indicated in red for comparison.

Used for the Store Connect module.

Submitting address changes: A store associate with authority to edit the shipping address can update the address in Store Connect.

Customer name anonymized? If the customer data on an order has been anonymized (deleted and replaced with asterisks), the customer name is displayed as:


Illustrates the old and new ship-to names and addresses replaced by asterisks.

See Anonymizing Data for background.

How to display this window: Select the icon (Illustrates the edit icon.) in the Details column at the History tab of the Order screen. This icon is displayed only if a store associate updated the shipping address on a delivery order in Store Connect.

Fields at this window

Field Description
User

The user ID of the person who performed the activity.

Date / Time

The date and time when the shipping address change was received. Format is based on the settings defined through the Users screen.

Old Ship To

The ship-to name and address before applying the change. Includes:

  • name: prefix (such as Mr. or Dr.), first name, middle name, last name, and suffix (such as Jr. or Esq.)

  • company name

  • first address line

  • apartment, unit, or suite number (prefixed by the label Apt / Unit #:)

  • address line 2

  • address line 3

  • address line 4

  • city, state, postal or zip code, country code

  • daytime phone number (prefixed by the label Day:)

  • evening phone number (prefixed by the label Eve:)

  • email address

    Note:

    Not all of the information above might be available for each customer. Also, the Attention field, if any, is not displayed.

Customer anonymized? If the customer data on an order has been anonymized, asterisks are displayed for the ship-to information. See Anonymizing Data for background.

New Ship To

The ship-to name and address with the changes indicated in red. Includes the same name and address fields as the Old Ship To.

Note:

The system does not flag changes in case; for example, updating the country from US to us, in red.

Customer anonymized? If the customer data on an order has been anonymized, asterisks are displayed for the ship-to information. See Anonymizing Data for background.

System Products

Purpose: Use the System Products window to review the existing system products for an item on an order.

Used for the Routing Engine module.

How to display this window: Available if Use Routing Engine is selected at the Tenant screen. Click the system product icon (Illustrates the system product icon.) next to an item on the Details tab of the Order screen.

All fields at this window are display-only.

Field Description
Organization

The organization associated with the order. The code and name are separated by a hyphen (-).

Product

The product on the order line. The code and name are separated by a hyphen (-).

System

See system.

System Product

See system product.

Master Style

See master style.

Browse Order Item

Purpose: Use the Browse Order Item window to view the details and activity of an order line.

Used for the Routing Engine module.

How to display this window: Click the display icon (Illustrates the display icon.) for an item at the Details tab of the Order screen.

Note:

Available if Use Routing Engine is selected at the Tenant screen. If you have Order Maintenance authority and the Use Split Order preference is selected, you advance instead to the Edit Order Item window.

All fields on this window are display-only.

Fields Description
Order Number

See Order Number.

Requesting System Line Number

The line number identifying the order line in the requesting location. From the line_item_no passed in the submit order message. A single line from the requesting system can create multiple order lines in Order Orchestration if the Allow Split Line preference is selected.

Line #

The line number of the item on the order in Order Orchestration.

How might the line numbers be different? It is possible for the line number, requesting system line number, and original line number to differ; for example:

  • Split by the Routing Engine:

    • The Routing Engine assigns the order to location A, and then Location A rejects the order

    • The Routing Engine assigns half the quantity to location B, and half to location C. Result: the quantity in location B is now line #1; the quantity in location C is now line # 2

  • Partial status update: The entire quantity of 5 was originally assigned to location A, but location A rejected 3 units. Result: the quantity in location A is now line #1; the rejected quantity, now reassigned or unfulfillable, is now line #2

Different line numbers even if not split: It is possible for the Order Orchestration line number and requesting system line number to differ if, for example, the requesting system sends line 20 of a multi-line order to Order Orchestration (Requesting system line number); when the Routing Engine creates the order, it assigns a line number of 1 because it is the only order line received from the requesting system.

Line numbers might not be consecutive: If the Routing Engine splits a line or receives a partial status update, the line numbers assigned in Order Orchestration to the split lines might not be consecutive. For example, a system sends 3 lines, which produce lines 1, 2, and 3. Subsequently, the Routing Engine receives a partial update for line 1 and creates line 4 for the quantity in the updated status.

Original Line #

The line number from which this line was split. Set to 0 if the line was not split after initial order creation.

Item #

The system product code for the user’s Default Organization. If the user’s Default Organization is not in the organization associated with the order, the system product code for the fulfilling or sourcing location is displayed. Up to 26 positions. Display-only.

No item #? If your user ID is not assigned a Default Organization through the Users screen, the Item # might not be displayed here.

Item Description

The name of the product.

Line Status

See Order and Line Statuses for a listing of possible statuses.

(Field label varies depending on the type of order)

Sourced = The location that transfers the inventory for a ship-for-pickup order to the pickup location.

Pickup = The location that the customer selected to pick up the ship-for-pickup order.

Fulfilling = Specified for the following types of orders:

  • Delivery order: The location that ships the order to the customer. This location might have been specified by the placed (originating) location, or selected by the Routing Engine based on the rules set up at the Preferences screen.

  • Pickup order: The location that the customer selected to pick up the order.

Note: An integrated system might use the term “fulfilling location” differently.

Pickup By Date

The last date when the customer can pick up a pickup or ship-for-pickup order line before the line is automatically canceled by the Auto Cancel Unclaimed Pickup Orders job. The Pickup By Date is assigned automatically when the order line is first eligible for pickup, based on the settings at the Fulfillments tab of the Preferences screen, but the date can be overridden through a web service message or at a screen.

This field is displayed only for a pickup or ship-for-pickup order, and only if the auto-cancel option is enabled, based on the settings at the Preferences screen. Even if displayed, the field is blank if the order line is not ready for pickup.

See Auto-Cancel Unclaimed Orders for background and more information.

Quantity

The quantity that is currently assigned to the fulfilling, sourcing, or pickup location. This quantity might be different from the Original quantity if:

  • the Allow Split Line preference is selected, and the Routing Engine split the line across multiple fulfilling or sourcing locations after it was initially rejected by the first location, or

  • the Allow Partial Update preference is selected, and the Routing Engine split the line because a location processed a partial status update.

Original Quantity

The quantity of the item that was originally assigned to the fulfilling or sourcing location. See the Quantity field, above, for a discussion.

Fulfilled Quantity

The quantity of the item shipped to the customer (delivery order) or picked up by the customer pickup order, ship-for-pickup order). Updated when the Routing Engine receives a status update message indicating that the new item status is fulfilled.

Price

The amount the customer paid for the item, preceded by the symbol of the currency on the order. The screen displays a 2-position decimal, although the database stores 4 positions. If no amount was passed from the originating system, the amount indicated is 0.

Tax

The total tax amount for this order line, as passed in the SubmitOrder message. Preceded by the symbol of the currency on the order.

Prorating tax for split lines: If a line splits, the tax amount is prorated across the split lines. This prorating can result in a rounding discrepancies of a few pennies.

Example: The total tax amount for 3 units is $1.00. If the line is split across 3 locations, the tax amount for each location is $.33, resulting in a rounding discrepancy of a cent.

Multiple tax amounts? If multiple tax amounts are included (for example, GST and PST), the total tax amount is saved in the xom_item table and displayed here.

Ext. Price

The price of the item times the current quantity, preceded by the symbol of the currency on the order. The screen displays a 2-position decimal, although the database stores 4 positions. If no amount was passed from the originating system, the amount indicated is 0.

Status Date

The last date and time when the status of the order changed.

Polled Count

Indicates the number of times the fulfilling or sourced location has sent a fulfillments message for information on assigned delivery orders, or the pickup location has sent an intransit message for information on assigned ship-for-pickup orders, and the Routing Engine has responded with a message that included this order line.

Polled status updates: This counter is used only if the requesting location’s system has the Require Status Update flag at the System screen selected; otherwise, the Routing Engine sets the poll count to 1 when it receives the fulfillment request message, and sets the status to polled.

See Require Status Update for Assigned Orders? for a discussion.

Resetting the polled count: Changing the status of an order or order line to new_order, canceled, or fulfilled resets the polled count to 0.

Intransit status updates for ship-for-pickup orders: When the sourcing location updates the status of a ship-for-pickup line to intransit, the Polled Count is set to 0. Then when the assigned pickup location sends an intransit message, the Polled Count is reset to 1. This counter is used for ship-for-pickup orders if the Require Status Update flag for the system is selected.

Resetting the polled count: Changing the status of an order or order line to new_order, canceled, or fulfilled resets the polled count to 0.

Edit Order Item

Purpose: Use the Edit Order Item window to view the details and activity of an item on an order, or update the item’s status, or fulfilling or sourcing location.

Used for the Routing Engine module.

How to display this window: Click the edit icon (Illustrates the edit icon.) for an item at the Details tab of the Order screen.

Note:

Available if Use Routing Engine is selected at the Tenant screen. You advance to this window only if you have Order Maintenance authority and the Use Split Order preference is selected; otherwise, you advance to the Browse Order Item window.

Options at this window

Option Procedure
update the status of an order line
  • Select the new status from the Line Status field for each line you want to change. If the Allow Partial Updates preference is selected, the Quantity field becomes enterable.

  • Optionally, enter a different quantity to process a partial status update.

  • Click Save.

Note:

You can change the status of a canceled line here regardless of whether the Restrict Reassignment of Canceled Line preference is selected.

Status change restrictions:

  • You cannot change the status of a fulfilled line on a ship-for-pickup order to rejected; instead, you can change the sourcing location if the status was incorrectly set to fulfilled.

  • When you select a status from the Line Status field for a delivery order, the fulfilling location field for that line becomes display-only. Similarly, when you select a status from the Line Status field for a ship-for-pickup order, the sourcing location field for that line becomes display-only. In order to change both the line’s status and its fulfilling or sourcing location, complete 1 update and then return to the Order screen to complete the other update.

  • If the Allow Partial Updates preference is selected and you change the Quantity, you cannot enter a quantity of zero or a number that exceeds the current quantity; also, you cannot change a partial quantity to polled or new_order status.

  • You cannot change the status of a full or partial order line to open or complete, since these are system-assigned statuses.

Updates:

  • When you change the line status to new_order, canceled, or fulfilled, the Polled Count for the order line is reset to 0.

  • When you change the line or quantity status to rejected:

    • delivery order: The Routing Engine reassigns the line or quantity and changes the status to new_order if another eligible location exists and if the Search Retries limit hasn’t been reached; otherwise, the Routing Engine changes its status to unfulfillable. There may be a brief delay before the update is applied.

      When you use RICS order fulfillment, rejecting a line on a delivery order triggers a release reservation request for the prior location and a new fulfillment order request for the new location to RICS. See Order Fulfillment through RICS Integration for more information.

    • pickup order: The Routing Engine changes the status to unfulfillable.

    • ship-for-pickup order: The Routing Engine reassigns the line or quantity to a different sourcing location, and changes the status to new_order if another eligible sourcing location exists and if the Search Retries limit hasn’t been reached. For a ship-for-pickup order, a rejected status update generally indicates that the inventory was not received from the sourced location, or that it was defective. There may be a brief delay before the update is applied.

  • If Auto-Cancel Unclaimed Orders is enabled, a status change on a ship-for-pickup order or pickup order can update the Pickup By Date based on the related settings from the Fulfillment tab of the Preferences screen; for example, changing the status from picked to canceled, rejected, or fulfilled clears the Pickup By Date. See Auto-Cancel Unclaimed Orders for more information on the rules that control setting the Pickup By Date when you have auto-cancel configured.

  • A status change can update the reserved quantity for the product location, depending on the setting of the Include Reserved flag for the system and any Reserved Statuses for the system. See the System screen for more information.

  • Order Orchestration decreases the quantity of the current line and creates a new order line in the specified status if you process a partial status update.

  • Order Orchestration tracks the status history. See the History tab.

  • The status of the order might also change, depending on its current status. See order status.

For more information: See Order and Line Statuses (Splitting Preference Turned On) for more information on automatic status updates for orders fulfilled through Store Connect.

update the shipment or sourced location for an item on a delivery or pickup order

Which locations are available for selection? The dropdown list includes each location that supports the type of order:

  • For a delivery order, the location must be flagged as Delivery Available.

You cannot select:

  • Any location where the line was previously assigned, even if it no longer supports the type of order.

  • The IN PROCESS location. See the Acknowledge Order Before Brokering preference for background.

Note:

The window does not prevent you from selecting a location:
  • where the item is not available. If you do so, and if the Include Reserved flag is selected at the System screen, Order Orchestration creates a new record of the product location.

  • that is not associated with the zone for the order’s shipping location if you use zone fulfillment.

Restrictions:

  • You cannot change the fulfilling location for a pickup order.

  • When you select a location from the fulfilling location field for a delivery order, the Line Status field becomes display-only. In order to change both the line’s status and its fulfilling location, complete one update and then return to the Order screen and select the Edit icon again to complete the other update.

Updates:

  • If you select the default unfulfillable location, the status of the order changes to unfulfillable.

  • Order Orchestration tracks the location assignment history. See the History tab.

  • If the system is configured to track reserved quantity and the line is in an applicable status, Order Orchestration updates the reserved quantity for the product location or creates the product location if it does not already exist. Otherwise, Order Orchestration does not create or update a product location.

When you use RICS order fulfillment, changing the fulfilling location for a line on a delivery order triggers a release reservation request for the prior location and a new fulfillment order request for the new location to RICS. See Order Fulfillment through RICS Integration for more information.

update the sourced location for a ship-for-pickup order

Which locations are available for selection? The dropdown list includes each location that is flagged as Ship For Pickup Sourcing Available.

You cannot select:

When you select a new sourcing location, the Line Status field becomes display-only. In order to change both the line’s status and its sourcing location, complete one update and then return to the Order screen and select the Edit icon again to complete the other update.

Note: The window does not prevent you from selecting a location:

  • where the item(s) are not available. If you do so, and if the Include Reserved flag is selected at the System screen, Order Orchestration creates a new record of the product location(s).

  • that is not associated with the zone for the order’s shipping location if you use zone fulfillment.

update the Pickup By Date for a pickup or ship-for-pickup order

This option is available only if the Auto-Cancel Unclaimed Orders option is enabled, and the order line is in a status indicating that it is ready for pickup:

  • Picked, if the order type is pickup, or if the order type is ship-for-pickup and the sourcing location is the same as the pickup location; otherwise,

  • Received, if the order type is ship-for-pickup, and the sourcing location is different from the pickup location. In this situation, the line is not eligible for pickup until the sourcing location has transferred the inventory to the pickup location, and the pickup location has received it.

In this case, the Pickup By Date is required, and must be in the future.

For a pickup order assigned to a Store Connect location, a new Pickup Ready Reminder to Customer (Pickup Order) email is generated, indicating the new Pickup By Date.

Fields at this window

Fields Description
Order Number

See Order Number. Display-only.

Requesting System Line Number

The line number identifying the order line in the requesting location. From the line_item_no passed in the submit order message. A single line from the requesting system can create multiple order lines in Order Orchestration if the Allow Split Line preference is selected. Display-only.

Line #

The line number of the item on the order in Order Orchestration. Display-only.

How might the line numbers be different? It is possible for the line number, requesting system line number, and original line number to differ; for example:

  • Split by the Routing Engine:

    • The Routing Engine assigns the order to location A, and then Location A rejects the order

    • The Routing Engine assigns half the quantity to location B, and half to location C. Result: the quantity in location B is now line #1; the quantity in location C is now line # 2

  • Partial status update: The entire quantity of 5 was originally assigned to location A, but location A rejected 3 units. Result: the quantity in location A is now line #1; the rejected quantity, now reassigned or unfulfillable, is now line #2

Different line numbers even if not split: It is possible for the Order Orchestration line number and requesting system line number to differ if, for example, the requesting system sends line 20 of a multi-line order to Order Orchestration (Requesting system line number); when the Routing Engine creates the order, it assigns a line number of 1 because it is the only order line received from the requesting system.

Line numbers might not be consecutive: If the Routing Engine splits a line or receives a partial status update, the line numbers assigned in Order Orchestration to the split lines might not be consecutive. For example, a system sends 3 lines, which produce lines 1, 2, and 3. Subsequently, the Routing Engine receives a partial update for line 1 and creates line 4 for the quantity in the updated status.

Original Line #

The line number in Order Orchestration from which this line was split. Set to 0 if the line was not split after initial order creation. Display-only.

Item #

The system product code for the user’s Default Organization. If the user’s Default Organization is not the organization associated with the order, the system product code for the fulfilling or sourcing location is displayed. Up to 26 positions. Display-only.

No item #? If your user ID is not assigned a Default Organization through the Users screen, the Item # might not be displayed here.

Item Description

The name of the product. Display-only.

Line Status

See Order and Line Statuses for a listing of possible statuses, and see update the status of an order line, above, for instructions on updating a status, including information on processing a partial status update if the Allow Partial Updates preference is selected.

(Field label varies depending on the type of order)

Shipment = The location that ships a delivery order to the customer. This location might have been specified by the placed (originating) location, or selected by the Routing Engine based on the rules set up at the Preferences screen.

Pickup = The location a customer selected to pick up a pickup order. In this case, the field is display-only.

Sourced = The location that transfers the inventory for a ship-for-pickup order to the pickup location. The sourcing location might have been specified by the placed (originating) location, or selected by the Routing Engine based on the rules set up at the Preferences screen.

See update the shipment or sourced location for an item on a delivery order or update the sourced location for a ship-for-pickup order above for instructions on updating the assigned location.

Note: If the location previously supported this order type and is now flagged at the Preferences screen to no longer support it, no location is displayed here.

Pickup By Date

The last date when the customer can pick up a pickup or ship-for-pickup order line before the line is automatically canceled by the Auto Cancel Unclaimed Pickup Orders job. The Pickup By Date is assigned automatically when the order line is first eligible for pickup, based on the settings at the Fulfillments tab of the Preferences screen, but the date can be overridden through a web service message or at a screen.

This field is available only if the Auto-Cancel Unclaimed Orders option is enabled, and the order line is in a status indicating that it is ready for pickup:

  • Picked, if the order type is pickup, or if the order type is ship-for-pickup and the sourcing location is the same as the pickup location; otherwise,

    Received, if the order type is ship-for-pickup, and the sourcing location is different from the pickup location. In this situation, the line is not eligible for pickup until the sourcing location has transferred the inventory to the pickup location, and the pickup location has received it.

    In this case, the Pickup By Date is required, and must be in the future.

    For a pickup order assigned to a Store Connect location, a new Pickup Ready Reminder to Customer (Pickup Order) email is generated, indicating the new Pickup By Date.

    See Auto-Cancel Unclaimed Orders for background and more information.

Quantity

The quantity that is currently assigned to the fulfilling, pickup, or sourcing location. This quantity might be different from the Original quantity if:

  • the Allow Split Line preference is selected, and the Routing Engine split the line across multiple locations after it was initially rejected by the first location, or

  • the Allow Partial Update preference is selected, and the Routing Engine split the line because a location processed a partial status update.

This field is enterable if the Allow Partial Updates preference is selected and you specify a different Line Status. In this case, you can apply the new status to the entire line quantity, or process a partial status update. See update the status of an order line, above, for instructions.

Original Quantity

The quantity of the item that was originally assigned to the fulfilling, sourcing, or pickup location. See the Quantity field, above, for a discussion. Display-only.

Fulfilled Quantity

The quantity of the item shipped to the customer (delivery order) or picked up by the customer (pickup order or ship-for-pickup order). Updated when the Routing Engine receives a status update message indicating that the new item status is fulfilled. Display-only.

Price

The amount the customer paid for the item, preceded by the symbol of the currency on the order. The screen displays a 2-position decimal, although the database stores 4 positions. If no amount was passed from the originating system, the amount indicated is 0. Display-only.

Tax

The total tax amount for this order line, as passed in the SubmitOrder message. Preceded by the symbol of the currency on the order. Display-only.

Prorating tax for split lines: If a line splits, the tax amount is prorated across the split lines. This prorating can result in a rounding discrepancies of a few pennies.

Example: The total tax amount for 3 units is $1.00. If the line is split across 3 locations, the tax amount for each location is $.33, resulting in a rounding discrepancy of a cent.

Multiple tax amounts? If multiple tax amounts are included (for example, GST and PST), the total tax amount is saved in the xom_item table and displayed here.

Ext. Price

The price of the item times the current quantity, preceded by the symbol of the currency on the order. The screen displays a 2-position decimal, although the database stores 4 positions. If no amount was passed from the originating system, the amount indicated is 0. Display-only.

Status Date

The last date and time when the status of the order changed. Display-only.

Polled Count

Indicates the number of times the fulfilling or sourced location has sent a fulfillments message for information on assigned delivery orders, or the pickup location has sent an intransit message for information on assigned ship-for-pickup orders, and the Routing Engine has responded with a message that included this order line.

Polled status updates: This counter is used only if the requesting location’s system has the Require Status Update flag at the System screen selected; otherwise, the Routing Engine sets the poll count to 1 when it receives the fulfillment request message, and sets the status to polled .

See Require Status Update for Assigned Orders? for a discussion.

Resetting the polled count: Changing the status of an order or order line to new_order, canceled, or fulfilled resets the polled count to 0.

Intransit status updates for ship-for-pickup orders: When the sourcing location updates the status of a ship-for-pickup line to intransit, the Polled Count is set to 0. Then when the assigned pickup location sends an intransit message, the Polled Count is reset to 1. This counter is used for ship-for-pickup orders if the Require Status Update flag is selected for the system.

Resetting the polled count: Changing the status of an order or order line to new_order, canceled, or fulfilled resets the polled count to 0.

RICS Log Message

Purpose: Use the RICS Log Message window to view a request or response message for an order fulfilled through the Order Fulfillment through RICS Integration.

Used for the Routing Engine module.

How to display this window: Click the display icon (Illustrates the display icon.) in the Request or Response column for an entry at the RICS Log tab of the Order screen.

Note:

Available if the Active flag is selected at the Add or Edit External Service window, available from the External Services screen, and there are any RICS log records that have not been purged.

Optionally, you can copy the message from this window so you can paste it into a text editor for troubleshooting or research purposes.

For more information: See Order Fulfillment through RICS Integration for background.

Purchase Order Inquiry

Purpose: Use the Purchase Order Inquiry screen to search for and review purchase orders assigned to your vendors for fulfillment.

Used for the Supplier Direct Fulfillment module.

Customer or vendor name anonymized? If the vendor or customer data on a purchase order has been anonymized (deleted and replaced with asterisks), the name is displayed as:

*** ***

***

If the vendor data has been anonymized, searching by vendor name is not supported.

A purchase order is eligible to be anonymized only if it is no longer open, and a vendor is eligible to be anonymized only if there are no open purchase orders for the vendor.

See Anonymizing Data for background.

How to display this screen: Select Purchase Order Inquiry from the Home Screen or the Orders drop-down menu.

Note:

Available if Use Vendor Portal is selected at the Tenant screen. Only users with Purchase Order Inquiry authority can display this screen. See Roles for more information.

How to display purchase orders on this screen: When you first advance to the Purchase Order Inquiry screen, no purchase orders are displayed. Click Search to display purchase orders matching your search criteria or to refresh the purchase orders displayed.

View by purchase order or item: You can use the View Results By option to switch the information displayed:

  • Purchase Order: displays information about the entire purchase order, such as shipping address. With this view, if the purchase order includes more than one line, the Due Date displayed is based on the first line on the purchase order. This is the default view.

    Item: displays information about the line(s) on the purchase order, such as your item number, the vendor’s item number, and the ordered quantity.

  • Most of the same information is displayed whether you view results by purchase order or by item. The information always displayed includes the purchase order number, the sales order number, and the date when you created the purchase order.

Sort order: The purchase orders are sorted first based on the PO created (entered) date. Within that date, they are sorted by the date and time when the purchase order was submitted to the vendor for fulfillment.

How to view purchase order updates? Click Search to refresh the screen and show current purchase order information.

How many records displayed? The screen displays up to 50 purchase orders or items.

Options at this screen

Option Procedure
search for purchase orders and display customer and other header-level information
  • Leave the View Results By option set to Purchase Order.

  • Optionally, you can enter any search criteria at the top of the screen. See below for descriptions.

  • Click Search.

The screen displays up to 30 purchase orders.

search for purchase orders, and include item information among the information displayed
  • Set the View Results By option to Item.

  • Optionally, you can enter any search criteria at the top of the screen. See below for descriptions.

  • Click Search.

The screen displays up to 500 lines on purchase orders.

Case: The enterable fields on this screen are not case-sensitive for searching; for example, an entry of po123 matches a purchase order number of PO123.

view more information about the purchase order

Click the display icon (Illustrates the display icon.) next to a purchase order or item to advance to the Purchase Order screen, where you can view information about the purchase order such as:

  • sold-to and ship-to customer names and addresses

  • ship via and shipping instructions

  • order totals and messages

  • lines, including any special handling instructions or item-related messages

  • purchase order line history

    invoices that include any purchase order lines

If the Purchase Order screen is already open in another tab, you advance to that screen, where the previously-selected purchase order is displayed.

The information displayed at the Purchase Order screen is related to the purchase order as a whole, regardless of whether you have been reviewing results by item or by purchase order.

Fields at this screen

Fields Description
Search fields

Optionally, complete any of the fields below before you click Search to display purchase order or items that match your entries.

Organization

See organization. Defaults from the Default Organization from your user profile defined through the Users screen, but you can override it.

Vendor

Optionally, select a vendor associated with your organization from the drop-down list to display purchase orders assigned to that vendor. The name or description of the vendor is displayed. See Vendors for background.

Vendor name anonymized? If the data for a vendor on a purchase order has been anonymized (deleted and replaced with asterisks), searching by the vendor is not supported.See Anonymizing Data for background.

PO Number

Optionally, enter a full or partial number or code identifying the purchase order in the originating system, such as Order Administration or CWDirect, to display purchase orders that start with or match your entry. Can include numbers, letters, spaces, or special characters. Up to 50 positions.

Case: If the originating system includes any lowercase letters in the purchase order number, Order Orchestration converts them to uppercase when creating the purchase order.

Not case-sensitive for searching; an entry of A or a matches an purchase order number of A12345.

Order Number

Optionally, enter a full or partial number or code identifying the sales order in the originating system, such as Order Administration or CWDirect, to display purchase orders whose order numbers start with your entry. Up to 30 positions.

Not case-sensitive for searching; an entry of A or a matches an order number of A12345.

Date Created

Optionally, enter or select the PO entered date to display purchase orders created on that date. Might not be the same as the date when the sales order was created. Format is based on the settings from the Users screen.

Brand

Optionally, select a brand associated with your organization to display purchase orders for that brand. See the Brands screen in Modern View for background.

Status

Select a status to display purchase orders or lines that are in the selected status.

View Results By setting: If the View Results By option is set to Purchase Order, purchase orders that match the selected status are displayed; otherwise, if the View Results By option is set to Item, lines in the selected status are displayed.

Possible statuses are:

  • Cancelled: You have cancelled the line or the entire purchase order.

  • Complete (multi-line purchase orders only): The purchase order includes more than one line, and the line statuses include a combination of Cancelled and Shipped; there are no remaining open lines.

  • Held: The vendor has held the line(s) on the purchase order from processing. The vendor might put a line on hold if the vendor cannot fulfill it, and is requesting that you cancel the line. When a line on a purchase order is on hold, it is not eligible for pack slip generation or to be sent to an integrated vendor; or, if the purchase order line was already in process, the line is not eligible for shipment confirmation, and if the vendor uses the void/reprint option, the held line is omitted from the new pack slip.

  • In Process: The vendor has generated pack slips for the entire purchase order or the line, or sent the purchase order to the vendor’s system (and the batch was acknowledged, if required) if it is an integrated vendor.

  • New Order: The vendor has received the purchase order, but has not yet generated pack slips for the entire purchase order or the line; or, in the case of an integrated vendor, the vendor has not yet received the purchase order or required acknowledgment, if required.

  • Open (multi-line purchase orders only): The purchase order includes more than one line, and the line statuses include at least one line that is Held, In Process, or New Order.

  • Shipped: The vendor has confirmed shipment of the entire purchase order or the line.

    Note:

    If you switch the View Results By setting, your selection in this field is cleared, because possible line statuses differ from possible purchase order statuses.
Item #

Your item number or code. Optionally, enter a full or partial item code to display purchase orders or items if the items start with or match your entry. For example, if you sell items ABC111 and ABC123, entering ABC1 matches both of these items. Up to 35 positions.

Not case-sensitive for searching; an entry of A or a matches an item number of A12345.

Vendor Item #

The vendor’s item number or code. Optionally, enter a full or partial item code to display purchase orders or items if the vendor’s item codes start with or match your entry. For example, if the vendor has item codes XYZ222 and XYZ234, entering XYZ2 matches both of these retailer items. Up to 35 positions.

Not case-sensitive for searching; an entry of A or a matches a vendor item number of A12345.

Due Date

Optionally, select a date from the calendar control to display purchase orders or lines whose original due dates match your entry. When searching by:

  • purchase order: select a due date to display purchase orders whose earliest original due date (not revised due date) matches your selection.

  • item: select a due date to display lines whose original due date (not revised due date) matches your selection.

View Results By

Controls whether the information in the Search Result fields includes information about the entire purchase order or the lines on the purchase order. If you set this option to:

Search Result fields
PO Number

The number or code identifying the purchase order in the originating system, such as Order Administration or CWDirect.

Case: If the originating system includes any lowercase letters in the purchase order number, Order Orchestration converts them to uppercase when creating the purchase order.

Order Number

The number or code identifying the sales order in the originating system, such as Order Administration or CWDirect.

Vendor

The name or description of the vendor assigned to fulfill the purchase order. Up to 40 positions; truncated if it exceeds the allotted space.

Vendor anonymized? If the data for a vendor on a purchase order has been anonymized (deleted and replaced with asterisks), the name is displayed as:

*** ***

***

See Anonymizing Data for background.

Brand

The name or description of the brand associated with the purchase order. Displayed only when View Results By is set to Purchase Order. Up to 40 positions; truncated if it exceeds the allotted space.

Customer Ship To

Information about the shipping address on the order. Displayed only when View Results By is set to Purchase Order. Includes the first and last name or the company name.

Customer anonymized? If the data for a customer ship-to on a purchase order has been anonymized (deleted and replaced with asterisks), the customer name is displayed as:

*** ***

***

See Anonymizing Data for background.

Vendor Item #

The vendor’s item number or code. Displayed only when View Results By is set to Item. Hold the pointer over the Vendor Item # to display the vendor’s description of the item.

Item #

Your item number or code. Displayed only when View Results By is set to Item. Hold the pointer over the Item # to display a description of the item.

Date Created

The date when the purchase order was created. Might not be the same as the date when the sales order was created. Format is based on the settings from the Users screen.

Due Date

When View Results By is set to:

  • Purchase Order: the earliest original due date for a line on the purchase order.

  • Item: the original due date for the line.

    The revised due date, if any, is not displayed. No due date is displayed when you review results by purchase order if the entire purchase order is shipped. Format is based on the settings defined through the Users screen.

Order Status

The status of the purchase order. Displayed only when View Results By is set to Purchase Order. See the Status, above, for more information.

Line Status

The status of the line on the purchase order. Displayed only when View Results By is set to Item. See the Status, above, for more information.

Ordered Units

The total number of units of the item for the vendor to ship. Displayed only when View Results By is set to Item.

Display

Click the Display icon (Illustrates the display icon.) to advance to the Purchase Order screen, where you can review the details of the purchase order, such as the sold-to and ship-to address, items, history, and messages.

Purchase Order

Purpose: Use the Purchase Order screen to review detailed information about a purchase order, including:

  • the sold-to and ship-to addresses

  • shipping instructions and messages

  • the lines on the purchase order, including any special handling instructions or line-specific messages

  • history of activity related to the purchase order, such as processing and shipment, or cancellation, address change, cost change, or due date revision

  • invoices that include any lines on the purchase order

Used for the Supplier Direct Fulfillment module.

Reviewing purchase order information: Open the tab related to the information to be reviewed:

  • Header tab: order summary information, including the sold-to customer and the shipping address. This tab is open by default.

Customer name anonymized? If the customer data on a purchase order has been anonymized (deleted and replaced with asterisks), the sold-to and ship-to customer name is displayed as:


Illustrates the sold-to name and address replaced by asterisks.

See Anonymizing Data for background.

Note:

The Purchase Order Information at the top of the screen is always displayed regardless of which tab is open.
  • Detail tab: the lines on the purchase order. From this tab, you can also advance to additional windows displaying:
  • Invoices tab: information about each invoice that includes any lines from the purchase order. From this tab, you can also advance to the Invoice screen.

  • History tab: activity that has taken place for the purchase order, See the History tab for more information. From this tab, you can also advance to the Purchase Order History Detail window if there has been an address change request for the purchase order

  • Messages tab: sales order or gift messages. See the Messages tab for more information.

Note:

When you are on this screen, the information displayed is not automatically refreshed. For example, if you review the information at the Header tab and then click the History tab, any recent activity that has taken place while you were reviewing the Header tab is not displayed at the History tab. To refresh the information on this screen, exit the screen and then select it again from the Purchase Order Inquiry screen.

How to display this screen: Select Display for a purchase order at the Purchase Order Inquiry screen.

Note:

Available if Use Vendor Portal is selected at the Tenant screen. Only users with Purchase Order Inquiry authority can display this screen. See Roles for more information.

Fields at this screen

Fields Description
Purchase Order Information

unlabeled area at the top of the screen

Purchase Order Number

The number or code identifying the purchase order in the originating system, such as Order Administration or CWDirect. From the po_no in the CreateDSOrder message.

Case: If the originating system includes any lowercase letters in the purchase order number, Order Orchestration converts them to uppercase when creating the purchase order.

Date Created

The PO entered date provided by the retailer. Might not be the same as the date when the originating system submitted the purchase order to Order Orchestration. From the po_entered_date in the CreateDSOrder message. Format is based on the settings at the Users screen.

Sales Order Number

The number or code identifying the sales order in the originating system. From the order_id in the CreateDSOrder message.

Order Status

Possible statuses are:

  • Cancelled: You have cancelled the entire purchase order.

    Complete (multi-line purchase orders only): The purchase order includes more than one line, and the line statuses include a combination of Cancelled and Shipped; there are no remaining open lines.

  • Held: The vendor has held the line(s) on the purchase order from processing. The vendor might put a line on hold if the vendor cannot fulfill it, and is requesting that you cancel the line. When a line on a purchase order is on hold, it is not eligible for pack slip generation or to be sent to an integrated vendor; or, if the purchase order line was already in process, the line is not eligible for shipment confirmation, and if the vendor uses the void/reprint option, the held line is omitted from the new pack slip.

  • In Process: The vendor has generated pack slips for the entire purchase order or the line, or sent the purchase order to the vendor’s system (and the batch was acknowledged, if required) if it is an integrated vendor.

  • New Order: The vendor has received the purchase order, but has not yet generated pack slips for the entire purchase order or the line; or, in the case of an integrated vendor, the vendor has not yet received the purchase order or required acknowledgment, if required.

  • Open (multi-line purchase orders only): The purchase order includes more than one line, and the line statuses include at least one line that is Held, In Process, or New Order.

  • Shipped: The vendor has confirmed shipment of the entire purchase order.

Brand

The name or description of the brand associated with the purchase order. See the Brands screen in Modern View for background. Identified through the brand_cd in the CreateDSOrder message. If the brand name has changed, the name in effect when the purchase order was created is displayed.

Placed

The code and description of the location originating the sales order. From the requesting_location_cd in the CreateDSOrder message. Typically identifies your distribution center. Separated by a hyphen (-).

Vendor

The name or description of the vendor assigned to fulfill the purchase order. Up to 40 positions. The vendor code follows in parentheses. Up to 10 positions. From the vendor_cd in the CreateDSOrder message.

Vendor name anonymized? If the data for a vendor on a purchase order has been anonymized (deleted and replaced with asterisks), searching by the vendor is not supported.See Anonymizing Data for background.

Organization

The name or description of the organization associated with the purchase order. See organization.

 

Pending address change request? The screen displays a message in red if there is an address change request submitted to the vendor and pending approval. Use the Purchase Order History Detail window to review the requested change.

This message continues to be displayed even if the vendor confirms shipment of the line(s) without accepting or rejecting the address change.

Header tab: Header summary fields

This area displays additional summary information about the order.

Next Due Date

The earliest due date on any of the lines on the purchase order, regardless of whether the earliest due date has passed. Blank if the entire purchase order has shipped. Format is based on the settings at the Users screen.

Ship Via

The code and description identifying the preferred shipper to use for the purchase order, separated by a hyphen. From the carrier_cd for the first item in the CreateDSOrder message. Not updated at shipment, even if the vendor specifies a different carrier. If the carrier description has changed, the description in effect when the purchase order was created is displayed.

Gift

Set to Y if the sales order is a gift order; in this case, no prices, charges, or totals print on the pack slip. From the gift setting in the CreateDSOrder message.

Buyer

The code and name of the buyer for the purchase order. From the carrier_cd for the first item in the CreateDSOrder message. Separated by a hyphen (-).

Shipping Instructions

The general shipping instructions for the order. From the shipping_instructions in the CreateDSOrder message. CWDirect and Order Administration System include shipping instructions such as DRP SHP ORD#00012025, where 12025 is the sales order number.

There may be additional instructions for the purchase order, such as customization instructions, gift messages, or order messages at the Browse Detail Customizations window, Browse Purchase Order Detail Messages window, and Messages tab,

Ship Complete

Set to Y if the purchase order should be shipped in a single shipment. From the ship_complete setting in the CreateDSOrder message. Informational only; does not control pack slip generation.

Total

The purchase order total, including the extended prices of all detail lines. Does not include additional charges, freight, additional freight, tax, or tax on freight. The currency symbol displayed is based on the vendor_currency_cd in the CreateDSOrder message.

Discount

The discount percentage or discount amount specified in the CreateDSOrder message. Zeros are displayed if no discount was specified in the message. Separated by a slash (/). From the discount_percentage and discount_amount in the CreateDSOrder message. The currency symbol displayed for the discount amount is based on the Currency specified for the purchase order.

Currency

The code identifying the currency on the sales order. Controls the currency symbol displayed for the purchase order. From the vendor_currency_cd in the CreateDSOrder message.

Header tab: Address fields

This area displays name and address information about the sold-to and ship-to.

Sold To

The customer who placed the sales order. Includes:

  • name: prefix (such as Mr. or Dr.), first name, middle name, last name, and suffix (such as Jr. or Esq.)

  • company name

  • first address line

  • apartment, unit, or suite number (prefixed by the label Apt / Unit #:)

  • address line 2

  • address line 3

  • address line 4

  • city, state, postal or zip code, country code

    Note:

    If the originating system includes any lowercase letters in the postal code, Order Orchestration converts them to uppercase when creating the purchase order.
  • daytime phone number (prefixed by the label Day:)

  • evening phone number (prefixed by the label Eve:)

  • email address

    Note:

    Not all of the information above might be available for each customer. At a minimum, the customer information must include:
  • first and last name or company

  • first address line

  • city, postal or zip code, and country code

From the sold_to information in the CreateDSOrder message.

Customer anonymized? If the data for a customer sold-to on a purchase order has been anonymized (deleted and replaced with asterisks), the customer name is displayed as asterisks. See Anonymizing Data for background.

Ship To

The customer to receive the line(s) on the purchase order. Includes the same information as the sold-to customer name and address, listed above. From the ship_to information in the CreateDSOrder message.

Customer anonymized? If the data for a customer ship-to on a purchase order has been anonymized (deleted and replaced with asterisks), the customer name is displayed as asterisks. See Anonymizing Data for background.

Header tab: Sales Order Summary fields
Pay Method

The description of the payment method on the sales order. From the tender_description in the CreateDSOrder message. Set to MULTI PAY if the originating sales order had more than one payment method.

Freight Charges

The freight charges from the sales order. From the freight_amount in the CreateDSOrder message. Rounded to a 2-position decimal.

Additional Charges

The additional freight charges (not the additional charges) from the sales order. From the order_additional_freight_charges in the CreateDSOrder message. Rounded to a 2-position decimal.

Paid Amount

The amount prepaid on the sales order. From the tender_amount in the CreateDSOrder message. Rounded to a 2-position decimal.

Tax on Freight

The tax on freight charges from the sales order. From the freight_tax in the CreateDSOrder message. Rounded to a 2-position decimal.

Tax Charges

The total tax for the items on the purchase order. The total of the amount from the tax for each purchase order detail included in the CreateDSOrder message. Rounded to a 2-position decimal.

Detail tab

This tab displays information about the line(s) on the purchase order, and includes options to display additional information about the line(s).

Line #

The line number identifying the item on the purchase order. From the po_line_no in the CreateDSOrder message.

Item #

The item number or code. Hold the pointer over the Item # to display the vendor item number or code and description. From the retailer_item_id in the CreateDSOrder message.

Item Description

A description of the item. Hold the pointer over the Item Description to display your description of the item. From the retailer_item_description in the CreateDSOrder message.

Order Qty

The total quantity of the item ordered by the customer. From the po_qty_ordered in the CreateDSOrder message.

Shipped Qty

The total confirmed shipment quantity of the item.

Printed Qty

The total quantity of the item that the vendor currently has on a generated pack slip or extracted to the vendor’s system, but not yet confirmed as shipped.

Cancel Qty

The total quantity of the item that you have cancelled.

Note: CWDirect and Order Administration do not support partial quantity cancellations. Additional information on canceling a partial quantity will be provided by Oracle at a later date.

Line Status

The current status of the line on the purchase order. Possible statuses are:

  • Cancelled: You have cancelled the line.

  • Held: The vendor has held the line(s) on the purchase order from processing. The vendor might put a line on hold if the vendor cannot fulfill it, and is requesting that you cancel the line. When a line on a purchase order is on hold, it is not eligible for pack slip generation or to be sent to an integrated vendor; or, if the purchase order line was already in process, the line is not eligible for shipment confirmation, and if the vendor uses the void/reprint option, the held line is omitted from the new pack slip.

  • In Process: The vendor has generated pack slips for the entire purchase order or the line, or sent the purchase order to the vendor’s system (and the batch was acknowledged, if required) if it is an integrated vendor.

  • New Order: The vendor has received the purchase order, but has not yet generated pack slips for the entire purchase order or the line; or, in the case of an integrated vendor, the vendor has not yet received the purchase order or required acknowledgment, if required.

  • Shipped: The vendor has confirmed shipment of the line.

Note: The line status is different from the Order Status if the purchase order has more than one line, and the lines have different statuses.

Due Date

The current due date for the line. Can differ from the original due date if the vendor has entered a revised due date. Included even if the item has shipped. The original due date is from the po_line_due_date in the CreateDSOrder message.

Custom

Select the icon (Illustrates the icon.) in the Custom column to advance to the Browse Detail Customizations window, where you can review the special handling instructions for the line. Available only if there are special handling instructions.

Messages

Select the icon (Illustrates the icon.) in the Messages column to advance to the Browse Purchase Order Detail Messages window, where you can review any sales order line messages for the line. Available only if there are order line messages.

Display

Select the icon (Illustrates the icon.) in the Display column to advance to the Display Purchase Order Item window, where you can review additional details about the line.

Invoices tab

This tab displays information on any invoices the vendor has created for the items on the purchase order.

Multiple shipments? If the invoice includes multiple shipments against a single purchase order line, each shipment is listed separately.

If the vendor deletes an invoice that is in New or Rejected status, it is no longer displayed at this tab. The vendor cannot delete an invoice in any other status.

See Invoice Inquiry for more information on invoices.

Line #

The line number included on the invoice.

Item #

The item number or code identifying the shipped item included in the invoice. The description of the item is to the right, separated by a hyphen ( - ).

Invoice Number

The invoice number specified by the vendor when creating the invoice.

Invoice Date

The date the vendor specified for the invoice. Format is based on the settings at the Users screen.

Invoice Qty

The total quantity of the item included in the shipment and being billed on this invoice.

Invoice Unit Cost

The vendor’s unit cost for the shipment. Multiplied by the Invoice Qty.

Different unit cost? If the vendor specifies an invoice unit cost that exceeds or falls short of the original PO Unit Cost by more than the Unit Cost Threshold you have specified for the vendor, the invoice detail line is out-of-balance. For example, if you set the threshold at 10%, and the vendor changes the invoice unit cost (higher or lower) by more than 10%, the invoice detail line is out-of-balance.

Held invoice? When the vendor submits an invoice that includes any out-of-balance lines, the invoice goes into Held status, and you need to either approve or reject the invoice. If you accept the invoice, it posts to the originating system. If you reject the invoice, the vendor can edit the invoice, including the Invoice Unit Cost, again, and resubmit the invoice; or the vendor can delete the invoice.

Email notification to vendor: The vendor receives an email notification when you accept or reject an out-of-balance invoice if indicated by the Invoice Balance Notification setting at the Email folder of the Preferences tab of the New Vendor or Edit Vendor screen.

Display

Optionally, select the display icon (Illustrates the icon.) to advance to the Invoice screen, where you can review details about the invoice.

History tab

This tab displays an entry for each activity that occurs related to a purchase order or a line on the purchase order. See

Line #

The line number updated by the activity. In the case of purchase order creation, there is a history record for each line on the purchase order.

Item (unlabeled field)

The item code for the item updated by the activity. In the case of purchase order creation, there is a history record for each item on the purchase order. From the retailer_item_id in the CreateDSOrder message.

The description of the item is to the right.

Quantity

The quantity updated by the activity.

Action Type

Possible action types are described below under Purchase Order History Entries.

Status

The status of the line after the activity took place. See Purchase Order History Entries, below, for details, and see Line Status for a list of possible statuses.

Date / Time

The date and time when the activity took place. Format is based on the settings at the Users screen.

User

The user who performed the activity.

  • A user of Admin is listed for purchase order creation, address update requests, cancellation requests, and cost changes.

  • A user of SYSTEM is listed when the customer data on the purchase order is anonymized.

  • Otherwise, this is the user ID of the vendor user who performed the action.

Source

Indicates where the activity originated:

  • UI (user interface) = the activity took place at a screen

  • WS (web service) = the activity originated from a web service message, such as the CreateDSOrder message, or through the vendor integration if this is an integrated vendor; or the purchase order was anonymized, either through the Completed Order Private Data Purge job, or through the ForgetPrivateData web service request.

Transaction Notes

Additional information about the activity. See Purchase Order History Entries for details and examples.

Details

If you have requested an address change, click the details icon (Illustrates the icon) to advance to the Purchase Order History Detail window, where you can review the details of a shipping address change, including the address before and after the change.

This option is displayed only if the address change was:

  • submitted when the line was in New Order status, before the vendor generated the pack slip or received the purchase order through the vendor integration, so that the address change applied automatically; or,

  • submitted when the line was in In Process or Held status, after the vendor generated the pack slip or received the purchase order through the vendor integration. In this case, the option is available regardless of whether the vendor accepted or declined the address change.

  • If you request an address change when the line is in Shipped or Cancelled status, Order Orchestration automatically rejects the change, and there is no history record displayed here.

Messages tab

Message lines are consolidated at this tab, but print on separate lines on the pack slip.

Sales order messages and gift messages are not anonymized when the customer data is anonymized.

Sales Order

This area displays messages related to the sales order originating the purchase order. From the order_message in the CreateDSOrder message.

Gift Messages

This area displays gift messages related to the sales order. From the gift_message in the CreateDSOrder message.

Purchase Order History Entries

The following table presents a summary of purchase order history entries.

Action Type Created When Source Status Transaction Notes
Simple Process Updates

PO Created

You submit the purchase order to Order Orchestration for fulfillment via the CreateDSOrder message. A separate history record is created for each line on the purchase order.

WS

New Order

none

PackSlip

The vendor generates pack slips for printing (PDF files) or extract to the vendor’s system (CSV files).

UI

In Process

Indicates the batch ID that includes the pack slip (for example, Batch ID (74)).

PackSlip

If an integrated vendor: the purchase order has been sent to the integrated system.

WS

New Order or In Process

Indicates the batch ID, as above.

Status remains New Order until the batch of purchase orders is acknowledged, if the Require Acknowledgement flag is selected; in this case, a separate history entry indicates when the batch is acknowledged.

Shipment

The vendor confirms shipment.

UI

Shipped

Indicates the ship date, carrier code, tracking number, weight, and freight rate, for example: Ship Date: 07/17/2013, Carrier: 50, Tracking #: Track12155, Weight: 2.34, Rate: $ 1.23

Shipment

An integrated vendor confirms shipment through the integration.

WS

Shipped

Cancellation Requests

Cancel

You submit a cancellation request for a line in New Order status.

WS

Cancelled

Automatically Cancelled

Cancel

You submit a cancellation request for a line in In Process or Held status.

WS

unchanged

Cancel Requested

Cancel

The vendor accepts a cancel request, either at the Purchase Order Change Requests screen or automatically when a line returns to New Order status after the vendor releases the line from hold or voids (but doesn’t reprint) the pack slip.

UI

Cancelled

Cancellation Approved

Cancel

The vendor declines a cancel request.

UI

unchanged

Cancellation Rejected

Cancel Auto Rejected

You send a cancellation request for a line that is already in Shipped or Canceled status, or if the requested cancel quantity exceeds the current open quantity on the line.

WS

unchanged

Cancel Request Auto Rejected

Address Change Requests

Address Change

You submit an address change request for a purchase order in New Order status.

WS

New Order

Address Change Automatically Applied

Address Change

You submit an address change request for a purchase order in In Process or Held status.

WS

unchanged

Address Change Requested

Address Change

The vendor declines an address change request.

UI

unchanged

Address Change Rejected

Address Change

The vendor accepts an address change request, either at the Purchase Order Change Requests screen or automatically when a line returns to New Order status after the vendor releases the line from hold, ships a partial quantity and returns the line to New Order status, or voids (but doesn’t reprint) the pack slip.

UI

unchanged

Address Change Approved

Address Change

The vendor ships a purchase order with an outstanding address change request. This message is written only for the first item on the shipment.

UI

Shipped

Address Change Auto Rejected

If the purchase order is in Open status: A purchase order in Open status can include lines in New Order, Held, Shipped, Cancelled, In Process status. In this situation, each line remaining line is treated separately.

       
Cost Changes

Cost Change

You submit a cost change for a line on a purchase order to update the unit price.

WS

unchanged

Before $8.98 - After $ 9.98 (where $ 8.98 is the previous unit price, and $ 9.98 is the new unit price)

Note:The currency symbol displayed is based on the Currency specified for the purchase order.

Additional Changes

Data Removal

Private data is anonymized.

WS

previous status

PII Data Anonymized

Maintenance

The vendor puts a line on hold.

UI

Held

Held: Backordered (where Backordered is the Reason Description entered by the vendor)

Maintenance

The vendor releases a line from hold.

UI

previous status

Released

Note:The Reason Description is not listed here even if the vendor entered one while releasing the line from hold.

Maintenance

The vendor revises the line’s Due Date.

UI

unchanged

Maintenance Delay Revised Due Date: 06/28/2022 (where Delay is the Reason Description entered by the vendor and 6/28/2022 is the revised due date)

Maintenance

The vendor enters a Reason Description without changing the line’s hold status or revising the due date.

UI

unchanged

Maintenance Expected next week (where Expected next week is the Reason Description entered by the vendor)

Maintenance

The vendor deletes a Reason Description for an line that is not held and does not have a revised due date.

UI

unchanged

Maintenance

Pack Slip Reprinted

The vendor uses the Void/Reprint Pack Slip screen or the Reprint Pack Slip option at the Purchase Order screen to void and reprint the pack slip.

UI

In Process

Indicates the new batch ID (for example, Batch ID (74)).

Pack Slip Voided

The vendor uses the Void/Reprint Pack Slip screen to void but not reprint the pack slip by setting the New Print Qty of all printed lines to 0.

UI

New Order

Indicates the current batch number voided (for example, Batch ID 73)).

Re-opened

The vendor confirms shipment of the entire printed quantity of a line, but there is an additional unprinted quantity because the vendor previously used the Void/Reprint Pack Slip screen to reduce the printed quantity.

UI

New Order

 

Data Removal

The customer data for the purchase order was anonymized, either through the Completed Order Private Data Purge job, or through the ForgetPrivateData web service request

WS

unchanged

Private Data Anonymized

Browse Detail Customizations

Purpose: Use the Browse Detail Customizations window to review the special handling instructions for an item on a purchase order. The special handling instructions also print on the pack slip.

Used for the Supplier Direct Fulfillment module.

Information from CWDirect or Order Administration: CWDirect and Order Administration send special handling instructions for drop ship items if the items use a custom special handling format, which includes a definition of each type of instruction (such as monogramming or hemming). If the drop ship items use standard special handling, which consists of free-form text, CWDirect and Order Administration System do not sent this information to Order Orchestration.

How to display this window: Select the icon (Illustrates the display icon.) in the Custom column at the Detail tab of the Purchase Order screen.

Note:

Available if Use Vendor Portal is selected at the Tenant screen. Only users with Purchase Order Inquiry authority can display this window. See Roles for more information.

Fields at this window

Field Description
Line #

The purchase order line number identifying the item receiving the special handling.

Vendor Item #

The vendor’s code or number identifying the item receiving the special handling. The description of the item follows, separated by a hyphen (-).

Retailer Item

The code or number identifying the item in the originating system, such as Order Administration or CWDirect. The description of the item follows, separated by a hyphen (-).

Label

The code identifying the type of special handling instructions, such as monogramming or hemming. Identified as the Label in Order Administration or CWDirect. From the customization_code in the CreateDSOrder message.

Value

The instructions related to the type of special handling, such as the letters to monogram or the length to hem. If the customization message is too wide based on the number of characters and their widths (a W being wider than an i), the message may be truncated on the window. Identified as the Input in Order Administration or CWDirect. From the customization_message in the CreateDSOrder message.

The customization label and instructions also print on the pack slip. The pack slip can print a wider customization than the Browse Detail Customizations window can display; however, if the message is too wide it is truncated on the pack slip as well.

Scroll up or down: Click the next arrow (Illustrates the next arrow.) to display the special handling instructions, if any, for the next line on the purchase order. Similarly, click the previous arrow (Illustrates the previous arrow.) to display the special handling instructions, if any, for the previous line on the purchase order.

If there are no special handling instructions for the next or previous line, the Label and Value fields displayed are blank.

Browse Purchase Order Detail Messages

Purpose: Use the Display Purchase Order Detail Messages window to review a sales order message related to an item on a purchase order.

Used for the Supplier Direct Fulfillment module.

Information from Order Administration or CWDirect: Order Administration and CWDirect send order line messages for drop ship items if the items if the messages are flagged to print on picks, or on both invoices and picks (although Oracle Retail Order Administration System Cloud Service 15.0 and later, or Order Administration System does not support the invoicing integration). You use the Work with Order Line Messages screen to work with or review these message lines in Order Administration and CWDirect.

How to display this window: Select the icon (Illustrates the icon.) in the Messages column at the Detail tab of the Purchase Order screen.

Note:

Available if Use Vendor Portal is selected at the Tenant screen. Only users with Purchase Order Inquiry authority can display this window. See Roles for more information.

Fields at this window

Field Description
Line #

The purchase order line number identifying the item.

Vendor Item #

The vendor’s code or number identifying the item. The vendor’s description of the item follows, separated by a hyphen (-).

Item #

The item number or code. The description of the item follows, separated by a hyphen (-).

Sales Order Line Message

A message related to the item on the sales order. From the order_line_message in the CreateDSOrder message.

Scroll up or down: Click the next arrow (Illustrates the next arrow.) to display the sales order message for the next line on the purchase order. Similarly, click the previous arrow (Illustrates the previous arrow.) to display the sales order message for the previous line on the purchase order.

If there is no sales order message for the next or previous line, the Sales Order Line Message displayed is blank.

Display Purchase Order Item

Purpose: Use the Display Purchase Order Item window to review additional details about an item on a purchase order.

Used for the Supplier Direct Fulfillment module.

How to display this window: Select the icon (Illustrates the display icon.) in the Display column at the Detail tab of the Purchase Order screen.

Note:

Available if Use Vendor Portal is selected at the Tenant screen. Only users with Purchase Order Inquiry authority can display this window. See Roles for more information.

Options at this window

Option Procedure
review the next item

Click the next icon (Illustrates the next icon.) to display the next item.

review the previous item

Click the previous icon (Illustrates the previous icon.) to display the previous item.

Fields at this window

Field Description
Line #

The purchase order line number identifying the item.

Item #

The code or number identifying the item. The description of the item follows, separated by a hyphen (-).

Vendor Item #

The vendor’s item number or code. The vendor’s description of the item follows, separated by a hyphen (-).

Gift Wrap

Set to Y if the item requires gift wrap. From the order_line_gift_wrap setting in the CreateDSOrder message.

Line Status

The current status of the item on the purchase order. Possible statuses are:

  • Cancelled: You have canceled the line.

    Held: The vendor has held the line(s) on the purchase order from processing. The vendor might put a line on hold if the vendor cannot fulfill it, and is requesting that you cancel the line. When a line on a purchase order is on hold, it is not eligible for pack slip generation or to be sent to an integrated vendor; or, if the purchase order line was already in process, the line is not eligible for shipment confirmation, and if the vendor uses the void/reprint option, the held line is omitted from the new pack slip.

  • In Process: The vendor has generated pack slips for the entire purchase order or the line, or sent the purchase order to the vendor’s system (and the batch was acknowledged, if required) if it is an integrated vendor.

  • New Order: The vendor has received the purchase order, but has not yet generated pack slips for the entire purchase order or the line; or, in the case of an integrated vendor, the vendor has not yet received the purchase order or required acknowledgment, if required.

  • Shipped: The vendor has confirmed shipment of the line.

Note: The line status is different from the Order Status if the purchase order has more than one line, and the lines have different statuses. See the Order Status for more information.

Original Due Date

The due date that was specified for the line. From the po_line_due_date in the CreateDSOrder message. Format is based on the settings from the Users screen.

Revised Due Date

The current due date for the line, if the vendor has entered a different due date. If the vendor has revised the due date more than once, the most recently entered due date is displayed. Format is based on the settings from the Users screen.

When the vendor revises the due date, the vendor also needs to enter a Reason Description.

Reason Description

The reason for a change to the line on the purchase order. When the vendor revises the due date, the vendor also needs to enter a reason description. The vendor can also enter a reason description when changing a line’s hold status, or for any other reason.

Ordered Qty

The original ordered quantity of the line. From the po_qty_ordered in the CreateDSOrder message.

Shipped Qty

The total quantity of the line for which the vendor has confirmed shipment.

Cancelled Qty

The total quantity of the line that you have cancelled.

Invoiced Qty

The total quantity that has been included on an invoice. See the Invoices tab at the Purchase Order screen for more information.

Unit of Measure

The unit of measure. From the vendor_uom_code in the CreateDSOrder message. Informational only.

Unit Price

The vendor’s single-unit price for the item. Rounded to 2 decimal positions (for example, a price of $1.3456 is rounded to $1.35). The currency symbol displayed is based on the Currency specified for the purchase order. From the vendor_unit_price in the CreateDSOrder message.

Ext. Price

The extended price for the item, calculated by multiplying the Ordered Qty * the Unit Price. Rounded to 2 decimal positions. The currency symbol displayed is based on the Currency specified for the purchase order.

UPC Code

The item’s UPC code, if any. From the item_upc_cd in the CreateDSOrder message.

EAN Code

The item’s EAN code, if any. From the item_ean_cd in the CreateDSOrder message.

Status Date

The last date and time when the status of the line changed. Format is based on the settings from the Users screen.

Purchase Order History Detail

Purpose: Use the Purchase Order History Detail window to review:

  • an address change applied automatically to a line because you submitted the change when the line was in New Order status

  • an address change you requested when a line is in In Process or Held status; these address changes do not apply until the vendor accepts them

Used for the Supplier Direct Fulfillment module.

Submitting address changes: The system originating the purchase order, such as Order Administration or CWDirect, can submit an address change through the SetDSAddress Change message.

Automatically rejected? Address change requests are not available for review in this window if they arrive when the line is already in Cancelled or Shipped status. These address change requests are automatically rejected.

Address changes for different lines on the purchase order: Even though the address change request is related to the purchase order header, Order Orchestration evaluates the status of the individual lines on the purchase order when determining whether to apply the change, reject it automatically, or submit it to the vendor for review.

Example: A purchase order is in Open status, with one line in In Process status and one line in Shipped status. The vendor needs to approve or reject the address change for the line in In Process status. The address change is automatically rejected for the line in Shipped status.

What if you submit multiple address changes for the same line? If you submit a second or third address change for the same In Process or Held line before the vendor has accepted or rejected the previously rejected change, Order Orchestration automatically rejects the previous address change. In this situation, when you display the Purchase Order History Detail window, only the name and address information for the most recent address change is displayed.

If you submit multiple address changes for a New Order line before the vendor generates the pack slip, each address change is automatically applied, and is displayed at the Purchase Order History Detail window.

Customer data anonymized? If the customer data on a purchase order has been anonymized (deleted and replaced with asterisks), asterisks are displayed for the Old Ship To and New Ship To customer name, address, phone numbers, and email address:


Illustrates the Purchase Order History Detail window with the old and new ship-to information replaced by asterisks.

The address change data is anonymized regardless of whether the address change applies automatically, is accepted by the vendor, or is rejected by the vendor.

See Anonymizing Data for background.

How to display this window: Select the icon (Illustrates the display icon.) in the Details column at the History tab of the Purchase Order screen. This icon is displayed only if there is an address change request that was received when the line was in New Order, In Process, or Held status.

Note:

Available if Use Vendor Portal is selected at the Tenant screen. Only users with Purchase Order Inquiry authority can display this window. See Roles for more information.

Window displayed for multiple history records? If the address change was:

  • accepted by the vendor = The window is available next to the history record marking both when the address change was requested and when the vendor approved the address change. The status indicated in both windows is Address Change Approved.

  • rejected by the vendor = The window is available only next to the history record marking when the address change was requested. The status indicated is Address Change Rejected.

Fields at this window

Field Description
Action Type

Always set to Address Change.

Date / Time

The date and time when the address change request was received. Format is based on the settings through the Users screen.

Status

The current status of the address change (not the status at the time the history record was created). Possible statuses are:

  • Address Change Requested = You have submitted an address change, the line is in Held or In Process status, and the vendor has not yet accepted or rejected the change.

  • Address Change Automatically Applied = Order Orchestration applied the address change automatically because the purchase order was in New Order status and the vendor had not yet generated a pack slip.

  • Address Change Approved = The vendor has accepted the address change for a Held or In Process line. This status is displayed in this window for both the original history record created when you requested the change, and the history record created when the vendor accepted the change.

  • Address Change Rejected = The vendor has rejected the address change for a Held or In Process line. This status is displayed in this window for both the original history record created when you requested the change, and the history record created when the vendor rejected the change.

User

The user ID of the person who performed the activity:

  • Admin: indicated when:

    • you request an address change

    • an address change is automatically applied to a New Order line

    • an address change is automatically rejected when the vendor confirms shipment

  • a vendor user ID: indicated when the vendor accepts or rejects an address change

Sold To Change

Indicates whether the sold-to address for the purchase order is the same as the shipping address, so you request that both addresses be changed. Possible settings:

  • Yes = update both the sold-to address and the ship-to address

  • No = update the ship-to address only

Source

Indicates where the activity originated. Possible settings:

  • WS (web service) = you submitted the SetDSAddress Change message, or the change is automatically applied or rejected

  • UI (user interface) = the vendor accepted or rejected the change through the Vendor Portal

Old Ship To

The ship-to name and address before applying the change. Includes:

  • name: prefix (such as Mr. or Dr.), first name, middle name, last name, and suffix (such as Jr. or Esq.)

  • company name

  • first address line

  • apartment, unit, or suite number (prefixed by the label Apt / Unit #:)

  • address line 2

  • address line 3

  • address line 4

  • city, state, postal or zip code, country code

  • daytime phone number (prefixed by the label Day:)

  • evening phone number (prefixed by the label Eve:)

  • email address

This information is from the CreateDSOrder message.

Note: Not all of the information above might be available for each customer.

Replaced with asterisks? If the customer data on a purchase order has been anonymized (deleted and replaced with asterisks), asterisks are displayed for the Old Ship To and New Ship To customer name, address, phone numbers, and email address.

New Ship To

Note: The ship-to name and address with the changes indicated in red. Includes the same name and address fields as the Old Ship To. This information is from the SetDSAddress Change message.

Replaced with asterisks? If the customer data on a purchase order has been anonymized (deleted and replaced with asterisks), asterisks are displayed for the Old Ship To and New Ship To customer name, address, phone numbers, and email address.

Invoice Inquiry

Purpose: Use the Invoice Inquiry screen to select invoices for review. You can also use this screen to select Held invoices so you can approve or reject them.

When is an invoice held? Order Orchestration holds an invoice if the invoice unit cost on one or more invoice detail lines exceeds or falls below the PO unit cost by more than the Unit Cost Threshold you have specified for the vendor. For example, if you set the Unit Cost Threshold to 10%, Order Orchestration holds the invoice if any invoice detail line’s cost is more than 10% higher or lower than the original PO unit cost. These lines are considered out-of-balance.

When you advance to this screen, it displays a message indicating how many held invoices waiting for review, for example: There are 3 held invoices awaiting review.

Email notification: When a vendor submits an invoice that includes an out-of-balance line, Order Orchestration generates a notification to the Invoice Balance Notification email address specified at the Email tab of the Drop Ship Preferences screen if the Invoice Balance Notification flag is selected. See the Out-of-balance invoice notification email to retailer for a sample.

Held invoices message: When you first advance to this screen, a message indicates the number of held invoices waiting for your review.

Resending invoices to the order management system: If the order management system, such as Order Administration, did not receive and create the invoices, you can resend one or more invoices by setting the posted_date in the vendor_invoice table to NULL. Order Orchestration then includes these invoices in the GetDSInvoicesResponse message the next time it receives the request from the order management system, such as Order Administration.

How to display: Select Invoice Inquiry from the Home Screen or the Orders drop-down menu.

Note:

Available if Use Vendor Portal is selected at the Tenant screen. Only users with Invoice Inquiry authority can display this screen. See Roles for more information.

Options at this screen

Option Procedure
search for invoices

When you first advance to this screen, no invoices are displayed. To search, complete any of the Search fields and click Search.

Case? All the enterable fields on this screen are case-insensitive for searching; for example, an entry of a or A matches an invoice number of ABC123.

select an invoice for review or maintenance

Click the edit/display icon (Illustrates the edit/display icon.) next to an invoice to advance to the Invoice screen, where you can review the information on the invoice. If the invoice is in Held status, you can also use the Invoice screen to accept or reject the invoice.

Fields at this screen

Fields Description
Search fields

You can use any of the search fields, alone or in combination, to restrict the invoices displayed in the Search Results fields.

Organization

See organization. From the Default Organization defined through the Users screen, but you can override it.

Vendor

Optionally, select a vendor associated with your organization from the drop-down list to display purchase orders assigned to that vendor. The name or description of the vendor is displayed. See Vendors for background.

Invoice Status

Optionally, select a status from the drop-down list and click Search to display invoices in that status, or leave this field blank to display invoices regardless of status. Possible statuses are:

  • Approved = The invoice was approved, either automatically or by you, but has not yet posted to the originating system.

  • Held = The vendor has submitted the invoice, and the invoice includes at least one line that is out-of-balance because the vendor changed the unit price by more than the Unit Cost Threshold: for example, you set a threshold of 10%, and the vendor changed the unit price by 15%. The invoice remains in Held status until the you either approve or reject it.

  • New = The vendor selected the Update and Save for Changes option when creating the invoice, and has not yet submitted the invoice to you for posting.

  • Posted = The invoice has been posted to the originating system, such as Order Administration or CWDirect, for payment processing.

  • Rejected = The vendor submitted an invoice that includes an out-of-balance line, and you rejected it. The vendor can change the invoice so that it no longer contains an out-of-balance line, or can delete the invoice.

Invoice Date

Optionally, select a date from the calendar control and click Search to display invoices with this date, or leave this field blank to display invoices regardless of date. This is the date the vendor specified when creating the invoice.

Invoice Number

Optionally, enter a full or partial invoice number and click Search to display invoices whose invoice number starts with or matches your entry.

Not case-sensitive for searching; an entry of A or a matches an invoice number of A12345.

PO Number

Optionally, enter a full or partial purchase order number and click Search to display invoices that include any purchase orders whose numbers start with or match your entry.

Not case-sensitive for searching; an entry of A or a matches a purchase order number of A12345.

Order Number

Optionally, enter a full or partial number or code identifying the sales order in the originating system and click Search to display invoices that include purchase orders for sales orders whose order numbers start with or match your entry.

Not case-sensitive for searching; an entry of A or a matches an order number of A12345.

Search Results fields
Vendor

The name or description of the vendor. See Vendors for background.

Invoice Number

The invoice number the vendor specified when creating the invoice.

Invoice Amount

The total amount on the invoice, including:

  • the current extended price on all invoice lines

    the freight, handling, and other charges at the invoice header level

    the freight, handling, and other charges for all invoice lines

Invoice Date

The date the vendor specified for the invoice. Format is based on the settings at the Users screen.

Invoice Status

The current status of the invoice. See the Invoice Status, above, for descriptions of possible statuses.

Display

Click the edit/display icon (Illustrates the edit/display icon.) next to an invoice to advance to the Invoice screen, where you can review the information on the invoice. If the invoice is in Held status, you can also use the Invoice screen to accept or reject the invoice.

Invoice

Purpose: Use the Invoice screen to review an invoice, and to approve or reject a Held invoice.

When is an invoice held? Order Orchestration holds an invoice if the invoice unit cost on one or more invoice detail lines exceeds or falls below the PO unit cost by more than the Unit Cost Threshold you have specified for the vendor. For example, if you set the Unit Cost Threshold to 10%, Order Orchestration holds the invoice if any invoice detail line’s cost is more than 10% higher or lower than the original PO unit cost. These lines are considered out-of-balance.

Approve or reject an invoice:

  • Click Approve to open the Approve Invoice window if you do not require the vendor to edit the invoice before it is eligible to post to your system.

  • Click Reject to open the Reject Invoice window if the vendor needs to edit the invoice before it is eligible to post to your system.

    Note:

    Only users with Invoice Inquiry and Invoice Maintenance authority can advance to these windows. See Roles for more information.

Email notification: When a vendor submits an invoice that includes an out-of-balance line, Order Orchestration generates a notification to the Invoice Balance Notification email address specified at the Email tab of the Drop Ship Preferences screen if the Invoice Balance Notification flag is selected. See the Out-of-balance invoice notification email to retailer for a sample.

How to display: Select Display for an invoice at the Invoice Inquiry screen.

Note:

  • Available if Use Vendor Portal is selected at the Tenant screen. Only users with Invoice Inquiry authority can display this screen. See Roles for more information.

  • If the Invoice screen was already open in another tab when you clicked the edit icon, you advance to this screen with the previous invoice information displayed.

Fields at this screen

Fields Description
Invoice Information

Unlabeled area at the top of the screen.

Invoice Number

The invoice number specified by the vendor when creating the invoice.

Organization

The name or description of the organization associated with the invoice. See organization.

Merchandise

The current extended price of all invoice lines.

Currency

A currency of USD is displayed regardless of the currency on the purchase orders included on the invoice.

Invoice Status

Possible statuses are:

  • Approved = The invoice was approved, either automatically or by you, but has not yet posted to the originating system.

  • Held = The vendor has submitted the invoice, and the invoice includes at least one line that is out-of-balance because the vendor changed the unit price by more than the Unit Cost Threshold: for example, you set a threshold of 10%, and the vendor changed the unit price by 15%. The invoice remains in Held status until the you either approve or reject it.

  • New = The vendor selected the Update and Save for Changes option when creating the invoice, and has not yet submitted the invoice to you for posting.

  • Posted = The invoice has been posted to the originating system for payment processing.

  • Rejected = The vendor submitted an invoice that includes an out-of-balance line, and you rejected it. The vendor can change the invoice so that it no longer contains an out-of-balance line, or can delete the invoice.

Vendor

The name or description of the vendor assigned to fulfill the purchase order. Up to 40 positions. The vendor code follows in parentheses. Up to 10 positions. From the vendor_cd in the CreateDSOrder message.

Total

The total amount on the invoice, including:

  • the current extended price on all invoice lines

  • the freight, handling, and other charges at the invoice header level

  • the freight, handling, and other charges for all invoice lines

Header tab: Invoice summary fields
Invoice Date

The date the vendor specified for the invoice. Format is based on the locale selected through the Users screen.

Invoice Description

The description the vendor entered for the invoice. Informational only.

Other Description

A description of the additional charges on the invoice. Informational only.

Freight

The total freight amount at the header level of the invoice.

Handling

The total handling charge amount at the header level of the invoice.

Other Charge

The total “other” charge amount at the header level of the invoice.

Detail Freight

The total freight charges on all invoice detail lines. You can review the freight charges for an invoice detail line at the Browse Invoice Detail window, available by clicking the Display icon (Illustrates the edit icon.) at the Detail tab.

Detail Handling

The total handling charges on all invoice detail lines. You can review the handling charges for an invoice detail line at the Browse Invoice Detail window, available by clicking the Display icon (Illustrates the display icon.) at the Detail tab.

Detail Other Charge

The total “other” charges on all invoice detail lines. You can review the “other” charges for an invoice detail line at the Browse Invoice Detail window, available by clicking the Display icon (Illustrates the display icon.) at the Detail tab.

Header tab: Payment Terms fields

Use these fields to review the payment terms, if any, the vendor has specified for the invoice.

Note:

The Vendor Portal does not validate the payment terms fields. For example, it does not confirm that the vendor enters a Discount Percent if specifying a Discount Days Due.
Discount Percent

The percentage discount to apply when paying the invoice within the Discount Days Due. Can include a 2-position decimal.

Discount Days Due

The maximum number of days in which to pay the invoice in order to qualify for the Discount Percent. Up to 3 positions.

Gross Days

The number of days in which payment is due for the invoice. Up to 3 positions.

Detail tab

This tab displays information about the line(s) the vendor is billing on the invoice, and includes options to display additional information about the line(s).

Separate shipments? Each shipment included in the invoice is listed separately, even if the shipments are for the same item on a purchase order. For example, if the vendor ships 3 units of item ABC123 separately for purchase order 456, all 3 shipments can be included on the invoice, and each unit is listed separately at the Detail tab, even if each of the fields described below (PO Number, PO Line #, Order Number, Item #, etc.) is the same.

Note: If the vendor uploaded the invoice and consolidated multiple shipments for a PO line into a single DETAIL record with full shipped qty, then there is not a unique invoice_line_no for each shipment of the PO detail line.

PO Number

The number or code identifying the purchase order in the originating system.

Case: If the originating system includes any lowercase letters in the purchase order number, Order Orchestration converts them to uppercase when creating the purchase order.

PO Line #

The original purchase order line number for the shipment.

Order Number

The number or code identifying the sales order in the originating system.

Item #

Your item number or code. Hold the pointer over the Item # to display a description of the item.

Shipped Date

The date when the shipment occurred. Format is based on the locale selected through the Users screen.

Invoice Qty

The total quantity included in the shipment and being billed on this invoice. Each shipment creates a separate invoice detail line, even if it is for the same purchase order detail line.

PO Unit Cost

The original unit cost from the purchase order.

Invoice Unit Cost

The unit cost the vendor is billing for the shipment. Multiplied by the Invoice Qty.

If the cost entered by the vendor exceeds or falls short of the original PO Unit Cost by more than the Unit Cost Threshold, the invoice detail line is out-of-balance: for example, you set a threshold of 10%, and the vendor changed the unit price by 15%. The invoice remains in Held status until you either approve or reject it.

Balanced

The out-of-balance icon (Illustrates the out-of-balance icon.) indicates if the invoice detail line is currently out-of-balance because the current Invoice Unit Cost> differs from the original PO Unit Cost by the Unit Cost Threshold.

Display

Click the Display icon (Illustrates the display icon.) to advance to the Browse Invoice Detail window to review additional information about the invoice line.

PO Inquiry

Click the PO Inquiry icon (Illustrates the inquiry icon.) to advance to the Purchase Order Inquiry screen, where you can review the details of the purchase order, such as the sold-to and ship-to address, items, history, and messages.

History tab

This tab displays an entry for each activity that occurs related to the invoice.

Action Type

Possible action types:

  • Created = The vendor created the invoice.

  • Maintained = The vendor maintained the invoice.

  • Submitted = The vendor submitted the invoice.

  • Approved = You approved an out-of-balance invoice, or it was approved automatically because it was not out-of-balance.

  • Rejected = You rejected an out-of-balance invoice.

  • Posted = The invoice posted to the originating system through the getDSInvoices messages. In this case, the User is Admin and the Source is WS.

Status

The status of the invoice as a result of the action. See the Invoice Status, above, for a listing of possible statuses.

Date / Time

The date and time when the action occurred. Format is based on the locale selected through the Users screen.

The date and time can be the same for a series of actions when some of the actions take place automatically. For example, if you create an invoice that is not out-of-balance and it is submitted immediately, the Created, Submitted, and Posted actions can all have the same date and time.

User

The user ID of the person who performed the action. A user of Admin indicates that the action takes place automatically without user intervention.

Source

Possible sources are:

  • UI = The action took place at a screen.

  • WS = The action took place through a message sent automatically between two systems (the vendor posting the invoice to the retailer’s system).

Transaction Notes

Possible notes include:

  • Invoice created (Action Type = Created)

  • Ready to Post (Action Type = Submitted)

  • Invoice Posted (Action Type = Posted)

  • Updated by Vendor (Action Type = Maintained)

  • Out of Balance. Submitted to Retailer for Approval (Action Type = Submitted)

  • Retailer Rejected - explanation, where explanation is your note when rejecting the invoice (Action Type = Rejected)

  • Retailer Approved - explanation, where explanation is your note when approving the invoice at the Approve Invoice window (Action Type = Approved)

Browse Invoice Detail

Purpose: Use the Browse Invoice Detail window to review information about a detail line on an invoice.

How to display: Select the icon (Illustrates the display icon.) in the Display column at the Detail tab of the Invoice screen.

Note:

Available if Use Vendor Portal is selected at the Tenant screen. Only users with Invoice Inquiry authority can display this window. See Roles for more information.

Fields at this window

Field Description
PO Number

The number or code identifying the purchase order in the originating system.

Case: If the originating system includes any lowercase letters in the purchase order number, Order Orchestration converts them to uppercase when creating the purchase order.

Order Number

The number or code identifying the sales order in the originating system.

PO Line #

The original purchase order line number for the shipment.

Item #

The code or number identifying the item. The description of the item follows, separated by a hyphen (-).

Vendor Item #

The vendor’s item number or code. The vendor’s description of the item follows, separated by a hyphen (-).

Shipped Date

The date when the shipment occurred, or the shipment date indicated by the vendor, if different. Format is based on the settings at the Users screen.

Invoice Qty

The total quantity included in a shipment and being billed on this invoice.

PO Unit Cost

The original unit cost from the purchase order.

Invoice Unit Cost

The unit cost the vendor is billing for the shipment. Multiplied by the Invoice Qty.

Different unit cost? If the vendor specifies an invoice unit cost that exceeds or falls short of the original PO Unit Cost by more than the Unit Cost Threshold you have specified for the vendor, the invoice detail line is out-of-balance. For example, if you set the threshold at 10%, and the vendor changes the invoice unit cost (higher or lower) by more than 10%, the invoice detail line is out-of-balance.

Held invoice? When the vendor submits an invoice that includes any out-of-balance lines, the invoice goes into Held status, and you need to either approve or reject the invoice. If you accept the invoice, it posts to the originating system. If you reject the invoice, the vendor can edit the invoice, including the Invoice Unit Cost, again, and resubmit the invoice; or the vendor can delete the invoice.

Email notification to vendor: The vendor receives an email notification when you accept or reject an out-of-balance invoice if indicated by the Invoice Balance Notification setting at the Email folder of the Preferences tab of the New Vendor or Edit Vendor screen.

Extended Invoice Cost

The current Invoice Unit Cost * the Invoice Qty.

Freight

The total freight charge for this invoice detail line.

Handling

The total handling charge for this invoice detail line.

Other Charges

The total “other” charge for this invoice detail line.

Other Description

A message about the invoice detail line. Informational only.

Last Update

The last date and time when the vendor updated the invoice detail line. Not updated when you accept or reject an invoice. Format is based on the settings through the Users screen.

Approve Invoice

Purpose: Use this window to confirm approval of an out-of-balance invoice.

How to display: Click Approve at the Invoice screen when you are reviewing an invoice that is in Held status because it is out-of-balance.

Note:

Available if Use Vendor Portal is selected at the Tenant screen. Only users with Invoice Inquiry and Invoice Maintenance authority can display this window. See Roles for more information.

Completing this window:

  • Enter the reason for approving the invoice. This information is displayed to the vendor under invoice history in the Vendor Portal.

  • Click Save to approve the invoice; otherwise, click Cancel to leave the invoice in Held status.

Updates: When you approve a held invoice:

  • The invoice status changes to Approved, and then changes to Posted as soon as Order Orchestration receives the getDSInvoices request message from the originating system and includes the invoice in the getDSInvoices response message. This activity is tracked in invoice history; see the History tab of the Invoice screen.

  • If indicated by your Invoice Balance Notification settings for the vendor at the Email folder of the Preferences tab on the New Vendor or Edit Vendor screen, Order Orchestration sends an email notification to the vendor that the invoice was approved. See the Out-of-balance invoices approved or rejected notification email to vendor for a sample.

Fields at this window

Field Description
Invoice Number

The number or code assigned by the vendor to identify the invoice.

# of PO lines

The total number of shipments included in the invoice. An invoice can include multiple shipments for the same purchase order line, and can include lines from multiple purchase orders.

Reason

The reason for approving the invoice. This information is displayed to the vendor under invoice history in the Vendor Portal. Required.

Reject Invoice

Purpose: Use this window to confirm rejection of an out-of-balance invoice.

How to display: You can display this window by clicking Reject at the Invoice screen when you are reviewing an invoice in Held status because it is out-of-balance.

Note:

Available if Use Vendor Portal is selected at the Tenant screen. Only users with Invoice Inquiry and Invoice Maintenance authority can display this window. See Roles for more information.

Completing this window:

  • Enter the reason for rejecting the invoice. This information is displayed to the vendor under invoice history in the Vendor Portal.

  • Click Save to reject the invoice; otherwise, click Cancel to leave the invoice in Held status.

Updates: When you reject a held invoice:

  • The invoice status changes to Rejected. This activity is tracked in invoice history; see the History tab of the Invoice screen.

  • If indicated by your Invoice Balance Notification settings for the vendor at the Email folder of the Preferences tab on the New Vendor or Edit Vendor screen, Order Orchestration sends an email notification to the vendor that the invoice was rejected. See the Out-of-balance invoices approved or rejected notification email to vendor for a sample.

The vendor can edit a rejected invoice and resubmit it, or the vendor can delete the invoice.

Fields at this window

Field Description
Invoice Number

The number or code assigned by the vendor to identify the invoice.

# of PO lines

The total number of shipments included in the invoice. An invoice can include multiple shipments for the same purchase order line, and can include lines from multiple purchase orders.

Reason

The reason for rejecting the invoice. This information is displayed to the vendor under invoice history in the Vendor Portal. Required.