Rounding on SAP B1 Clients?

[Former Member]

HI all!

Please shed some light for me on this topic:

sometimes i use number roundings and decimal specification dinamicaly.

(like if the rounding (default is 0.01): currency on the document is X then 0 else 2)

my value is 3212.4243

on the server, where my cr is installed it shows:

3212.42

on the server in my b1 client:

3212.42

on an sap client (connected to the same server):

3212

[Former Member]

8.8 pl 18

[Former Member]

This could be a bug. You need to do more testing and try reproduce the issue from demo db.

[Former Member]

I managed to solve this, by trial and error.

For a reference for every one:

the values defined here (not in the formula) overrule the final resoult of your formula.....

So:

if you define the rounding to 2 digits, then create a formula, to set this sometimes to 4 digits, the reports WILL display 4 digits, but the value will still be rounded to 2 digits....

I didn't had time to vertify that is this client only behaviour, or not, but best practice for me now follows as:

set the rounding to the most you'll need (for this example to 4) then create te formula the other way around (so to make it 2 digits most of the time.

Hope this helps some one.

Regards.

D

[Former Member]

This is the same across all versions and PL:

If you define the rounding to 2 digits, then create a formula, to set this sometimes to 4 digits, the reports WILL display 4 digits, but the value will still be rounded to 2 digits. It is very reasonable.

[Former Member]

What is your B1 version and PL?

[Former Member]

In your example, what is the document currency?

[Former Member]

Gordon,

Then i'll put it anotherway, because the doc cur and even the doc type is indiferent here, it doesn't matter whats the data.

My problem is:

On the SAPB1 server rounding works dinamicaly (334321.231 to 334321.23. and if there is no decimals 100,00 to 100), and on the SAPB1 client not (334321.231 to 334321.00 instead of 334321.23, the no decimals logic works okay).

THe only difference is i'M running the same riport on a client pc or on the server.

i hope this one is clear enough now, if not i'll rephrase again (=

Regards&Thanks

Daniel

Edited by: Daniel Omaisz Takacs on Feb 9, 2011 6:41 PM

[Former Member]

Your question is not very clear. Please clarify what is the exact meaning of currency on the document is X then 0 else 2. Where did you put the formula?

Thanks,

Gordon

[Former Member]

Sorry then.

at the formating of the number, i chose custom, then at the roung formula i specify

if oinv.doccur="Ft" then 0 else 2

this means, if the documents currency is not HUF, then use rounding to 2 digits.

i do the same with the number of digits.