-
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
-
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.
-
BC SaaS: Add custom code at inserting new record in table Sales Header
Hi All, I am working with BC SaaS. I would need to change the standard code of table "Sales Header" as new record is being inserted, where I need to modify the code that inserts the "No." value of table "Sales Header", so Numbering series. I noticed that if I add my code in trigger OnInsert of table "Sales Header", it does…
-
How To set Visible Columns on List page
I want to Choose other fields to display in Visible Columns
-
upgrade from BE 3.70A to latest online Dynamics 365 Business Central version
Hi all, I want to upgrade our current Microsoft Business Solutions Navision BE 3.70A (4.0 SP3) to the latest online BC. Our 3.70 version is practically standard. Who can assist me? What are the steps to take? Do there exist scripts for this?
-
"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
-
BC 14 Cumulative Update Issue
ello everyone, i am doing BC14 Cumulative update from CU 16 to CU23. It is only platform update. When I try to convert database then I am getting below error 1 and is not able to proceed. SQL Server is Azure managed instance and I am trying make database single user from within Business Central and using SQL Query but get…
-
Error asigning value to HttpHeaders
Hy all folks. I need to assign these headers to an httprequest: xlHttpHeaders.Add('x-amz-access-token',…
-
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…
-
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…
-
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…
-
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…
-
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
-
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…
-
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…
-
Web Service API Business Central OnPrem
Within an On Prem BC18 Installation I' have exposed a new api page to my web service and I'm attempting to connect via web service. What settings and url would I need to connect to the following: page 50120 MyCustomerApi { PageType = API; Caption = 'My Customer API'; APIPublisher = 'contoso'; APIGroup = 'app1'; APIVersion…
-
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?
-
Cannot create a new Business Central cloud Sandbox environment from Production
Hi experts, In Business Central Administration Center, I try to create a new Sandbox environment. I want it to be a copy of Production. When I do so, it is shown in the list of environments (with status "Preparing" if I remember it right). After 5-10 minutes, the environment is gone again. No warnings. No error messages.…
-
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…
-
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.…
-
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…
-
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 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…
-
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…
-
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…