-
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…
-
Ignore messages while importing by using SetHideValidationDialog.
Hello I am using NAV 2009R2 and I have an xmlport to import sales invoices and i would like to ignore any messages while I import. I used SetHideValidationDialog(TRUE) right before validate lines for the sales header and for the sales line but I still get one message while I am importing. I traced the code and it has…
-
OIOUBL Remarks dose not come in XML file
Hello We are useing Busniess central on Premis, the xml file dose not incloud the remarks lines in the invoice how can include them? Thank you Best regards Firas
-
Error while accessing 365BC NAV RTC Client, help
Tóm tắt luận văn thạc sĩ về quản trị vốn luân chuyển Trong bài viết sau đây Luận Văn 24 xin chia sẻ đến bạn nội dung tóm tắt luận văn thạc sĩ về quản trị vốn luân chuyển. Nếu bạn không có thời gian để hoàn thiện bài luận văn của mình, bạn có thể tham khảo dịch vụ làm luận văn thuê của chúng tôi tại đây: viết thuê luân văn…
-
Rebuild Dimension Set Entry Table
Hi, does anyone have a report to hand that can rebuild the records in the dimension set entry table based on the dimension set entry tree node table. The tree node table is correct but the set entry table has been corrupted. Regards
-
Viewing archived purchase orders
We have recently started to archive Purchase orders once they have been invoiced. Unfortunately now when we want to look at a previous order for reference the archived list shows all the versions of the purchase order. Is there a way that we can look at old purchase orders and only see the latest version, similar to how we…
-
How to populate BLOB field in report
Hi all Work description field was defined as BLOB type in purchase header table, how to populate the same in report. Thanks saitsh
-
DotNet cannot use in BC14 anymore?
In BC 14.10 (CU 09 Dynamics 365 Business Central Spring 19 Update W1) I'm trying to use DotNet to access an external DB At the first step to use DotNet, we neet to add { "target": "OnPrem" } setting into the app.json, but I receive the error like below. (Same setting at extension 4.0 (BC15) is ok) Is that mean, in…
-
Thai Characters appear as SQUARES in SSRS reports
Hi, I am using NAV2017, running on SQL SERVER 2016 SP2, on Windows 10 Pro. When I create a new report, using the font Segoe UI, Thai characters in the report appear as squares. However, existing NAV standard report that uses Segoe UI font did not have this problem. However, existing NAV reports that uses the Segoe UI font,…