-
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?
-
How to add the custom field in the standard workflows
How can I add a custom field to a base workflow in Business Central?
-
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 =…
-
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…
-
Commit() in Page Extension Action button
Hello Experts. I have a few questions regarding Commit() function and would appreciate some clarifications. 1. is Commit function in a page extension action button risky? I have an action button that modifies a table column and right below that a preview posting function. (GenJnlPost.Preview(Rec)). it's returning an error…
-
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…
-
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…
-
[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…
-
Intercompany Module
Hello please i create a function where using from bottom to send to Company partner in the same instance , from Posted Sales Shipment This my code for the sales line is not generate correctlly i dont why not inserted Unite of measure codeunit 90110 TTMgt { TableNo = "Sales Header"; Subtype = Normal; Permissions = tabledata…
-
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…
-
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…
-
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…
-
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.…
-
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…
-
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,…
-
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…
-
How do we migrate Table Extension from older extension to V23 ?
Hi All, does anyone know how to migrate from Table extension version 22 (or before) to version 23 ? Thanks.
-
RDLC Report
How to set the number of lines coming in a report to 8 in RDLC layout? Thanks in advance.
-
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…
-
Cannot start NAV2018 NAS service on Windows 11 23H2
Some computers that run latest version of windows 11 can't run NAS service anymore. The same settings work on other windows 11 based machines but some don't and I can't figure why. The error appears right at the start of this year on some machines that run build 22631.2861 of windows 11. Tried removing the latest update…
-
Scheduled Reports crash Job Queue (BC14 on Prem)
Hello, I have a problem with BC14 on Prem and scheduling Reports. Scheduling reports via the task queue works in principle. However, there are always problems when the reports processes large amounts of data and produce many pages. For example, we have an invoice journal that lists all posted invoice headers with invoice…
-
RDLC Layout issue
Hi, PFA . I need to remove this space from this report? Is there any solution? The space is coming in between the detailed row and footer.
-
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…
-
how to remove caption of a cardpage?
Datacaptionfield property in table in empty...the card page caption is coming as the key of that table.. I wanna remove that caption . Thanks in advance.
-
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…
-
Upgrade/conversion from WW to NA
Hi all, I have someone who is a US subsidiary of a Spanish company. Currently, they are on NAV2016 and just a separate company within that database. There are some unique business requirements for the US company - Sales Tax, for one - they have been "adapting" the VAT feature in the WW version but it's not optimal. The…
-
How to get name of database server in AL w/o dll usage?
Hi community, is there a way to determine the name of the sql database server in AL without using dlls? I need the database name which I should get from the active session, but I have no clue how to get the database server name - the active session only carries the name of the BC server. Thanks in advance and best regards…
-
Current User Email not retrieved correctly.
Hello all, Just wondering if someone could help me with the following issue. Environment details BC22 OnPremise Version: W1 22.1 (Platform 22.0.56191.0 + Application 22.1.55890.56216) Two services, one using NavUserPassword and another AccessControlService The Problem When I update the "Authentication Email" on the User…
-
Developing Custom Approval Workflow?
I want to develop a custom approval workflow on creation of Resource record in the system. When a user inserts a new Resource in Business Central, it should be first approved by the approver, before it can be used anywhere. Any help in this regard will be highly appreciated.