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 test the value of an option field in AL (Dynamics) Business Central

I'm new to AL (Business Central). I want to be able to test the value of an option field. if myOptionField::Booking then begin Message('Booking'); end; But it didn't work.
AbdulAzeez Olanrewaju
  • 976
  • 1
  • 13
  • 32
0
votes
1 answer

Import and export files between D365 Business central and VM

I'm working on a project where I've found myself in a situation where i need to import .txt files into d365 business central from a repository in a distant Virtual Machine. Is it possible to establish such connexion in both ways…
0
votes
1 answer

What is difference between AL programming language and X++ language in Dynamic 365

I am trying to learn Dynamic 365 and I need to know what is difference between AL Programming langauge and X++. what are the usage of each.
MJ X
  • 8,506
  • 12
  • 74
  • 99
0
votes
1 answer

How to subtract current value from previous value in a column using C/AL code

I have a column that I need to subtract a current value from the previous value in Bid Price LCY column and save the result on another column called Daily Return(Offer). The value is incrementing instead of decrementing in Daily Return(Offer)…
Annie
  • 33
  • 11
0
votes
1 answer

How can I create a nested IF without ELSE in Business Central AL

I would like to have a nested if without an inner else but I do want to have an outer else branch. See the following procedure as an example: procedure GetRelatedInvoiceHeader(SalesCrMemoHeader: Record "Sales Cr.Memo Header") SalesInvHeader: Record…
binford
  • 1,655
  • 1
  • 18
  • 36
0
votes
1 answer

Business Central Codeunit "Base64 Convert" is returning different base64 code than an online converter

I am trying to convert a report to base64 code so that I can send it to a different application via API calls. To test, I used an online pdf to base64 converter, I copied the generated code and the application successfully received the document that…
0
votes
1 answer

Exchange data from Microsoft Business Central to JavaScript

Curerntly I'am working on a scanner that inputs data into BC fields. The communication between the device and the software is in javascript. I can send data from JS to BC with Microsoft.Dynamics.NAV.InvokeExtensibilityMethod('BarcodeRead',[BCode]…
0
votes
1 answer

DocuSign Integration with Dynamics 365 Business Central

We have a software extension for Dynamics 365 Business Central. I want to integrate our product with DocuSign. Where should I start looking? I have been searching online for the past couple of days and I haven't found anything explaining how a C/AL…
0
votes
0 answers

Using OpenAL-Soft in Ubuntu fails to return device

I'm new to audio programming in Ubuntu 20.04 and was looking at open source audio libraries and found OpenAL-Soft. I'm following this tutorial online https://www.youtube.com/watch?v=kWQM1iQ1W0E&ab_channel=Code%2CTech%2CandTutorials The basic code…
Brian
  • 105
  • 12
0
votes
1 answer

Add serialized item tracking details to a transfer

So we are trying to shore up some gaps with implementing Microsoft Dynamics Business Central 365. Currently testing out v19 W1 on-prem. One of our use cases involves serialized items. To help shortcut the process, since the Serial No. values are…
gregarican
  • 105
  • 1
  • 11
0
votes
2 answers

shortcut of multi-conditions with and in AL and Business Central?

Suppose we've procedure is_even return if the number given is even or not! that's a good code: if is_even(22) = true or test(1) = true or test(2) = true then //... And even that's a better: if true in [ is_even(22), is_even(1), is_even(2) ]…
XMehdi01
  • 5,538
  • 2
  • 10
  • 34
0
votes
1 answer

Setting the value of an Enum field in a temporary record

Total newbie in AL here; I'm experimenting with automated testing in Dynamics BC for a new deployment. As a very basic test, I'd like to simply create a new Item record in the Cronus test database and validate each field. I'm running into trouble…
Werrf
  • 1,138
  • 6
  • 14
0
votes
1 answer

Converting DateFormula to DateTime

In business central there is this data type named DateFormula, in it you can define things like '1D + 2H + 3S' (1 day, 2 hours and 3 seconds). I found out that i can convert this time range to a Date using CalcDate() however, Date objects dont…
Luke_
  • 745
  • 10
  • 23
0
votes
1 answer

Print multiple reports on business central

I need to use multiples Report.Print() in a code, but business central only prints the last requested print. Using a dialog.confirm(), a page.runmodal() or a message() between the prints works, but I need the code to run automatically without user…
0
votes
1 answer

Add a new Role Center On Dynamics 365 Business Cental

I am working on an AL programming project in order to add new functionality to the existing Business central .I am trying to add a new button on the role center like shown in the image. I want to add "Gestion des compétences et des carriéres". Is…