-
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…
-
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,…
-
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…
-
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 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.
-
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.
-
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?
-
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
-
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…
-
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 :=…
-
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:…
-
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?
-
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
-
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?
-
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…
-
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.
-
How can I use my dll in cside (NAV 2018)
I want to create a cside variable of type DotNet of my custom dll. What do i need to do? The dll contains a function to generate some key. It's NAV 2018.
-
Overwriting "Send To" on report request page
Hi! Whenever you run a request page, there is the "Send To" button, that allows user to use different files type. The thing is, that if the user choose the "Microsoft Word" file type, the file is going to be editable when saved, unlike the PDF. Is there any way, to prevent user to use this "Send To" button on request pages?
-
Problem with Base64 conversion and Excel files
Hello, I have an application that gets Excel files encoded in Base64 I try to decode the Base64, put the obtained text into a blob to download it later with DownloadFromStream But I get corrupted Excelfiles I developped a little procedure (see link) to see if Base64-coding and Base64-decoding is altering the data. The…
-
Show all tables data
Hello experts, I have two fields in my table, TableID and RecordID. TableID is for selecting the Id of any table in NAV, I have no problem with that, but the second field, RecordID must contain all records of the table that I had selected when I filled the field TableID. EXP : I entered 18 in the field TableID, so the…
-
How the warehouse Entries are processing?
Hi all, Can anyone tell me how the warehouse entries are managed/Stored when the Register inventory movement done and which codeunit helps to store the data in warehouse entry table in Nav ? Thanks, Rajan.
-
Business Central 19 Wave 2: Cannot Publish Extension With Updated License
A third party vendor added some granularity to our license and our partner downloaded it and sent it to us. Now we can no longer publish after importing the new license. It is giving the error: [2022-12-08 10:35:10.50] The request for path…
-
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:
-
Callback URL for Cloud BC
Hi All, I am pulling data from 3rd party system. so they will give me callback url. how do we do callback url in BC? any advise? Thanks.
-
Duplicating (splitting) lines by code
Hi All Is there a way to duplicate a selected line and insert a new line (copy) below the selected line? For example in the transfer order we want to copy the selected line and insert a new line below? Thanks
-
Text encoding issues when saving report as PDF
Hi, Hope some one can help. I have a customer that sends pay slips to it's employees as PDF. Their employees have been issued Android phones and most of them only view their pay slip on that phone. The system that they send it through in Denmark charges pr kb so to reduce the size of the PDF i have disabled…
-
RTC Client: Partially keying No. field and tabbing vs hitting Enter
I have filters that are entered when the Item List page opens so when you manually key in part of the full Item No. on a sales order, it will use those filters and show the results on that inner field page. Here's the issue. When you hit Enter, it will use those filters and return the 1st record found. However, when you…
-
Memory usage on BC on-prem service tiers
Hi, First of all, I don't know if this is the right forum? We have a fairly large installation, with 16 service tiers spread out on 3 servers, and a complete test/development copy. I have three questions. Is there any way to know what causes high memory usage? It seems that in time the service tiers consume almost all…