Microsoft Dynamics GP (Archived)

Printed Cheque amount in words

(0) Share

Report

Posted on by Alaa Ramadan

4,130

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:

One Hundred Fourteen Dollars and 00 Cents

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Stefanie Christiana 75 on at

Like (0)

Report

I have this same problem. Anyone have a solution?

Thanks!

Was this reply helpful? Yes No
Verified answer

Arayan Sinanan 65 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
spena 1,501 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
David Musgrave MVP ... 14,095 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Using report writer we can easily achieve this. For your Reference

congruentdynamics.blogspot.in/.../converting-dollars-and-cents-to-words.html

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report
Create the below calculated fields in Report Writer and drag the final calculated field (12th) to your report.

amount = Pass your amount here

dollars = RW_Truncate (amount, 0, 0)

cents = (amount - dollars) * 100.0

dollarstr = RW_ConvertToWordsAndNumbers (dollars, 0, 0)

centposition = RW_Pos (dollarstr, "00", 1)

amountinwrd1= RW_Left (dollarstr, centposition - 1)

amountinwrd2 = RW_Substring (dollarstr, centposition + 2, 20)

centinwrd1 = RW_ConvertToWordsAndNumbers (cents ,"_", 0)

length = RW_Length (centinwrd1)

centinwrd2 = RW_Left (centinwrd1, length - 4)

amountinwrd3 = RW_Trim (centinwrd2 , 3, " ")

resultinwords = amountinwrd1+ amountinwrd3+amountinwrd2

Hope this helps!!!

Was this reply helpful? Yes No
sattty on at

Like (0)

Report

How to do that, I am stuck with it?

Was this reply helpful? Yes No