Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

written amount on checks

Status
Not open for further replies.

agridge

MIS
Feb 12, 2001
2
US
I've been using approach for some time to write my laser checks. I've been sucessful in accomplishing most aspects necessary such as collecting payroll tax, w-2, and 1099 info, expense and account tracking. I would like to know if anyone has come up with a method to take the check amount number and convert that to a written amount. Currently I must either type this written amount into a field that prints or cut the written check amount into each check using an old mechcanical check writter. Both of these options are workable, but can lead to a check produced which has a typed amount either misspelled or different than the number amount, which is usually the correct amount because it's derived from the pay information or invoices paid information that is entered. One other problem that I've had is the blank page that ejects after each check form or report is sent to the printer. How can I turn that off.

If you can help, I'd appreciate it.

agridge
 
1) Newer versions of Approach have a NumToWords() function you can use to create a calculated field containing the words for any number field selected. If you have an older version of Approach (97 or earlier), there is a free download on XpertSS.com that demonstrates how to turn a number into words. Take the "Free Download" link on that site and do a search for "check".

2) The printer problem, if you have version 3 of Approach on W95/98, can be fixed by editing the file WIN.INI with notepad. It is in your Windows folder. Find the [Compatibility] section and a line in the text file starting with Approach= . Put a semicolon in front of the word, like ;Approach= and save the file. Reboot for this to take effect.

Sue Sloan
 
Thanks Sue. Mucho Grasics. Kudo's. Etc. Appreciate your time. A Ridgeway
 
This problems may have been resolved long time ago.
But, in Crystal Report 6.0, there is a much easier way to convert the amount from the numeric status to the words of that amount, even it takes care of the negative amounts:
ToWords(fieldname).
Kamal Khalil
Sr. Client Technical Analyst
kkhalil@Houston.ds.adp.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top