-
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…
-
NAVClient hang at splash screen for 20 minutes, then shows connection lost
Hello community, hope you can help me. We opened a new location for our company. The new location should use our NAV 2013 CU58 via NAVUserPassword authentication. At first we gave them a OpenVPN Client and the NavClient runs fine at the new location. Now we established an IPsec Tunnel between our location and the new one.…
-
Permission Sets
When doing a conversion from a previous version to BC14 (in my case from NAV2017 to BC14) there is an issue with Permission Sets that are not base but custom. The custom Permission sets that are converted are defined as type (scope) = System so that they cannot be modified/updated. Is there a way through a pre- or…
-
Can I get Business Central to find the right unit price using the new price calculation v16?
Hi experts, This is in Business Central cloud. I have made my own table with some of the same fields as there is on table "Sales Line". I have fields with "Item No.", Quantity, "Unit Price" etc. I also have a customer number. How do I call the new price calculation v16, so it finds the right unit price for my item?
-
Are customers, not partners allowed to develop in the latest versions of Business Central?
In old Dynamics NAV, they had to buy an Application Developer license for 6000 euros to do that, and yet it was not allowed to modify a Codeunit 80 to for example fill out a field in the invoice. Only the 30 000 euro Solution Developer allowed that. How does that work in Business Central now? Are they still allowed, if…
-
XMLPort import xml with variable tag position
In NAV 2017 I want to import xml file from third party source. Some tags in source file has the same tag in variable positions. For example: Variant 1 <x> ...subtags </x> <invoicee> ... some subtags </invoicee> <y> ...subtags </y> Variant 2 <x> ...subtags </x> <y> ...subtags </y> <invoicee> ... some subtags </invoicee> How…
-
Intermittent sending email on NAV 2016
We're facing an odd issue where emails sent from NAV will not send intermittently. The error is: /The SMTP mail system returned the following error: /Failure sending email/. Authentication failed because the remote party has closed the transport stream./ The email account is an O365 account. This issue started happening…
-
Send to excel function does not open excel
Hello, I have problem when sending data from page to microsoft Excel. When the button is pressed, for few seconds the mouse shows loading icon, but apparently excel never opens. It works on one of the clients computers, and stopped working on other cient computer and also server. I get no error messages, nothing. It just…