Draft:AL (programming language)

From Wikipedia, the free encyclopedia
  • Comment: Three of the four sources are definitely primary and the last is close. We need in depth coverage in independent secondary sources. Stuartyeates (talk) 08:28, 28 April 2024 (UTC)

AL (programming language)[edit]

AL is the programming language for Microsoft Dynamics 365 Business Central, which marks the inclusion of the former Microsoft Dynamics Navision as ERP software into the Microsoft 365 environment. With this change AL replaces the C/AL programming language as programming language for the newer versions of the software.[1][2]

Differences to C/AL[edit]

AL is being written in visual studio code instead of C/SIDE (Client/Server Integrated Development Environement), which is also what the C in C/AL stands for. The launch conditions to apply changes to the software are set in .json files.

Other differences include:

  • Procedure overload[3]
  • Page extension objects to add to objects outside editing permission
  • Protected variables have been added[4]

Examples[edit]

Hello World[edit]

This is the classic Hello World example. Like C/AL the AL language despite being written in Visual Studio Code does not use the console output, therefor this example uses the dialog box.

MESSAGE('hello, world!');

Functions and filtering records[edit]

Variables are defined in the code in front of the function as local or at the bottom of an object as global variables.

local procedure getCustomer(value : Integer) : Text
var
    customer record: customer
begin 
    customer.SETFILTER("ID",value);
    IF customer.FINDFIRST then
        exit(format(customer.name));
end;

Looping and data manipulation[edit]

Going over reasonably large sets of data to edit them in code is achieved with only a few lines of code.

Item.RESET;
Item.SETFILTER("order date",'%1..%2',010123D,311223D);
IF Item.FINDSET THEN
  REPEAT
    IF Item."Weight In Kg" > 20 THEN BEGIN
      Item."shipment price" := Item."shipment price"  * 1.2;
      Item.MODIFY(TRUE);
    END;
  UNTIL Item.NEXT = 0;
Item.MODIFYALL();

See also[edit]

References[edit]

  1. ^ Brummel, Marije; Studebaker, David; Studebaker, Chris (2019). Programming Microsoft Dynamics 365 Business Central. Packt Publishing. pp. 5, 25. ISBN 978-1-78913-779-8. Archived from the original on 29 April 2024. Retrieved 2024-04-29 – via Google Books.
  2. ^ "The new development experience for Microsoft Dynamics 365 Business Central: Making things worse?". MSDynamicsWorld.com. 2019-05-14. Retrieved 2024-04-27.
  3. ^ SusanneWindfeldPedersen (2022-02-15). "Procedure overload - Business Central". learn.microsoft.com. Retrieved 2024-04-27.
  4. ^ "cmty_blog_detail". community.dynamics.com. Retrieved 2024-04-27.