Help--Convert number to word

Comments

• Options

  RobertMo Member Posts: 484

  2005-01-08

  Take a look at the Payment Journals under Purchase & Payables area.
  Enter a payment and select Payments/Preview Check.
  You should see that your amount was converted into words.
  
  The functions that are doing that are found in Report 1401 Check.
  Also take a look at the form 404 Check Preview to see how previous report is called.

             ®obi           
  ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯

  0
• Options

  vikas Member Posts: 46

  2005-01-12

  hi..
  
  if you want to display the "Amount" field (as example) in text format then, creat a recordset of 1401 ("Check" Report), then a text variable of maximum length. With this you must also creat a recordset of "Gen. Journal Line" (so tht currency matches).
  
  then call this function,
  
  CheckReport.InitTextVariable;
  CheckReport.FormatNoText(NUMBERTEXT,ROUND(Amount,0.01,'>'),GenJnlLine."Currency Code");
  
  where CheckReport is recordset for "Check" Report and GenJnlLine is for "Gen. Journal Line" .

  0
• Options

  WarrenLiu Member Posts: 14

  2005-01-13

  Hi
  
  Thank you all for the valuable infomation. I followed your instructions and finished the report.
  
  Thanks again.[/quote]

  Warren

  0