-
[Version 2018] Issue while extracting data to excel from Report
Dear buddies, [Version: NAV 2018] I am trying to export data from Trial Balance report to excel. While running I am getting below error: Cannot create an instance of the following .NET framework object: assembly Microsoft.Office.Interop.Excel, version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429, type…
-
$ is not defined
After running web-client. I made data upgrade from BC14 to BC15 cu03 on-prem. Errors caused by not correct work role centers. They have chart pages which cause error. Should I do some settings with Addins?
-
Dynamics Nav Report Builder Drillthrough Report
Hi Everybody, I wanna ask a question. I am a Nav developer and Consultant. I would like to create a report. But I wanna use Drillthrough specify in reports. I used to able this specify on SSRS but Nav Report builder on I can't find. I went to "Place Holder" --> "Action" --> "Go To Report" here doesn't exist other my…
-
checking value of field in navision?
Hi all, I have field on sale order as no. which access no. series using assitedit local local00001 to local99999 export export00001 to export99999 When No. field having value start with export**** then show message export no, series please note as it is no. series intial letter same but each No. is different how to achive…
-
Error during Json parsing using Newtonsoft .net dll
Hi, I am using the Newtonsoft dll to parse the json response I am receiving from an external API. During the parsing the first two arrays packdonedetails and orderdetails are parsed successfully. But when parsing the packingBoxDetails array I am getting the error that Microsoft Dynamics NAV Break On Error Message: A DotNet…
-
how to compare value1of page1 with value2 with page2
Hi all , I have one field in page One which have value as 200 on page two user enter value should same as page one ie;200 if not give error how to achive it i don't know what is code should use and on which page or trigger? Thanks in advance
-
SQL Error when copying a company - Execution Timeout Expired
Hi, Everyone. I would like to seek help on the issue I'm experiencing when trying to make a copy of our Live company. I keep on getting the error below. The following SQL error was unexpected: Execution Timout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. I've…
-
Check report formatting
Hello there. As you know if the check is printing more than 10 lines of payments (lets say 15) , the first page will be a voided check with 10 lines and the next page with be the check with the remaining 5 lines. Client would like a new report to print to replace the first page that is printing in check stock paper to save…
-
System Notes: Crashing Client for a small handful of users
Experiencing an issue with NAV closing without error on a page with the system notes factbox. Having investigated the event viewer I identified the below errors. It mentioned RichTextBox in the error, so I thought this might be down to the notes box rendering. I removed the factbox from that user profile and low and behold…
-
Change custom report layout by C/SIDE
If I have a report with two defined custom reports, how can I choose one of this layouts before printing the report? I wnat to to that by C/SIDE. Is it possible? Thanks for all answers.
-
How top open a folder dialog in web client?
Hello guys, I'm moving old functionality to BC15 and I've run into a problem. The user is required to choose a folder path, yet it doesn't seem possible in the latest release of BC. I used the BrowseForFolderDialog procedure from File Management codeunit but it throws me a dotnet operability error. I set the Target in…
-
Why is OnAfterInsertEvent subscription triggered (twice) when opening a sales order?
Hi All I have a code unit that has this line in it: [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnAfterInsertEvent', '', true, true)] It fires twice for every line when I open a sales order and the lines are displayed Puzzled Mark
-
How to assert record count is zero for testPart
Hi All Using BC 13 on-prem. I'm an end user writing test (so no dev license or test libs or access to Application Test Toolkit) I need to write a test using a test part that checks that there no records matching a filter. Use case is, user changes ship method to FLOC, the extension inserts a freight line with item FLOC,…
-
The service account has insufficient privileges to register service principal names
Dear Friends I am setting up3 tier using cloud VM's, NAV app in one server, IIS on the second server & RDS on the 3rd. As mentioned in the documentation, Enabled the 'ServiceLogonAccount' to register SPN on itself. But event view i get the below message 'The service account has insufficient privileges to register service…
-
Data Exch import: get a substring of XML value
Hi Experts, I have an XML file with very long descriptions in one of the node. I would like to take only first 10 characters from the node. Is it possible to do somehow with XPath? I tried /CustData/Line/Item/substring(ItemDescription,1,10) as a "Path" in Column Definition, but this fails with error "expression must…
-
To Create another Instance of Business central on Same machine but with other Database.
Hi All, I have already created an Business Central Instance with Name BC150. Now i want to create another instance with different database and ports running on same machine and also wants to open its web client. What are the steps to do this.
-
Strange code on Sales Order List page
I think I am losing my mind. The code in these two triggers on the Sales Order List is causing a HUGE delay in one of my customers' system. I just can't figure out what this is supposed to do, especially the OnNextRecord trigger. It is doing next(1) and next(-1), seemingly going through all the records up and down, but I…
-
Purchase tracker report
Hi Experts, I have to create a vendor wise Purchase tracker report using rdlc layout. Could some one help me how to set dataitem link between the tables as follows. Expanded Data Type Data Source Name Include Caption 1 DataItem Purch. Rcpt. Header <Purch. Rcpt. Header> No 0 Column "Purch. Rcpt. Header"."Buy-from Vendor…
-
Convert string value with decimal separator to decimal value
I need help. I need to convert string with decimal separator like this "1,500.45" to decimal value of this "1500.45" The thing is, i don't want to harcode DELCHR "," onto EVALUATE because the decimal separator might be different in some database. Is there a way to for the NAV to recognize the decimal separator ? I'm using…
-
BC365 (cloud) Print not working anymore for Edge, Chrome. Ok Firefox
Hi, with latest build 15.3.40074.40822 (from March), I cannot print a report directly. When I clint PRINT on the request page, nothing happens. If I do the same in sandbox 15.2 then it works. Additionally: If I use Chrome 80.0.3987.122 it works, with 80.0.3987.132 it doesn't ->so we have 2 technical features conflicting.…
-
TestPages - Create Customer with OpenNew
Hi All I'm writing and AL extension (on-prem). I'm trying to create a customer (for now I want it committed, so I set test isolation to "Disabled") I'm calling the following from an action button. My No series is set for Default and Manual nos is disabled codeunit 50006 ClesenTestRunnerCodeUnit
{ Subtype = TestRunner;…
-
'Assert' is an ambiguous reference
Hi All I'm writing tests for an on-prem AL extension. I'm getting this message when creating a variablevar Assert: Codeunit Assert; "'Assert' is an ambiguous reference between 'Assert' defined in 'Application, Microsoft, 13.9.33838.0' and 'Assert' defined in 'Test, Microsoft, 13.9.33838.0'." How can I specify which version…
-
Anyone know where to find the test tool.chm
This page refers to it, but it's not on my install media (v13) https://cloudblogs.microsoft.com/dynamics365/no-audience/2012/11/07/application-test-toolset-for-microsoft-dynamics-nav-2013/ Anyone know where I can find it? Thanks Mark
-
End user access to test tool and libraries
Hi All We are an end user and are writing our own AL extensions (365 BC 13 on-prem). I want to use the MS test tool and test libs. I can't find the test tool and if I try to access a codeunit from the test library, I get an error: You do not have the following permissions on CodeUnit Library - Sales: Execute I thought I…
-
NAV crushes while exporting to Excel
Hi All, We didn't have this issue before but suddenly we started to have it (maybe because of windows update ? ), we are not sure what the problem is. Version - Dynamics NAV 2017 Problem - Exporting to Excel by using Ctrl+E . If we try to export from any list page (customer list, item list , assembly bom list, etc), it…
-
How to Enter date Which not exceeds 1 month duration/
Hi Experts I got requirement from user that subcontracting order have page which is having two fields Posting Date and Document Date.User Add data in document Date and Posting Date flow from Subcon order page which fill by Purchase Order officer. now Document Date enter By other user .this date should not exceeds than 1…
-
How to production Journal Should Exactly Same As consume quantity?
Hi Experts In Sub contracting process when Quantity consume from Delivery Challan and receive Sob-contracting order.and in production journal enter output quantity. Now I need output quantity On production Journal Should Exactly Same enter by user As consume quantity at subcontracting how to Achive this ?what restriction…
-
Can I sort a listpage ascending on one field and then descending on a second field?
Can I sort a listpage ascending on one field and then descending on a second field? I know i can set the SourceTableView property on the page. I can select multiple fields there. But only set descending or ascending applied to all those sorting fields. Can I set the sorting descending on one field and ascending on another?…
-
No Test Tool BC130 on prem
Hi All Working on an extension on on prem install I've imported the following from Dynamics.365.BC.33838.NA.DVD\TestToolKit * CALTestRunner * CALTestCodeunits.US * CALTestLibraries.US When I search for "Test Tool" nothing shows up I can run my test code units and pages OK from my own test runner, but how do I get the MS…
-
adding new fields in Trans Sales entry
Hi, Experts, I have to add two fields (customerNo,customerName). That has to lookup the values from the Customer table 5050. Since we have no direct link to the customer table from Trans.Sales entry. Could someone suggest how we can fetch both the values from the customer table Thanks in Advance.