-
Can't find System.Data.SqlClient dotnet, do I have to install something?
I can't find the System.Data.SqlClient dotnet so I can send a SQL query to an external SQL server I have to install something? I'm looking for this groups of dotnets: System.Data.SqlClient.SqlCommand.'System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'
-
RMS to RMH
As Dynamics RMS is being discontinued by Microsoft RMH is replacing Has anyone done upgrade from RMS to RMH or replaced or can anyone advice on Integration with NAV with RMH ? Thank you
-
Business Central Cloud, import large files?
Anybody here knows how to import large amount of records to Business Central Cloud, from CSV file? First i tried by Rapid Start with full amount of Customers (207000 records), not working. Then I tried with 5000, not working. Anybody here who can help?
-
BC16 Onprem - Access REST API (secondary instance)
I have configured a second service on the server using NavUserPassword authentication. Created a self-signed cert, applied thumbprint. Created web server instance. Enabled API Services in config. Web Client login works fine. OData works fine http://server:7058/BCExt/ODataV4/Company(name)/svcName API, gives a 404 error when…
-
Previewing Report Data Sets (and reports in VS) in BC2020 (web only)
Hi All I'm spending a lot of time customizing reports and it's extremely unproductive without a) having the ability to view the data set's data (in RTC I could use Ctrl-Alt-F1) b) being able to preview inside VisualStudio, like I can with SSRS reports Anyone got a solution for either? Thanks mark
-
Intercompany invoices for different coutries there is calculated VAT
Hi, there is something wrong in intercompany postings... When posting a sales invoice in a company (LU) to another company (BE) with a line with an amount of 1000. When posting between different countries there is no VAT. When posting it is coming into the handled outbox transactions. So for so good. The purchase invoice…
-
NAV2015 C/AL - How do i pass parameters from a table to a user function
Hi all and a happy new year :-) I'm by no means new to NAV but i'm just beginning with application development and as such i am 'fighting' with C/AL. :-) I have an easy question which i cant seem to solve no matter what I do. I have a function 'Addnums' that has two parameters 'NrIn1' and 'NrIn2' and a result 'NrOut'. The…
-
SAF-T localisation for portugal
Hi all, I am working for a software house integrating our software with Dynamics NAV for a client in Portugal. We were asked to implement a certified SAF-T (Standard Audit File for Tax) solution for signing our invoices. We asked first our NAV partner in Portugal, if it can be done in NAV. But he stated that there is no…
-
Error "you cannot correct this posted sales invoice because item" when correcting posted invoice
Hello, when trying to correct a posted invoice by using the correct-button I get the above message. This happens, when combined shipments for the invoice exist. The error is thrown by CU 1303, due to the fact that threre are sales shipment lines, connected to the sales invoice lines by the Shipment No.-field in Table 113.…
-
Can we select multiple dimension values for the same dimension in single journal line.
Hi All, One of our client is asking for selection of multiple dimension values for the same dimension in single journal line. For example: In JV of Travel Advance for 2 employees say X and Y the finance person given amount of Rs.5000/-. So, he need to select both X and Y dimension Values for Employee dimension. please…
-
Importing orders from XML (exercise)
Hi all, I'm doing a practical exercise for my enterprise where i'm making my stages for my software programming studies and I have to import from an XML sales orders with their headers and lines. The XML only passes me the Customer No, the Order Date for the header and the sales line type, the item no and the quantity for…
-
dynamics nav windows client hyperlink not working in gmail?
Hi Dears, dynamics nav windows client hyperlink not working in gmail.but working in outlook.Why?
-
Allow Sales Credit Memos to blocked Customers
Hi, i'm a rookie searching for assistance. I have a codeunit where I set to All the field Block from Customer when its credit limit is up to 120%. Now i need to allow blocked customers to do sales credit memos. How can I implement this? Lots of thanks!
-
Running report from Task/Job Scheduler
I'm trying to run a report that execute some SQL queries in NAV 2015 If I run the report manually it's working perfectly, but when I set it into the Task Scheduler it give error as it has an automation that is trying to load in the client. I've changed the CREATE parameters to (FALSE, FALSE) instead of (FALSE, TRUE) so it…
-
ODATA API Select and Insert
Hi NEWBIE to API, I want to create a small API to list customer order header, customer order lines of that document and possible update. So, I created two entity pages one for header and other lines and published. Can access them via the browser. By passing the document number in URL…
-
Workflow Notification E-mails Not Sending
We are having an issue where the out of the box workflow notification is not sending the e-mails in BC. There is an error in the job queue - A call to MailKit.Net.Smtp.SmtpClient.Send failed with this message: No recipients have been specified. We can send a test e-mail successfully from the SMTP Mail Setup - to people…
-
How many CAL/AL developers do microsoft engage for NAV/BC?
Hi, This is something I have always wondered about, I'm also sure the number fluctuates. Approximately how many CAL/AL developers do microsoft engage for maintaining/developing NAV and BC? Regards & Thanks Roddy
-
Can any body explain Multi Threading batch process with examples
Need to implement multithreading batch process
-
Problem with updating BC V16.5 to V17
After Update from version BC16.5 to V17.0 Application Database Version is still V16. All steps from the documentation are done. After update the webclient starts, but from the development environment i cannot publish my extension because of the Application Database Version V16. Synchronisation is done. Navdataupgrade is…
-
BC OnPrem Upgrade question
I am trying to upgrade a BC15 database to BC16 According to microsofts instructions, https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-unmodified-application-v15-to-v16 Task 2 step 4 states Unpublish all system symbols. Does this mean to unplublish ALL published extensions symbols OR…
-
Decryption of API Data in BC365 [SAAS]
Hello Everyone, I am getting encrypted value with key from API and I need to decrypt the data using that key in bc365 SAAS. Encryption algo is SHA256. Thanks
-
Sending a report without attaching it
Hi everyone, I'm working in a customer with NAV2017. Is it possible to send by mail, a report (sales shipment for example) without attaching it? For example, sending an hyperplink in the mail body, and the receiver of the mail will click into that link, and download the PDF. Thank you all
-
BC17 - Changing Object Name - Translations
Hi! I have noticed that when I change the object name in my project in Visual Studio Code, by using F2, to also change references in whole project, I am loosing translations for this file. I have noticed that "base xlf file" is changing the "trans-unit id", but it remains the same in my translations file. Is there a way to…
-
Is it possible to enable the Arabic language in Business Central On Premise?
Hi All, One of my client is asking to enable the Arabic language in Business Central On Premise. Please can you help me do we have language module for Arabic to show the system in Arabic. Thank you Naidu
-
Publishing a Base App from powershell, issue with adding a new field to existing table
Hi, I'm in the process of upgrading our vertical to BC17, this is a modified base app rather than extensions. I can add a field to an existing table and publish via VSCode and all is well with the world. However, when I publish via powershell, I run into a problem. When running a page with the new field, I've added a test…
-
Missing DotNet System.Linq.Expression assembly
Hi , I am trying connect NAV to SharePoint and i need dotNet Variable System.Linq.Expressions.Expression. I have figured that DotNet Assembly Subtypes System.Linq.*** are not available under the Assembly list in NAV 365BC 130. Please, Can someone advice, What should I do to get those assemblies? Thanks a lot, Dominik
-
Create Docker Container that can access host's network resources
Hi, Is there a best practise for this? Our nav solution needs to access another system outside (not BC/NAV) the container. Regards Roddy
-
Filters page not loading on Workflow condition Assist Edit
Hey, Am working with Dynamics business central Version W1 13.1 13.0.27183.0 and can't open the filters page to specify conditions for a workflow. The assist edit button marked below yields nothing. Please help
-
Table WebHook Subscription not available on cloud
Hello, Me and my colleagues are creating an extension of a WebHook menu, where you can view all subscription, create, delete and update. Because we use BC16 on-Cloud, we are having some complications. We do not have access to the 'WebHook Subscription' table. Problem: The type or method 'Webhook Subscription' cannot be…
-
NAV 2013 Upgrade: Dimension Value ID Error
Hi together, I currently try to upgrade a database from NAV 2009 R2 to NAV 2013. Now I'm on step 2. While upgrading the "Document Dimension Archive" table I get the Error "Dimension Value ID must have a value in Dimension Set Entry: Dimension Set ID=0, Dimension Code=PROJECT. It cannto be zero or empty." But this table…