Rounding of decimal places

[kothandaraman_nagarajan]

Dear Experts,

I have problem while rounding the tax amount.

Problem:

While printing local purchase order, the tax displayed with two decimal places. but if i print in USD currency, the tax displayed without decimal places.

Note: The printlayout is same for both PO and decimal places are rounded to 0.

Thanks,

Nagarajan

[Former Member · Accepted solution]

Hi Hagarajan

Do you want 2 decimals or no decimals? Are you using the system variable or table field? The best is to change to using the database field instead of the system variable and then try formatting. The system variable always includes the currency so this is a character field and not a value field, making it difficult to format. Then add a field with the currency and link the 2 if you want the currency to display.

Kind regards

Peter Juby

[KennedyT21]

Hi Naga Rajan...

Does the Issue closed or Not if closed the close the thread with correct or helpful answers

Regards

Kennedy

[KennedyT21]

HI Naga Rajan..

Check with the currency setup how many decimal places set for the rounding....

Hope Helpful

Regards

Kennedy

[Former Member]

Hello Naga,

    You said u r using PLD so in that Are you using the system variable or table field? If you want decimals or no decimals, Instead of changing the system variable best way is to change using the database field and reformatting. Actually the system variable is a character field which always includes the currency so this making it difficult to format. after that add a field with the currency and link the 2 if you want the currency to display which is the better way for handling this type of issue.

Regards

Rakesh

[former_member186712]

Hi Naga,

Are you using PLD or Crystal reports?

Regards,

Augusto Silva

[kothandaraman_nagarajan]

Hi,

I am using PLD.

Thanks & Regards,

Nagarajan

[former_member186712]

Try this in the field you want to print.

Round(field, 0)