-
Visual Studio Just-In Time Debugger error when publishing from VS Code
Hi, Since this morning, when trying to publish (with or without debugging) to any SaaS sandboxes from VS Code, I get a Visual Studio Just-In Time Debugger error I do not have Visual Studio installed, only VS Code I just click on OK and the process continues, but it's annoying. Doesn't happen if I'm publishing on Prem.…
-
Whats is the Link between Ordinary a Sales order and Purchase order in Navision?
I know that , Sales order is linked with Purchase Order in case of Purchase code is either "Drop Shipment" or "Special Order". Apart from that we can link Sales order with Purchase order by means of "Reserve" by Clicking Line ---> Functions---> Reserve in Sales Line of "Line"Action Button. is there is any other link…
-
BC TechDays 2023 Video
My impressions of this year’s conference: BC TechDays 2023
-
Transfer Nav Exported file to SFTP directory file and download file from SFTP to Nav directory.
Hi Everyone,[Nav 2017] I would like to transfer Nav Exported file to SFTP directory file and download file from SFTP to Nav directory.(File is in Csv format) Eg. Nav folder: C:\Desktop\DEMO\ForSFTP> SFTP folder: C:\Desktop\DEMO\FromNav Nav folder: C:\Desktop\DEMO\FromSFTP <SFTP folder: C:\Desktop\DEMO\ForNav For this I am…
-
NAV Business Central - is it possible to do SQL Query?
Good day! NAV Business Central - is it possible to do SQL Query using Microsoft SQL Server Management Studio and MS Excel? Thank you!
-
How do I get SQL Authentication to work on Dynamics BC v21
I am currently trying to setup SQL Authentication for Business Central I am running a three-tier architecture as below - APP Server - running BC v21(Installed all components except SQL components) - DB Server - running MSSQL Server 2022 (Installed only SQL Components) All the servers are running windows 2022 NON-DOMAIN…
-
Dynamic NAV2018 Could not find prepared statement with handle 6046
Hello all, I use NAV2018 get an "Could not find prepared statement with handle 6046". Sometimes once a month, sometimes every week one time. Than you can only restart SQL Server services / NAV service to solve the problem Are there other solution centers outside with the same problem and do have a fix for this. In the…
-
Unable Login Dynamics 365 Business Central Mobile
Hi all, is there a bug in the mobile app? Since april 10, 2023 some users cannot log in to mobile app. the app say session expired and after i click button refresh, the display return to login and this repeat continuously. I try to check event viewer in server but i dont get an error notification instead i get information…
-
NavHttpClient Request Failed
I get this error when executing a HTTP Client Request from BC Code: "Code: 0, Message: NavHttpClient Request Failed, Error: The operation was canceled.". The error is thrown after what looks like (more or less) precisely 2 minutes. If I limit my request in BC so that it takes less than 2 minutes, it completes without…
-
"Internal Server Error" production environment
Hi everyone, I'm trying to publish a production environment for a new customer and I keep getting an "Internal Server Error" when publishen or when downloading symbols. I tried a few things myself and nothing works; - I checked data in the app.json and launch.json objects and everything looks good. - I tried to remove the…
-
BC 22.0 Import-NAVEncryptionKey The provided encryption key file contains invalid data
Hello, I'm trying to install Business Central 22.0 on an Azure VM. I have created an Azure SQL database with a dba owner user. The database encryption has been enabled (CREATE MASTER KEY ENCRYPTION BY PASSWORD = ''). Now I want to configure the database user and password for the BC service tier. New-NAVEncryptionKey…
-
Find credit memo line(s) associated with an invoice line.
This is NAV 2015. My dev problem is this: From a given Posted Sales Invoice line, find any/all Posted Sales Credit Memo lines associated with that invoice line. I've hunted through a whole jungle of tables/recs to find a foolproof path from one to the other and I just don't see one. I would have thought there would be…
-
BC V20 on prem AAD auth using OpenID
I have managed to get the on prem working with AAD auth but only with WS-Federation. I had to set a flag in BC to enable WS-Federation. Looking thru the latest docs it appears I will need to move over to OpenID in the future. Does anyone have any links for a good guide on how to implement OpenID with BC v20 on prem?
-
Reverse Charge in UK
Can you advised me how to use Charge VAT. Please could you advise how this should be processed and any set up changes we need? We have to process postponed VAT and had to have changes made so I’, assuming this will be similar. Thank you
-
NavEncryptionKeyNotFoundException
Hi, BC16 OnPrem, when you open Customer, Vendor or Contact cards, you get aMicrosoft.Dynamics.Nav.Types.Exceptions.Encryption.NavEncryptionKeyNotFoundException Kind of found a workaround which suppresses the error by disabling CDS on the CDS Connection Setup page. I get the same exception when then trying to run…
-
Is there a way to link Nav 2015 Session ID to SQL SPID?
Hello, I am wondering if there is a way to link a Nav 2015 Session ID found in Active Session table to the SPID of the session in SQL (found by running the sp_who2 stored procedure for example) The sp_who2 command will let me identify what session is causing blocking, but it won't say anything about the user as it only…
-
How to open 2 windows session in Business Central
Hi, I want to open 2 windows authentication user session in 2 different tabs in Google chrome. If anyone knows how to do , please let me know the steps to achieve it. Thanks in advance. Regards, sekar.
-
Old versions base app
I need to download symbols for older versions of base report 7305 “Whse.-Source - Create Document”. Does anyone have to code or know how to do that? I want to compare the code from version 18 with the current one using one of those online code comparisons. I tried to view the code in NAV but it's a long report, so checking…
-
Adding additional Options to "Item" quick filter drop down
Good afternoon, I'm trying to add an additional field to choose for the item quick filter, I've added fields to other tables and changed the available fields on the customer/vendor cards. Can anyone point me in the right direction? Thanks very much in advance.
-
delete the Empty Nodes in XML port through code unit with using Dot net variable.
Hi I need to delete the Empty Nodes in XML port through code unit with using Dot net variable. Is my code is correct ? kindly suggest some answers. Documentation() OnRun() Document:= Document.XmlDocument(); Document.Load('D:\xml\xmlportforexport.xml'); Parentnode:= Document.SelectSingleNode('Root'); Nodelist:=…
-
Import File from Azure File Share to Cloud BC
Hi, i am using BC20 and try to download a file from Azure File Share. I can create files, upload data (TempBlob) to Azure and get file information (example below), but how can i download data into my TempBlob? Regards procedure ReadFile(FileName: Text; TempBLOB: codeunit "Temp Blob"); var CryptographyManagement: Codeunit…
-
BC21: Production Orders Components Page very slow
I have a customer that has the page of the Production Order Components that is very slow to open from the Production Order card when a particular extension is installed. And by slow I mean >1 min to open on production orders with 30 components. When I uninstall the extension, the time decrease to a couple of seconds. The…
-
Financials in BC
I am using BC and preparing financials in excel. Concerned on how the cost of sales will be presented and still be in balance.
-
Show each month on Account schedule and YTD
Hi, Wanted to setup an account schedule that has Jan/Feb/Mar etc... and a YTD column. If we set the col definitions with comparison period +1M +2M +3M .. but then I would always need to filter on Jan... which makes YTD difficult to calculate. If I let the user filter on say 01/01/2023..31/03/2023 as a date filter YTD is…
-
BC2022 hide specific page for a profil
Hello everybody, i am using BC 2022 and iwant to hide a specific page for a certain profile to make it not visible (Tell me functionnality) for security reason. Is it possible? Thank you
-
PowershellRunner in BC
Has anyone tried using powershellrunner addin in BC (v15 and above). Was it working for you? It was working in with C/AL versions, but not working in only AL versions?
-
failed with this message: The request was aborted: Could not create SSL/TLS secure channel. SOAP API
I am getting below error and i am not expert in SOAP API integration. Below code was working fine but suddenly i have start getting the above error, to solve this issue i have used the below code also ServicePointManager.SecurityProtocol := SecurityProtocolType.Tls12; but no luck. i am getting error on the this line of…
-
BC 18 Edit in Excel Invalid server configuration
Hi guys, please can you help me with issue - Excel Addin for BC 18 is not working. Customer has OnPrem BC 18 installation with AAD auth enabled. Users reported me, that Edit in Excel function stopped working but they did not use it much. I inspected app registration, ODATA are working, SSL is enabled. Everything is done as…
-
Allocation costs in BC
Hi. I have a question regarding Allocate costs. When posting purchase invoices, they are correctly transferred to cost entries (entries are separate). The problem arises when we run the function allocate costs for the specific date, for example 05/22/2023, function combines all cost entries (all the previous dates too)…
-
how to set boolean true - as a default
Hi everyone i m new here in Navision developer , here i am stuck in one page - there is one field (data type -boolean) , when i open its showing true always . i have checked in field property there is nothing such set. also that boolean field is connected with another page if true. i want to make it false - as default…