Hello,
I am new to ERPNext. I am facing issues in terms of the individual inventory item in my warehouse.
1. I have a Product with inventory items purchased at different times. E.g. my product is called - Tomato Juice Concentrate - 1 ltr. bottle
1.A. I have purchased an inventory with Lot No. TJC101 - total quantity 100 bottles Purchased in Jan 2014
1.B. Second inventory of the same product was purchased with Lot No. TJC102 - Total quantity 500 bottles Purchased in Feb 2014
I am struggling with the following:
1. When I see Inventory reports, my inventory total is 600 bottles but I can't differentiate between TJC101 and TJC102.
2. Is there a way that I can sell TJC102 to a specific customer since the color of this lot is what my customer wants, provided my inventory valuation method is FIFO.
Appreciate your advise to map this requirement within ERPNext without customization. Creating different products is a possible solution I can think of, but my inventory items run in thousands across multiple warehouses.
Thanks in advance.
Sarang