NAV Three Tier

All versions starting from "7.0" - Only new technologies (RTC, Webservices, Reporting Services, Query, OData, ...) Use this forum to discuss topics related to RTC (Role Tailored Client), Reporting Services, Web Services. All new technologies which were introduced with NAV 2009 (SP1) can be discussed here, but NOT the classic client, native DB-server, NAS. Those topics belong to the general NAV/Navision Classic Client forum.

Error in page filters, only a user of 200
Hello everyone. First excuse my english. I use Dynamics NAV2018 CU4. I have a user with problems on a page, it does not recognize the filters. I have 200 users and it only happens to him on his computer. If him test on another computer works correctly. I have deleted C:\Users\xxx\AppData\Roaming\Microsoft\Microsoft…
SQL Database size
I'm wondering if there is a limit to the size of the NAV database. We're at 2.6TB with a single company. Our largest table is the Sales Invoice Line table that is 490GB in size. Our G/L Entry table is 400GB. Normally, I wouldn't ask but our users have been complaining about performance issues over the last few weeks and I…
Cant download Symbol from C/AL in AL
Hi All.. I want to upgrade from NAV 2018 to BC On Prem 14 So now in BC on Prem 14 I want to use these tables from NAV 2018. but after generatesymbol, sync , restart... after i download symbol in VS Code, it still cannot find this object from CAL i already follow all these steps from here…
Why did Microsoft not redesign AL as a programming language when switching to Business Central?
Hi there, When Microsoft decided to change the old platform of NAV to Business Central and change the programming language that is used to develop functionality inside of Business Central. Why did they not make AL an full fledged OOP language to support a more mordern way of developing solutions for Business Central?
Can not run BC19 after a successful upgrade
Hi, I'm unable to run BC19 after a successful upgrade from NAV2017. I'm getting errors in the event log. Please see the summary of event log and detailed event log below: - Summary of event log WARNING Event Log 1 Message The required nav app to be injected was not published in the app db:…
Business central AL using Rendering for report layout
Hi Mibuso's, I'm using the new rendering possibilities in BC for the layout, but, I cannot select them through code. If I create a selection in a MenuItem, how to select the desired layout as it's in a [Report Layout List] Table and not as a custom layout in [Report Layout Selection] Thankx a lot for you help BR, Chris
How to Put a Exported XML file from Xmlport to Azure Blob Container in BC 365 AL
Hello Everyone, I wanted to achieve a task in which i am using an xmlport to export a xml file and trying to put that file into Azure Blob Storage Containers. Written the code something like this.This code is just placing a blank file on Azure, not my Exported Xml file which is in Outstream (OutStr). Please help with the…
Can you change option value based on a condition?
Is it possible to do the following? Lets say there are two dropdown options which I will call A and B. Based on the user selection in dropdown A, the options adjust for dropdown B. For example, dropdown A has 2 options: vehicle and colour. User selects vehicle for dropdown A. Now dropdown B has options: one, two, three,…
[Solved] Upgrade BC20.2 to BC21.0 - Extension compilation error on Microsoft_Base Application.app
Hi, I'm converting a BC20.2-database to BC21.0 (OnPrem). I'm stuck at the step where I am supposed to publish the new Base App. It raises compilation errors in three codeunits: Does anyone know how to fix this? Best regards, Roel
How to setup default value as NO for Confirmation dialog in API ?
Hi all... I am using cloud BC and publish the page. but sometimes upon modify (my case is Posting Date), there is a confirmation dialog. in BC, I want it to be NO but unfortunately there is no confirmation dialog if validate via API. Are we able to set as No in API? Thanks before.
Why is not possible to add fields with personalization on production ?
Hello guys, I'm able to add fields for this customer using personalization on Sandbox env but I'm not able to do it on Production. (Sandbox env was updated already to V21). What could the problem ?
Overwrite a field in Vendor Ledger Entries
I want to create an action on the Vendor Ledger Entries page, once clicked, prompt the page with a field to allow the user to override the external document number on the select vendor ledger entry. Could anyone please help me with the idea of how to achieve such an action? Or maybe know a similar action that does that on…
Business central installation
Hi All, I am trying to install the business central(Current Version), but i couldn't. i have installed visual studio code and business central .while I am trying to connect BC from visual studio I am unable to connect and download symbols.(getting error). Can someone help me pls. Thanks, Rajan.
Cancel payment to vendor
Hello, one of our customers has the following concern: he booked a vendor payment against an incorrect account and would now like to cancel it. So he has re-entered the payment in a general ledger, but here the amount with a negative sign. Now he gets the error message: "Amount must be positive in general ledger journal…
Business Central- The VAT Posting Setup does not exist. Identification fields and values: VAT Bus.
Hi everybody, I am a new user of business central dynamics and would really appreciate any assistance. I'm attempting to post the expense entries, but it's giving the error shown below. What should I do? Error Message: Journal Entry: However, all other bank-related entries are easily posted. Please assist me in resolving…
XMLPort doesn't recognize carriage return characters
Hi, developers: I'm working in a XMLPort in BC version 20. This XMLPort has next properties: Direction = Import; TextEncoding = UTF8; Format = VariableText; FieldDelimiter = '<none>'; FieldSeparator = '<TAB>'; UseRequestPage = false; At the end of each line of .txt file there are LR and CR characters. However, when object…
Purchase invoices - Business Central posting group error
Hello, I am unable to publish the expenditure related entry from the general journal, hence I am attempting to do so through the 'purchase invoices' section. I'm getting the following issue; could you kindly walk me through the steps so I can post this invoice? Error: Purchase Invoice Form: TIA
cant bookmark page
hi, is there a property or something so a page can be bookmarked? i cant bookmark a certain page?
NAV2013R2 and Microsoft Server2012 R2
Hi all, We are having some trouble getting 2013R2 working on an Server 2012R2. First there was an issue on OCsetup and the .NET framework 3.5 (took a while) but finaly the install on a 3-tier is working (development is working). Problem is we cannot get the service tier running, the administration tool shows running, RTC…
Deactivate Change Tracking on SQL server (Performance tuning)
Hi, Have a customer with performance problems. They have a SQL consultant looking into SQL performance. He says that Change Tracking is activated on database, and that gives performance issues. Can we deactivate Change Tracking on SQL database without problems for the running NAV 2018? Are there any other areas to do…
List all object and get description
Hi, in previous version (NAV) there is a table (object) which allowed me to obtain the description by indicating the type and idnumber of an object. Now in BC there is a way to do same?
BC/NAV career prospects
It's 2023 you are to become a junior developer, do you choose the path of Business Central/NAV develper role? Why yes and why not?
Adding extension to Preview Posting Business Central AL Extension
Hi, I have an event EventSubscriber for SampleTable OnAfterInsertEvent to populate the tempSampleEnty temp table and another EventSubscriber to another Codeunit 20 (Posting Preview Event Handler) for the event "OnAfterFillDocumentEntry" to add new row in POSTING PREVIEW window but my temporary table is uninitialized or…
Issue and solution for Import Excel to Cloud BC Table
I was trying to import some records to a Cloud BC table from Excel. I could not use these following Methods in Cloud BC, which was good for on-premises BC. This is due to the scope of the methods (onPremise vs Cloud). ServerFileName := FileMgt.UploadFile(WindowTitle : Text[50];ClientFileName : Text); SheetName :=…
Entries applied to an Outbound Transfer cannot be unapplied
Hi Experts, I got the error msg "Entries applied to an Outbound Transfer cannot be unapplied" when trying to post Purchase Return Order. What should I do to avoid this error? Thanks,
User log in error: NAVCancelCredentialPromptException
Hi, I have an database upgraded from BC15 to BC20.6 onprem using AAD for authentication. At times users are not able to log in and it appears the browser is processing something on the log in screen. Users can only log in after clearing the cookies for the BC website. In the event log I am seeing the following error:
Add file in encrypted ZIP file
Hi to all, Adding files into a .zip file is possible using FileManagement and functions for adding file to zip archive. But, is it possible in NAV to encrypt the ZIP file when it's created with pre-defined password in the system? I'll be grateful for any experience or advice. Best Regards
Getdata function of Report builder
Hi all, I didn't know how the getdata function works in report builder. specifically in report 206, CustAddr is variable that has dimensions=8. here how CustAddr storing the customer details into the dimentions(Address, city, state, zip code)? thanks, Rajan.
Business central + mermaid.js
Hi everybody I need to create a gantt diagram in Business Central, and I am thinking about doing it with mermaid.js (https://mermaid-js.github.io/mermaid/) but I can not manage to make it work in a Control AddIn i business central. Has anyone managed to do it, or something similar? Thank you in advance.
Google Worksheets manipulation on NAV 2017
Hello everyone, is it possible to import/export data to and from web-based google worksheet link?

NAV Three Tier

Discussion List

Categories