Distribute amount by quantity does not allow whole number

(0) Share

Report

Posted on by Community Member

Hello,

I am trying to distribute the amount for an item by quantity, but item is for some reason not allowing a whole number. It always has a trailing number at the end, unless I do a perfectly even split.

For example, I have 700 quantity and want to split 400-300: it defaults to this 400.003 and 299.997 and I cannot change it

But with a perfect even split it works

Thanks

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Khaled Alloud 3,658 on at

Like (0)

Report
Copy link

Link copied!

Dear JonH,

Why do you want to split the lines per quantity on this level?

Thank you,

Was this reply helpful? Yes No
Suggested answer

Chandra Wijaya Seti... 1,145 on at

Like (0)

Report
Copy link

Link copied!

Maybe due to your unit decimal setup ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Kaled,

The client wanted to be able to perform this function in a system test

Chandra,

I checked all the decimal rounding for the units and they are all at 0...any idea what could be causing this?

Was this reply helpful? Yes No
Suggested answer

Khaled Alloud 3,658 on at

Like (0)

Report
Copy link

Link copied!

Hello JonH,

I do not think this is possible in form; however, what is the business purpose behind this request, this client request might be valid.

Regards,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Kaled,

Sure, when the client needs to split the line between two different department you would use the distribution so that you can post to two different financial dimensions for the line. Do you have any idea about what could be causing this rounding issue?>

Thanks

Was this reply helpful? Yes No