cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

UoM rules to round input/output SAP IBP

mzahmed
Participant
0 Likes
295

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

Accepted Solutions (1)

Accepted Solutions (1)

Irmi_Kuntze
Product and Topic Expert
Product and Topic Expert
0 Likes

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

Answers (0)