Best way to purchase multiple item codes for one selling item code

ERPNext Stock/Inventory
1

Hi all,

Problem:

We purchase the same item from different suppliers/Brands. These come with multiple codes.

Item code:

w301 (Red wire)

Supplier:

12R-WR (Red wire)
6MM-R-WR (Red wire)
RED-6MM-WIRE

ETC

Can you guys help me find an easy way to allow me to purchase items under many codes, then associate them to one item code.

It needs to track stock correctly as well

IE)

Purchase Order:

12R-WR (Red wire) QTY: 10
6MM-R-WR (Red wire) QTY: 10
RED-6MM-WIRE QTY:10

then Item Code w301 (Red wire) = QTY 30

I dont want to make it complicated, so the simplest way is the best way.

Thanks for your help

2

As for you way of thinking it is not possible. By another way it can be sorted out.

  1. Create Item W301
  2. Go to the purchasing tab of W301 and add the supplier code and their item code (12R-WR) … for each supplier enter their item codes.
  3. Then using client script you have fetch the item code W301… Not easy… but you have to think in that way to make a solution
1 Like
3

Yes that is interesting

So I wouldn’t be able to do it with variants and then change the variant codes.

4

Try product bundle https://docs.erpnext.com/docs/user/manual/en/product-bundle

5

Make/Create Batch for each supplier against same item.

6

So A Batch that “lives constantly” and we just receive against that batch