How to convert amount in words in Microsoft Dynamics Navision.

For converting the valid numeric value to words, follow below process.

-Create new codeUnit and define two variable as shown below.



Name
Datatype
Subtype
Length
Dimensions
AmountInText
Text

90
2
Rpt
Report
Check



Now write wire below code to “OnRun” trigger of code unit.

Syntax: object.FormatNoText(<AmountArrayVariable>,<Numeric value>,<Currency Code>)

Code::
Rpt.InitTextVariable;
Rpt.FormatNoText(AmountInText,2023,'');
MESSAGE(AmountInText[1]);

Output:



Comments

  1. Rahul JanakMarch 21, 2017 at 3:37 AM

    Hi, I would like to know whether you have added any extra code for rupees and paisa to appear in the text. Thanks.

    ReplyDelete
  2. AnonymousFebruary 8, 2018 at 10:58 AM

    I have error: You hace specified an unknown variable. InitTextVariable. Define the vaiable under 'Global C/AL Symbols.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to make and use web service in Microsoft Dynamics Navision.

Image
Web services is use to do operation on data of NAV from outside the NAV environment, you can’t insert, update, delete the data of NAV using web service with proper authentication. For creating the web service in NAV follow below steps. (Here we are making the web service with gives vendor name based on vendor number. And we consume this service in windows application outside the NAV area.) Open NAV development environment and create the new code unit. Make one function “GetVendorName” Function name: GetVendorName Input Parameter : VendorNumber Output (Return) parameter : VendorName Now write below code in function. IF Vendor.GET(VendorNo)THEN BEGIN     EXIT(Vendor.Name); END ELSE BEGIN     EXIT('Vendor Not Found'); END Now save this codeunit with proper Id and Name. Now open the client application module and search for ‘Web service’ in search text box.  Open the “Web service page” and click on “NEW” button, it will ask following details Object Type: Codeunit Obj...
Read more

How to use Format function in Microsoft Dynamics Navision.

Image
Format function is use to display date in various format some example given below. Format function take 3 input argument First: date which you want o display Second: number of character return by default is 0 (o means return all the string) Third: string format in witch you want to convert. Example: 1 MESSAGE('Today  date is : %1 ', FORMAT(TODAY,0,'<Month Text> <Day,2> <Year4>')); OURPUT: Emaple:2 MESSAGE('Today  date is : %1 ', FORMAT(TODAY,0,' <Day,2> <Month,2> <Year4>')); OUTPUT:
Read more

How to create simple report in Microsoft Dynamics Navision.

Image
Report is one type of data representation in NAV , report is use to display data from the database to outside user. Here we make simple customer list report as example, for creating simple report using Microsoft SQL server report builder you have to follow below steps. Open the Microdot Dynamics Navision development Environment and  go to “Tools  >> Options ” and go to “Use Report Builder” variable and set it to “Yes” and  then close screen by clicking on OK. Now go to “Report” table and click on “new” button. It will open new windows, here you have to specify the data item as any table which you want to display in report, and here we take “Customer” table as show in below image Now we have to add column which is used in report so for adding this we have to add data columns  for this, so go to next row and select column as data type and for adding column you can go to Option >> Field  menu option as show in below image. Now select the field which you...
Read more