-
Erase an unused company in BC20
Hi All, In /My settings/ in my BC20 sandbox i have tried to create a new company which failed at the end of the proces. The name of the new company is created but it is not possible to select. Now i want to erase this company. How can I do that? Best regards Bent Dalsgaard
-
Cannot edit the description on Sales Quote Line.
One of my user cannot edit the description on Sales Quote Line and got "We have no further details about this." but she has a Super Permission and Dynamics 365 Business Central Essential License. Could you help me to solve this case?
-
Business Central Docker Container not working with hostname?
Using Docker Desktop I have created a new BC container. I am able to access it through 1XX.XX.XX.1/BC (example IP) but not through stefan/BC (which is the name of the container). My hosts file has the correct values (it updates whenever I run the container) and I have read permissions on it. Whenever I publish an app from…
-
Business Central 14 The remote certificate is invalid according to the validation procedure
We use the ECB (European central bank) exchange rate service. When i add the URL in BC, https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml, i get error "The remote certificate is invalid according to the validation procedure". I've checked that the root certificate for the issuer Entrust is there and if i go to…
-
Control add-in error
Hi, I have a problem with control add-ins in a new on-prem BC23 NZ installation with db upgraded from BC17. Some of the control add-ins don't work. The weird thing is that it's specifying public key token a4af7ee0f073bc1a instead of 31bf3856ad364e35 Also the OAuthIntegration Control add-in is not working The control…
-
Error with custom report.
Hi, How can I obtain the related records between the "Item Journal Line" table and the "Reservation Entry" table in a custom report? On the "Production Journal" page I added a button called "Generate Labels" and I want to show in the report the records from the "Reservation Entry" table that are related to the "Output"…
-
SignedXML codeunit
Hi I'm creating an integration from Business Central (SAAS) with the eHealth platform (Belgium) and I need to sign my created XML with 3 references. I've created the following xml document (manually with the XML objects):<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<soapenv:Envelope…
-
Anti-Virus Exclusion Recommendation
Hi, I was searching all over the internet for a article or document, with anti-virus exclusion recommendation for Business Central on Prem, but i didn't find any info. Are there no such recommendations for the server instances and the webclients on IIS?
-
Hide Insights are on role page in BC
Hello, How can I hide the Insights area on a role page in BC using al? Kind regards, Kristof
-
Dynamic dynamic filters based on another DataItem level in Query API
Hi! Im trying to get this code working but cannot get it to bypass the error I in the attached screenshot. Is there anything that I have missed in the syntax or is this way of setting filters in a Query API basically impossible? query 50101 "ItemVarBalance API Query"
{ APIGroup = 'xxx'; APIPublisher = 'xxx'; Caption =…
-
[NAV2018] Transaction failed. SendAsDenied error while sending PO for approval
Hi, [Version: NAV2018] I am sending a PO for approval and there are 3 persons (A,B,C) in the approval chain. Persons A,B,C are added in Approval User Setup with their respective email IDs. When I send a PO for approval, I am getting below error in Job Queue Entries. By default it is not taking up the e-mail ID from the…
-
Dynamics NAV Web Services SOAP <Key>
When ever you READ (or insert) a NAV SOAP Web service, NAV will return a SOAP response with <Key> Value. E.g. <Soap:Envelope xmlns:Soap="http://schemas.xmlsoap.org/soap/envelope/"> <Soap:Body> <ReadMultiple_Result xmlns="urn:microsoft-dynamics-schemas/page/ws_fixedasset"> <ReadMultiple_Result> <ws_FixedAsset>…
-
Variable value passed to report is not being printed
So I'm trying to display my variable value in my report. But it prints in the message "Numerario" but in the report is not showing anything.. OnPreDataItem() PaymentMethodCode:=CustLedgEntry2."Payment Method Code"; PaymentMethod.GET(PaymentMethodCode); PaymentMethodDescription:=PaymentMethod.Description;…
-
How to add the custom field in the standard workflows
How can I add a custom field to a base workflow in Business Central?
-
VS Code debugger in wrong place on standard code - BC v23
When debugging, I go through several functions of bespoke code and everything works fine. Stepping into, over and out all fine, but when I get to here and step into the standard Sales Header table code, it brings me here I believe it is debugging the correct lines in the background, it's just not taking the Namespace ___…
-
Using Control-AddIn WebPageViewer in NAV 2016
Hello all, got a Problem with a Control-AddIn that has me rather baffled. In NAV 2017 you have a new one called WebPageViewer. NAV uses this to give you a preview show (in page 9700, Email Dialog) of the email body if you defined a word document to be a Body for a report. When selected in NAV 2017 the AddIn created 4…
-
Find the specific "Sales Price" the used to validate "Unit Price" on Sales Order Lines
Hi! This is in Business Central cloud. I'm looking for a way to find the specific "Sales Price" the system fetches to determine the "Unit Price" when validating the "No." field on Sales Lines for orders. I have a custom field on the "Sales Price" table that needs to be transferred from the correct "Sales Price" line to the…
-
VS Code unable to connect BC Instance
Hi, The VS Code on my VDI can not connect to the Business Central Instance ( on Server B ) due to below error message. The VS Code and BC Instance are installed in two different machine. I can access BC environment using Web Client on MY VDI but can not connect BC Instance and download the symbols. Configuration of BC…
-
LS Retail Trans. Sales Entry Status table
Hi, Can anyone explain to me what the Trans. Sales Entry Status table is used for in LS Retail? I am trying to understand why there would be entries in this table but not in the Trans. Sales Entry table? Thank you.
-
XMLport Import Text Element not clearing itself - still filled on next loop
Hello I got a problem while importing an xml file. Somehow I can't find anyone having the same problem on google ._. So my structure is following MLIST - M - DATA1 - DATA2 I do processing in the M - Import::OnAfterAssignVariable() Now let's assume DATA1 is always filled and DATA2 like every third loop only. So it's filled…
-
XMLDSIG signing XML data with .NET or Bouncy Castle / use higher .NET Framwork version?
Hello :smile: In short my issue: I need to xmldsig my xml data to fulfill some regulations. As NAV 2016 offers .NET System Security 4.0 which has System.Security.Cryptography.Xml.SignedXml Now I need to set the algorithm, but as of 4.0 it only offers those SignatureMethods:…
-
Adding a permission set for a single codeunit in BC?
Hi all, I'm using a BC (SaaS) and I have created a new Codeunit: 6000 "Test" with some subscribers to the Tables: "Sales Line" and "Purchase Line": [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnBeforeValidateEvent', 'Quantity', false, false)] local procedure SalesLine_OnBeforeValidateEvent_Quantity(var…
-
Sql Error sync-navtenant error NAV18
I´m upgradaing from Nav 13 to Nav 18, when ´m trying to compile objects I´m getting this error The following SQL error was unexpected:Incorrect syntax near '$7'. In the Event Viewer Message: <ii>El siguiente error SQL no se esperaba: Incorrect syntax near '$7'. Instrucción SQL: DECLARE @StatisticsToDrop NVARCHAR(MAX);…
-
[Solved] Restrict access to table 15 and 17
Hello, Two of our customers have expressed a similar concern: certain employees should be denied access to the accounts and general items. Problem: Employees should still be able to book (orders). If I understand it correctly, full read access (i.e. not just indirect access) must be available. Is there a way to ensure that…
-
Reporting/tracking data Storage Capacity Usage
Hello, I have had a few Business Central clients report that they have checked their data Storage Capacity Usage in their admin center and discover that they are over capacity, which they had not anticipated. There are data retention tools and procedures, which we have helped these clients with, but as far as I am aware,…
-
Why do AL use record.Copy() instead of temporary tables
Hi All I'm trying to understand Record.copy function in relation to order planning worksheet so I can extended and add other fields. for example below procedure:local procedure InsertSalesLine(var UnplannedDemand: Record "Unplanned Demand") var UnplannedDemand2: Record "Unplanned Demand"; begin with UnplannedDemand do…
-
Track who uninstalled an extension on production environment of Business Central cloud?
One of the extensions from production env was uninstalled, I have checked Change Log Entries and it doesn't keep a log of such events. How can one, find out who installed or uninstalled an extension?
-
Requestpagehandler cannot address variables in report extension requestpage
Hi there, We have created a report extension on "Create Reminders": - added two variables to the request page - added some code to the OnPostReport() trigger For automated testing purposes, I now want to use this report in a test codeunit: fill these two variables from code and then proceed with OK. My expectation was that…
-
Error in Sync-NAVTenant
I am updating a version from NAV2015 to BC22 so I'm performing the first step that upgrades to version BC14. When execute Sync-NAVTenant -ServerInstance DemoInstance system return this error: Sync-NAVTenant : The following SQL error was unexpected: String or binary data would be truncated. The statement has been…
-
Editable field on page in al code
Greetings experts, Forgive me, I’m new to working with pages in al code. I have created a page with two fields. I want to take the input of one field, send it to a method in a codeunit using an action, and show the returned text in another field. I’ve marked the field and the page objecr as editable, but it is not editable…