RW - Getting RW_ConvertToWordsAndNumbers() to show cents in words
A little while ago I wrote an article about how to get the RW_ConvertToWordsAndNumbers() report writer user defined function to work correctly for both originating and functional currency views. Today, a comment was added to that article asking about how to get the RW_ConvertToWordsAndNumbers() function to return the cents in words rather than numbers.
Usually the function will convert the dollar amount into words but the cent amount is shown as numbers.
For example: Using the amount 1,234.56 and the currency ID Z-US$ will return:
One Thousand Two Hundred Thirty Four Dollars and 56 Cents
However, the request was to get the following, with the cents in words:
One Thousand Two Hundred Thirty Four Dollars and Fifty Six Cents
None of the available Report Writer (RW) functions which can convert amounts to words can achieve this result. So...
I decided to write some Dexterity code (using the Runtime Execute window in the Support Debugging Tool) to manipulate the values returned from the function to achieve the desired end result. This code is written only using RW functions so it can be transferred to calculated fields in the report writer easily.
The concept is to separate the dollars amount from the cents amount and then pass the cents amount to the function as though it was a dollar amount. We then take back the resulting strings and splice them back together to get the result we wanted.
Dexterity Code
I then took the same logic and formulas into report writer as calculated fields and created an updated version of the report from the original post (see attached).
Please see the link below for the original article:
RW - Getting RW_ConvertToWordsAndNumbers() to work with multi-currency
An example package of the v10.0 POP Purchase Order Other Form is attached at the bottom of the article.
Hope you find this useful.
David
