web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Batch reservation is going to negative inventory when on-hand inventory exists on another batch

(0) ShareShare
ReportReport
Posted on by 111

I have :-

5 pcs of Item A on batch B-01 with expiry date on 08/06/2023

8 pcs of Item A on batch B-02 with expiry date on 04/28/2024

Reservation is based on FEFO basis.

When a sales order is created for 7 pcs, instead of reserving 5 pcs of batch B-01 and 2 pcs of batch B-02, it reserves the entire batch B-01 for the 7 items taking it to negative -2. 

I do not want to disable negative physical inventory as the client requires this.

Below is a screenshot of my setup. As you can see, I have unchecked Same batch selection.

pastedimage1662992258262v1.png

I have the same question (0)
  • Danny Bilodeau Profile Picture
    4,941 Super User 2026 Season 1 on at

    Hi Abdul,

    Is that the actual item model group for the process that reserves negative inventory? That Item Model Group does not allow negative...

    In the Sales Order line details, can you confirm that the batch number is not selected?

  • Abdul Muqsith Profile Picture
    111 on at

    Yeah the negative inventory check box is ON. I accidentally posted the wrong image here.

    In the sales order line, the batch is automatically reserved as I have turned on auto-reserve when Sales order line is created.

  • Suggested answer
    Danny Bilodeau Profile Picture
    4,941 Super User 2026 Season 1 on at

    Hello Abdul,

    My experience with allowing negative inventory on Item Model Group is just like you are experiencing.  I dont know of any way to force reservation on on-hand inventory when "Negative Inventory" is enabled on the Item Model Group.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 153 Super User 2026 Season 1

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 113 Super User 2026 Season 1

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 102 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans