-
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
-
Getting Error "Excel Not Found" while running the job queue
i have created a program for GL Data extraction and through job queue it should be automatically Email to user . While running the job queue i am getting error "Excel Not Found". I also tried by changing the Path to Network location but still its not working
-
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
-
Date Formula
HI, Is there any simple code to get the 3rd Monday of the month?
-
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',…
-
in case "if Page.Runmodal(...) = Action::Lookup then" doesn't show an ok-button
It is caused if you run a page from the launch.json. If you then run another object that uses the above code, it will never show the OK-button. If you then CLOSE the page that was opened on publish and reopen it again in the session, then the OK-button will appear It seems that launch.json runs a page as RUNMODAL which…
-
Nav 2018 SQL DB Replication possible?
Hi What would be best sql replication methods for Dynamics NAV 2018 database which the partner still uploads changes (objects including tables). The DB is around 200GB and subscriber will also be in the same premises (different building) I see snapshop, transactional etc. Not sure which one will work in this case?
-
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…
-
LS RETAIL JOB NOT RUNNING AUTOMATICALY
IF YOU HAVE CONFIGURED JOBS AND THAT NOT RUNNING AUTO THEN check codeunit 99001469 (in job que set interval in 1min) and compile and run codeunit99001468
-
Outlook signature
Hello everbody, One of our customers send emails with navision. Does anyone know how I can add his signature to a new mail message when I choose the Email icon form the customer card? Greets, Frank
-
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…