-
Running ADCS on Business Central 180
Hi. I am trying to setup ADCS on a Honeywell scanning device. I am able to setup 3 miniforms for Main Menu,Warehouse Picks and Warehouse Put Aways. I have created a web service for the ADCS and setup ADCS Users,enabled ADCS on location card. But now getting the link login with on the honeywell devise is my challenge. I…
-
AL Triggers are not working in VSCODE.
new to AL and not sure if this is the right place to post but,page 50110 DataTypeCard { PageType = Card; ApplicationArea = All; UsageCategory = Documents; Caption = 'Date Type Card'; layout { area(Content) { group(GroupName) { } } } actions { area(Processing) { action(ActionName) { ApplicationArea = All; trigger…
-
Error with extension not properly connected to separate company
Hi there, I am installing an extension that I only want active in one company. However, when I try to use my other company where the extension is installed but not connected/active, I get this error on the pages that the extension touches. We can't connect with this other company since it is in a different country and the…
-
Updating Profile role from web client
Hi there, if you go to the profile role, there exist the possibility to customize the profile for all. But when I click to Customize a new site is opened with following link: http://s22-navapp2c:48900/BC190?profile=BUCHHALTER/IN&customize the port 48900 does not exist. May be it is because of missing the Client Base URL in…
-
Troubleshooting session resource consumption
Hi, I recall in the old versions of NAV, (before 2009 classic client) you could view connected sessions and view the resources used by each session. E.g. Processor time, and memory usage. Is there anyway to do this in modern client? I Am currently using NAV2017.
-
What is the structure in C# to add records to a BC Cloud table via the OData v4 web service?
I have created an application in Azure and I have given it read and write permissions in BC, in BC I have published the page as a web service. So far I only have the C# code to display the records. The requirement is to monitor a specific folder in Windows and whenever a text file is added, the content of that text file…
-
NAV 2013 R2 QL Server error or errors occurred when accessing the Object table
Hello i have just restored a database frp, live, iam gettin SQL error after restoring the database in sandbox server, the database located on Azure. i have tried to sync the database via Tools-> "Buld server application object " whch comes with bunch of ForNav objects. i have have finaly tried on powersheel sync-NAVtenat…
-
Build Docker Container in a VM running Windows Server 2019
Hi all, Has anyone had success using bccontainerhelper to build a Docker image inside a VM that is running Windows Server 2019? I believe I've installed Docker correctly - it shows that the service is running and the Hyper-V and Containers are active in Server Manager. I'm trying to build various images, but here's an…
-
v16 Sales Price Lists
We're upgrading a customer to SaaS and as a trial we've enabled the new sales price experience in a sandbox. The feature upgrade has created 3 separate price lists, S00001, S00002 and S00003, and I can't see a reason why it did this. They've all got data from the old Sales Price table, and the last one also includes some…
-
OData WebServices BC14
We have custom normal page which we have incorporated OnNewRecord trigger which populates the document no (based on balance of the journal and the no series present =UpdateBalance / SetupNewLine functions). (based similar to Page = 39) The custom page works well when used manually (document number is populating). When we…
-
how to fix this in bc cloud
report 8069153 "Financial Statement Export" { Caption = 'ECF Sage Export'; ProcessingOnly = true; dataset { dataitem("G/L Account"; "G/L Account") { DataItemTableView = SORTING("No.") WHERE("Account Type" = FILTER(Posting)); trigger OnAfterGetRecord() begin Win.UPDATE(1, "No."); Win.UPDATE(2, Name); DecGMntC := 0; DecGMntD…
-
how to Import json file to navision Table
Hi all, I am new to Navision, can anyone of you tell me , how to import json file to Navision ? thanks, Rajan.
-
Deleting Reservation Entry Table Reservation from AL code
Hi All We have sales order item demand reserved to production orders. I want to delete the reservation entry table entry for sales order--prod order (2 lines for each reservation) and re-create the reservation linking production order to Job Planning line. Are there any known risks involved in deleting reservations and…
-
Protecting C/AL Code
Hi all, I was wondering is there any reliable way to protect NAV code from being reused by other partners. I thought extension is the answer as object disappears. But when I try to debug, I'm able to see all the code in the extension. It's as easy as I created a tool to export licence file from NAV DB. So it appears the…
-
How to transfer data from ONE Sql server DB to another Sql Server DB
Hi All, We are using two Sql servers in different locations. Is it possible to transfer table data from one Sql server DB to another sql server DB without manual intervention. This sync has to be done on daily basis. Please share your ideas. Thanks & Regards, Kishore
-
TLS 1.2 and Development Environment Client using NAV2013 R2
Hi, We recently banned TLS 1.0 connections to database server on a NAV2013 R2 environment and everything seems to be working fine except the Classic - Development Environment Client. Does anyone know if there's any solution to make it work? Are newer NAV Development Environment versions compatible with TLS 1.2? Regards,…
-
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…
-
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.
-
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…
-
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…