Erpnext: Batch number management

[ftorreti]

For a given item number we might have different batch numbers (i.e. same item produced on different dates / different production lots for which we need to have traceability from PO to Delivery Note.

If we have an order of 600pcs for which we have 3 different production lots we need to add 3 items in the delivery note to be able to assign the quantity to a given batch.

A function we do miss from other ERP systems is the possibility to pick Batch Nr. and relative qty to assign so that for one Item in the delivery note one might have several Batch numbers so we can have the following:

Item Description Qty
ABC Custom Item 600 Pcs
Lot: 123 Qty: 200 Pcs
Lot: 456 Qty: 200 Pcs
Lot: 789 Qty: 200 Pcs

Instead we need to pick ABC 3 times.

[ftorreti]

Any plans to address this?

[rmehta]

Don't see a big demand immediately. Can you find a freelancer to work on this?

[ftorreti]

I am on frappecloud...not on my own server

Sent from my phone

On Rushabh Mehta [email protected], Sep 15, 2014 5:35 PM wrote:

Don't see a big demand immediately. Can you find a freelancer to work on this?

Reply to this email directly or view it on GitHubhttps://github.com/frappe/erpnext/issues/2121#issuecomment-55569267.

---

This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com

---

---

This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com

---

[rmehta]

@ftorreti sorry i realized - tagged. The problem still remains though - there 300+ good features to implement which one can we do first. Your issue is a reasonable one, just that we need some time to get to it.

[ftorreti]

As an alternative thought that I think it may be easier to implement, I have the following idea:

Given that the key principle in the above functionality is available with serial numbers, would it be possible to have a flag in the item master that would allow to pick a quantity > 1 when choosing a Serial Number?

By having this, it will still maintain the same current functionality but the flag set as true may disable the check on "multiple quantity for same serial number".

Just a thought to see if this can be made easier?

[ftorreti]

@rmehta I understand the issue of several features in a queue. Prioritizing is always tricky :-)

What do you think of the work around above?

[cgpurbaugh]

@rmehta our company is interested in this feature. Could you give me a quote for Paid Development? Thank you.

[rmehta]

@cgpurbaugh I think we will have to create a small table inside the item grid to set batch quantities (that can be edited via a popup) or create a separate table like Packing List that will contains details of the batches being transacted. This has to be done in all transactions - Stock Entry, Delivery Note, Purchase Receipt.

And we will have to add validations in the back-end to maintain batch quantities. This seems like 2 days of work but we will not bill you for the full development. Can your company sponsor $600 for this feature? Thanks!

[jk2081]

Is there any update on this feature?

[johntonji]

How can I create Lot number

[cgpurbaugh]

There is no separate feature to make a lot number, There is batch number and serial number. You can make either of these in the Stock Module.

[ftorreti]

@rmehta @cgpurbaugh we are willing to support 50% of the development as we really need this function as well.

[ccavolt]

@ftorreti Are you still interested in supporting 50% of the development of this feature? If so, we'd be interested in providing the other half.

[ccavolt]

@rmehta Will this feature still cost $600 (I'm asking since you quoted it over a year ago)? While it'd definitely be nice to have a co-sponsor, I think we'd be interested in sponsoring regardless, as long as the rest of the features we'd like to sponsor won't exceed our budget (this isn't the highest priority, but it'd definitely be nice to have).

[rmehta]

I think we need a picking system (for both batches and Serial Nos) this has come up frequently. Will be great if someone makes a mockup for this

Edit: OCA has a module for this https://github.com/OCA/stock-logistics-workflow

Will be great if someone can mock it up and post screenshots

[dottenbr]

@kickapoo and @emakis please check out this issue, I think this closely relates to what we are implementing at the moment and what we need.