Skip to main content

Amount In Words in Navision / Business Central

Hi Guys,

In this article, we will see how to display amount in words in Microsoft Dynamics Business Central. Here, I am taking an example of Report object which is widely used in Navision for converting decimal amount field into words.

Procedure :- 

Step-1

Declare the following Global Variables :

        RepCheck: Report "Check";
        NoText: array[2] of Text;
        AmountInWords: Text;

where, (1) RepCheck is a variable of  Report DataType Named as "Check" which is 1401.

(2) NoText is a variable of DataType "Text" with array Dimension value as 2 which is defined as shown above.

(3) AmountInWords is a variable of DataType "Text" which will store final result of amount in words.

Step-2 Now, add the following code in OnAfterGetRecord() trigger of DataItem containing that decimal field value.

So in my custom Purchase Order Report, i am adding code in the Purchase Header (DataItem) - OnAfterGetRecord() trigger.

 trigger OnAfterGetRecord()
 var
 begin
  RepCheck.InitTextVariable();
   RepCheck.FormatNoText(NoText, ROUND("Purchase Header"."Amount",0.01), 
"Purchase Header"."Currency Code");
   AmountInWords := NoText[1];
  end;

Here, I have rounded off the Amount to 2 decimal places and also define the "Currency Code" available in "Purchase Header" Table.

Basically "Currency code" varies from transaction to transaction and it also impacts on "Amount In Words" value. If Currency code is not available it may also be denoted as blank as ' '.

Step-3

Now get the variable "AmountInWords" under the DataSource "Purchase Header" in the report and display it in the design layout of Report as shown below.

dataitem("Purchase Header"; "Purchase Header")
        {
            RequestFilterFields = "No.";
            DataItemTableView = WHERE("Document Type" = const(Order));
            column(PH_AmountInWords; AmountInWords) { }
        }

After updating Layout & Code and running the report Amount will be displayed in Words as shown in below

Output:



Thanks for Reading😊

    Comments

    1. Unknown13 December 2021 at 15:11

      Very helpful

      ReplyDelete
    2. NAV Sparrow10 February 2022 at 02:27

      Still I'm getting 25/100 as Cents

      ReplyDelete
      Replies
      1. Kunal Huria11 February 2022 at 14:54

        You have to do some changes in Check Report (1401) to print decimal value in words. If you need more help plz share your mail ID for code reference.
        Thanks!!

        Delete
      2. NAV Sparrow13 February 2022 at 22:42

        yes please , tell me the changers , tharukaofficial@gmail.com

        Delete
      3. Anonymous17 May 2022 at 20:17

        Hello Kunal

        Please I need the reference code as well.
        tayoismail@gmail.com

        Thanks

        Delete
    3. Anonymous7 March 2024 at 12:58

      Still I'm getting 25/100 as Cents , Need Code
      [Email : tarunsingh962272@gmail.com]

      ReplyDelete

    Post a Comment

    Popular posts from this blog

    Flow Custom field to G/L Entry and other Posted tables : From Purchase Order to Posted Purchase invoice

    Hi Readers, In this blog we will see how we can transfer data from " Purchase Header" to "Purchase Invoice Header" & "G/L Entry" table in Business Central. In this example, will create "Remarks" field on Purchase Header table and after posting, flow it to Purchase Invoice Header & G/L Entry tables: Firsly, create required fields ("Remarks") in below mentioned tables by creating table extensions: Purchase Header (38) Purch. Inv. Header (122) Gen. Journal Line (81)  G/L Entry (17) For the Purch. Inv. Header table, you can just create copy the field from purchase header and paste it in  Purch. Inv. Header  table. If the field ID No. is same for that field for both the tables then you don't have to code i.e, it automatically transfer that field data from Purch. Header to Purch. Inv. Header . Step-(1)   tableextension   50104  "Purchase Header Ext"  extends  "Purchase Header" {      fields     {         
    1 comment
    Read more

    Calculate Date : Using Date Formula and CalcDate Function in Navision/BC

     Hi Everyone, In this article we will see how we can Calculate Date by adding and subtracting No. of Days / Months based on CalcDate and DateFormula datatype. Here, I define three variables required for: (1) " No of Days " -  To define No. of Days / Months as required. You can also use these units denoted as: <Unit> = D | WD | W | M | Q | Y (D=day, WD=weekday, W=week, M=month, Q=quarter, Y=year). (2) " From Date " and " To Date "  Date type Variables to store calculated date in it. page   50103  "Date from Date Formula" {     PageType = Card;     ApplicationArea = All;     UsageCategory = Administration;     SourceTable =  Integer ;      layout     {          area( Content )         {              group( General )             {                  field( "No. of Days"; "No. of Days" )                 {                     ApplicationArea = All;                 }             }         }     }      actions     {          area
    Post a Comment
    Read more