-
SSO is not working after upgrade
Hi, We upgrade our Business Central environment from version 1901 to 1902. We deinstalled version 1901 and installed version 1902. SSO is not working anymore after installation. We check the configuration files, but the are the same. In the Event Viewer I see the following: Message (NavSerializationException):…
-
Webservice with and temp Table
Hello, I have a page, which displays the Lot Numbers (as a list) to an article. This page gets the data via a function in the page, because the page has set the property SourceTableTemporary to Yes. The SourceTable is Lot Number by Bin Buffer. The OnOpenPage trigger calls the local function FillTable, which inserts the…
-
Connect Visual Studio Code to Business Central on premise
I cannot download symbols from Business Central (2019 second wave). Business Central is on a server and I have Visual Studio Code on my local PC. App.json: { "id": "a31dcs4b-0ab4-4134-98ae-f3c780b5b0ad", "name": "Moes", "publisher": "Default publisher", "version": "1.0.0.0", "brief": "", "description": "",…
-
Showing error during creation of 'dimension set id' in Dimension set entry table.
Hi Everyone, I am creating 'dimension set id' in temporary dimension set entry table,once its created ,but now its showing its already there. Please find below my code: TempDimSetEntry.RESET; TempDimSetEntry."Dimension Code" := 'DEPT'; TempDimSetEntry."Dimension Value Code" := DeptCode; TempDimSetEntry."Dimension Value ID"…
-
BC14 Web Client shows only logo and cannot start
Hello all, Just wondering if any of you came across this issue. I have installed BC14 on my laptop and the web client cannot start and only shows the BC logo. * I can open the RTC client without issues * The C:\inetpub\wwwroot\BC140\navsettings.json file is configured correctly to target the right NST * I'm using windows…
-
Grouping table by a field and finding sum in Dynamics NAV 2018
I'd like to group a table by a field- employer code and then calculate the sum of a decimal field- total contribution in that group from C/AL code. Here's my table structure Employer No_ Total Contribution
PRTEMP005022 1817.64
PRTEMP005022 1782
PRTEMP005022 2049.3
PRTEMP005022 1568.16
PR0000247148 47750.62
PR0000247148…
-
data insertion in table
Hello experts, I have scenario like i have custom page on page i have action on click of that action data from page is store in table .for that i have created table QC test Result. In action added codeQCTestResult1.INIT; QCTestResult1."Test Certificate No":="Test Certificate No"; QCTestResult1."GRN No.":="GRN No.";…
-
Job Queue Stuck after post batch
Hi all, I am using cloud BC after I tried post sales invoice using post batch, with some errors then there are these Job Queue Stuck. how to prevent this? i tested with same scenario in bc on premise, there is no error message like this. is there any setup? (p.s : i didnt tick background posting in Sales & receivable setup)
-
how to make price excluding vat inactive
Hi i want to make the field unit price excluding vat in active when raising a sales order only to view the amounts but not able to change in the sales order subform am using BC .Your guide will be highly welcomed.
-
Multi Language captions not always correct.
Hi, We have a system which both English and welsh captions added onto actions and fields. Some of these come across fine but others do not. Here is an example.. This is an action item with a Welsh Translation. Here we can see in a User running as the Welsh Language in the User Personalisation the button still reads the…
-
How i Can Solve this error Could not initialize Microsoft SQL Server 2012 Report Builder 3.0: Illega
i try to upgrade reports in 2013 but this error show ''Could not initialize Microsoft SQL Server 2012 Report Builder 3.0: Illegal characters in path. Verify that Report Builder 3.0 is installed correctly.'' after click upgrade reports.
-
NAV TechDays 2019 Video
My impressions of this year's conference: NAV TechDays 2019
-
Dynamics NAV service Tier - login failed for ANONYMOUS LOGON
I am setting up a service tier for MS Dynamics NAV 2009, but am unable to connect due to a login failure. Login failed for user 'DOMAIN\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. Error: 18456, Severity: 14, State: 11. I have the following…
-
Executes external programs and operating system commands from Dynamics Busniess central (SHELL)
Hello Dos anybody know i can i emplemt SHELL in extention 02 programming? Regs. Firas
-
Encrypt/Decrypt text in version 15
Hi all, In previous version of BC/NAV we used some system dotnet libraries to encrypt/decrypt text. Do we have any alternative for this in version 15 (Cloud)? I know for built in function's Encrypt/Decrypt. But can we used same encryption key on the other side for opposite process? Thanks
-
NavContainerHelper, includeAL and local extensions
When using -includeAl on New-BcContainer i get the source code from the base app as al-code. But the image that I am using also contains local danish extensions published by Microsoft. Can I use -includeAL to get the source code from these extensions included in the image? Or is there some other way to extract the source…
-
About "Application Area" Property
Hi Experts, In BC140, after I created my own tag of Application Area in Table 9178, put the tag in the Objects accordingly, and activate it, it takes effect in the Web Client (which is what I intended to). However, it also affects RTC (RoleTailored Client), which is what I do not want, is there a setting/a way to have the…
-
Team Member Question
Hi Does anyone know if a team member licence would allow a user to convert an approved purchase quote into a purchase order? thanks
-
In Dynamics BC / Configuration package import executing field OnValidate code
Hi, Does Configuration Package import execute code that's found on OnValidate trigger of fields? Is there an option to do that?
-
Security Filtering using Extension in AL Code
Issue : When I use security filter in field "Code" in table "No. Series", I get error "A security filter has been applied to table No. Series. You cannot access records that are outside that filter" when create new Sales Order. I debug and it break on code below in function "CheckNumberSeries" (codeunit 1400) : IF…
-
Reservation of incoming documents
Dear Sir, One of my clients storing their incoming documents in NAV 2016 Database as blob files. In this ways, the database size is getting increased day by day rapidly. To avoid unnecessary database increase, I have given a proposal to reserve the same (document wise) in separate place instead of NAV Database. Kindly…
-
Can i create Flowfield with (Field A - Field B) or (Field A / Field B) ?
Can i create Flowfield with (Field A - Field B ) or (Field A / Field B ) without coding ?
-
XMLPort - Export Ampersand character
Hi guys, I've got an XMLPORT( Encoding: UTF-8) that needs to export an URL that contains an ampersand but the output data is converting the & symbol into this data -->& My attempts were:Char1 := 38; URL := TextAA + FORMAT(Char1) + TextZZ URL := TextAA + '&' + TextZZ with the same result…
-
Configuration File Error
Hi There, Does this error message look famliliar to any of you ? It happens only when a particular user tries to get into NAV. They're on NAV 2016 version. Thank you for your cooperation in advance. Best Regards
-
How to mapping the xml file field name attribute to record field by looping
Hi Experts: I produce a Item data to xml format file and passing to NAV code unit web service for receiving. How could I map the xml file field name attribute to record field by looping field record and give the xml value when received the xml file. the xml file format like this <col_1 filedname="No." >001</col_1> <col_2…
-
Error when printing a check in Navision
Good day, My cashier attemps to print a cheque, which is always possible in Navision, but now is gettint an error message "Seventy Eight Cents Results in a written number that is too long".
-
Table 'TempBlob' is marked for removal. Reason: Replaced by BLOB Storage Module
Hi all, How shall we call Codeunit.Run(CodeunitID, TempBlob) if TempBlob will be removed in future? Thanks
-
Create Dimension set id for the combination of three 'Dimension code': Dept,Project and Channel.
Hi Everyone,(Nav-2018) I would like to create 'Dimension set id' for the combination of three 'Dimension code': Dept,Project and Channel in "Dimension set entry" table. for this i am following the below link: https://dynamicsuser.net/nav/b/amol/posts/dimension-update-in-nav-2016 For this: Step:1. I have created one…
-
Error when Creating a new company
Helo. I'm trying to create a new company, but I'm having trouble to open it. When I try to open it, it starts to inicialize but stops with an error. Debugger showed me, that CodeUnit 2 pops up the error, however I have no clue where to start looking for the text that is mentioned in the error. Code stoped at line:…
-
The NAV 2013 R2 klient crashes witout any messages
When a certain user opens the customer card (page 21) of a certain customer and then opens the job list (page 89) NAV closes immediately without any messages. What could be the reason for this? If i'm doing the same there is no problem.