Is there any workaround for the following challenge? I believe there must be a workaround in ERPNext for this common challenge.
Here is the scenario.
I have default UOM “Nos” which we are using at POS. And maintain it for Item Reorder level as well.
But our buying is in BOX or packs. For a retail where there are thousands of items are being purchased every day. It’s not possible to go through every item to change it’s UOM in PO and also while changing UOM, QTY is not being changed automatically.
I hope I’m not the only one who is having this issue. The quick work around could be if we can display another UOM on the PO print which will help the receiving people to understand the actual boxes instead of Nos.
Thanks Pawan. i studied this document and we know this is the only option to change UOM in Purchase request and we can change it one by one for each item in that purchase request. the challenge comes when we have more than 1000 products every day to buy and changing UOM for each item is not viable solution. i hope i’m able to explain the problem
Don’t try to motivate us by calling this a challenge.
It is possible to do this without any serious customizations. You just have to experiment and research how to do it. Maybe somebody on the community can show you how it is done, if you run into problems. If not you have to find somebody that can do it for you and pay him/her to do it for you.
Open Source does not mean an investment in money in terms of license fees, but it does mean that it is an investment in terms of time, or you have to procure those services from the community.
Apologies if I sound preachy, but these are the basic facts of an open source ecosystem.
So now that I have said it is possible and it is reasonably easy, let me try and challenge you to find out for yourself how to do it.
Correct. Then you only switch the Stock UOM and the UOM field. I wanted to say 1 No. = 5 Kg in this so, I should have used a conversion factor of 0.2. I used 5 and that’s the reason you see 25. You will get it right by a bit of experimentation.
have a look at this what i’m looking for.
in your example Stock UOM is Nos and at the time of making LPO you select different UOM that’s why it worked.
in your example if you select the same UOM as your stock while making PO you’ll get the same result in both columns.
but on PO i need to display Box which is for supplier and receiving person. we cannot change UOM at the time of PO because there are around 1000 Items or more per PO and it’s not easy to change it every day. these PO’s are generated through scheduler using the Re Order Level logic.
So, did I give you a basic solution that you’d already considered and discarded? lol!
So give me a rough idea of what each of these 1,000 items look like, what is the UOM you are using for stocking, what UOM you want on the PO and for the Stores Person and what’s the conversion factor between these two UOMs? Is the conversion factor always the same or does it get different for each item?
The Idea is,
for items, these are retail Store Items.
we are using only two UOM. Nos and PIP(Box) these are defined in UOM List.
and yes Conversion factor is different most of the items. and there may be some items where there is only 1 UOM which is default Nos.
Add custom fields in Item, add the other UOM and Conversion Factor into it. Pull these into the Purchase Order Item, write a small custom script to multiply the Stock UOM (the only UOM you will use) by the Conversion Factor and return the product of these two into another Custom Field in the PO Item doctype and display these fields in your PO.