-
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 variants that are a total of 1300 and insert them into a table created in Business Central. When I run the code if you do the…
-
Executing cURL from NAV
Has anyone written C/AL in NAV to execute a cURL command? I'd love to see that. Many thanks
-
Empty role center, detailed menu and pages after upgrading to BC24
Hi all, after upgrading from 18.6 to 24.3 I have an empty role center and the detailed menu is also empty, more or less. When running a page via url parameter like ?company=CRONUS%20AG&page=32 I only see No., Description and fields I've added with page extensions. When running a tabe via url parameter like…
-
Odata V4 & Odata Web Service Error but SOAP is working
Hello, on the web Services Page, when we click the URL under OData V4 & Odata URL, getting Message 'This XML file does not appear to have any style information associated with it. The document tree is shown below.' and no Data generated but when running the SOAP URL, we can see the details on browser. Anyone has this issue…
-
FET and Sales Tax
Hello- I have a client that has a unique requirement i have not come across. They have items that have a FET (federal excise tax) added to specific items. These items require this 12% tax ALWAYS. However, that specific customer might also be tax liable and depending on the area, have a 6% tax added. So this single item…
-
AL Base APP export all objects
Hi All, Is there any way to export all base APP objects into a text file? I'd like to continue using something like "where used" tool as Prism is paid and expensive. I've found this link below but the command doesn't seem to exist.…
-
Set If condition for Data Exchange Definition in Business Central
Hi All, is there a way that we set if condition for data exchange definitions? so for example with some criteria i want to export it as "V". other than that, i want to export it as "I"
-
Extension dependencies
I have some trouble designing an extension in AL. My extension uses a field of a certain table in it's code (which happens to be in the OnPreReport trigger of a reportextension object) [App 3]. The field is defined in a tableextension object in a different app [App 2]. The table is defined in yet another app [App 1]. I…
-
Business Central Extension - Table not showing in CAL
Hi everyone, I don't know if it's possible, but my question is: Is there any way I can view a table created through an extension in CAL? (same question for viewing table fields in CSIDE created through an extension) The BC version I'm using is 14. Thank you very much.
-
Permission Error After Login - Docker
I setup a Docker container and install latest version. Everything went smoothly and service is ready for connection. Connected to http://bc23/bc and user name, password worked. Unfortunately, I am getting the following error. We used the client license W1during setup which was download recently from Customer Source. Do we…
-
how to export nested JSON Value
Hi All, i want to export nested json value. something like this how do i make that? Thanks."Signature": [ { "Id": "signature", "Object": [ { "QualifyingProperties": [ { "Target": "signature", "SignedProperties": [ { "Id": "id-xades-signed-props", "SignedSignatureProperties": [ { "SigningTime": [ { "_":…
-
Importing a Google Sheet into NAV
Has anyone written CAL in NAV (2017 for example) to read data from a Google Sheet? If so, I'd love to see that. Many thanks
-
Adding Shipment Date to sales order list page in mobile view
Hello everyone, I'm using Business Central Cloud and I would like to add 'Shipment Date' to the sales order list page in the mobile view. Can anyone suggest how to do this, either with code or other functions? Thanks in advance
-
How can I restart the BC14-Service in a BC14-Dockercontainer
Hi everyone, I created a new BC14 docker container together with a Cronus-DB. I would like now to import my development license into the database. To activate this license I normally have to restart the BC-service. But when I list all of the windows services from the docker container I cannot find any BC-services. Can you…
-
Determine which SQL Server version to restore from Bacpac file
Hi, So I already export my BC database to azure storage, and download the bacpac file. How do I know which SQL Server support my bacpac file? Thanks
-
Sorry, the current permissions prevented the action (Table data modify)
This is BC22. I have made a table to store user login data from all companies. It is a simple table with two fields (field(1; "User ID"; Code[50]), field(2; "Last Login DateTime"; DateTime)). The table has DataPerCompany = false; so it will record logins for any company. Here is the code that is giving me the error:…
-
How can I use a React.js component in a Javascript add-in?
I would like to use a fluent UI component based on React in a Javascript add-in. How can I import and use a module for this? Here is a code example for JS: import * as React from "react"; import { Calendar } from "@fluentui/react-calendar-compat"; import type { CalendarProps } from "@fluentui/react-calendar-compat"; export…
-
Error When Publishing to a BC Docker Environment
Hi, I am encontering a strange error when trying to publish to a local Docker environment. Does anyone know what this means? Please note: * I have published other .app files, in the same way, to the same Docker, without error. * The .app file is functional. I have published it, successfully, to another Docker. Thanks in…
-
License Issue on BC21 - posting purchase invoice
Hi, I have received the following error when posting a purchase invoice testing a customer license. I'm wondering is there is a specific granule I need to order, the system is BC21 on prem. "Sorry, the current permissions prevented the action (Codeunit WMDonald Subscriptions Execute: Base Application). Please see image…
-
NAV 2018 - Task scheudler strange behavor
Hello NAV and BC experts, i want to share with you a strange behavior i'm expiriencing within a process which is using task scheduler to execut background task. Appearently, the task created by the process are all exevuted except some with a very specific property. Here the case:i have created a table "Post Process Buffer"…
-
BC24 Cloud Migration from Azure SQL not accepting same version
I am trying to use the Cloud Migration Setup to copy data from Azure SQL to Cloud. I keep getting the major version mismatch error. The cloud version is 24.2.20227.20460 and it is a sandbox. The Azure SQL database has the following settings in place: $ndo$tenantdatabaseproperty applicationversion = 24.2.20227.20460…
-
Can't connect to Microsoft Current User Connector
We can't connect to the Microsoft Current User Connector so that users can send emails from their sign-in account. The email address on the Email Accounts List Page is always empty in Version 24 (on-prem). This worked perfectly in Version 18 (on-prem), shows the user's email address and allows us to send a successful test…
-
Business Central Upgrade V21 to V24
Hi I need to upgrade a V21 on prem database to V24 CU2 onPrem I have around 20 extensions with various levels of dependency. I am using a PowerShell script that interrogates all the extensions which have been placed in a folder, builds a dependency tree then installs and publishes the extensions in least dependency order.…
-
AES Encryption for Cloud BC
Hi All, I need to encrypt for AES Encryption in Cloud BC. is BC able to do that? usually i encrypt from here --> https://www.devglan.com/online-tools/aes-encryption-decryption
-
URGENT: CustomerSource missing. Need to download OnPrem License
Hi There We all know the customersource is now retired. Unfortunately, I could not find a place to download the latest license for OnPrem BC. We urgently need to download this and the partner staff is not very helpful. I checked my admin.microsoft.com portal but it is not there. Anyone know the correct URL to access the…
-
Report with temp tables
Hi experts, This is in Business Central cloud. I have made a header table "H" and a table "L" with the lines in the header. I have made a report that prints one H and the connected L records. When the header table is posted, all fields on H and L are copied to two other tables, "Posted H" and "Posted L". And the H and L…
-
Bearer Authorization does not work
I am currently working on an API with GraphQL that uses Bearer tokens for authentication. It's strange because it always works in Postman, but when I try it in Business Central, it doesn't. It seems like the API doesn't recognize that I want to use Bearer tokens for authentication because I always get some HTML code as a…
-
how to solve field error in BC
Hello, I am trying to register a purchase order in BC, but I get this error,Shipping No. Series must have a value in Sales Header: Document Type=Order, No.=V-002. It cannot be zero or empty., I already filled out the fields and it still shows the error
-
Slow start of BC service
At one of our customers the BC service takes more than 4 minutes to start. We're using BC24 on-prem. We're getting three events like this in the event log: Held lock "App Group Update" for 165986 milliseconds. I made a technical support request to MS but the support engineer doesn't seem to have a clue... So I'm hoping one…
-
BC TechDays 2024 video
My impressions of this year's conference: BC TechDays 2024