Assignig same batch to different items

ERPNext Stock/Inventory
,
1

Hello, experts!

I hope you all are doing well. I am stuck in a scenario and need your help. The scenario is that I import multiple items, and I assign a batch number to each individual shipment. Each shipment contains multiple products, such as Product A, B, C, and so on. I have already configured the system, and I have checked the “Has Batch No” option in the item master.

Now, when I create a purchase receipt and manually type the batch number at the item level, the system prompts me to create a new batch. When I attempt to create a new batch, the system requires me to provide the batch number and item, which are mandatory fields. However, when I go to the second item at the item level in the same purchase receipt and manually type the batch number, the system again prompts me to create a new batch, and it does not accept the same batch number because it’s already assigned to Item 1.

I need this setup because, after creating the Goods Receipt Note (GRN), I also need to create a Landed Cost Voucher to capture additional costs for that specific shipment so that they are included in the item’s valuation. Additionally, in reporting, I want to see multiple batch numbers for the same item purchased from five different suppliers, so each of those five shipments has a unique batch number. From the report, I should be able to see how many batch numbers there are for these items, with filters to view the data item-wise, item group-wise, batch-wise, vendor-wise, and so on.

Kindly assist me with this. I look forward to your response.

Best Regards,
Ikrama Haryani

2

You can’t apply the same lot number to different items, the relationship doesn’t work that way.

Why not just use the Purchase Receipt number, which you can define, as apseudo batch number for your own tracking.
The landed cost voucher seems to be raised against a purchase receipt and its contained items? There is an option to distribute the associated charges manually (at least in v15).

3

Thanks for the response @pmjd . I have found an alternate way which is to create a custom field at the header level and write a catch number manually on that. When I sell the product I will also be using the system field and its match series which numbering series will be resembling to the Purchase Order to track which shipment belongs to which batch number.