-
Batch job/job ques takes different time in BC
Hi, We are at a performance testing stage with a customer. We have an isolated on prem environment (BC22). We are testing batch jobs. We are running identical tests with the same amount of data, and the same code. But the time the jobs takes, differs from 2 hours to 6 hours. BC runs on a Azure platform with and Business…
-
Error the current permissions prevented the action
Hello everyone, I have created an extension for exported some data with reports. But i have an error when i scheduled my report with a job queue entry. This error is : "Sorry, the current permissions prevented the action (CodeUnit ****** Execute)" This job queue use my user session. I created a permissionset object with…
-
The text 'generatesymbolreference Database=xxx ServerName=xxx' is too long
hi, I'm trying to run the below command .\finsql.exe Command=generatesymbolreference, Database="Demo Database BC (14-0)", ServerName="xxx" but i'm getting the below error Microsoft Dynamics NAV Development EnvironmentThe text 'generatesymbolreference Database=Demo Database BC (14-0) ServerName=xxx' is too long. Text can…
-
How do I get NAV 2017 to work with Visual Studio 2017 for the creation of reports?
Hello, I am very new to working with Nav, so please excuse any nonsense I may say. According to the system requirements of NAV 2017, I should be able to use Visual Studio 2017 with "Microsoft RDLC Report Designer for Visual Studio" installed, to create and edit RDLC report layouts.…
-
NAV C/AL code vs NAV Query Object
Hi, Version affected in NAV2017 cu 14. Recently we hit a performance related issue. When I investigated further, I found out that this was caused by Query Objects in the Role Center. And when I tested, I even found out that it was better to use NAV C/AL to get the calculated results vs NAV Query object. This is because,…
-
Business Central Benchmark
Hello, I test the validation of accounting ledger under Business Central. I have an accounting sheet with 200,000 lines. I would like to optimize my installation and validate as quickly as possible the volume of information With a standard nav installation the system validates the sheet in 20 minutes The processors do not…
-
SQL Performance Query Object
Hello everyone! We have a performance issue with a query object in NAV BC14. We isolated the code snippet with the Performance Profiler that caused this issue and we stumbled upon a SQL statement (caused by an Query.READ) which needs 7-10 seconds to run through. The SQL statement looks like this: The code that calls the…
-
Norway, VAT reporting (Report 10618)
Hi, I have a Norwegian Customer (NAV 2018 11.0.46855.0), they are working on Dynamics NAV 2018. In their Norwegian Company, they are trying to upload the Xml file at /Skatteetaten/ using the report 10618 (Trade Settlement 2017). They receive the error attached. Is the output xml file, from report 10618 not valid anymore?…
-
Checking/Comparing for empty string filter
Hi there, today I stumbled upon something I thought would be a simple problem but I couldn't figure out why it did not work. So I wrote some code which checks if specific filters on a Reservtion Entry record are set (those filters are set in the base app) And one of those filters is a filter set on the field "Source Batch…
-
BC Check MICR font
We are using BC V22 On-Prem. We are implementing bank checks in BC. I am using report builder. We copied the MICR font from the NAV Server to the BC Server. I am using the exact alignment as NAV. The checks look perfect in NAV. The bank rejected checks in BC. The MICR font is not aligned and not in the proper position.…
-
Extension Development:Page not opening in Edit mode and pre-filtered with the No. from the item list
Hi, Extension development I'm coding a new action button from the Item List to call a new list form which would have 2 fields: Item No., Extra field (non relevant). Both fields form the primary key on this new page. When opening this new page, I would expect to have it open prefiltered with the Item No. (which it does),…
-
Manifest Book Pages
Having an issue when posting the manifest that UPS does not receive all the "pages". Is there a way to take a look at the ups summary for a specific book and page number?
-
XMLPort Namespaces
Hi. I want to export the xml with some specific namespace. I have the following properties:DefaultNamespace = 'dm22irccli-net';
UseDefaultNamespace = true;
Namespaces = "version" = 'v2023'; What is exported:<My_XmlPort xmlns:version="v2023" xmlns="dm22irccli-net"> What i want:<My_XmlPort xmlns="dm22irccli-net"…
-
How to convert custom reports from NAV to Business Central?
How can I convert NAV 2018 reports as extensions for Business Central in the cloud? Is it possible to do it using Microsoft tools, as it was done previously with Business Central on-premise and not with third-party tools? As an additional note: the version has already been upgraded to Business Central but without the…
-
Remove Schema from Xml export via XMLPORT
Hi, I'm trying to remove the schema part from the xml exported by a xmlport. The objective is to only get the generated xml without the schema part. I'm about to quit this xmlport nonsense and go for a codeunit. I tried something like this after the export, but it never finds the node i'm after <xs:schema>…
-
item tracking. importing serial nos from external system
Hi, Not an expert on item tracking here :-) External system assigns serial numbers to Purchase Order Lines via BC extension method (see code below) Sometimes, purchase order line already has the serial numbers assigned and they could be the same as those in external system. External system does not know about it and still…
-
BC14 Service Tier Event Log errors
Hi, we are running BC14 and in the eventlogs of our servers I see a lot errors like this one. Protokollname: Application
Quelle: MicrosoftDynamicsNavServer$BC14-TEST-EK1
Datum: 08.12.2023 11:34:49
Ereignis-ID: 708
Aufgabenkategorie:(33)
Ebene: Fehler
Schlüsselwörter:Klassisch
Benutzer: Nicht zutreffend
Computer:…
-
Service to service auth and multiple api customers
Hello, guys I would like to investigate such case: - BC Api exposed with s2s auth i.e. creating webshop integration - is it possible using azure and BC to distniguish customers i.e. register the api with s2s muultiple times but in oauth claims put customer no and use it in bc? - or the only possiblity in such case would be…
-
API Page-OnInsertRecord(BelowxRec: Boolean): Boolean
Hi all, I have created a new custom API page, and I have seen in a book and in the standart API pages that exit(false) is used in OnInsertRecord(BelowxRec: Boolean): Boolean on API pages. Could you please tell me why is like that. In which cases I have to use exit(false) ? Thanks Ivona
-
Document signature - XAdES-BES format
Hey, Is there anyone who has implemented Documents (such as xml) signing in XAdES-BES format in AL or C/AL?
-
BC service falling over
Hi, I have a client whereby the BC service is falling over a couple of times a day, this is from the event log:- I was wondering if anyone has seen this before? Regards and Thanks Roddy Server instance: SVCT-Live Tenant ID: Environment Name: Environment Type: User: Type: System.OverflowException Message: Arithmetic…
-
Codeunit SignedXML
Hello, I'm trying to use the codeunit SignedXML in Business Central to get an XML signed. I have spent a long time without any results, Can anyone help me? Thanks in advance
-
Block users from deleting system notes that wrote other user
Hello, I used OnBeforeDeleteEvent for this, but the problem is that it also triggers when users are converting a Sales Quote to Sales Order. It also happens when deleting Records containing notes. Is there a way where I can block the user only when it's pressing the delete button of a systempart Note? Thank you :)
-
How to make reusable sales quotes in BC?
Hello, we want to make templates for sales quotes which can be used for different contacts/customers. It is possible to copy sales quotes, but prices etc. get lost or have to be recalculated. So I want to know what's the best practice. Should you create a "master" contact or a "master" customer to store the templates?…
-
separate schema inside NAV or BC database
Hi All Is there any issues in creating and maintaining a separate schema inside the BC or NAV database and creating and maintaining custom SQL views to extract data from NAV tables? Will this be lost or change or creating any problem?
-
Problem reading xmlnode
From webserwis I get the following file XML. <?xml version="1.0" encoding="UTF-8"?> <reservations> <reservation> <comId>84913135</comId> <resId>63960910</resId> <lanId>11</lanId> <voucher>REZ/2022/0153</voucher> <term> <from>2022-11-20 14:00:00</from> <to>2022-11-23 10:00:00</to> </term> </reservation> <reservation>…
-
Restore BC OnPrem from BCOnLine Bacpac file
Hi, Has any one ever done this before? The steps I used to do this: 1) Download bacpac from BCOnline 2) Dowload and Install BCOnPrem with the same app version as BCOnLine 3) Import bacpac file to a SQL Server database 4) Set BCOnPrem to multitenant 5) Mount BCOnline tenant db to BCOnPrem instance 6) I get errors in NAV…
-
How to create custom workflow for customized table and customized page?
Hi experts, Is it possible to create customized workflow for a customized page related with customized table in NAV. How far it is possible and if yes, how we can achieve it. Please help.
-
question regarding calcfields repeat-until
Hi Guys, Kinda new here.. My issue is that i'm trying to calculate and sum all the 'remaining amount' entries in vendorledgerentry based on the start date and vendor no i'm entering in the report request page. For example if its 11/24/2023 that i'm entering on the request page all the entries before this date's remaining…
-
Degraded the Calcum of Quantity per Min and Max , and Level
Hello I have create a table Configuration whish the field's is (SalesPersonneCod;StartDate;EndDate;Level(Option : 16); WeightFrom;WeigtTo; and Amount So, i need to calc the sum of item ledger entry. entry type:: SALES per Salespersonnecode,and Posting date [StratDate|EndDate] and after get the difference between two…