-
Server License Expired even though License is not expired
Hey there! On of our systems we have multiple NAV Versions installed. When trying to open the DEV Env. for 2013 we get a warning saying "Your program license has expired". The unusual thing is that the Dev. Env. doesn't open at all, just the warning and then it's gone. We uploaded the license manually via the AdminTool…
-
current user as the type of email account configuration
Hello all , i am using BC 21 on premise, office365 as email plateforme i want to configure current user as the type of email account option. the problem is that BC point always to port 48900 which i did not configure. as http://mycomputername:48900/BC210/OAuthLanding.htm i have already set up the The redirect URI which i…
-
Nav tips and tricks
Dear all, I have 2 questions if You can help me: 1. Can I set alarm in NAV for items quantities, meaning that for some items if quantity drops bellow predefined, I got mail or something? 2. How can I upload order confirmation pdf or excel to NAV? Thank You very much. Best regards. D
-
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.
-
Rendering Output failed for Report in RTC
Hi guys, When running a report in Classic, it works fine for both small and large amount of data. But when running the same report in RTC,it works fine only for a small amount of data. For large amount of data,when previewing,only captions are displayed with no values.When printing the following error message is displayed…
-
Remove-NAVServerUserPermissionSet error "No Access Control in filter"
Hello, We are using Business Central 230. In Powershell (run as Administrator) I use "Remove-NAVServerUserPermissionSet $MiddleTier -PermissionSetId "<name of the permissionset>" -UserName $LogonAccount -Force". When the permission set is super, I see no errors and super is removed from the user. But when I use a different…
-
Job Queue - "The current permissions prevented the Action (Codeunit ... Exceute)
Hey there! We created a job queue that executes a Codeunit in one of our extensions. We created a permissionset that includes the Codeunit with "X" permissions. Permissionset is assigned to the user. When we execute the Job Queue manually everything is working as expected. However, if the Job Queue runs automatically…
-
SMTP test error
Hi, Im not too tech savy so would appreciate if the anwear is in a "beginner level". Im trying to set up the SMTP Mail Setup settings for a customer in NAV 2017. When I try to send as myself, to myself the test goes through. But when I try to send to another mail I get the following error. I have tryed to enter another…
-
LSCIN Tax Transaction Value V2 data send Issue
In LS Central, I am enabled DD Send Transaction to push transaction from Store database to HO database, transactional data are pushed to HO except table LSCIN Tax Transaction Value V2 data.
-
Price includes VAT by default on Item Card?
Is there any easy way to make the system to assume and set "Price includes VAT" to true whenever an item is created? I tried subscribe to "OnAfterOnInsert" from Item table and make it to true. But it throws an error the VAT Prod. Posting group field not populated yet.
-
How to create Agenda Outlook Stile?
Good morning everyone, a client asked us to create an outlook-style appointment diary for him on BC21 (onprem). Currently our vertical (they are all customized tables) shows them in "matrix" style format, while the customer would practically like to see the agendas of the individual resources (even all together) with the…
-
How to lock columns in NAV 2018 using excel Buffer
I need to lock (protect) all columns except one. In Classic, the automation routines used, have protect and lock. In NAV 2018, the dotnet routines used do not seem to have these functions. Name DataType Subtype Length XlWrkSht DotNet Microsoft.Office.Interop.Excel.Worksheet.'Microsoft.Office.Interop.Excel,…
-
How to Merge cells in Excel while extracting report from navision using Excel Buffer...
How to Merge cells in Excel while extracting report from navision using Excel Buffer... I am using navision 2016 . i have tried this https://forum.mibuso.com/discussion/70593/how-to-merge-excel-cell-when-exporting-excel-buffer-nav-2016... but i didnt get solution...... please do needfull
-
Unable to select layout! Cannot build the page 9660, the metadata object was not found.
Hello all. I ran across a very weird problem that was bugging me, and after finding the solution I wanted to share it with everyone, it may help someone else. On production environment, client was unable to "select layout", whether from the "report layout selection" page, or by running the report directly and choosing…
-
Record IsTemporary useage and documentation
Hi Guys I see often when writing event-based code units something like: if Rec isTemporary then exit else begin end Is there any good resources that explain temporary records in BC and how and when they are used. ideally I want to create a test where the record is temporary and my codeunit or function exist to test. Some…
-
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…