Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Suggested answer

Retail and Commerce Posting Statements with Batches and Negative Inventory

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? 

  • Kartik Sharma Profile Picture
    Kartik Sharma 130 on at
    RE: Retail and Commerce Posting Statements with Batches and Negative Inventory

    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

  • Mutinda Profile Picture
    Mutinda 95 on at
    RE: Retail and Commerce Posting Statements with Batches and Negative Inventory

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

  • Kartik Sharma Profile Picture
    Kartik Sharma 130 on at
    RE: Retail and Commerce Posting Statements with Batches and Negative Inventory

    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

  • Dp21 Profile Picture
    Dp21 10 on at
    RE: Retail and Commerce Posting Statements with Batches and Negative Inventory

    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.

  • Suggested answer
    Xusheng Profile Picture
    Xusheng on at
    RE: Retail and Commerce Posting Statements with Batches and Negative Inventory

    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
    Dp21 10 on at
    RE: Retail and Commerce Posting Statements with Batches and Negative Inventory

    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
    Xusheng on at
    RE: Retail and Commerce Posting Statements with Batches and Negative Inventory

    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?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans