Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Inventory Reservation and Negative Inventory

(0) ShareShare
ReportReport
Posted on by
Our company chooses to use a custom reservation job that runs every three hours on Daytime settings. This job finds available inventory from locations designated as available and commits that inventory to sales orders, transfer orders and production orders. 
 
In addition, our company set up a routing job that will look for orders that cannot be filled by our distribution center and will seek to reassign sales order lines to those stores with sufficient physical available to satisfy the order line. Part of that routing job will re-route order lines back to the distribution center for reprocessing if they are short picked at the stores.
 
Lastly, we allow negative inventory in D365 as a result of the way our connector to Shopify is set up. We must allow negative in order to permit the sale of items we do not have on hand (backorders) via our POS product.
 
The combination of all three of these factors has led to a problem I will call /over-reservation/. For two specific reasons, our reservations are ending up /in the negative/ by creating negative physical available values, preventing the release of those order lines into valid pieces of work, and getting these order lines hung up in the system.
 
1. How can I write a special script that will look for reservations /in the negative/ and clear those reservations, enabling them to be re-routed to the distribution center for reprocessing?
2. How can I designate which locations are eligible for the reservation job to reserve against? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,017 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans