-
Debugger (Extension) Suddenly Stopped.
Hi all, When I'm doing the debug in extension, debugger suddenly stop and showing the error: That is standard Business Central coding, I don't know why this error will appear. May I know that how to solve this issue? Thanks.
-
BC - Dynamics CRM Integration
Not sure how many people have used the BC<->Dynamics CRM integration, but once enabled the CDS and Dynamics connection loads BC "CRM ....." tables series 53xx The question is, are these virtual type tables or references to the CDS Entitiy? I wrote an event OnAfterModifyEvent and OnAfterInsertEvent from the CRM Incident…
-
Print Settings section in report request page BC16.3
hi All Hope you can help me. BC 16.3 Saas. Report 116, and 1316 both have a Print Settings Section at the top as shown in the screenshot below. Viewing the code of the request page in VScode this section does not exist! it starts at "Options" The reason I am looking for this section is to see how it's populated and why it…
-
Business Central Device User Limitations
Hi, is there official documentation that clarifies wether the Device User has module limitations like the Team Member? Would it be necessary to add Custom Objects to the "application module" like it is the case with the Team Member? (Licensing Guide says for Team Member: "Team Members application module* may be customized…
-
Publishing code modified base app runs into error "Object reference not set to an instance of an obj
We are developing a rather large (~18.000 AL objects with many dotNet Addins) code modified base app. The compilation from Visual Studio code with Ctrl+Shift+B runs successfully. We have created a local Database including NAV-Server with only the system tables. We are able to compile and publish a code modified base app…
-
Preferred connection cache hit rate very low
Hi The preferred connection cache hit rate on our NAV 2015 application server is very low. The data cache size on the service is 12, so 4GB cache for around 45 ursers. Our application server and sql server are both VM's hosted on a onprem VxRail. Any idea how we can improve this rate?
-
Document approval release before reaching the approver
hi i have problem with document approval in nav 2009, the system is releasing the document before reaching the approver
-
Adding global variables on a request form of a report
I have a report which uses 15 global variables, already initialized on the OnPreReport trigger. I need users to be able to change their pre-determined values on launching the report. I would thus like to add thoses 15 global variables on the request form. Sure, I can manually add 15 checkboxes/textboxes + 15 labels then…
-
Open Excel File Saved by reporting services, on BC14
Good Morning I can't open Excel files saved in xlsx format from Reporting services, it gives the attached error ExcelBuffer.OpenBook fails If I open the file manually with Excel and save it in xlsx format then the OpenBook does not give an error Anyone know if something can be done? Thanks in Advance
-
NAV2018 System Tables modification
hello I am running a NAV2018 database with side-by-side development. I added a boolean field in the Company table through c/side (since these cannot be extended through Extensions). However when I am referencing to it through an extension, it is not visible. I've already generated symbols and tried with different tables,…
-
Unable to Run Batch sales Posting (Report 297) using Job Queue
I want to batch post sales invoices for which I am using Report 297. which is working fine if run the report manually. However, when I schedule the report 297 to run through Job queue, it shows successful in the Job queue logs but doesn't post the unposted invoice. NAS scheduler is working for other reports and codeunits…
-
Data Exchange Transformation Rule
Hello All, Setting up a Data Exchange Definition two transformation rules do not seem to work. Initially I want to remove - from the Bank Account Sort Code for example 20-55-77 should be set to 205577. Please can someone review the setup and give any suggestions to correct it. When I do a Test on the transformation rule it…
-
How to add new Custom Module in Business Central.
Dear All, Can some one please explain me how add custom module in Business Central.
-
cant open my database error showing is "this file is not a database".. dynamics nav 2009 r2.
Hello, Recently i lost my database and later was able to recover it and restore it back to its original file location. Since then i have been trying to open the database file but i get this error message "this file is not a database". The file recovered is a .fdb file. I have also tried creating a new database but i still…
-
NAV BC Planning Worksheet Page (99000852) - Column Sorting
Hi Everyone, Is there a properties field where I can allow column sorting for the user so when they click on the column it will sort? It was by default in NAV 2013 and now it seems users can't sort on this and other pages. Thank you
-
[NAV 2017] ODATA Web Service - POST Json Body with root
Hello community, I have a problem with above topic. I published a simple page as ODATA Web Service. If I test the web service with postman it works with a simple JSON body as POST statement: { "Field1":"Value1", "Field2":"Value2" } But if I change the JSON body to the following, it don't work: { "JSONBodyRoot" [ {…
-
Business Central 14 upgrade to 16.2, error during upgrade.
Hey I'm trying to upgrade a BC 14 to BC 16.2 and got stuck at the process, where i need to sync the base application. I am following the steps in "https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-unmodified-application-v14-v16". When I run this command below: Sync-NAVApp…
-
Microsoft Dynamics 365 Business Central On-premises on Windows 10 Home
Hi, Is Microsoft Dynamics 365 Business Central On-premises (demo installation) compitable with Windows 10 Home ? Kindly inform. Rgds, navuser1
-
Txt2Al Conversion Tool --tableDataOnly parameter
In this page txt2al there are instructions for using the txt2al tool with the tabledataonly parameter. Unfortunately, this parameter is not available in any version of BC14 and in subsequent versions the tool is not available. Where am I wrong?
-
Dynamics 365 for Smart Cities
Hi, Greetings of the day. Visiting Mibuso after longgg time. Recently I have seen videos of Microsoft Dynamics 365 for Field Service. Is that an add-on on top of Microsoft Dynamics 365 (Higher version of Ax)? Does this product have other modules of ERP, like Financial Management, Sales, Purchase, Project Management,…
-
BC 365 SOAP web service timeout
Hello, Can anybody tell me how can i limit soap web service timeout BC 365? All i can see is OData or Rest service timeout. i have published SOAP web service which is successfully consumed externaly, but sometimes the web service that calls my web service doesn't receive any response after 60sec and it generates failure…
-
How to apply SSL in Four-Tier Architecture
Hi All, I installes the BC14 as described in the below blog: https://docs.microsoft.com/en-us/dynamics-nav/walkthrough--installing-the-microsoft-dynamics-nav-web-server-components-on-three-computers Server1 - SQL Server2 - NST Server3 - IIS, Web Server Client - Browser Client All are working well with windows…
-
BC on-premise - ISV solution - new version notification
We are an ISV with a solution for NAV/BC. With the more rapid release schedule of BC, we find ourselves providing more frequent releases of our solution. Up to this point, new releases involved manually contacting customers via email, but we'd like to streamline this process and provide information about new releases of…
-
Copy posted invoice to Sales Invoice Diffrent Debitor with dynamics BC on Prem
Hello I wander how to code (subscribe to over write) the Copy posted invoice to a Sales Invoice from different debtor without recalculating the linces, the description field should not be overwritten by the default value. incloude header = false Thank you Rgs. Firas
-
Experiences with Workarounds for Mixed Keys
Hello everybody, in AL there is the problem that you can only create keys in TableExtensions with fields from the TableExtension itself. It is therefore not possible to use fields from the original table in a new key of the TableExtension, e.g. in a new key of a TableExtension that extends the Table Item, you cannot use…
-
Prepayments:I deleted 2 pre-payment invoices and now cannot change anything in the original order
I am trying to understand the functionality. I am stuck with this. I am on the demo version of NAV 2013 R2 * Create new order, 100% prepayment on header * Enter one item line (bicycle), qty=1, create a prepayment invoice for 4000. * Re-open the sales order * Update qty to 2, create a second prepayment invoice (another 4K)…
-
REPORTFORMAT::Html crashes Windows Client
I just installed a new BC 13.18 and have run into a weird problem. When I try to email the statement on a customer the client crashes with only an ArgumentOutofRange error in the event viewer. I have debugged it down into cu 8800 where we try to create a HTML file using REPORT.SAVEAS that crashes the system. I have made a…
-
OnPremise region selection, show wrong decimal separator (comma instead of point)
Hi, I've a BC16.1 onPrem installation. Where can I change the regional settings to have a DOT instead of a COMMA in my decimal separator? It looks like this is managed on the serverside (NST or IIS) - unfortunately, Microsoft decided to have a , for the swiss-French region- I changed it on the server but maybe only for my…
-
NAV 2017 - Prevent NAV from converting a backslash to a CRLF
Hi everybody, Is somwbody knows how to prevent NAV from converting a backslash to a CRLF ? I created a we service that return a JSON as a text and I apply a Json.Encode(myJsonText) to escape all the special characters. The problem is that the Json escape the special characters by adding a backslash and in place of return…
-
How to import all type of files in a page in business central
Hi i'm new to nav , how we want to import files in page by clicking action or assist button of a field in business central Thanks in advance.