cancel
Showing results for 
Search instead for 
Did you mean: 

Rs to display in Pld For Amount in words.

former_member206437
Active Contributor
0 Kudos

HI Good Mormning to Every One

In PLD My Invoice amount i made to display in words also for

it is displaying like : Fifty Seven Thousand Eight ninty three Indian Rupee And fifyt two paisa.

But i would like to show like this : Fifty Seven Thousand Eight ninty three Rs And fifyt two paisa. or

Rs Fifty Seven Thousand Eight ninty three And fifyt two paisa.

How to do this?

Regards

Giridharan

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Giridharan,

Jacqueline Jiang is right that means this is SAP limitation,But you can achive this using formulas.

You can print amount in words in indian format using formulas

e.g

1)One System Variable Named u201CField_092u201D of value 88

i.e. print the Document Total here.

2)Three Database Fields named u201CField_095u201D,u201Dfield_096u201D and u201CField_097u201Detc.

Field_095 means AR Invoice : Document Currency

Field_096 means Currency Codes: Currency

Field_097 means Currency Codes: Name of 100's on checks

Note: Set Relate to property of Field_096 and Field_097 's to Field_095

3)Three Formula fields named u201CField_093u201D,u201DField_094u201D and u201CField_098u201D

Field_093 means "DecimalLeft(Amount(Field_092))"

Field_094 means "DecimalRight(Amount(Field_092))"

Field_098 means "Concat(Field_093, ",Field_096," ",Field_094," ",Field_097)

4)Field_098 is the Out Last Formula to print amount in words in Indian Format except this hide all the fields.

Hope this will resolve your issue..

Regards,

Mahendra

Edited by: Mahendrakumar on Jul 18, 2008 7:06 AM

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Giridharan,

U can get Rs by changing

1.open administration>setup>currencies

2.change the description in column english to Rs for ur currency row.

3. then u will get rs in pld

Regards,

Naresh k

Former Member
0 Kudos

Hi Giridharan,

Sorry to let you know that this is currently a system limitation.

As a workaround (in order for your customer to print the amount in the desired format), they can add a user defined field to the title of the marketing documents, and fill it with the desired amount in word

manually before printing. They should also modify the default printing template and link the total amount field on the template to the UDF they added.

Hope it helps.

Regards,

Jacqueline Jiang

SAP Business One Forums Team

former_member206437
Active Contributor
0 Kudos

Hi Jacqueline Jiang

Thanks for ur reply.

Whether we can't do anything by using formulas or by queries in PLD? other than avoiding the UDF.

Rgds

Giridharan