-
BC crashes when I open Table Information page.
BC crashes when I open the "Table Information" page. BC20 cust database. I tried to uninstall all extensions, but it didn`t help.
-
Requesting Date (2000000007) takes a very long time
Hello, has anyone any clue, why requesting the virtual table Date (2000000007) can take very long? I wrote a simple codeunit for test: DateRec.SETRANGE("Period Type", DateRec."Period Type"::Date);
StartDatetime := CURRENTDATETIME;
DateRec.FINDLAST;
EndDatetime := CURRENTDATETIME;
MESSAGE(STRSUBSTNO('%1 - Duration: %2 ms',…
-
MRP setup
Hi All, I have a client using Business Central and we are trying to set up their planning parameters for MRP. This is the scenario: One of their items, which is a component on a production BoM has a 52W lead time. They want to create a PO each month for their average consumption to receive each month as the next month…
-
Schedule task to export text file
I've BC19 and I need to schedule task to create and download text file using codeunit. This task takes several hours and for this reason I would like to use the job queue. Is there a way to make available for download file created on the web client? How can do it?
-
HttpWebRequestMgt.GetResponse not getting response
Hi! I'm trying to connect to a REST Api. I'm using XMLport to send and receive the JSON and looks like it works fine until the…
-
NAV Application Server checking always for Bad Query objects?
I've now twice imported nav object ( 8-9 months apart) to our new live that had mistake in it. Wierdly enough the Chart of Accounts page always does not open if I have a broken query in object database... It immediately throughs an error (same as referred by the query). The broken query has no references to itself in the…
-
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?