-
Programmatically activating custom views
I've defined a couple of views in my PageExtension like the example below. Is there a way to activate a view from (for example) an OnDrillDown trigger that uses Page.Run(...) to open the page with the custom views? views { addlast { view(Invoicing) { Caption = 'Invoicing'; Visible = true; SharedLayout = false; OrderBy =…
-
Get oAuth2 token based on Authorization Code
Hi, I'm using a NAV routine to get Authorization code (oAuth2 protocol). How can I convert this authorisation code into Token used further for API requests ? The authorisation code is available in next context: 1. in browser there is a callback like this:…
-
How is Suggest Reminder Lines batch works
Dear all, I am trying to run the suggest reminder lines batch job from reminder page. I want to know what formula system uses to populate the lines in reminder lines. Ex: Inv0001 Due date = 22/10/22 Inv0002 Due date = 28/10/22 Now I have set 3 levels of reminders 1st level +5D 1Addnl Fee =$10 2nd level +7D Addnl Fee = $15…
-
LookupPageID,DrillDownPageID
What is the diff b/w LookuppageID and DrillDownPageID Properties in table. Can anyone give some example as well Example : We removed drilldown property for customer table but we did not found any difference so please give me an example why we use that property in table Thanks in Advance.
-
Business Central: Problem with creation of Docker BcContainer
Hi, (sorry if wrong forum, correct option about BC was not present) I want to create a BcContainer (Docker container). I have installed Docker Engine and the latest BcContainerHelper. I am now trying to execute: $ArtifactURL = Get-BCArtifactUrl -type Sandbox -country dk $containername = "(name)" New-BcContainer…
-
Date filter for a Page
Hello, I have the following problem. We have an additional table, which has the item number and the language code as a key. This is where the data for creating a data sheet is stored. This table has about 50 fields. Now I would like to filter the item list and then only display these corresponding items in another page,…
-
BC on prem subscriptions indirect provider in UK
Can someone please help me with a UK indirect Provider / Distributor for BC On-prem Subscriptions. Seems most focus on CSP and NCE and are oblivious about distributing On-prem subscriptions.
-
Mail setup In docker environment
Hallo, Als ik een mail setup wil doen met office. las ik dat ik in azure -> app-registraties mijn app moet registeren. Nu telkens ik een test email wil versturen in bc central zegt hij dat de omleidings url niet correct is. Kan iemand me zeggen wat ik bij omleidings-uri's moet invullen? bv https://test/BC/?company=CRONUS…
-
Getting error "Login failed connecting to SQL server xxx"
Client is running 2012 SQL server based Navision 2009 R2 older version. Primary activity is in Payroll. The server is having problems so temporarily we are moving the sql database to a standalone workstation and continue to work from there until server issues resolved, then create backup from local wkst and restore back to…
-
business central
hi, in buisness central on prem v22, the drop-down menus are cached behind the main menu, and consecuently cannot see them completely. see attached example. is it a bug or has any solution?
-
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…
-
what are prerequisites of autosplit key to use in my code ?
I need an answer what is the purpose of autosplit key to use
-
Automate C/AL code to AL conversion
Join the demonstration of how simple C/AL code to AL conversion can be with automated Simplanova AL Tools (SALT), and hear from Xitec (NL) how they apply SALT in their add-on upgrade from C/AL to AL. During the webinar, you will also learn that SALT will be available for download on Visual Studio Code Marketplace. Register…
-
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…
-
Can we reuse the custom object numbers?
Can we reuse the custom object numbers? like 50100 to 99999 If we are already used it by objects. then possible? If possible please explain
-
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…
-
Post resource cost to general ledger in Job Journal
Hi, I'm using NAV 5.0 SP1. When posting resource usage to a job in Job Journal, I would like to create general ledger entries. The WIP-method is contract completed. Resource costs should be posted debet on a WIP-G/L-account (3110) and credit on a G/L-account called "covering Salary" (4080). This means the journal ledger…
-
Create Sales Orders from Blanket Orders
I created a Blanket orders with different shipments date like this Sales line :10000 Item : 1000 Shipment date : 29/04/22 ; Sales line :20000 Item :1000 shipment date :12/01/22 to customer 10000. Sales line: 10000 Item: 1000 Shipment Date: 29/04/22; Sales Line: 20000 Item: 1000 Shipment Date : 10/01/22 to customer 20000.…
-
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
-
Nav 2014 diameter pie chart
Hello all, I have the following problem: I have programmed 3 different pie charts in C/AL in Dynamics Nav 2014. In the display all 3 charts are shown with the correct data, but all 3 pie charts have different diameters (despite the same measured variables). Is there any way to set the pie chart diameter so that in the…
-
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…
-
XMLPort Import Sales Order / Sales Lines
Hey Guys, i'm a newbie at C/AL Coding, so i hope, you guys can help me :) I have a XML-File, which should be imported to a sales order. I already got, that i have a sales header. This Code works finde Now i have to add the sales lines to the same Sales Order. That's what i've got so far, but the error message said, that…