Warehouse Bin System

ERPNext
61

We have built the Structured Warehousing Solution - we call it RARB System - short for Room, Aisle, Rack, Bin. However, the assumption is that the Bins are tied down to a RAR - Room, Aisle & Rack.

I think what you are conceptualizing and expecting is a movable bin into which anything can be kept and that can be kept anywhere.

It’s an interesting solution and I’d love to build it for you if you have a budget. :slight_smile:

Thanks

Jay

62

Like I was saying, we have built the fixed Bin system. The flexi bin system is an interesting concept and needs to be built.

Thanks

Jay

63

Our RARB system is designed along more or less the same way. Here’s how it is designed:

  1. You first have to make a Warehouse and flag it as a RARB warehouse
  2. Now you say how many Rooms, Aisles, Racks and Bins (RARB) does this warehouse support. Right now you have to pick the same number - meaning different rooms cannot have different number of Aisles; different aisles cannot have different racks; different racks cannot have different bins. Though you can say whether a Bin (you can only store stuff in a BIn) is active or not. So the expectation is that the user organizations will use the max value of RARBs and then only flag the viable/existing bins as active.
  3. Each Bin can be flagged to store just one item or can be flagged to store any item. Same item can be stored in multiple Bins.
  4. After this everytime you make a stock transaction involving a warehouse that’s flagged as a RARB warehouse, the RARB Location at the item level ends up becoming mandatory.
  5. We have Stock Balance RARB and Stock Ledger RARB reports

We are also integrating this with an Android app with RFID Integration that will break down an item into Packing Items and Packing Boxes. So, when you are making a dispatch, we have built the system that says what are the packing boxes (and quantities of packing boxes) that are necessary to complete this shipment - How many packing boxes are available and where. And whether the packing boxes are Complete (all packing items are in the packing box) and packed (meaning it’s been taped or otherwise secured). And for the Packing boxes that aren’t there or are partially filled, whether the packing items that need to be in the packing boxes are available - where are they available and whether they are packed. A pick list and Grab Packing box functionality is being built with audio and visual indicator when all packing boxes have been grabbed and the consignment is cleared for shipment.

This is being built and it supports typically a made to order kind of configuration. I think it can be hacked to work for a Made to Stock configuration, though it maybe a bit annoying in places.

Thanks

Jay

2 Likes
64

Hi Mary,

Please check out this response:

Hope this helps.

Thanks

Jay

65

Hi Jay,

The design you described above sounds great!
Do you need help implementing it? I would happily contribute code and test it in a Warehouse which is already using a RARB system.

Bastian

66

Hi Bastian,

Thank you for your message. Most of it is either being built or is already built. You are welcome to use it and test it. And make it more robust. Or nhance it. No, that’s no typo, our app on which all these are built is called nhance.

Thanks

Jay

67

Hi Jay

Thank you so much for your response. What you have designed and almost implemented is to much extent in accordance with my users’ requirement. May I know how and when it would be available? whether as a part of ERP Next future releases or any other way?
If needed I’m ready to help you in functionality testing and maybe the extension.

Regards,
Mary

68

Is your app public ?
can we try it out locally to check and contribute to it ,
Mind sharing the github link to it .

69

Yes, our App is public. Not sure if it can work right out of the box. Not sure if it can work on ver 12. I haven’t even looked at Ver 13 yet. It definitely works on ver 11. I will try to make it work on Ver 12 and put the documentation together and share it here. If nothing it can work on Ver 11.

Thanks

Jay

1 Like
70

Great , is there a public repo where it is hosted , so we can download and contribute to it as well .
Please do share.

71

Hi @JayRam Give us the link. We will help you in making a version 12 version of it. Normally it should work on V12 as it is backward compatible. Nevertheless, we can assist you there.

72

All our customisations have always been open source and available publically at: umaepoch · GitHub

There is no repository for RARB, but is included in nhance. Please let me know if you guys need any help.

Thanks

Jay

2 Likes
73

We ended up just using ERPNext Warehouse doctype. In the end we have about ~20,000 warehouse nodes. Basically we just created a group node for each Row, Aisle, and Shelf, then another node for each Bin. We did this for each of our warehouses.

Unfortunately, it is very slow. Maybe it’s just my server config. But some of the time I have to wait until company closes to add a new warehouse because it completely overruns the maraidb processes and makes it impossible to do anything else. I’ve waited 30min and still the process was executing just to create 1 single Warehouse node.

Anyways, that disadvantage aside. The next problem I encountered was selecting the delivery warehouse in sales order. Because there are so many warehouse nodes to chose from It became impossible to just select a delivery warehouse from the sales order. We ended up customizing the Territory doctype to include a warehouse field. This way depending on what territory the customer belonged to the delivery note would created the stock transaction from the closest warehouse the item is available.

Here is a hook we implemented for the Sales Order

Hopefully someone may find it useful :slight_smile: Cheers!

74

You should check out our solution. It’s built on a layer on top of ERPNext and works fast.

Thanks

Jay

1 Like
75

I have just installed nhance on our test site how do i get started?
I’ve added a rarb warehouse, how do I map the items to the bins?

Thanks
Gurshish

76

Hi Jay,

I just tried to install it on V13. Here is the result:

Installing nhance…
Updating DocTypes for nhance : [======== ] 22%An error occurred while installing nhance:
Module import failed for Stock Requisition (nhance.nhance.doctype.stock_requisition.stock_requisition Error: cannot import name ‘check_for_closed_status’ from ‘erpnext.buying.utils’ (/home/erp/frappe-bench/apps/erpnext/erpnext/buying/utils.py))

Should it work on V13 or not yet?

77

Hi Bruno,

That’s a different error in nhance and should not affect the RARB Functionality.

Still, I don’t know if it will work on Ver 13.

If a deal goes through, we will get the RARB functionality Ver 13 ready in a few weeks.

There are other Custom Scripts and Custom Fields that are necessary and I can send you the list of such scripts and fields in a few days. Actually it will be easier to do that when we work on getting it ver 13 ready. I should know this week if I can get my developer to start working on getting the RARB Functionality ver 13 ready.

Thanks

Jay

1 Like
78

Hi Jayram,

I see great work being done by you regarding RARB.

We are facing this problem too.

Can you help with the steps for installation also.

79

Hey JayRam,

is the system ready for v13 yet? I am interessed to have it implemented.
Please PM me, if your interessed in a project. All the results of the project should be shared with the community.

I assume I can move the bins from one shelf to another. e.g. get the bin with the part I need. Get the part out of the bin. put the bin into a differnet rack in a differnet aisle and store, that is lives there from now on. (chaotic warehouse management)

Cheers
Jan

1 Like
80

I’m also interested in this module. Using the default warehouse tree is getting a little out of hand for us. If you need some help working on this I’d be glad to help out.