-
Run a script file in web client for Nav 2016
Hi Experts! I have create a script.bat file and I want to run in web client. It is running in RTC but in Web client i am getting following error "The operation cannot complete because it uses a feature that is not supported (.NET Framework Interoperability.)" I have written below code. Kindly help me Process :=…
-
How to HTTP post in Dot Net
I have a few lines of code using automations. I would like to change the code by using dot net functionality but I'm having difficulties figuring out which dotnet class(es) I need to use. The code is basically trying to do an http post and replying on the response. How would the code look like using dot net and which…
-
Why can the customers license not see the extended fields?
I have created an extensions that handles some information via the Sales Line. Simplified version is one table that holds the values/options that are available table 68015 "Order Service Contract Code" field(1; "Order No."; Code[20]) field(2; "Service Code"; Code[10]) field(3; "Contract Code"; Code[10]) And an extension to…
-
Control-AddIn Trigger not firing
Hi experts, Problem: I developed a ControlAddin for BC (140, WebClient, AL) which calls various Triggers of the usercontrol from Javascript viaMicrosoft.Dynamics.NAV.InvokeExtensibilityMethod('d3cControlReady', []); On my local dev machine and our demo servers this works like a charm, everything gets called as it should…
-
how to record in Change Log Entry if using Transferfield ?
Hi all. i am using Cloud BC i have developed on sync button from company A to company B both companies i have turned on the Change Log Activities. but in company B it wont recorded in Change Log Entries. Scenario : i created new item in company A so i want to push this new item from Company A to Company B in company A it…
-
Webservice "listener-service" to run in BC / Consume Webhook Request in BC
Hi all, I'm currently trying to consume a WebHook Request in Business Central. I want to communicate between my bc365 app and a registration/authorization service from the internet. When the registration was successfull, this service is posting a webhook request to a specified "callback url" with some information about the…
-
NAV 2016 - better deadlocking monitoring
Hi, our customer wants better deadlock monitoring in NAV 2016. Does anybody offer solution, even paid one? I found only this https://www.erpsoftwareblog.com/2017/01/jeanmartinnavsolution/ but I got no response from them. Yes, I know, NAV 2017 and later offer better locking monitor btu customer does not want to upgrade.…
-
How to fix two invoices with one invoice number
Hello All, My NAV has created two invoices to two different customers, however these invoices has the same invoice number! One is already posted but the other one failed because the number has already been posted. How do I sort this out?
-
External Document No. on Sales Order Header (Nav 2018)
Hi, I would like to know how to write a simple piece of code where under sales order header there is an field called External Document No.; If for a customer A, I have already entered the external doc no. as Testing and post the order, that's fine since it is the first time entry with such a external document number. What…
-
Job Queue Category Locked error when running JobQueuePosting
Hi, Do any one of you face any errors with Scheduled Tasks/Job Queues/JobQueueSalesPosting? This is on NAV2017 CU29. The error is --> The operation could not complete because a record in the Job Queue Category table was locked by another user. Please retry the activity. This error is traced to Codeunit 448. LOCAL…
-
NAV Development Environment
Good morning, I have just installed the NAV 2016 demo on a local machine. I want to access the Development Environment but I get the alert "You do not have permission to run 'Design, Codeunit, Basic' System. Contact your Administrator to have your permissions changed". How do I go about to have this issue fixed?
-
Colour Coding Issue - Nav 2016
I have done colour coding on a Nav 2016 page, but when exporting the data on excel, the coloured data isn't exporting, Any way out?? Thanks in Advance
-
Who posted a document
Hi all How do i find who posted the document(sales order or transfer order etc) in NAV 2018, is there any tables keeps track of the same? Thanks satish
-
Negate the value towards Item Ledger Entry
I am trying to negate the value to negative based on a condition, and no matter what method I apply to negate it, I get positive value. Here is the code; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Item Jnl.-Post Line", 'OnAfterInitItemLedgEntry', '', true, true)] procedure MyProcedure2(ItemJournalLine: Record "Item…
-
Sales Order Header
Hi, Under NAV 2018 the sales order header has a field called Requested Delivery Date. When run the table in design mode the type is as Date. I am trying to bring this field into posted sales invoice header but failed to do so. I did created a new field under 50,000 series and named it as Requested Delivery Date and…
-
Is this a bug?? Insert data in another company - the change log settings from the source company ???
We have a company that gets a refresh of all customers, suppliers, items and a few other base files. Therefor we do not need to track any changes in the change log in the destination company, and they *are* switched off in the change log settings. Nevertheless we get a full set of log-entries, and I get the feeling this is…
-
Unable to select Items from Itemtable, it gives error
I have records in item table, also I can run Reports but I can see error ' The Item table is empty'. Please advice Warm regards Cris
-
when I upload a file, it should automatically get saved it in specific folder using web client
Following code works but the file automatically save in downloads folder instead of the folder i have mentioned. Please Help!! Filename:= FileManagement.BLOBImportWithFilter(tempblob,Text002,'','All Files (*.*)|*.*','*.*'); tempblob.Blob.CREATEINSTREAM(FileStream);…
-
The remote server returned an error: (401) Unauthorized
Hi all, I am trying to open ODATA web service of customer card in Excel.I tried In Excel Get External Data->Data Connection Wizard Opens->Now we can add O data ,username,Password : Web services access key(i want this as password) then when i click next it gives me following error. does any one know how to do login using…
-
TLS1.0 E-Mail warnings
Hi all, We have a customer that reports us that they are getting a warning that the mail coming from the NAV server is using TLS 1.0. I'm unsure whether we should upgrade the NAV server or the SMTP server if that makes sense. And if it is the NAV server, what steps should we give: should it be a NAV build upgrade, and/or…
-
Creating a Word Layout Report in Microsoft Dynamics 365 Business Central MSDYN365BC
Creating Word Layout in Business Central Consist of 3 Steps 1) Creating AL File 2) XML Mapping in Word 3) Creating Layout in Word https://divyeshchittenavbc.wordpress.com/2020/01/01/creating-a-word-layout-report-in-business-central-msdyn365bc/
-
Error While run Nav Database Object after Restore
Hello Everyone i am trying to restore database an run nav.but it givs me following errorMicrosoft Dynamics NAVCannot connect to the server because of a protocol mismatch. This can be caused by the client and server having incompatible credential settings (ClientServicesCredentialType). Contact your system administrator.OK…
-
Convert JsonToken or JsonValue to Variant
Hi, I'm having a problem with assigning value from JsonToken or JsonValue to Variant variable. I didn't find in documentation how can I check if value from token is certain type, and to assing that value to Variant if JToken.IsInteger() then variant := JToken.AsValue().AsInteger(); Thanks
-
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.";…