Home

Can we restrict user to not to allow user to allow BOM to be enter only 3 digits after decimal.

is it possible can  we write a validation check to make sure that users enter the correct qty value?

 

On a BOM the qty can not have more than 3 digits after the decimal, we need to check this because SAP only allows 3 digits.

 

See example below:

OK – 12.111

Not Ok – 12.1111

 

Ok – 0.111

Not ok – 0.1111

 

Agile User Asked on May 17, 2021 in Product Collaboration.
Add Comment
Cancel
1 Answer(s)

Hello

Yes. you can definitely write a custom event (Update table) to validate this input

One point to note. Since BOM updates happen a lot, the event also will get fired for each row. So, it is better to run this check when the user is submitting the ECO

Hope this helps

– Raj

Cancel
Agile Angel Answered on May 17, 2021.

Madhu

Hi Raj,

Thanks for information and its helpful.

I was looking for the OOB solution, is this possible with Character sets ?

Thanks,

Madhu

 

on May 18, 2021.
Cancel

rchinnia

Good thought. But looks like you can’t do in BOM Quantity field even though you can set it to Numeric

If you configure a new “numeric” field, you can set the scale to 3 and that should solve. But they don’t seem to allow it in Quantity field

on May 18, 2021.
Cancel

Madhu

Hi Raj,

Might be  am wrong, But how can we use the UOM. Where it is applicable?

on May 19, 2021.
Cancel
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.