Integrate Route Inventory

You can understand the integration of the consumer goods mobile application with supply chain system and manage route inventories.

During the route execution, the mobile application captures and maintains the route-inventory transactions. The following inventory transactions are read-only in the sales application:

• Restock for Shipment: Increases the route inventory with the quantity that's required for a shipment. It also provides the sellable quantity of the transaction.

• Restock for Additional Inventory: Increases the route inventory with the quantity that's required due to reasons other than shipment. It also provides the sellable quantity of the transaction.

• Delivery: Decreases the route inventory based on the quantity delivered in a shipment. It also provides the sellable quantity of the transaction.

• Damage: Changes the route inventory from sellable to unsellable. When the quantity of sellable inventory decreases, the quantity of the unsellable inventory is increased by the same amount.

• Loss: Decreases the route inventory based on the quantity of the inventory lost. It also provides the sellable quantity of the transaction.

• Recovery: Increases the route inventory based on the quantity of the inventory recovered. It also provides the sellable quantity of the transaction.

• Return: Increases the route inventory based on the quantity of the inventory returned. It also provides the sellable quantity of the transaction.

• Unload: This transaction decreases the route inventory based on the quantity of the inventory unloaded. It also provides the sellable quantity of the transaction.

To update the inventory records periodically or after each route execution, you must use Supply Chain Management (SCM) system to process and refresh inventory position in the mobile application.

Depending on your business use case, you can first determine how you want to refresh your inventory records and then configure your system accordingly.

Here's how this integration works when using the Maintaining Static Inventory Position method of calculating the inventory level:

1. The SCM system recalculates inventory using the Maintaining Static Inventory Position method and sends the updated records to the consumer goods server.

2. The CX Retail Execution Mobile retrieves the refreshed inventory records from the consumer goods server to update the inventory position for the next route execution.

3. CX Retail Execution Mobile sends transaction records created during route execution to the consumer goods server.

4. The consumer goods server prepares the transactions records and makes them available to the integrating SCM system.

The following graphic shows the integration flow:

In this integration, the mobile application calculates the inventory position as follows:

1. Reads the route-inventory level and the Last Processed Transaction Time Stamp from the Route Inventory staging table.

2. Reads all transactions later than the Last Processed Transaction Time Stamp. See, Integration Tables and Key Fields.

3. Adds the transaction quantity of each transaction to the original product inventory level.

The inventory position thus calculated by the mobile application is temporary and isn't sent to the consumer goods server. The inventory transactions that remove items are in the negative and those that add items are in the positive.