-
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…
-
NAV Service start error
We're facing a issue that NAS Service doesn't start. System events error: La sesión Microsoft Dynamics NAV Application Server para el inquilino 'default' tiene un error permanente y no se reiniciará. Motivo: Type: System.ArgumentException Message: Ya se agregó un elemento con la misma clave. StackTrace: en…
-
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
-
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…
-
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"
-
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…
-
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…
-
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…
-
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…
-
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
-
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.
-
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": [ { "_":…
-
Why some extensions marked _exclude_?
BC 23.1 OnPrem I received request to add few custom fields to the "Bank Deposits" sub form and ledgers. When try to extend, I couldn't find the Bank Deposits objects initially. Then I found them under namespace "Microsoft.Bank.Deposit' or "Microsoft_Exclude_Bank Deposits_23.1.13431.13812.app" and extended them after adding…
-
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…
-
This is a real head scratcher! - Server killing sessions
I've been rattling my head over this for best part of a year, and its known to have been occurring for longer .. Essentially we have LS retail running on NAV 2017 (CU5) and every 7-10 days (no obvious frequency) the LS Retail scheduler service tier gets its SQL session killed. The only common factor is it usually occurs at…
-
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"…
-
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…
-
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…
-
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…
-
Dynamics BC Data Upgrade Nightmare rant
Hi, Have anyone tried to successfully upgrade data from a custom BC14 solution on C/AL to BC 18 on prem before? I find the experience very confusing. I am stuck at : https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v18#task-14-synchronize-final-extensions While…
-
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…
-
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…
-
Run codeunit
We need to run specific codeunit (OnRun trigger) and stop session afterwards from Windows Task scheduler. Our issues: - for logged user client shows message to confirm connection (-consolemode parameter doesn't help) - for not logged user codeunit isn't invoked. Event viewer reports unspecified error - probably concerning…
-
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
-
Create new BC23 on-premise development enviroment
Hello, I would like to create a new development environment from my BC23 on-premise server instance because the test data is outdated. Unfortunately, I can't find any instructions on how best to proceed. Greetings Hubertus