4,084
Does anyone know why the amount in words show like the following when i print check with amount of $114
**114 Dollars and 00 Cents
and why is not showing like this:
*This post is locked for comments
Create the below calculated fields in Report Writer and drag the final calculated field (12th) to your report.
Hope this helps!!!
Using report writer we can easily achieve this. For your Reference
congruentdynamics.blogspot.in/.../converting-dollars-and-cents-to-words.html
From the RW Function SDK Document
RW_ConvertToWordsAndNumbersParse
Module:
System Manager
Series:
System
Script type:
Global function
Form (If a form global):
Category:
Numeric Manipulation
Description:
Convert currency value to Words and Numbers, using descriptive terms from the Currency ID supplied. Returns the result parsed into lines of a specified length. Uses the Dexterity Field_ParseText() function.
Prerequisites:
none
Parameters:
in currency IN_Value. { Value of Currency }
in string IN_Currency. { Currency ID of Currency - Leave Blank for Functional }
in integer IN_Mode. { non-zero = Use Numbers and Words instead of only Words }
in integer IN_Characters. { Number of Characters per Line }
in integer IN_Line. { Line Number to Return }
Return Value:
function returns string OUT_string.
For more information:
blogs.msdn.com/.../using-the-built-in-report-writer-functions.aspx
David
Hi,
Can you please provide a screenshot of what the Calculated Fields looks like in Report Writer? I'm assuming you need a calculated field because when I try and apply a format to the String A 255, I get an error saying you can only apply formats to Integers.
This is due to the use of the Amount to words and numbers function and not the Amount to words function. You can customize the check using the report writer and use the Amount to words function and remove the amount to words and numbers function.
I have this same problem. Anyone have a solution?
Thanks!
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (