-
Automated Testing for BC365
Hello :) Good day. Is there any applications for automated testing for BC365 ? and where can I get it too? thanks and God Bless :) Regards, Jhan
-
Layout printed on currReport.skip
Good morning, I hope someone can help. Any ideas why the word or rdlc layout comes up after doing a currreport.skip on the main dataitem? Probably it is i don´t do as many reports as I used to.. Thanks.
-
credential for onpremise BC - Incognito/Private mode
Hi All, I am using on premise bc version 18 using google chrome is ok but if i use incognito mode, it will prompt me user name and password what user name and password should i use? 1. AZUREAD\USERNAME and domain password --> failed 2. USERNAME and domain password --> failed 3. user.name@domain.com and domain password -->…
-
I have issue in grid layout page on business central
Here i have created a new grid layout page in business central , page type - worksheet in this page the fields are showing above action button Is there is any way to rectify this Thanks in advance
-
Performance - Insert to temporary table
I have a Repeat\Until loop that builds records and inserts them into a temporary table. The table's primary key is "Entry No." with the records being inserted in increasing "Entry No." order. Creating and inserting 250 records takes about 2.5 minutes. If I comment out the INSERT statement, but let all the record…
-
NAV 2013 / Net Tcp Port Sharing / Dedicated service account
Hello all, I try to configure a port sharing between the different services Navision. I have set a service account, who is a AD user, to launch the services. This account is not an admin account (local and domain). I don't want that it have this permission. But he is in the group "Log on as a service". I've followed this…
-
How To set Visible Columns on List page
I want to Choose other fields to display in Visible Columns
-
How to control booleans values to excel?
Does anyone know how to control the displayvalues being sent from NAV to Excel? I have two seemingly identical machines installed running on the same NAV2017 server. When using the default "Export to Excel" functionality, for instance in the customer overview, one machine display TRUE/FALSE and the other YES/NO in the…
-
"Applies-to ID" gets cleared issue on BC
Hi, has anyone had issue with following fix which was introduced with "CU 12 for Microsoft Dynamics 365 Business Central April'19 on-premises (Application Build 14.13.42648)"? If so, how did you solve it? When cash purchase invoice is being posted "Applies-to ID" value gets cleared and Vendor Ledger Entries are not applied…
-
Office 365 Tasks and Calander
Is it possible to display Outlook tasks and potentially the calendar in the Business Central Role Center. The customer has read a lot about the integration to Office 365 and had hoped this would be possible. Cant see anything when searching for it. Is it possible to display a web page in a card part. May be possible to…
-
is it possible, TCS in Sales Journal in Dynamics NAV 2016 IN ?
Hi friends, I have a problem in NAV. I am calculating TCS in Sales invoice, it is correct. But when I go to Sales Journal then we can not select any TCS nature of Collection even we create nod/noc lines for customer. Thanks in advance
-
How to Change Caption Style
Hi I know you can change field value color by style property like Attention. How do you change the caption of the fields such as Customer, Item etc or column headings on page
-
Use NTLM Authentication
I'm implementing a new interface between NAV2013 R2 and an external system. This system calls the NAV webservice from a Linux machine. There for I had to change the setting Use NTLM Authentication in the servicetier. My question is if I just can change this setting or does it have consequences for existing interfaces which…
-
Adding any custom field in any table getting error.
Hi Everyone/Expert, I am trying to add one custom field in table "ship-to address"(222), but during compilation getting below error: Here, company name is showing different after the default schema. And same error is coming for any table during the adding any field. Please suggest/guide to overcome this issue, as i tried…
-
Error asigning value to HttpHeaders
Hy all folks. I need to assign these headers to an httprequest: xlHttpHeaders.Add('x-amz-access-token',…
-
Add Open in Excel action to ListPart page
Hi all, Business Central provides the Open in Excel action as a built-in feature on some page types like List oder Worksheet. I am currently in the need of having this action applied to a ListPart page but this type of page doesn't provide it per default. Is there a way to add it manually to the action list by AL code or…
-
Business Central: Report Extension - Accessing variable from OnAfterAfterGetRecord trigger
Hi, Trying to code against OnAfterAfterGetRecord trigger for a report. How would you access the variable that's in the base nav OnAfterGetRecord trigger of a dataitem? Blanket Sales Report - dataitem RoundLoop - local variable SalesLine in the OnAfterGetRecord trigger.
-
Server AddIns with ServiceTierAdministration
Hi, Thanks for your time in this forum, I am unable to have access to the AddIns placed in the AddIns folder of the instances or services created by the tool. Despite the dlls are there, when I try to access from NAV, the Server Assembly List is empty: The dlls and folders are there. I have tried to provide permissions to…
-
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.
-
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…
-
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?
-
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.…