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

Date Filter is not covering correct time range

I have two fields ("Start date","End date") both being of type Date. And I also have two scenarios which I'm trying to cover up - without success: A: "Start Date" is not defined, but "End Date" is e. g. Start Date=0D,End Date=31.12.2020. That now…
0
votes
1 answer

Business Central API - Create Custom API Page for Sales Invoice Lines

I need to create a custom API Page for Business Central on Dynamics 365. I need to get a the AL source for the API…
0
votes
1 answer

Business Central API Extension: How do I connect insert trigger to API Custom Page?

I created a new page type of API that uses the Sales Invoice Header Source. I would like to get newly inserted Record and update its value. After that display that values in alert. Currently I have an empty page after I create new Sales…
Jure Fadiga
  • 195
  • 2
  • 19
0
votes
1 answer

Business Central Create new View not displayed in DropDownList

I am trying to create a new view for Purchase Invoices. I am used this example: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-views When I import the extension on my demo tenant successfully, there were no…
Jure Fadiga
  • 195
  • 2
  • 19
0
votes
1 answer

Automatically setting parent id when creating item from list part in Business Central/AL

I am quite new to building extensions with AL for Business Central. I am trying to setup an extension for a school application. The tables I have built work, and they follow this data model: School - Course - Lecture | / Teacher Inside the…
-1
votes
0 answers

Is there any way I can return Text in Bound Action in Business Central?

I tried to return Text in Business Central Bound Action but in the Odata the api is not seen, when I removed the return type it is seen. Is there any way? Below is my code. [ServiceEnabled] procedure CreateOrder(var ActionContext:…
-1
votes
1 answer

with this code as no idea why. voices = engine.getProperty('voices') KeyError:'VoiceAge'

I am trying to create a Voice Assistant but cannot get over this error from this code as nothing is helping me out even looking it up. import datetime import pywhatkit import wikipedia listener = sr.Recognizer() alexa = pyttsx3.init() voices =…
Michael
  • 1
  • 2
-1
votes
1 answer

Error exporting data to JSON in Business Central

I am trying to export data to Json and having some trouble. When I run this I get error that says: The JSON object already contains the key 'Description'. And the same error comes up with whatever line is run where I'm adding. Here is my code, can…
Hansen
  • 1
  • 2
-1
votes
3 answers

Get a list of relations ordered by pivot field in Laravel

Basically I have users who belongs to many users. We can imagine friendship relations between users. So I have a pivot table for the relation, with the id's of 2 users and one additionnal field 'created_at'. users table: id, name friend_user table…
-1
votes
1 answer

how to publish code from VSCode to Dynamics 365 Business Central production environment

I'm writing code in Al extension for Dynamics 365 Business Central in VS Code and trying to publish it to strong textproduction environment(sandbox i tried and it worked) that stores data to Azure. Now publishing thing to production environment is…
1 2 3 4 5
6