-
Generic List and x-www-form-urlencoded REST API
Hi, I what I need to do is call REST API using x-www-form-urlencoded body to get a token that I can use calling other services, I'm using Http Client but what I can't figure out is how to create a list of the type <string><string> in NAV. Edit, I'm trying to use Dictionary to achieve this…
-
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
-
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…
-
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?
-
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
-
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…
-
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…
-
Safety measures in deployment window (BC/AL)
Hi Guys, Happy New Year! :) Since the introduction of AL apps it has become even more critical to prevent data changes in the system during app deployment windows. Changes sources could be users, web services, job queues. During app installation some of the existing ones are getting uninstalled and during that time their…
-
hi, Can one help how to make repeat control under another repeat control - word layout
Hi, I am unable to make repeat control under another repeat control in word layout. Example I have job task and for each job task there are repeating Job planning lines. I am unable to do the same. it is only job task are repeated and job planning lines repeated at the last Warm Regards Kris
-
DataItemTableview - filter on multiple doc types
Hi All I want to have a report that runs identically from sales orders and blanket sales orders. Is it possible to change the where clause below to Order or Blanket Order: DataItemTableView = SORTING("Document Type", "No.") WHERE("Document Type" = CONST("Blanket Order"));
-
Hostname Webclient
how can I determine the hostname for the webclient