Stack Overflow
Stack Overflow

Questions tagged [dynamics-al]

Application language (AL) is the language used to create objects in Microsoft Dynamics 365 Business Central. With AL, you can manipulate data, and the statements and functions are able to read, write, and change data in the Business Central database. Use with the [dynamics-business-central] tag

AL is a programming language to create objects in Microsoft Dynamics 365 Business Central. From the Microsoft site

All functionality in Business Central is coded in objects. The extension model is object-based; you create new objects, and extend existing objects depending on what you want your extension to do. Table objects define the table schema that holds data, page objects represent the pages seen in the user interface and codeunits contain code for logical calculations and for the application behavior. These objects are stored as code, known as AL code, and are saved in files with the .al file extension. The AL Language extension also supports the multi-root functionality which allows you to work with multiple AL folders within one workspace.

85 questions
0
votes
1 answer

How to make an Action that opens a page that is filtered after multiple option values in AL?

I'm pretty new to business central so excuse me if this is a rather stupid question. I have been trying to make a button that sends the user to a page where he can see products that are new or old. A product has a field named "Status" which can have…
lino1000
  • 13
  • 5
0
votes
1 answer

Email Body for a custom report in Business Central

I have created a custom (.RDL) report in SQL Server Report Builder and an AL extension that emails this report as a PDF attachment from an action on a custom page & table in Business Central. This is working fine. My question is about the email body…
NickSO
  • 33
  • 2
  • 6
0
votes
1 answer

Blob field not displaying on Business Central page

I've created a table and a page in a BC extension. One of the fields in the table is of type: BLOB. It is not displaying on the page. I've tried to replicate what happens with the 'Work Description' BLOB field in the Sales Header table / Sales…
NickSO
  • 33
  • 2
  • 6
0
votes
1 answer

Dynamics Nav: How do I create and link an editable field to two tables using Events?

I've created a table and a page for my custom field and I've extended the Customer table and Sales Header. Basically, I want to create a new field in the customer table, card, and list. This field needs to appear also in the Sales Invoice under the…
SadCoder
  • 21
  • 4
0
votes
0 answers

Where should we need to convert images from rgb to greyscal in image classification

I am working with an plant disease image classifiaction, is it necessary to convert the dataset to greyscal
MR_MYSTERY
  • 9
  • 2
0
votes
1 answer

Where can I find table and field specs on the existing tables in Business Central?

I'm trying to create Relations to fields in other tables from the standard BC install. For example adding a table with a field having a Relation to the UOM table in Business Central. From my current knowledge, what I'm seeeing, on the table list,…
Redgren Grumbholdt
  • 1,115
  • 1
  • 19
  • 36
0
votes
1 answer

How to find identify blocks that do not contain specific word between brackets

I'm new to regex, and I have a question. Is it possible to use regex to identify blocks that don't contain a specific word between two specific characters? I want to highlight all blocks starting with action, part, systempart or field, followed by…
db_0123875
  • 11
  • 1
0
votes
1 answer

Why is Filtergroup (-1) in Navision Page OR filtering on page level not working

Is it possible that filtering with an OR condition (using FILTERGROUP(-1)) isn't working on page level`? and if so, why isn't it working? I'am new to MS-Navision and i try to understand the underlining programming of it. in MS-Navision Cronus-AG DB…
Yoo oo
  • 83
  • 1
  • 6
0
votes
1 answer

AL:Go! command not found

I just installed the AL extension in VS Code, and am trying to run the Al:Go! command, however it produces an error and indicates that the command 'al:go!' is not found. When I open the command palette and begin to type in the command, it offers…
maplesyrupman
  • 41
  • 4
0
votes
1 answer

Unable to convert from NavJsonValue to NavDate

After making a Get-Request to an Endpoint, I parse the returned Json String key by key, which works. The problem occurs when I try to convert the returned Date ('createdAt') to Date Type. The error I receive Die Konvertierung von…
samuel gast
  • 331
  • 4
  • 17
0
votes
2 answers

Selected / Marked records on Business Central page

In an AL Extension CodeUnit, how do you iterate through the records that a user has selected / marked / ticked on a list page using the 'Select More' functionality? For instance, is there an IsMarked / IsSelected / IsTicked property in a data-type…
NickSO
  • 33
  • 2
  • 6
0
votes
1 answer

Understanding JSON Iteration

I work in a language called AL for work but we have JSON Objects, Arrays, etc.. I'm querying this api: http://citibikenyc.com/stations/json and I have the result stored in a text variable. My objective is to store the ID and Station Names in a…
Lewis Hyett
  • 1
  • 1
0
votes
1 answer

Can't resolve domain name

I'm learning AL programming in BC and I'm experimenting with the HttpClient class to make http requests. I try to make a request to the jsonplaceholder api but I get a "The remote name could not be resolved:…
joaorosadev
  • 45
  • 5
0
votes
1 answer

SerialPort read in extension fails on dotnet error

I'm writing an extension that reads serial port data. I'm running on BC14 OnPremis. Here is what I have. The global variable, running on client side (obviously serioal port is not on the server, with events because I need to receive data…
Mak Sim
  • 2,148
  • 19
  • 30
0
votes
1 answer

Business Central AL Code Hyperlink Method

I need to display a URL during the login process in Business Central. Have an event on the OnAfterLoginStart event. Part of the event code will display a Terms of Service. Displaying the terms of service page as following: …
D. Moore
  • 33
  • 5
1 2 3 4
5
6