How can I have 2 UOM for the same Item in the same transaction

ERPNext
,
1

I want to have 2 UOMs for the same Item. For example 1 Carton of “Product A” has 20 Nos of “Product A”. So while printing an Invoice I want to mention both the UOMs in each line Item. Also, just so you know, the conversion factors will be fixed for a particular product (i.e. 1 Carton of Product A will always have 20 Nos, that will not change). We deliver 1000’s of cartons in a shipment and we make invoices as per the base UOM i.e. Nos. For the recipient, it would not be possible to count all individual items as per base UOM, so we mention the alternate Unit Carton. Right now I am editing the PDFs manually as I have not found any solution to this.

2

Hi,

If you look in the Item master , there’s a default UOM in the Details tab, then other UOM’s are added in the Inventory tab. In the Sales tab , there is a Default Sales Unit of Measure. I think you can customize your Sales Invoice print format to add the Qty as per Stock UOM as a column in the Item table. I haven’t tried it but have a look.

3

That doesn’t work, because my stock UOM is also Nos, as I am a manufacturer and I all of my purchase and manufacruring cycle is set as per the base UOM (Nos) It just that for the customer ease an extra UOM is to be printed on Delivery Notes / Invoices. If you have any other ideas or workarounds please share

4

Hi,

You can easily do this with Unit of conversion in Item Master.

You can define the conversion for Carton to Nos. for each item and in print format you can print both.

Thanks,

Divyesh Mangroliya

5

Can you elaborate on how will I be able to print both UOM’s? As far as I know only UOM & Stock UOM can be printed, and in this case my selling UOM and Stock UOM are the same. Just that I want to include additional UOM in Sales Invoice/ Delivery Note (again, the additional UOM “cartons” is not the UOM i’m selling in, i’m selling in “Nos”).

6

Let me elaborate this for you:

Example I’m selling product A, my stock UOM is in Nos and my default UOM is also in Nos.

Now, 1 Master Carton of Product A has 12 Nos.

  1. First issue of all would be that I won’t be able to set this conversion factor for this at all as there is a restriction that any conversion that happens has to happen from the default stock UOM i.e. Nos in this case and by simple math 1/12 would be an infinitely recurring number 0.0833. And hence anywhere I use this UOM there will always be an Error Factor.

  2. Assuming that this infinitely recurring number does not occur, still I won’t be able to display alternate UOM because as far as I know UOM & Stock UOM can be printed, and in this case my selling UOM and Stock UOM are the same.

7

Hi,

This cannot be avoided. Maximum you can increase the decimals to reduce the error.

For This, In Custom Print Format you can fetch the Alternate UOM and Conversion from Item Master using Jinja. You may follow this: Fetch child table values using Jinja tags (erpnext.com)

Thanks,

Divyesh M.