on 07-17-2008 5:22 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.