On hand stock level requests form third parties using the Dynamics 365 Inventory Visibility Add-in
- wouter468
- Jan 25, 2024
- 2 min read
Scenario: A third party needs to retrieve the real time stock on hand levels from the D365 transactional system.
Doing this multiple times during the day will have a negative impact on the D365 transactional system as inventory levels are constantly updated by warehouse, sales, purchasing etc. transactions.
One way to enable a third party to do multiple on hand stock level requests without negatively impacting the D365 transactional system is by using the Inventory Visibility Add-in.
What is the Inventory Visibility Add-in?
Real time inventory stock level updates (via transactions in an ERP, warehouse system etc.) are synchronized via a microservice to a Dataverse database with a Power Platform model driven app frontend and a set of REST API interfaces.
Or a more functional explanation
The Inventory Visibility Add-on for Dynamics 365 Supply Chain Management is a stand-alone microservice that is highly scalable, enabling high-volume retailers and manufacturers to manage millions of inventory updates every minute and get real-time visibility of inventory positions between channels.
How can I use the the Inventory Visibility Add-in?
First follow the steps to install the Inventory Visibility Add-in.
You can find the model driven power app via the Power Platform. Click on the Environment URL and find the Inventory Visibility tile:
Set variables for the app:
Run the On Hand Query:
HTTP request to the Inventory Visibility Add-in Oh hand Query
Third parties can call the Inventory Visibility Add-in Oh hand Query via a OnHand GET HTTP request.
I downloaded and edited the Inventory Visibility Add-in Postman collection.
Ensure that the Postman environment variables are set correctly. Look carefully at the values in the Authentication section: Inventory Visibility public APIs - Supply Chain Management | Dynamics 365 | Microsoft Learn
NOTE: First call: Get Token and copy paste the returned "access_token" value into the Access_Token POST. This returned token becomes the Bearer token.
Now the on hand inventory value can be retrieved
Note: Inventory Visibility Add-in for Microsoft Dynamics 365 Supply Chain Management – For companies that have a valid Supply Chain Management license, Inventory Visibility is available at no extra cost.
Because Inventory Visibility is based on Microsoft Power Platform, it's subject to Microsoft Power Platform storage capacity and API limits. Your Supply Chain Management license should include default storage and API capacity.
댓글