-
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?
-
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.
-
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…
-
Creating functionality to TEXT a phone number when backorder get received
I am looking for new functionality to have NAV 2018 automatically send a TEXT message to a specific phone number to alert the customer the backorder sales line is received in - is this possible?
-
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?
-
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.
-
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.
-
Can't delete a company in Sandbox
So I am working with SaaS Business Central that is: Version: W1 20.2 (Platform 20.0.41086.43114 + Application 20.2.41144.41547) The user I am logged in with, has Super, Security, Full Business, Extension Management - Admin rights for all the entities. I have total of 3 entities and wish to keep just one. Whenever I try to…
-
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…
-
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…
-
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
-
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…
-
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…
-
How to add barcode in Navision Reports?
hi all, Can you please tell me how to add barcode to nav reports? thanks, Rajan
-
Error on Data Upgrade from NAV2009 to NAV2015
Hi, I am doing an upgrade from NAV2009 to NAV2015, but on the Data Upgrade, I always get the following error (in german): SessionId : 5124 CodeunitId : 104055 FunctionName : StartUpgrade CompanyName : xxx StartTime : 27.04.2016 16:16:31 Duration : State : FailedPendingResume Error : Fehler bei einem Aufruf von…
-
Xml import question
Hi, is there a way we can import a complex type element in an xmlport? I am getting the error 'the element cannot contain text. Content model is empty'. I'm not sure how to get around this Regards,
-
NAV Regular Expression - Match Transformation
Hi, I notice something peculiar with the NAV Standard RegEx - match found in Page Transformation Rule Card (1238). This NAV standard RegEx Match skips the 1st match result. e.g. I expect to see As match results. But NAV RegEx match skips the 1st match result. When the same Regex expression in tested in: regexr.com/73md2 It…
-
Allowing Pop-Ups when using hyperlink to start software
Hello, I would like to open a PDF-Viewer or other software and I used so far hyperlink, which works fine with NAV2017 With BC I get a message from the brower that I have to allow pop-up messages and I entered http://localhost:8086/BC190/ But the browser (Chrome) still does not allow to start the software. What is wrong or…
-
NAV 2017 Client freeze att random times
We have a very weird issue where one of our customers clients always freezes at random times. This is for the whole company. Main Issue Freezes at random times at all their computers we cant derive this to anything special they do. It happens like 5 times a day 30 sec freezes always, and then the program starts workning…
-
Line Amount Excl. VAT getting calculated wrong!
We have a receiving invoice that was posted. Normally the Items for our lines will pick Direct Unit Cost automatically and we don't let users select it nor do we let them change the Line Amount Excl. VAT. We noticed as attached below that Line Amount Excl. VAT which is 86.40 is not correct. The Quantity * Direct Unit Cost…
-
RDL Error Definition of Report is not valid
Hi, I have this weird error below when trying to modify a rdlc layout and compile a report object. Microsoft Dynamics NAV Development EnvironmentError while validating RDL content: The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with…
-
Why do we need so many table keys in NAV/BC
Hi Guys I have looked at couple of tables to understand the base app allocation of table keys, for example, sales line table contains 19 keys for all possible combinations to retrieve data. Is this the norm when creating your own tables as well? For example I created a table with say DocType, Number, Customer and possible…
-
internet browser is not installed
Hello everyone, I have a problem in NAV 2013. When I click on the icon next to the Home Page field (customer or vendor), I get the message "internet browser is not installed". NAV 2009 works. Do you have an idea? I have already uninstalled and reinstalled IE9. In addition, I made a repair run of NAV 2013. Everything seems…
-
There are any Microsoft Tool in order to convert the database in EUR?
Dear NAV & BC experts, We have a croatian Company. As you know, in January croatian companies have to pass to EUR currency. Dou you know if there are any Microsoft Tool in order to convert the databe in EUR? Thanks in advance.