-
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…
-
SSRS reporting in F&O discontinued?
I’m new to F&O, used to work with Nav/ Business Central for years. Now I started off in a F&O project where all reports are developed via SSRS. The reports mostly relate to functionality of an ISV for Logistics Service Providers, but also to standard F&O. The project is currently on hold, as there is a discussion whether…
-
Pre-Sales material
Hi All Microsoft used to share all the pre-sales presentations and info on partnersource. I am unable to find it there anymore. Can some one share where this material is shared, if at all.
-
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…
-
Database Restore Failure - Incorrect Checksum
Hi All, I am getting an error when I am restoring Database in NAV 2009 R2. "Database Restore Failure - incorrect Checksum" Can anyone please help me to restore. Raghubir
-
Please see this below question (it is lengthy, that's why posted below)
General Journal, Payment Journal, Cash Receipt Journal, Recurring journal both having "Gen.Journal Line" as table, can anyone explain in theory way what's the difference between it. & Technical, if possible, please.
-
"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…
-
Application Management MAKEDATEFILTER
As usual, something I thought would be simple has turned into a dog-fight. I need to put a control on a report request form to collect a date filter. Looking at a stock example I went to form 490, Acc. Schedule Overview. There, the date filter is a textbox with the source expression "Acc. Schedule Line"."Date Filter". I…
-
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…
-
Install business Central on linux
Hi Guys Do you know if business Central 365 is supported when it will be installed on a Linux/Ubuntu vm with sql 2017? Any experience with it?
-
Problem in our Stock
We have had some problems with historic stock. Although it was decided at the time that it would be too much work and too time intensive to correct. I’ve been looking and there is also a lack of continuity across different reports for the same stock item. I’ve taken 1 item that I know is a problem (C1144SA), along with…
-
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…
-
Having msvcp140.dll is missing error
Hello there, I am getting a message in my computer that msvcp140.dll is missing from the computer when i try to open an application, I downloaded msvcp140.dll from the given link but do nmot know how to use it, there are no instructions on website, Can someone help, Thanks in advance, Emma
-
Reverse charge - Business Central
Hi, We have received an invoice which the supplier has advised us we have to use Reverse 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.
-
Break bulk-NAV 2009
Hi, we have some problems with break bulk function in warehouse picks. We are using Nav 2009. Break bulk works fine when gathering smaller UOM (pieces → boxes) (only pieces in inventory), but it doesn’t work the other way around (boxes → pieces) (only boxes in inventory). The base UOM and sales UOM is always the same…
-
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…
-
XML port - create value list
I have a couple of times had the need to create a simple value list with an XML port. A sample output would belike is: <TestAPI> ..<brandId>622b300e4b18948f3e71679a</brandId> .. <productIds> ....<productId>9702820189648</productId> ....<productId>9702820189649</productId> ..</productIds> </TestAPI> Is there any way, that…
-
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.
-
BC 14 Service is not starting in service & also instance is also not starting.
Installed BC 14 month ago, i was worked fine, but now server instance is not starting, and i also viewed the event log.I got this error. Please help on me, very urgent, thank you Server instance: SampleBC Category: SqlConnection ClientSessionId: 00000000-0000-0000-0000-000000000000 ClientActivityId:…
-
NAV 2009 to Dynamics 365 Business Central License Upgrade
Good Day everybody, I am actually using NAV 2009 R2 version at my company and I am planning to move to the latest version of Dynamics 365 Business Central. I would therefore like to understand how Microsoft converts my existing NAV 2009 BRL License when I upgrade same to Dynamics 365 Business Central. I currently have the…