on ‎2020 May 26 10:53 AM
Greetings Experts
We have a requirement that when a value is generated by the system, it should consider what the base UoM is and round it accordingly. Allow me to give 2 examples.
1. We are working with Chairs with a base UoM of Each. When the system generates a value or when disaggregating, the system should round 1.2 chairs to 2 chairs. Integer only required as the base UoM is in Each.
2. We are working with Cables with a base UoM of Metre. Here the vendor supplies cables in, lets say, 0.5 metre increments. So my procurement suggestion should round a value of 1.76m to 2m.
I hope what I have described makes sense. The idea is similar to Rounding values and Incremental lot size but in the context of UoM.
I will appreciate any solution or workaround to this requriement.
Regards,
Mohammad
Request clarification before answering.
if you want to really round (then 1.2 would become 1), you could change the decimals to 0. That does rounding by base UoM. That would be pretty easy. The setting for the rounding is the same then for the display of the KF decimals for the webUI
But if you always want to round up (1.2 will become 2), you need a workaround. You have the Base UoM as attribute to your product, so you can check on it. So you would need to do a calculation on ….PROD...UOMTO - level and check the target currency vs the BaseUoM.
I dont have a solution for that second use case out of the box, but I assume using 0 decimals would help here as well
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 14 | |
| 9 | |
| 8 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.