-
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
-
When page is opened , need to to select all records
I have customization on pages, when a page is opened, first all records should be selected, can any one suggest me how to do it? Advance Thank you
-
Doubt about SumIndexField
Hi friends... I have a doubt about SumIndexField in a Table Key.... I tried to find it on internet but I can't, so I hope one of you can clarify my doubt... I have one table (Table A) with many keys with diferent fields... and many of them have specified the same field as SumIndexField (Field "Total Importe producción"…
-
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…
-
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.