Improve D365 Commerce performance with channel-side calculation on POS inventory lookup

Real-time Service (RTS) is an integrated service that provides real-time communication between Headquarters and channels. Real-time Service (RTS) enables individual POS computers and online stores to retrieve specific data from Headquarters in real time. RTS is used to get Real-Time limited data requests from Headquarters, thereforeRTS calls could generate significantly high SQL calls per API invocation, impacting the system performance.

The Inventory lookup operation in POS uses a RTS call (inventoryLookupByStoreXML RTS API) to headquarters to get inventory information for the selected product for both the user's current store and any other stores that are configured for the fulfillment group as part of the channel configuration for the store. In customers with hundreds of POS, the inventoryLookupByStoreXML RTS API could be responsible for most of the SQL calls, as you can see in this telemetry example:

The solution is to switch from real-time service calls to channel-side calculation to determine the on-hand inventory that is physically available for the store and any other locations that are defined in the fulfillment group.

To configure the POS Inventory lookup operation in Commerce headquarters to use the channel-side calculation logic and turn off real-time service call, you must

1) Enable the Optimized product availability calculation feature for Commerce headquarters

2) Sync the changes to the channels through the distribution schedule process in headquarters

Enable the Optimized product availability calculation feature through the Feature management workspace in Commerce headquarters:

Go to Retail and Commerce > Channel setup > POS setup > POS profiles > Functionality profiles.

Select a functionality profile.

On the Functions FastTab, in the Inventory availability calculation section, change the value of Inventory availability calculation mode from Real time service to Channel. By default, all functionality profiles use real-time service calls. You must change the value of this field if you want to use channel-side calculation logic.

Every retail store that is linked to the selected functionality profile will be affected by this change.

Next, you must sync the changes to the channels with? the distribution schedule process in headquarters by following these steps.

Go to Retail and Commerce > Retail and Commerce IT > Distribution schedule.

Run the 1070 (Channel configuration) job.

For more information, please review the following link:

Calculate inventory availability for retail channels - Commerce | Dynamics 365 | Microsoft Docs

Thanks for reading,

Said

Acknowledgments: I want to thank my colleague Amy Flowers (Customer Engineer) for her contributions and peer review.