364 questions
0
votes
1
answer
193
views
Document Attachment in Sales Order in Business Central — "Read called with an open stream" Error
I’m trying to create a document attachment in Business Central using this API:
🔗 POST /documentAttachments
However, I always get the following error:
Read called with an open stream or textreader. ...
- 416
0
votes
0
answers
73
views
Item Journal Posting in Business Central
I have created an item journal entry using below web service url in BC.
POST - https://api.businesscentral.dynamics.com/v2.0/{tenant}/{environment}/ODataV4/Company('{company}')/ItemJournalsWS
But when ...
- 327
0
votes
1
answer
44
views
How to populate the Service Item Worksheet Lines?
I’m new to Business Central and I’m trying to figure out which API I should use to populate the Service Item Worksheet subform (Lines). I’ve already tried Service Item Lines, Service Lines, and Lines (...
- 416
0
votes
1
answer
95
views
How to properly format a POST request to a custom business central API
I have a business central API page. When I POST to it, I get a 400 error. Here is the AL code for the page:
page 50115 PunchoutReceiverAPI
{
PageType = API;
APIPublisher = 'Contoso';
...
- 135
0
votes
1
answer
75
views
Is it possible to render an external URL via a control add-in?
I am working on a punchout application for Business Central and I would like to redirect a user to external URL via a control add in. Right now I have a startup script
Microsoft.Dynamics.NAV....
- 135
0
votes
1
answer
70
views
In Business Central's AL, how can I subscribe to the event of an approved purchase requisition?
I am working on a punchout application for business central that automates various tasks. I would like to be able to send off an API call and create a purchase order whenever a purchase requisition is ...
- 135
0
votes
1
answer
449
views
Business Central Server-Driven Paging @odata.nextLink in c#
I'm trying to get some example code to transform this logic into one where it requests while there is @odata.nextLink. There seems to be 10k records in my http response, limiting by request.Headers....
0
votes
1
answer
83
views
Assigning Permissions to execute report extension in AL Business Central
i want to create a new Report for a Business Central OnPrem solution with the runtime 14.0.
Therefore i created a pageextension like this:
pageextension 50100 CustomerListExt extends "Customer ...
0
votes
1
answer
102
views
Equivalent of .Net Encoding.UTF8.GetBytes(data) in Business Central AL?
I’m implementing AWS SigV4 authentication in BC AL, but I keep running into 403 - SignatureDoesNotMatch errors.
While debugging, I noticed discrepancies in the HMAC-SHA256 hashing results—sometimes ...
- 21
0
votes
1
answer
56
views
Configure Azure Application Insights to capture severity level 3 telemetry in a Business Central extension
We’re creating a Business Central extension and want to receive telemetry from that extension. We’ve set up an Application Insights resource in Azure, and in our app.json, we’ve specified the ...
0
votes
1
answer
60
views
Business Central AL return customer default dimensions as part of /customers endpoint
I am creating essentially an extension of the default get customer endpoint, but need to return dimensions as part of the /customers endpoint, so part() won't work for me. I presume I need to do ...
- 53
1
vote
1
answer
183
views
Business Central AL enum returning Unicode
I am writing a Dynamics Business Central API v2.0 AL extension that creates a new page for my organization. The API is being used in a Power Automate flow to pass data back and forth to a Power app ...
- 13
1
vote
1
answer
173
views
How to add Custom Report Layout through code in Business Central
I have report in AL and should upload it in Custom Report Layout, but from code, not manually from the Business Central.
Is there a way ?
- 21
1
vote
1
answer
377
views
How to fill a page part based on a temporary table in Business Central?
I'm adding a page part in Sales Orders, where I want to show tracking lines.
This is the page part in Sales Orders:
pageextension 63200 "Sales Order Ext" extends "Sales Order"//42
{...
- 755
0
votes
1
answer
487
views
How to force a symbol version in Business Central?
I'm trying to develop in my sandbox environment, which is at this versions:
Version: ES Business Central 25.3 (Platform 25.2.29913.0 + Application 25.3.28755.30175)
This is my app.json:
{
"id&...
- 755
1
vote
0
answers
157
views
Posting JSON Data in Blob Data Type Using Postman in Business Central
I have created a table in Business Central that includes fields with the Blob data type. When I try to send JSON data to these fields using Postman, I encounter the following error:
Postman API Call:
...
2
votes
1
answer
148
views
VS Code is not showing any trigger in source code for Business Central Base App
I am trying to open any Microsoft Business Central Base Application .dal file in VS Code and it's only giving me the "basic structure". E.g. if I navigate to .alpackages, ...
- 21
1
vote
0
answers
83
views
using oData4 to pass a variable *by reference* when calling a code unit in Microsoft Dynamics Business Central
I am converting our code to communicate with Business Central using oData rather than SOAP to call pages, code units etc.
I am struggling with code units that require passing a parameter by reference -...
- 149
0
votes
0
answers
23
views
Cannot POST on integration between Business Central to Finance and Operation (Token OAuth2)
I get issue when I'm trying to integrate between Business Central to Finance and Operation.
The authorization is OAuth2, with credential client, the bearer token has been generate and get with secret ...
0
votes
1
answer
97
views
create a field inside a table schema in business central
I am currently migrating data from Oracle NetSuite to Dynamics 365 Business Central, and I need to add a custom field, 'Subsidiary', to the existing Contacts table (Table ID 5050) in Business Central.
...
2
votes
1
answer
1k
views
How to debug web service calls in Business Central?
According to the Microsoft Documentation...
I'm trying to debug my API:
The page code is just here, a copy of the standard customers api
I've only modified the OnAfterGetRecord() trigger with this ...
- 755
0
votes
0
answers
33
views
Business central change dataset in Power Apps
I have created a PowerApps solution in my dev environment which is connected to Business Central Dataset ( Sandbox environment + Company A ).
Now I want to migrate this Power apps solution to ...
- 111
0
votes
0
answers
1k
views
POST Sales Order using API_SALES_ORDER_SRV
I face some issue on creating Sales Order using API_SALES_ORDER_SRV from External Application (in this case is Dynamics 365 Business Central.
I am trying to create a new sales order from an external ...
- 73
0
votes
1
answer
289
views
How to update Field in my Business Central Table Extension?
I am trying to create a new field for the "Prod. Order Routing Line" table that shows the total planned time for each operation. Total Planned Time is defined as the Setup Time + (Prod Ord ...
1
vote
1
answer
540
views
BC AL: How to perform lookup using temporary record and a base app page? + get filter
a beginner here, i want to know what do y'all usually do when you need to perform lookup, based on temporary record, but you want to use base page, and also get the filter. Getselection filter will do,...
- 21
0
votes
0
answers
60
views
Is it possible to keep an XML reference of an Excel file while editing it with python?
I have an xlsx file from a configuration package of my business central with a given table that I've to feed with a lot of data from a database. After editing the file with openpyxl it always "...
- 11
-1
votes
1
answer
51
views
Parameter with spaces in datafactory business central
In datafactory i try to make a rest api get request to only get results of the past few days so i want to filter on postingdate but datafactory is replacing the spaces of the parameter woth %20 and ...
- 159
0
votes
1
answer
368
views
Custom response in Business Central API
In Business Central (SaaS, version 24), I have developed a custom API page that provides tailored endpoints for my application needs. Currently, both the GET and POST methods are operating smoothly, ...
- 19
0
votes
2
answers
295
views
How to find all references (or occurrences) of a certain field in the code of a Business Central .app
I'm working with an imported .app, it's open source (but readonly) so in .alpackages folder I can click in the .app file in Visual Studio Code and navigate through all its code files (tables, ...
- 428
2
votes
1
answer
145
views
How to prevent Auto Trigger of Azure Pipelines based on condition?
For a Business Central Extension, the key component is the app.json file which is unique to every extension. With each change in the extension, normally we would manually update the "version"...
0
votes
1
answer
299
views
How does this Business Central API code work calling Record.Insert twice?
I'm trying to understand how the Microsoft Business Central APIs work. I'm looking at the Vendors API (APIV2 - Vendors). In the OnInsertRecord trigger, it appears to me the record is inserted twice if ...
- 121
0
votes
1
answer
363
views
How to know the Type of DevOps Agent in a Pipeline?
I have been trying to setup a CICD Pipeline for Business Central and would like to know in runtime what type of Azure DevOps Agent is being used to run the pipeline? (Azure Hosted vs On-Prem Hosted) ...
0
votes
1
answer
78
views
Beyond Compare grammar. Color only regex matching groups, not whole match
I want to add syntax highlight for AL language to Beyond Compare using grammar.
For example I have following line
EventSubscriberInstance = Manual;
AL have a lot of this properties and I don't want ...
- 2,352
0
votes
2
answers
218
views
How to sum the value of a field in a page extension taken from another table?
Excuse me,
I have received a request to add a 'grand total amount' column on the 'Posted Transfer Receipts' page.
enter image description here
This column should be filled with the total of 'cost ...
- 1
0
votes
1
answer
161
views
Is it possible to host a Blazor WebAssembly app inside business central control add-in?
Is it possible to host a Blazor WebAssembly app inside a business central control add-in?
To clarify this better, I do not want the Blazor app to be hosted on a server and then be loaded in the ...
0
votes
1
answer
541
views
GET request not supported in custom API in Business Central. "BadRequest_MethodNotAllowed"
I try to call a method in a custom API in a code unit in Ms Dynamics 365 Business Central. I tried everything to make it a simple GET method, but I keep receiving "BadRequest_MethodNotAllowed&...
- 5,082
0
votes
1
answer
353
views
Is a custom table added to MS Business Central automatically available in the API (2.0)?
If I want to update a sales invoice, I can use the build in API (2.0) in Business Central.
Here is described how:
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/...
- 5,082
2
votes
1
answer
288
views
Business Central API V2 Uploaded Attachment is empty
I create attachments for Business Central, Journal Lines, using the V2 API. The code looks like this:
// Creating a file
const fileData = new FormData()
const fileBlob = new Blob([file.buffer], { ...
- 17.8k
0
votes
1
answer
196
views
Business Central Custom report shows blank page
Have a custom report just to display "Hello World!". No datasets.
Looks fine when previewed in Report Builder. When run in BC just a blank page shown.
Report code (.rdlc):
<?xml version=&...
- 1,511
0
votes
1
answer
195
views
How do I get all my variants from the API? The query only gives me 250 and not the 1300
How do I get all my API variants? The query only gives me 250 and not all 1300.
I have a problem with my code in AL for Business Central. What I am trying to do is to get from the shopify API all my ...
0
votes
1
answer
618
views
Business Central SetTableView with temporary table doesn't apply filters
I am trying to populate list with filtered records in temporary table. Records in temp table are stored and counted properly. But when page is open all records from original table are displayed.
...
- 1,511
0
votes
1
answer
580
views
AL report Date filtering Business central Development | Date restriction on RequestFilterFields
Hello, struggling to learn with AL. I got simple report that is supposed to show data in table.
RequestFilterFields = "Transfer Order Date";
I was hoping to use requestfilterfields to sort ...
1
vote
1
answer
790
views
How do I pass variable information from one page to another part of the page AL
I'm trying to make a system where the "LineReferenceNumber" in the Incoming Lot Table is passed to the "Incoming Lot Lines Page", and from there, that number is used to set the &...
- 129
0
votes
0
answers
303
views
D365 Business Central 2024 wave 1 issue connecting to VSCode
I recently installed D365 BC 2024 On Prem tenant for study purposes. I've been having trouble connecting it to VSCode since it gives me the following error message:
[2024-06-02 14:02:44.73] Using ...
0
votes
1
answer
86
views
Get SCC code (barcode in "Item Reference" table) with Business Dynamics extension
I have created a custom extension and I need to get the SCC number (Shipping Container Code) from some items. The SCC number is a barcode that goes on the shipping container vs on the individual items....
- 93
0
votes
2
answers
135
views
Creating a PurchaseInvoiceLines with a UnitOfMeasure through Business Centrals API fails
So I am trying to create the following purchase invoice line
{
"itemId":"be04fb82-fdaa-ee11-a568-0022489c7d90",
"quantity":152.0,
"expectedReceiptDate":&...
- 567
0
votes
1
answer
333
views
Get Marketing Text with Business Central Dynamics AL
I have created a custom extension for a client and one of the things I need to do is fetch the Marketing Text for products. This data is stored in a table called Entity Text and I can't figure out how ...
- 93
0
votes
1
answer
508
views
How to deep inserts in Business Central with a custom API?
I'm trying to do multiple line inserts in a single call to a Business Central API
Right now, the test page I have is this one:
page 60000 "Sales Order Inserts MIM API"
{
PageType = API;
...
- 755
0
votes
1
answer
1k
views
How to insert multiple rows in a Business Central API?
I'm trying to insert a json with multiple records into Business Central via Web Services
page 60000 "Sales Order Inserts MIM API"
{
PageType = API;
SourceTable = "Sales Order ...
- 755
1
vote
1
answer
471
views
How can i hide a field in Microsoft Business Central AL Programming
I want to hide the field "Other Reason" if the field "Reason" has a value of "Other". See the following page extension to see the page fields.
pageextension 50101 ...
- 13