Use Retail Integration (H26) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Default SKU Generator L/S Style (J04) |
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; also, the selected inventory transaction code should have its +/- (Add to/Subtract from inventory) flag set to +.
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 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.