Frappe Cloud Support Partners Foundation Frappe School

Warehouse Bin System

This recent post notes open source systems exist but does not list specific products for consideration

Nicole: We have a RARB - Room, Aisle, Rack, Bin system designed. What it does is that it doesn’t treat the Bins as separate warehouses, but in the Item Master it makes you specify the RARB Number for the item (you could use multiple RARBs for the same item if you need more than one bin to store quantities of the item), and when you do an inbound stock transaction it generates a Put List and when you make an outbound stock transaction, it generates a Pick List.

Does that work for you?




Is this contributed?

Actually, it seems like for the companies I work with, it is a good idea, but I haven’t progressed along the implementation with any of my clients to reach this level of sophistication to even test the concept out. So, I’m happy to flesh out the concept with an appropriate volunteer company, fine tune it, make it work on the shop floor and begin the parallel process of doing a pull request.

@nicole: IS that volunteer you? Or your organization? :slight_smile:



1 Like

Count me in @JayRam

@Sam_NAVARRO: Thanks for volunteering.

This is how we have designed it:

There are two types of Room, Aisle, Rack, Bin (RARB) we have conceptualized -

  1. Predetermined RARB (typically for items that have a predictable size and shape and quantities)
  2. On-the-fly RARB for items that do not have a predictable shape or size

Here’s how it works:

First you have to specify which of your Warehouses follow the Room, Aisle, Rack, Bin (RARB) system. Let’s focus on the Predetermined RARB for now.
Then you have to specify the number of rooms, aisles, racks and bins. You cannot say that room 1 has 5 Aisles, but Room 2 has 8. We suggest that you use the highest number. You can leave whole Aisles, Racks and Bins inactive, though.
Then you get ERPNext to generate the Unique RARB numbers.
Then you need to nail down the RARB numbers that the Items are placed in. You can keep the same item in multiple Bins though.

Now you are ready.

One thing you need to know though: This version will not generate the RARB number in the Stock Balance report. This is significant for especially the same items that you are using multiple bins for as the system will not tell the picker or the putter (okay bad word) which Bin to pick from or put the item at. So the Picker has to try one of the bins, if that’s empty s/he has the try the next and so on. Similarly for putting (try not to think of golf), if the bin is full the user has to find the next bin.

But you do get a Pick List and a Put List (it’s a print format) to help users achieve this.

Does this sound okay to you? Is it enough to begin? Or are there any show stoppers that we have to build?



Hi @JayRam
I would like to discuss more of your bin system. I already elaborate something on my side for pickings.
I still have issues on productivity (steps that slowing down the process).
Perhaps can we do a Skype meeting to discuss further and share more our process.
Will be great if more people can join. I believe that more brains are better than one.

Sure. Sam. When’s a good time for you. I’m based in India. We can set up the schedule and publish the time and all interested people are welcome to join.

Does that sound okay to you?



What do you think on Wednesday at 2 pm in New Delhi?

I can create a new post about this and invite people who might be interested from previous similar posts.

Can do Friday.



Hello @JayRam

Good concepts but how will this impact on stock counts? Will this have to be done bin by bin ?


@JayRam so Friday 2pm India - New Delhi time?
@olamide_shodunke want to join?

Am game

Can you send a meeting invite

Sorry, I’m late. Are we jumping onto the call now?

Hello Everyone,

Thanks for this thread. I’d like to know about the progress of this feature and the possible date of publicly availability.


This is a customization that has been done by us (Epoch Consulting) and we require a volunteer organization that can implement what has been developed that then suggest minimum requirements for it to get rolled out as part of ERPNext codebase.



1 Like

Volunteer Organization?

I’d like to see what’s been developed and if this is what I’m looking for. Is it possible to show us a demo?

And, how would that volunteer organization implementation work?

@fnrfarid: Please check this out. This is what our Warehouse Bin System can do for now. If you don’t see any glaring gaps and you think it can work for you, I am happy to demo it to you.



@JayRam Thank You.

I’d like to implement this demo in my demo site and check out those features live.

But, as I’ve said earlier, I’m not a programmer and I don’t get the heavy stuff, how can I get this demo implemented easily?

Is ERPNext is planning to integrate this Bin System in next version update?

Apologies for the late reply.

Thanks again.

Hi Farid,

Sure, let me finish up the base requirements and push it to our app and send you the instructions how you can download the app and what other requirements are needed.

You can then try that out.

The plan is to integrate this with the ERPNext code base once the whole feature set reaches critical mass and stability.



1 Like