-
Problem with Visual Studio while viewing report layout
Hi everyone, I am beginning to work with reports in NAV 2009. Configuration: NAV 2009 R2, SQL Server 2005, Microsoft Visual Studio 2005. When I try to view a report layout, I get the following error message:The application for project 'C:\Documents and Settings\bbb\Local Settings\Temp\Microsoft Dynamics…
-
Dynamics 2013 Continia issue
Hi, has anyone else running Continia encounterred a problem where NAV will not run logging in as Windows user but works when logging in with username and password? This is the error, it points to the CanLoadType call in CreateVars function in Continia codeunit 6085599 - kust falls over when calling the CanLoadType IF NOT…
-
Payment Services options in NAV 2018
I note that there is a payment services option in NAV 22018 for PayPal. Has anyone created a payment service option which would integrate NAV to payment processor (such as Converge, https://www.myvirtualmerchant.com/VirtualMerchant ? We have a need for a solution where we are using ChargeLogic for bringing orders into NAV…
-
The odata.context url is invalid when trying to connect to Excel from Business Central using ODATA
The message is received when trying to connect excel to an ODATA feed. The characteristics of this issue are bizarre because all of the standard Cronus web services can be picked up with no problem. However, when creating a new Page or Query and trying to connect to Excel via ODATA, the error message complaining about the…
-
DateTime calculations
Hi, Is there any standard function that calculates the DateTime like CalcDate? I couldn't find anything useful, to be honest. For example: 18.10.2022 00:30:00 - 1 hour = 17.10.2022 23:30:00
-
Can not reach BC client application based on a docker/container
Hi I have installed BC19 as a container. See below. It is working fine for to there days than the application will not start. When I use docker logs than I get this below error Do someone know why the service is not starting? or what I can do? Best Regards Javaid Sethi
-
how to change the status of output to close for a finished production order
Hi manufacturing experts, I'm learning NAV manufacturing module and noticed the status of the output still shows Open after the production order was finished. I checked a few finished production orders in demo NAV 2018, which also show open status for outputs. I'm wondering how to change the status to close so the costs…
-
How to create New Payment Services in SaaS BC ?
Hi All, how do we create new payment service in SaaS BC other than PayPal? Similar like this app source Stripe Thanks before
-
Business Central G/L Budget Export
I have a financial year with differing period lengths, having created the budget I need to export in period order but cannot see away of exporting in Accounting Period Age Buckets ?. Thanks
-
Pick Register Error
Hi All, I am trying to create transfer order between white to silver. while doing the register pick, I have got error and attached below. so please advice me to resolve this issue. thanks, Rajan
-
Over-Supply - How do people handle these?
Hi, Was wondering how your businesses/clients handle oversupply for items which you did not order? The vendor may or may not invoice you for the items - it could be a Purchase Order typo on their system, or a genuine picking error. For example, if you've ordered 100 widgets from a Vendor, but they have sent 200 units. * Do…
-
Calling Kaizala(REST API) using RestSharp DLL
Hi, For demo purpose I am trying to call Kaizala Rest APIs (https://docs.microsoft.com/en-us/Kaizala/). I want to use RestSharp(http://restsharp.org/) DLL for this purpose. I tried with following code: Variables Client DotNet RestSharp.RestClient.'RestSharp, Version=106.0.1.0, Culture=neutral,…
-
CRM Integration, proxy tables, fields ids on the 10,000 range
Hi, In the context of an integration BC/CRM (BC20), we have used the altpgen tool to generate proxy tables and do the developments based on this. For example we have got the definition of the CRM account extension. We have been able to work and test deploying using Visual Studio Code. However, when we have tried to deploy…
-
The runtime version '3.0' is not supported by the AL compiler
I've installed last CU04 Business Central Version. After I've installed Visual studio Code and AL extension from VSIX file included in package. When I create my first AL project an error was in problem list: "The runtime version '3.0' is not supported by the AL compiler" Whats the problem?
-
QR Code Generation and Save to Blob Field
Business Central On Prem - Latest Could some one help to create a QR code and save it to a blob or image field? Later to display it on a page as an image? In reports, they say it is easy use a 2D font. but, here want to create and save internally.
-
Delete a file on ftp server with use of .net
Hi Can someone tell me how to delete a file on ftp server using .net. FTPUpload (Working fine) FileRec.SETRANGE(Path,FTPSetup."Path to Files"); FileRec.SETRANGE("Is a file",TRUE); IF FileRec.FINDSET THEN REPEAT FTPWebRequest := FTPWebRequest.Create(FTPSetup."FTP Server" + FTPSetup."Path on FTP Server" +…
-
Report with Images
I have a report that has a maximum of 3 pages. The report must display either 2 images or only 1 image on page 2. I added a rectangle and assigned the two images there. Only one image should be displayed on page 3. But now the images should only be displayed if there is an entry in the corresponding image path. And…
-
Restrict back dating and future date when selecting calendar date
I have a date field which the user will select from the calendar dropdown, now I want only the current date to be selected, future date and backdating should not be allowed. I am using NAV 2018.
-
Permission to execute XML port
I'm trying to use XML port in code unit for web services. But, once I call code unit, web service returns below error even I can execute the XML port manually. I followed tutorial https://www.kauffmann.nl/2011/01/15/how-to-use-xmlports-in-web-services-1/. Why I'm getting the error and how can I fix the issue? Thank you.…
-
Prevent user triggered changes via Table Subscriber
Hi, I am trying to prevent user triggered changes to a Vendor table. Changes done indirectly is allowed e.g. Changes done via C/AL MODIFY, INSERT or DELETE statements are allowed. I am looking at the triggers for the Vendor table, but I cannot find any suitable events. The most suitable I can find is to use the…
-
Item and unit of measure Tracking In Navision
Hi All, I am new to Nav, I am trying to track the item changes using events but while tracking it makes multiple records/rows against single item creation process. I have attached the screenshots. if anyone know, help me. Thanks. Rajan.
-
Half year rule for fixed asset additions
Hello, I have several fixed asset cards where I need to record additions monthly. I need the additions to follow the half year convention/rule, while the original book value of the asset depreciates normally. Does anyone know how I can make this work? The half year rule works during the first year of the fixed asset card,…
-
Add column to temp dataitem using report extension
Need to add Location Code to Sales Shipment report but the Sales Shipment Line is temp dataitem, is there a way to add the column using report extension?
-
Page list too slow
I've converted to BC19 an old nav2015 DB. In this there is a page list that shows linked table with 20 million record. In RTC page load after 1 minute. In BC19 the page never loads. The loading icon remains and after 15 minutes show timeout message Why this difference? There is a way to solve?
-
VAT Statement - credit memo
I want to have the value but only considering the entries of credit memos of a certain VAT, business group, etc.
-
Error message currency : The request was aborted: Could not create SSL/TLS secure channel.
Hello Error : Microsoft Dynamics NAV A call to System.Xml.XmlDocument.Load failed with this message: The request was aborted: Could not create SSL/TLS secure channel.OK No problem to access with Explorer to https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml but error when I try to update with NAS or Update…
-
D365 Business Central v 20.5, company hub
page Company Hub, how the requests to approve column is updated? users have requests to approve but the column is not updated, displays 0 instead of the number of request to be approved by the user. Additionally, can you please let me know what is the filters that the company hub uses for the field Vendors - Payment on…
-
Unusual behavior calling external web service NAV2013
Hi all, I've written some functions to call a provider's web service from NAV2013 and process the response. Thanks to great examples found here on Mibuso, it all works... for the most part. Here is where it gets weird. The first time I run either of the two functions I created after a NAV service restart, it always fails.…
-
Trying to set up a codeunit to consume External REST API
Hi! I'm trying to learn a bit about APIs but not getting very far. Can anyone help me? I had a browse for some APIs I could mess around with and decided to use this one as it seemed to have a lot of documentation. Free Public football API. I'm struggling to get my code to work with it however. Currently I am only trying to…
-
MSXML.XMLHTTPRequest Replacement
Hi, to challenge an update from NAV to BC I have to refactor the code, because some of the libaries doesn't exist anymore: MSXML.DOMDocumentClass.'Microsoft.MSXML, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' MSXML.XMLHTTPRequest.'Microsoft.MSXML, Version=8.0.0.0, Culture=neutral,…