-
Posted Sales invoice Line Insert Field - which trigger
Hi All I have created an UDF on posted sales invoice line table to record total shipped quantity on each line (from sales shipment line table). Trying to update this field via a code unit and not sure which code unit and trigger to use. Someone else mentioned to use OnAfterInitFromSalesLine but could not find it on…
-
Delete user ID from "user page list"
Hi people, On BC 14 (c/al still on premises) i am trying to delete a user from the list. It doesn't allow me me to saying the following error: "Microsoft Dynamics 365 Business Central The user "XXXXX" cannot be deleted because the user has been logged on to the system. To deactivate a user, set the user's state to…
-
Logout session using ACS login and Windows Client
Hi, does anyone know, where the windows client store the session token while logging in via access control service? We have the problem that the user cannot log out once he has successfully logged in via ACS Login. There does not seem to be a logout function. The client never ask again for credentials before the token is…
-
D365BC multiple companies to one CRM
Can a D365BC with multiple companies be connected to one D365 CRM
-
Date in Json array
Hi, Can anyone give me some advice regarding Google Chats Calendar Charts. In this connection you must have a Json array with the date and a number value like this: [new Date (2012, 3, 13), 37032] How to make this Json array element? Thank in advance PRLI
-
Download Location for Report add-in for Visual Web Developer Express 2008 - Any ideas??
Hello, I have been tasked with looking at some RDLC reports from NAV2009R2 but, although I have managed to download and install VS Web developer Edition 2008 for the life of me I cannot find a valid download link for Report add-in for Visual Web Developer Express 2008.. Can anyone point me in the right direction please??…
-
LinkedObjecs in BC14
We are in the process of upgrading NAV2009 to on-prem BC14 and we came across a problem with LinkedObject tables. We have a number of such tables that we use to read data from other databases. Although the table property LinkedInTtransation is set to No, when we run the table in BC we get an error that "....linked server…
-
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…