Microsoft Business Central development; including AL, JavaScript and .NET extensions, consuming or connecting to the Business Central API and Web Services, and installation and configuration of the development tools. Questions about how to use the product as an end user are off-topic here, as are questions about installation of the ERP system itself.
Questions tagged [dynamics-business-central]
289 questions
0
votes
3 answers
NOT IN statement is slowing down my query
I have a problem with my query. I have a simple example here that illustrates the code I have.
SELECT distinct ID
FROM Table
WHERE IteamNumber in (132,434,675) AND Year(DateCreated) = 2019
AND ID NOT IN (
SELECT…
pancake
- 590
- 7
- 24
0
votes
2 answers
Starting docker container that is more than 90 days old
I had created a docker container image for Business Central 2 months ago. Now when I try to start the container it starts with an unhealthy status and Business Central client doesn't work.
docker start
I checked the logs that told me…
Khadim Ali
- 2,548
- 3
- 33
- 61
0
votes
1 answer
Insert a Power BI report into a custom page in AL
I'm new in Microsoft Dynamics 365 Business Central and AL code and my boss told me that he wants to see a new page in our sandbox environment that shows a Power BI embedded on it. Is there any way to show something like the right part of the…
0
votes
1 answer
Open two reports simultaneously on one OnAction
I am trying to open two of the same report (different filters) when clicking on the print PDF function. I want to be able to open both reports clicking this rather than repeating myself.
Currently I am able to open one of the reports, NAV will…
pcthedev
- 1
0
votes
1 answer
How to authenticate with Azure Active Directory programatically in a Connect App for Business Central?
I am attempting to write a connect app that will receive a set of data from an external source and put it inside an instance of microsoft dynamics 365 business central via its APIs. Documentation says there are two ways to do this, using basic…
pruche
- 1
- 2
0
votes
1 answer
Dynamics NAV + BC Control Add-In not exposing methods and events
I have created a simple control add-in for Dynamics NAV/BC and I'm having some trouble with it.
I have done exactly the same (as far as I can tell) in this add-in, as I have done in previous add-ins I have created of the same type, which have worked…
Aidal
- 799
- 4
- 8
- 33
0
votes
1 answer
Automate process for downloading cumulative update
I want to automate process of downloading newest CU for NAV and BC.I wrote powershell script, but still need part how to donwload zip file from this page (https://www.microsoft.com/en-us/download/details.aspx?id=58275)
This is the code that I wrote…
tomasevicstefan
- 31
- 4
0
votes
1 answer
Can we use two source table or more in a page or in page extension in AL BC365?
I've created a page extension which extends "item card" , now what i'm trying to do here is that i have a table which i created, and want to access fields of that table in this Page extension.
Basically the problem is that the "item card" page…
Umar Naeem
- 3
- 4
0
votes
1 answer
Visual Studio Code Debugger not working under other connection
when I run the debugger mode under network of my home, the debugger work correctly.
But, when I try to debug from at network of my office work, it doesn't work..
It start and I can see the the dialog of the debug at top to right, but not attached..…
AlexPad
- 10,364
- 3
- 38
- 48
0
votes
1 answer
Azure File Storage API access using Shared Access Signature
I'm currently trying to access files & directories on an Azure Storage Account Fileshare (let's call it rootdirectory ) from a Dynamics Business Central page action.
The method to access files stored in it is to build and send an HTTP GET request…
Canass3242
- 3
- 1
-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
Renaming the blob storage file
I have a problem with changing the name because as you can see in the code below I download the blob by name but this name is an identifier I would like the name to be changed to the name that is stored in the database and the blob to have the…
Maksio
- 23
- 6
-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
1 answer
Replace special characters with escape sequences - VSCode
I would like to edit my code to replace all special characters. For example I am replacing the & character with ""&""
Here is my code:
trigger OnOpenPage();
var
ItInput: Text[50];
ItWhat: Text[50];
ItWhit: Text[50];
…
Martin Vargas
- 7
- 3
-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…
user15061537
- 19
- 2