Show TOC

  Determination of the Open Quantity and Status of an RO Item

Use

SAP Supply Network Collaboration (SAP SNC) can automatically determine the following data for a request schedule line and for an item in a published replenishment order item (RO item).

  • Open quantity

    This is the quantity that the supplier has not yet delivered. The system determines the open quantity on the request schedule line level. The open quantity on item level is the sum of the open quantities of the request schedule lines.

  • Item statuses Partially Delivered and Delivery Completed

    The status of a replenishment order item can be Partially Delivered or Delivery Completed . This status shows that the customer has received either a part or all of the ordered product quantity.

The status and the open quantity of a replenishment order item are related: A completely delivered item has an open quantity of zero. A partially delivered item has an open quantity greater than zero but less than the requested quantity. The system can also consider underdelivery tolerances for replenishment orders in the SMI scenario. In this case, an item has been completely delivered if the open quantity of an item is less than the absolute underdelivery tolerance.

Features

Options for Determining the Open Quantity of a Replenishment Order Item

The system can determine the open quantity and the status of a replenishment order item in a number of ways. The method that you choose, depends on the process variant: Does the customer send goods receipt information from his or her back-end system to SAP SNC? How (that is, with which XML message type)? Which data? Does the supplier use advanced shipping notifications?

You have the following options:

  • The customer sends goods receipt information to SAP SNC. For this, the customer uses the following XML message types (depending on the process variant):

    • ProductActivityNotification

    • ReceivedDeliveryNotification

    • ReplenishmentOrderConfirmation

  • The customer does not send goods receipt information to SAP SNC. If, however, you use advanced shipping notifications (ASN), SAP SNC can determine the open quantity using the ASN that the supplier has published in SAP SNC.

    Note Note

    To avoid inconsistencies, do not combine the methods for updating the open quantity of order items.

    End of the note.
Update Replenishment Order Items Based on ProductActivityNotifications

You have the following options for updating replenishment order items:

  • Update Replenishment Order Items Based on Date/Time

    In this case, SAP SNC sets the status Delivery Completed for all replenishment order items whose availability date at the customer location lies before a certain point in time. SAP SNC reduces the open quantity of these items to zero. The customer transfers the reference time in the ProductActivityNotification (inventory status date/time).

  • Update Replenishment Order Items Based on Open Purchase Order Quantity

    In the ProductActivityNotification , the customer can transfer what is known as the "on-order quantity" for a customer location product. The on-order quantity is the quantity that, from the customer's point of view, the customer has ordered but not yet received. Upon receiving a ProductActivityNotification , SAP SNC compares the on-order quantity of the product with the total open quantity of all replenishment order items for this product. Depending on the result of this comparison, SAP SNC reacts as follows:

    • On-order quantity in PROACT = open quantity in SAP SNC

      If the on-order quantity from the ProductActivityNotification and the open replenishment order quantity in SAP SNC are equal, SAP SNC does not change the open quantity or the status of the replenishment order items.

    • On-order quantity in PROACT < open quantity in SAP SNC

      If the on-order quantity from the ProductActivityNotification is less than the open replenishment order quantity in SAP SNC, SAP SNC reduces the open quantity of the replenishment order items accordingly. SAP SNC processes replenishment order items in order of their availability date at the customer location, starting with the earliest replenishment order item. For each item, SAP SNC reduces the open quantity to zero until the difference between the open purchase order quantity from the ProductActivityNotification and the open replenishment order quantity in SAP SNC is used up. SAP SNC sets the status Delivery Completed for items with an open quantity of zero.

    • On-order quantity in PROACT > open quantity in SAP SNC

      If the on-order quantity from the ProductActivityNotification is greater than the open replenishment order quantity in SAP SNC, SAP SNC creates a replenishment order with a replenishment order item whose requested quantity and open quantity both equal the difference in quantity. SAP SNC assigns a replenishment order number to this replenishment order, but it does not assign a sales order number or a purchase order number. The replenishment order receives the status Published, but is not sent to the customer back-end system or to the supplier back-end system. When the customer sends the next ProductActivityNotification with a new on-order quantity, SAP SNC also updates the open quantity of the replenishment order.

Update Advanced Shipping Notification Items Based on ProductActivityNotifications

If the supplier in replenishment order collaboration uses advanced shipping notifications (ASNs), SAP SNC can update the ASN items that relate to a replenishment order, upon receiving a ProductActivityNotification . This is done in addition to updating the replenishment order item. SAP SNC determines the following data for each of these ASN items:

  • The received quantity

  • T he item status ( Partial Goods Receipt or Goods Receipt Complete )

SAP SNC updates the ASN items after the replenishment order item. As with replenishment order items, SAP SNC can update ASN items in the following ways based on the date/time or based on the open purchase order quantity:

  • Update ASN Items Based on Date/Time

    In this case, SAP SNC sets the status Goods Receipt Complete for all ASN items whose delivery date/time lies before a certain point in time. SAP SNC sets the received quantity of these ASN items equal to the ASN item quantity. The customer transfers the reference time in the ProductActivityNotification (inventory status date/time).

  • Update ASN Items Based on On-Order Quantity

    In this case, SAP SNC reduces the total "open quantity" of the ASN items that relate to a replenishment order item, to the open quantity of the replenishment order item. (The open quantity of an ASN item is the difference between the published quantity and the received quantity.) If the open quantity of an ASN item is zero, the ASN item receives the Goods Receipt Complete status. If the open quantity of the ASN item is greater than zero, but less than the published quantity, the ASN item receives the status Partial Goods Receipt .

    SAP SNC processes ASN items in chronological order of their availability date at the customer location, starting with the earliest ASN item. SAP SNC uses the difference in quantity between the open quantity of the replenishment order item and the open quantity of the ASN items to reduce the open quantity of the ASN items. It updates the ASN items one after the other (increasing the received quantity of the ASN items to the published quantity) until the difference in quantity is used up.

    Note Note

    If an ASN item does not relate to a replenishment order item, SAP SNC always updates this ASN item based on the date/time (see above).

    End of the note.

If you want to update replenishment orders and advanced shipping notifications based on ProductActivityNotifications , you must configure the required options in Customizing for Supply Network Collaboration by choosing Start of the navigation path Exceptions Next navigation step Data Import Controller Next navigation step Update the Quantities and Statuses of ROs and ASNs. End of the navigation path You can set that SAP SNC updates only replenishment orders, or both replenishment orders and advanced shipping notifications.

Update Replenishment Order Items Based on ReceivedDeliveryNotifications

As an alternative to updating replenishment order items based on ProductActivityNotifications , SAP SNC can also update replenishment order items based on ReceivedDeliveryNotifications . If the supplier publishes an ASN for a replenishment order item in SAP SNC, SAP SNC automatically creates an ASN-confirmed schedule line for the replenishment order item. The ASN-confirmed schedule line contains the received quantity as well as the delivery quantity. If the customer sends a ReceivedDeliveryNotification to SAP SNC, SAP SNC transfers the received quantity to the ASN item and also to the ASN-confirmed schedule line of the replenishment order item. SAP SNC then updates the open quantity in the request schedule line of the replenishment order item. To determine the open quantity, SAP SNC assigns the received quantity from the ASN-confirmed schedule line to the request schedule lines. Starting with the earliest request schedule line, SAP SNC assigns the necessary quantity from the received quantity to the request schedule lines one after another until the received quantity is used up. Request schedule lines that are not covered or are only partially covered by the received quantity from the ASN-confirmed schedule lines have a corresponding open quantity. If the open quantity of the item is zero, SAP SNC sets the status Delivery Completed.

To calculate the open quantity from the received quantity, you use the validation check Calculate Open Quantity with GR Quantity from ASN-Confirmed Schedule Line . (PO_OPENQUAN_FROM_ASNGRQUAN).

If you want to use this method, you must set the No Update of Replenishment Orders or ASNs option in Customizing for Supply Network Collaboration by choosing Start of the navigation path Exceptions Next navigation step Data Import Controller Next navigation step Configure Open Order Quantity Determination. End of the navigation path

Update Replenishment Order Items Based on ASNs

This option is relevant if the customer does not send any goods receipt messages to SAP SNC. In this case, SAP SNC uses the delivery quantity from the ASN-confirmed schedule line to update replenishment order items. To do this, SAP SNC assigns the delivery quantity from the ASN-confirmed schedule line to the request schedule line of a replenishment order item. Starting with the earliest request schedule line, SAP SNC assigns the necessary quantity from the delivery quantity to the request schedule lines one after another until the delivery quantity is used up. Request schedule lines that are not covered or are only partially covered by the delivery quantity from the ASN-confirmed schedule lines have a corresponding open quantity. If the open quantity of the replenishment order item is zero, SAP SNC sets the status Delivery Completed.

To calculate the open quantity from the delivery quantity, you use the validation check Calculate Open Quantity with Planned Delivery Quantity from ASN-Confirmed Schedule Line (RO_OPENQUAN_FROM_ASNQUAN).

If you want to use this method, you must set the No Update of Replenishment Orders or ASNs option in Customizing for Supply Network Collaboration by choosing Start of the navigation path Exceptions Next navigation step Data Import Controller Next navigation step Configure Open Order Quantity Determination. End of the navigation path

Update Replenishment Order Items Based on ReplenishmentOrderConfirmations

In the SMI scenario, the supplier can send a ReplenishmentOrderConfirmation with confirmed data and goods receipt data from his or her back-end system to SAP SNC. SAP SNC creates corresponding confirmation schedule lines for the replenishment order item. The validation check RO_OPENQUAN_FROM_ROC calculates the open quantity of a replenishment order item as follows:

Open quantity = requested quantity – goods receipt quantity from the confirmation schedule lines.