-
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
-
Passing quantity back to originating function
Wondering the best way to pass a quantity value back up a chain of functions. I have an originating function that calls another, and another, etc. to where the final function is 5 steps down from the originating. This is all base NAV. I'm looking for a way to pass a quantity from the final function back to the originating…
-
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
-
BC14 developer license
Hello I want to extend my BC14 license and a solution developer(developer license). My partner said that it is impossible, can you confirm it? I've done it with different clients with NAV2016 and there was no problem.
-
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…
-
Caution: Your Program License expires in 25 days
Hi Guys, One of the customers we are supported is getting the License Expires error message when accessing Development Environment. They are on NAV 2015. There is no error when client is launched, only on the designer. Any ideas?