-
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.
-
error when i click new button in page Post Dated Checks-Purchases
Dynamics NAV 365, When i click new button in page "Post Dated Checks-Purchases" then error occurred .
-
Upload File without dialog box on Web Client
Hi, Is it possible to upload client file without showing dialog box to import file again? I'm using this to upload file to azure blob storage directly when user add file in record links. Thanks
-
Report preview has value but export doesn't
When I run a report on the preview the "project field" has value but if I export the report to word it loses that value. It has an RDLC reporting not a Word layout. What should I do to show this value on the word export as well? (Only one field has this problem another values are not affected)
-
NAV 2018 has no Sales Lead Time per item?!
To my knowledge, NAV 2018 can't create a Sales Lead Time per item. Only when you use the production module is it possible. If this is true, are there any workarounds or add-ons which could resolve this? When entering a new Sales Order, we now have to remember manually which (assembly) Item has which sales lead time. We…
-
Web Services REST API
Hi Experts, I'm newbie in web service. If I got 10 Items in Business Central and I want to use loop to calling httpClient.POST for 10 times. Is possible? I have successful to POST first call, but started 2nd calling is failed. Do you have any suggestion? Thanks.
-
Error While Running NAV R2 RTC
Hi Experts, i have installed Navision R2 IN and its RTC was working fine. Then i require to install Navision R2 GR (Greek version). Classic client is working fine. when i tried to start the role center of the same the error message i am getting is- The page 9006 is not valid and cannot be shown. Please contact your system…
-
Excel - data connections to BC On-Premises > SQL-Server or NAV-Query + OData or ...?
hi, we are busy with preparing to switch from NAV 2013 to BC On-Premises. In our own SQL server database, we set up some SQL server views of the NAV 2013 database today. In many Excel reports, we’ve got access to these views via the Excel data connections and use them for Excel dashboards, pivot tables, power queries and…