-
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…
-
Is it possible to insert 100+ sales orders in a single API call?
Hi, Is it possible to insert 100+ sales orders in a single API call? I was thinking on making some Power Automate, but maybe it's natively supported... Any info is welcome <3 Thanks in advance
-
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"
-
How to see why you are getting CONSISTENCY Error
This is a trick I use whenever I do try to solve and see why you the db is getting CONSISTENT Error. I create the following CU. OBJECT Codeunit 50000 Single Instance CU{ OBJECT-PROPERTIES { Date=10/11/07; Time=[ 2:50:02 PM]; Modified=Yes; Version List=MOD01; } PROPERTIES { SingleInstance=Yes; OnRun=BEGIN IF NOT StoreToTemp…
-
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…
-
Nav->ForNav->Foxit(pdf reader)
Hi all, Imagine two ForNav reports in the same database/company having same label/caption in them with Japanese hieroglyphs. If previewed as PDF, one of them shows squares instead of Japanese and another one is totally fine. What could it be? 😬 I’ve ran out of ideas of where to look. If anyone has any leads, please, share.…
-
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": [ { "_":…
-
Data mirroring
Good afternoon, I'll give it a try whilst I am having troubles finding simple tutorials or look-a-like projects. Our company is using: NAV 2009 R2 I have limited access (only object designer) due to license. I am trying to write code behind a report. I would like that once the report is ran, it mirrors delivery weeks…
-
Sorting on a Flowfield
Hi all, I have two tables, one of them has "detailed" transactions about the master table. From the master table, I created a flowfield which gets the current status from the detailed table. However it always just get the first record for the filter. Is there a way to get the flowfield to get the last record? Can you use…
-
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"…
-
Navision 4.0 SP2
Any one has the old CD/DVD for Navision 4.0 SP2. I need to the NODBC installation to get some data out from the Navision Native Data
-
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…
-
Mapping Intercompany transactions
I have set up an intercompany partner and enabled auto-send transactions. I created a purchase order and sent it to IC, which then created a sales order in another company. However, I want to map the expected receipt date of the purchase order to the shipment date of the sales order. Currently, the posting date of the…
-
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…
-
BC to CRM integration Tax
Hi Guys Dynamics CRM does not have Tax on the Sales Quote. Has anyone integrated tax or implemented tax with dynamics sales with integration to BC? Quote created in Sales and flows through to BC with tax codes
-
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…