-
"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…
-
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.