Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Commerce forum / Retail and Commerce Po...
Commerce forum
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?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans