Troubleshooting Tips/Techniques to use ConvertNumericValueToWord (Convert Numeric Value To Word) for your Country/Language

Purpose of Document

The purpose of this document is to guide as-is implementation to Convert Numeric Value To Word to print check or some other purpose. Note that this conversion routine does not cover all language and formats.

• In case you need to find whether there is your country specific implementation: refer to JD Edwards EnterpriseOne Applications Documentation > (Tab) Localizations
• Currently available language options can be found at <Document 1476100.1> E1: DD: LNGP (Languge, LanguagePreference) and UDCs 01/LP, H79/AS and H95/LN
• General routine of X00500 is explained through <Document 1111286.1> E1: BSFN: Frequently Asked Questions on X00500C - Convert Numeric Value To Words

Disclaimer:
This document may contain information, software, products, services which are not supported by Oracle Support Services and are being provided “as is” without warranty.  

Please refer to the following site for My Oracle Support Terms of use: My Oracle Support Terms of Use

Using the suggested workarounds requires advanced knowledge of the JD Edwards EnterpriseOne toolset, including but not limited to using event rules, APIs, business functions etc..
Although logic examples may be provided; field assistance will need to be requested if the customer requires more detailed development help with their implementation. These are billable activities that are not supported by Oracle Global Support.

This document is made up of,

• Available batch applications to print Check
• General routine to Convert Numeric Value To Word
• Available Check print through R04572 (Print Automatic Payments - Standard Format)
• ConvertNumericValueToWord (N0400105 - Convert Numeric Value To Word - NER)
• Available countries and Check Routines
• List of business functions which converts Numeric Values to Words
• ConvertNumericValueToWords (X00500 - Numeric Value, Convert to Words)
• Currency Codes
• Languages
• Question and Answers

◊ Note that this document is written based on EnterpriseOne application release 9.1 so some of objects shall not be presented in your applications release.

Available batch applications to print Check
     : Currently below batch applications are available. In case you need to have your own you may choose nearest application to use it as base object. 

General routine to Convert Numeric Value To Word
      :  Each country has it's own generally accepted accounting method and guided format to make the output valid. Generally this routine contains

• Convert Number to word in specific language
• Formatting of values converted

Available Check print through R04572 (Print Automatic Payments - Standard Format)
      : Most of major currency can be printed using R04572 which calls Named Event Rule (NER) ConvertNumericValueToWord (N0400105 - Convert Numeric Value To Word - NER)

Note:

ConvertNumericValueToWord (N0400105 - Convert Numeric Value To Word - NER)

• Purpose: this function converts and formats input numbers based on Program Name (Business Function) specified. You can call this business function independently if needed.
• Parameter:
• Data Structure: D0400105 - Convert Numeric Value To Words - NER

Detail Routine

1. Check whether szProgramName is specified
2. If szProgramName is specified then convert numbers based on the business functions specified (either specify it from processing option of R04572* or manually populate it)
3. If szProgramName is not specified then get business function name from F0013 (Currency codes) from column F0013.CKR (CheckRoutine)

Available countries and Check Routines:

List of business functions which converts Numeric Values to Words
     : Currently there are available business functions as below,

ConvertNumericValueToWords (X00500 - Numeric Value, Convert to Words)

• Purpose: This business function will convert a numeric value to words and left fill the resulting array with asterisks.
• Parameters
• Data Structure: D0000213 - Convert Numeric Value To Words

Detail Routine:

• Set Array for words to count by 10 (ZERO, TEN, TWENTY, THIRTY, FORTY, FIFTY, SIXTY, SEVENTY, EIGHTY, NINETY)
• Set Array for numbers to 9 (0, 1, 2, 3, 4, 5, 6, 7, 8, 9)
• Set Array upto 19 (ZERO, ONE, TWO, THREE, FOUR, FIVE, SIX, SEVEN, EIGHT, NINE, TEN, ELEVEN, TWELVE, THIRTEEN, FOURTEEN, FIFTEEN, SIXTEEN, SEVENTEEN, EIGHTTEEN, NINETEEN)

Currency Codes

  : Same information can be found through P0013 (Currency Codes) application as below, 

Languages
  :  Refer to <Document 1476100.1> E1: DD: LNGP (Languge, LanguagePreference) and UDCs 01/LP, H79/AS and H95/LN. This note contains the list of languages which EnterpriseOne can translate.

Questions and Answers:

Question 1: Is there any available standard business function that provide the functionality to convert numbers to Eastern Arabic words?

Answer 1: Currently, there is no available business function to convert numbers to Eastern Arabic words.

Enhancement Request <Bug 11051348> - CONVERT NUMBERS TO ARABIC has been raised to provide this functionality in a future release.  If you are a member of Quest User group please refer to <Document 1192883.1> Enhancement Requests via Quest User Groups for escalating enhancement requests.

Question 2: Is there any limitation for X00500 and X00500FR?

Answer 2:  For both business function X00500 and X00500FR, if the string length of the amount that has been converted into words are exceeding the length of 83 characters, it will be printed as numeric values. If it is not exceeding the specific length, the total amount will be converted properly into words and it will also be printed in check.

From <Bug 10918080> - X00500 AND CHECKS OVER 1 MILLI - SAR: 8009325, it mentions that that this business function currently can only handle a total output string length of 83 including "AND 99/100". If the string length of the amount that has been converted into words are exceeding the length of 83 characters, it will be printed as numeric values. If it is not exceeding the specific length the total amount will be converted properly into words and it will also be printed in the check.

For instance,

5,953,125.99 will be printed as : FIVE MILLION NINE HUNDRED FIFTY THREE THOUSAND ONE HUNDRED TWENTY FIVE AND 99/100*************
55,953,125.99 will be printed as : $55,953,125.99 ********************************************************************************

In addition, the business function X00500 will only convert numbers up to XX,XXX,XX.99 digits. The business function X00500FR will only convert numbers up to X,XXX,XXX.99 digits

An Enhancement Request <Bug 25597886> - "X00500 CAN ONLY HANDLE A TOTAL OUTPUT STRING LENGTH OF 83 INCLUDING" has been logged to request the business function X00500 to handle more than 83 characters so that it can cater to a string output to the largest converted value of xx,xxx,xx.99 digits.

REFERENCES

<Internal_Only>

To be completed by end of June-2014. Since this is not completed document I set it as internal. Please review it and approve to stop time clicking

Updated on 07-Jan-2015 (further touch up to be done soon)

</Internal_Only>