800
I have a request to modify the way the check amount wording is shown on a Stub Top/Bottom - Graphical layout.
A check for $500.13
Current wording example: Five Hundred Dollars And 13 Cents
Modified wording needs to be: Five Hundred and 13/100 Dollars
Can anyone tell me how to accomplish this? I would prefer to use a calculated field over VS.
*This post is locked for comments
Almost there, but not quite...
I need the cents to show as 13/100. As you suggested, I changed the Currency Subunit to "/100 Dollars" (Note: I need the slash in front of the Dollars). However when I do this it shows as 13 100/Dollars. Is there a different way to enter this? I think the problem may be the leading '/'...
My bad! You still need to preserve the Unit-Subunit Connector as "And". You can then set the Currency Subunit field to "100/Dollars".
Hope this clarifies.
Oops, my post above should show cents as 35/100. :)
Mariano,
First, thanks for the reply.
I tested this out and when making the changes above the amount on the check is written as
"Five Hundred 35 Dollars".
I need to make 2 adjustments: 1) Include 'And' between Five Hundred and 13/100 Dollars. 2) Show the cents as '13/100'. Is there a way to accomplish this?
You can accomplish this by changing the way the currency is setup. In the Currency Setup window (Administration | Setup | System | Currency) select the currency ID for US dollars, then clear the Currency Unit and Unit-Subunit Connector fields, then replace the Currency Subunit for Dollars.
In reality, these fields are used only for check printing, so nothing else should be affected throughout the system.
By doing this, you don't need to modify the report or create any customizations.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (