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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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,348

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

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

    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.

  • Cynthia Audain Profile Picture
    Cynthia Audain 1,348 on at

    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 on at

    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,348 on at

    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

  • Community Member Profile Picture
    Community Member on at

    Hi Lisa

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

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans