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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Retail and Commerce Posting Statements with Batches and Negative Inventory

(0) ShareShare
ReportReport
Posted on by 10

We are running into an issue with our retail and commerce POS daily posting statements. If we have an item with two batches. Batch #1 has inventory quantity of 10 each's and batch #2 has inventory quantity of 20 each's. Both batches are in the POS inventory depletion location. When we have a single customer POS receipt transaction that has a sale of quantity 30 each's the system positing at end of day is depleting 30 each's from batch #1. So now we have batch #1 with negative 10 each's and batch #2 with 20 each's. Is there a setting or configuration that we are missing that would deduct 10 each's from batch #1 and then deduct 20 each's from batch #2? The desired result would be to have Batch #1 with quantity zero and Batch #2 with quantity zero. If there is not a configuration what is everyone doing about the batch with negative inventory? 

I have the same question (0)
  • Suggested answer
    Xusheng Profile Picture
    on at

    Hi,

    What Dynamics AX version you currently use?

    Why you have two statement batch jobs for the same product? We are setup up the statement based on the date or shift, why you need setup two statement batch jobs?

  • Dp21 Profile Picture
    10 on at

    We are on cloud version of Dynamics 365 finance and operations 10.0.14. We have multiple batches for an item because the item has an expiration date. So in my scenario Batch#1 has quantity of 10 eaches with an expiration date of Feb 15th. Batch #2 has a quantity of quantity of 20 eaches with an expiration date of Mar. 1st.

  • Suggested answer
    Xusheng Profile Picture
    on at

    Hi

    maybe you need try to move the item form batch #2 to batch #1 to post it. It seems there are no configuration to combine these two batchs.

  • Dp21 Profile Picture
    10 on at

    So we are able to Post because we are allowing inventory to go negative. But I was hoping there was a way to only deplete inventory that is available in the batch and then move on to the next batch. Or if there was a way to combine batches after the fact so inventory is accurate.

  • Kartik Sharma Profile Picture
    130 on at

    Hello,

    I know this is from 2020, did you able to find the resolution for this. We are facing same. Please share your solution

    Thanks

    Kartik

  • Mutinda Profile Picture
    97 on at

    Hi Kartik, I believe the solution is 'do not allow negative inventory' in the item model group inventory policy.

  • Kartik Sharma Profile Picture
    130 on at

    Hello Mutinda,

    Thats what I thought, But that's a basic requirement from my Client, as they are in retail. Inventory have to go negative.

    Thanks

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 302 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 183 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 120 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans