Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Splitting of Bins
Microsoft Dynamics SL (Archived)

Splitting of Bins

(0) ShareShare
ReportReport
Posted on by Cynthia Audain 1,270

Hi

I have a scenario where I have two bins set up for one site.  I have quantities available in both bins, for example in bin 1, I have 20 quantities  and in bin 2, I have 40 quantities for an item.

On doing on a sale, I am selling 10 quantities for the item.  In the shippers screen I am seeing an asterisk * in the warehouse bin location column and when I click on the line item and then click on the bin/lot button, I am seeing where the system is taking  10 quantities from bin 1 and 10 quantities from bin 2.

My question is, what will cause the system to take quantities from two or more bins and how to prevent this from occurring?

I am seeing "splitting lots" on the line item checked, but that seems to be checked by default and I cannot uncheck it.  By the way, the items are not defined as lot/serial.

Any suggestions/responses will be appreciated.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Splitting of Bins

    Hi Lisa

    Are the Items lot serial controlled ?, if so, Bin location can be selected by user and they can choose from two bins.

  • Cynthia Audain Profile Picture
    Cynthia Audain 1,270 on at
    RE: Splitting of Bins

    Hi Nam the customer is using Average method and they do not want to sell the same item from different bins on one sales order. The problem here is that the quantities in both bins have sufficient quantities for what is being sold so it is not a case where sufficient quantity is not available in one bin so the system is taking from another bin. In fact I didn't see that happening.

    No priority was set by bin but I believe the customer was set up with priority levels.

    Regards

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Splitting of Bins

    Hi Lisa

    I think our requirement quite same yours, they want system to pickup good by Bin location until it's empty then move to next Bin. We setup method type for inventory is FIFO and set priority for each Bin location and it run correctly. Of course some time quantity in one Bin location not enough and system has to pickup good in two Bin location.

  • Cynthia Audain Profile Picture
    Cynthia Audain 1,270 on at
    RE: Splitting of Bins

    Hi Nam

    The valuation method that is being used is Average costing.  

    Right now all the bins in the site have 0 as their priority.  Are you saying that I need to set priority for the bins?

    In addition, when I had a look at the bins, the quantity being sold was less than what was in both bins.  This is what have me a bit confused.  I am not sure if the quantities being shown were wrong.

    For some more information, the shipping option is set to "Ship Complete", CPS is turn off and the quantities are being calculated without any supply or demand options being checked.

    Any other thoughts.  Thanks again for your input.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Splitting of Bins

    Hi Lisa

    As I know, if you don't set priority for Bin location, the system will pick good by method type come along with item and I guess that it is FIFO in this case. So if you want system pick good by Bin location you should try to set priority for it.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans