Inventory Transaction Code for ’Sync’ Processing (I85)

Purpose: Use this screen to indicate the inventory transaction code that signals a sync transaction when received through the generic inventory transaction upload.

Code field: Enter the user-defined inventory transaction code that signals a sync transaction, rather than an adjustment, when passed as the transaction_code in the Inventory Transaction Upload XML Message (inCreateInvXaction). This screen displays all user-defined inventory transaction codes.

Note: Your entry here cannot be a system-defined transaction code.

About sync transactions: The Generic Inventory Transaction Upload processes a sync transaction by comparing the current on-hand quantity of the item/SKU in the item location with the transaction_quantity passed in the Inventory Transaction Upload XML message. If the transaction_quantity passed in the message is greater than the current on-hand quantity in the item location, the resulting transaction adjusts the inventory upward by the difference; if the transaction_quantity is lower than the current on-hand quantity in the item location, the resulting transaction adjusts the inventory downward by the difference. If the transaction_quantity is the same as the current on-hand quantity in the item location, the system does not process an inventory transaction.

If the transaction_code passed in the Inventory Transaction Upload XML message is a user-defined code that does not match this system control value, the resulting transaction adjusts the on-hand inventory by the transaction_quantity.

Examples: The following table describes the results of a sync transaction and an adjustment transaction when the current on-hand quantity is 100:

transaction_ quantity =	Sync Transaction (inventory transaction code matches system control value)	Adjustment Transaction (other user-defined inventory transaction code)
25	25 is lower than the current on-hand quantity of 100. The sync transaction subtracts 75 from the current on-hand quantity in order to reset it to 25.	The transaction adds 25 to the current on-hand quantity, resulting in a new on-hand quantity of 125.
125	125 is higher than the current on-hand quantity of 100. The sync transaction adds 25 to the current on-hand quantity in order to reset it to 125.	The transaction adds 125 to the current on-hand quantity, resulting in a new on-hand quantity of 225.
100	100 is the current on-hand quantity. The system does not process an inventory transaction.	The transaction adds 100 to the current on-hand quantity, resulting in a new on-hand quantity of 200.
-50	You cannot process a sync transaction for a negative quantity; this creates an inventory transaction error.	The transaction subtracts 50 from the current on-hand quantity, resulting in a new on-hand quantity of 50.

Why use sync transactions? Processing sync transactions provides a way to keep inventory levels in sync with a remote system, such as CWStore. If you use the Point of Sale Integration with CWStore, you can receive periodic sync transactions from each store location that is represented by a warehouse in Oracle Retail Order Management System so that you can review inventory levels in these store locations.

For more information: See:

• Generic Inventory Transaction Upload

• Work with Inventory Transaction Codes (WITC)

• Working with Inventory Transaction Errors (WITE)

Leave this field blank if you do not need to process sync transactions through the Generic Inventory Transaction Upload.