cancel
Showing results for 
Search instead for 
Did you mean: 

PLD: two type of currencies need different decimals in the same place

Former Member
0 Kudos

Hi! Expert;

I have a problem with decimals in PLD.

First, I tried currencies set up as "Without Decimal" but only works on System Variable areas. I'm not happy about this result.

One currrency such as $, need two decimal places; however,

the other currency such as YEN, no need any decimal place

Example:

Concat (f_111,' ',f_222) in this field

Document Currency f_111

Document Total f_222

I tried Round(F_222,0) and but both of them show 0 decimal even using link to and formulas -such as

f_111 != 'YEN'

f_111=='YEN'

Please help me !! Thank you

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Naoko,

get the data in document by database fields instead using system variables. your problem will solved.

Thanks,

Suresh Yerra

Former Member
0 Kudos

Hi!

Thank you for your help

Most of data is made by database fileds, but decimal places are not working.

So I need a help for these fileds.

System variables is worked well, and I do not have any problems in these fields.

Thank you!!

Former Member
0 Kudos

Hi,

Instead of Round(F_222,0) try to use F_222x1 for 0 decimals.

For 2 decimals, use formula F_222x1.00

Nat

Answers (2)

Answers (2)

Former Member
0 Kudos

Dear Naoko Miyakawa,

You could use formula in PLD DecimalLeft(Round(F_222,0)) to show the amount without decimal in YEN currency.

Best Regards

Jane Jing

SAP Business One Forums

Former Member
0 Kudos

Dear Naoko Miyakawa,

Please try the solution as following steps:

1. In "Administration > System Initialization > General Settings > Display", set Decimal Places as 0 in Amounts.

2. For currency YEN, set Decimals is Default

For currency $, set Decimals is 2 Digits

Then when you create the document the amount YEN will have not decimal and $ will have 2 decimals.

Best Regards

Jane Jing

SAP Business One Forums team

Former Member
0 Kudos

Hi! Jane;

Thank you so much!!

I like your help but I can't decrease the decimal places.

Do you have any other concerns?

Thank you!!