-
How can I disable the print in report on NAS?
The report should be run without printing.
-
Business Central BC180 On Premise / Test environment
I am a (junior) developer in a Business Central development team, we want to set up a test environment to unittest our .al solutions. Via a Mastering BC book we find out that you have to include the following .app packages in your .alpackages folder: Microsoft_Any.app Microsoft_Library Assert.app Microsoft_Library Variable…
-
How to export all objects from BC SaaS SandBox environment to text file
Hi, is there any option to export all objects from BC SaaS database into a text file? Thanks
-
Accessing Global variables in report extension
I'm looking into the new ability to extend reports in, what I need to be able to do and can´t find out if it is possible (yet) is to access the global variables in the OnPreReport trigger. What I'm actually trying is to change the PeriodStartDate , PeriodEndDate and HeaderText in report Aged Account Receivable.
-
Extension not publishing to Sandbox BC 18 cu1 after update from BC18 cu0
After updating Sanbox BC 18 cu1 from BC18 cu0 extension not publishing for Sandbox. Only after creating new sandbox extension was published The request for path /v2.0/Test/dev/apps?SchemaUpdateMode=forcesync&DependencyPublishingOption=default failed with code UnprocessableEntity. Reason: You do not have the following…
-
Strange behaviour of Menusuites
Hello I was confronted yesterday with a somewhat oblique phenomenon: a customer of ours uses an add-on. From this, as if out of the blue, several menu items disappeared yesterday. They also couldn't be found through the search. I compared the menu suite for this add-on as well as the MS 1090 with the respective versions in…
-
Windows Client Issue with Credential Type UserName
Changed ClientServicesCredentialType to Username. Web client works, but Windows client would complain: The ClientServicesCredentialType configuration setting cannot be parsed into a valid NavClientCredentialType Using NAV 2017. Any suggestion please. Thanks.
-
Total sum per group
Hi everyone. I just started with C/AL navision. I want to create simple report thate contains two tables : Sales Invoice LIne and Resurce. I added a few globas variables , and report looks like this. (No. is Number of Resource, and at the same time No. of resource in Sales Invoice Line No. Name Price Qauntity Production…
-
Can't download symbols for BC18 when including test
I would like to write custom test codeunits, but I have trouble accessing the necessary symbols. If I don't include"test": "18.0.0.0" in app.json, VS Code download all symbols just fine, but it can't reach the objects relevant for testing, such as Assert. If I do include the property, I can't download the symbols without…
-
Display Mediaset images in factbox
Hi I would like to create a factbox through which I can display all images in the Picture mediaset field in the Item record. Can anyone advise how I can achieve this? It seems by default only the first image in the Mediaset is displayed. Perhaps by having a Next and Previous action to iterate throu the mediaset images and…
-
Connecting middle tier to SQL using a service/single account?
Hi All I've seen this done and I really should have paid more attention at the time but didn't think I'd ever need it again. Basically they setup NAV to authenticate to SQL using a single service account rather than the usual multiple users. I assume the users connect to the middle tier and then the requests to SQL happen…
-
NAV 2013 R2 connect to external SQL Server
We use to have codeunit using Automation to get some data from another SQL server but now getting errors. We would like to re-write it if possible using other means connecting to SQL Server directly. However I've done some search for such info but no luck. Any link/info as how to connect to another sql server and grab…
-
How change sql database in BC Container?
Hello. I have BC18 Container that use standard CRONUS database. I restored one more database. And now how can I change from CRONUS to new one?
-
Who i can disabled the preview in report
hello everyone, Who i can disable the preview in report.
-
AppObjectId from event log doesn't exist
Hi, I try to track down some performance issues and found an entry in the event log of the service tier with a long running SQL statement. However, it states AppObjectType: Page AppObjectId: 9599 But this page doesn't exist. What is going on there?
-
File Name with Special Character ~ changed
I am trying to do download file using downloadstream. var
FileName: Text
InS: InStream;
begin
FileName := '01~Jan~2021.txt';
DownloadFromStream(InS, '', '', '', FileName);
end; When the file is downloaded the file name is changed. All ~ is changed to _. In above example downloaded file name will be 01_Jan_2021.txt How to…
-
Upgradation
For one of our Customer we were supposed to upgrade to NAV 2018 from NAV 2013R2. We did the Application code upgrade to latest CU of NAV 2018 but I saw where in Microsoft is saying to upgrade to NAV 2018 CU 2 first. Is that really needed OR I can continue to the latest CU. Eventually we need to move to Business central.…
-
Export File to Azure Storage Location
Hi, From BC on prem, is it possible to export a file to an azure storage location? Regards,
-
Universal Excel Import Export
Universal Excel Import With success of "Universal Data Import Export", we have received a lot of requests from customers and community for importing data from Microsoft Excel as "Universal Excel Importer". It is friendly and very useful that Classic NAV Systems (NAV 2009 earlier) should have. Unfortunately, it hasn't…
-
SharePoint configuration issues in Nav 2017
Hi. I have a problem in Nav 2017 in standard SharePoint connection settings. I configured it a few years ago with my SharePoint site and it had never given me problems, but for a few months, just by hitting the Test connection button, I get the following error: Could not connect to the SharePoint site. SharePoint Server…
-
Null in a function
Hello, i need to use a variant null in a function. The function has 5 parameters, and the first a second have to be null. how i put this null parameters ?
-
I am getting an error message while connecting NAV 2016 and power Bi via oData.
Hi, I am trying to connect power bi to NAV 2016 via odata. While trying i am having the below error. I tried to put below URL but cannot connect: http://<Server>:<OData Port>/<DB instance>/OData It give me below error: Dynamics NAV: Request failed: The remote server returned an error: (503) Server Unavailable. (Service…
-
How to encrypt and decrypt the password using RSA algorithm in NAV 2016
Hi All, I need to encrypt the password which uses "Public Key" and send the same using HttpWebRequest, it will give reponce which is encrypted. I can send and receive the data but cannot encrypt and decrypt. Please help to encrypt and decrypt the data using RSA algorithm. Thanks in Advance, Srinivas.
-
Navision 5.0 Support SQL Server 2019?
Dear all, One of my client want to run navision 5.0 in SQL server 2019. will Navision 5.0 is supported in SQL Server 2019? Please let me know. Thanks in advance. Regards, sekar.
-
How can I prevent the web client from focusing on records that are inserted or modified?
I am building a custom price list page based on a custom temporary price list table. Due to high calculation time on a few price fields, the values of these fields are not calculated prior to the page loading. Instead, these fields are calculated and modified 100 at a time by a page background task. This works fine with…
-
Importing posted invoices in Business Central
Hi folk, We are starting to implement Business Central. We are currently in Navision 4, so the approach we have decided is re-implementation. I am doing a kind of POC for data migration, but I found there is no way to use a configuration package to import posted sales invoices. Is there any way I can do that? We have more…
-
Data Extraction
Hi, In Nav 5.0,Can we extract data to email on daily basis in Excel Format?
-
Download old versions
There used to be a nice archive of old versions on PartnerSource. Now PartnerSource is dead, does anybody know if it's still available somewhere? We have a new customer that wants to upgrade from v4 sp2 and doesn't have the original database... Thanks in advance!
-
Report issue
While i opening a report eg: report 1 using report builder, it automatically creating a new report as "report builder - backup" how to avoid this
-
How to export the Account Schedule data from multicompany
I got a requirement in Nav 2009 classic client, Not RTC, that the users want to export Account Schedule from Multiple companies, do you have some suggestion for that? thank you in advance, I have done some coding, it will change the account schedule description, but it will not change the data(Value), some guy have the…