-
Reducing the scope of SQL queries to a single attribute in NAVISION 2009 R2
In NAVISION 2009 R2, it seems like NAV always request every attributes of the records (by sending a "SELECT * FROM" SQL request), even if I only use a single attribute of the records (e.g. : via code on a report or via the columns of a form). Example of an actuel SQL request send by NAV : SELECT * FROM…
-
Cannot create database in Navision 2016
Hi Can someone tell what this error means and how I can solve it. Thanks.
-
Update one table from another
Hi all This seems unbelievably basic but I just can't seem to figure it. I want to update a heap of vendor payment term codes from another table which I read in from Excel. My new table consists of just two columns: the Vendor No. and what I want their payment terms to be. So, for example, I might have an entry for Vendor…
-
Error 233
I'm using SSMS client. In my client everything will connect fine, but if i go to another computer and try to connect to the server, it could't connect. What should I do?
-
Recommend SQL database backup for db size 1TB
Currently, our NAV 2013 database has been growing up, it about 1TB now and running on SQL server 2008 R2 in windows server 2008 R2 enterprise edition, we would like to check if there any best practice of database backup at this size. any advice or guidance would be greatly appreciated
-
How to insert record Id in record link table using SQL in Dynamics Nav
How to insert record Id in record link table using SQL in Dynamics Nav, thanks in advance.
-
Microsoft Business Solution 4.0 SP3, SQL 2000 Database Suspect.
We're Running NAV with SQL2000 Database. Couple days ago, it wont open, and when i check on sql Server Manager, the Database get Suspect. When i try to copy the MDF, NDF, and LDF file to other location, The MDF file unable to copy to unreadable Data. So i assume that MDF cause the suspect. I try to recover the MDF with…
-
Reporting onExpected usage vs Actual usage on Prod Order Consumption
I've been tasked with creating a SQL report that reports on actual prod order consumption vs expected consumption. This is basically a variance report but instead of on the dollars, the actual quantities. What is the best way to go about doing this? Comparing the ILE's with the Prod_ Order Component lines? We have found…
-
List of Granule to run a web service?
Hi all, I m in a problem to run a web service in NAV 2009, all time i run the web service it gives me the error that "You do not have permission to run the 'Microsoft Dynamics NAV Server' System. Contact your system administrator to have your permissions changed" I checked the license of my user it has Advancement…
-
SQL Script in germany
hi someone have SQL Script in germany? i need learn more about that. Thanks Trung
-
Nav 2018 physical server - Memory and CPU
Hi guys, So i know that there is an existing formula to calculate the memory and CPU for a new server that will have a new Navision 2018 installation and SQL. So my main question is how to achieve the exact memory and CPU required for a new implementation on a physical server. *About 100 users will be available in that nav…
-
Navision 2018 SQL pull
I am seeking some help; not the best at sql by a long shot. I had some help from a previous Macola ES programer that helped me get the base of our sql query started but is no longer able to help. Currently, as this query excecutes it pulls the available date as 30 days from todays date. we would actually want that to be…
-
SQL database not loading data on dynamics Nav
dynamics nav server is starting but not synchronizing with sql database to load data, everything on the server seem blank, someone please help.
-
Power BI connecting to NAV via Odata result in deadlock on SQL server and NAV service tier shutdown
Dear Community, I am experiencing issues when connecting to NAV via Odata feed in Power BI With no specific pattern, the SQL database log the following error and afterwards all the NAV services lose connection to the SQL database. "All schedulers on Node 0 appear deadlocked due to a large number of worker theads waiting on…
-
Replication of the table 17 G / L Entry
Hello, I installed Microsoft Dynamics NAV 2016 and for reasons of internet connection (unstable connection), I had to proceed to two standalone installations of the solution on both sites of the client who is very distant. Currently, I am coding an ETL with SQL Server for periodic synchronization of data from the…
-
Problem with timestamp by copying data
Hi, i want to create a copy of table data via sql. But I have a problem when I want to insert the data in another table. I tried INSERT INTO table2 (column1, column2, column3, ...) SELECT column1, column2, column3, ... FROM table1 WHERE condition;
-
SQL DateTime is different to DateTime shown in Navision
Hello, i have the following Problem: I crated a new Table in Navision. With an extern Programm I write Data's in this Table. The Primarykey of the Table is the Timestamp. The Extern Programm is running in an Windows XP Client on witch is Navision 4.01 is installed. The Navisionclient is the SQL Client. To create the…
-
create sql query based flow filter
HI everyone, I'm trying to create the sql query code based on a flow filter calc formula. The formula is "Sum("Detailed Vendor Ledg. Entry".Amount WHERE (Vendor Ledger Entry No.=FIELD(Entry No.),Posting Date=FIELD(Date Filter),Excluded from calculation=CONST(No)))" and I "convert" this to Select Sum([E18375$Detailed Vendor…
-
NAV 2018 on NVMe disks
It's time to upgrade and I am looking to purchase a new server for our company. One of the options is to use NVMe disks instead of a standard server with SSD/15k spinners. The NVME alternative is cheaper and offers better speed. The "disadvantage" with NVMe seems to be that it's not using standard raid so Windows/VMWare…
-
Adding a flow field from one view to another view
I need to add the assembly BOM field from the Item card in a view. This is a flow field. I have a view that is pulling the fields from the BOM component table in NAV . And I have a separate view that is pulling the fields from the item table (27). The Assembly BOM field as a flow field on the item card is a Boolean type.…
-
Dynamics Nav 2009 Drop Down using Field Groups
Hi All, Thanks to the below blog I have gathgered a lot of ino about Drop Downs, but I have a question from Field Groups. http://blogs.msdn.com/b/clausl/archive/ ... roups.aspx Is it possible to have the drop down list to display different set of fields from different Pages, I can see that it is possible to add a 2nd line…
-
How to calculate the Purchase order[PO] requisition from Netsuite data table available in Sql Server
Sql Server database
-
Help with a SQL statement / query
Hello all I have a table in NAV (part of a third-party solution) that contains, among other things, a field "Stored FilePath" and that has hundreds of entries like "\\servername\documents\filename.pdf". However, the server is retired and now I want to change "servername" within that string to "newservername" whilst…
-
Unable to rename company in Navision.
Microsoft Dynamics NAVThe following SQL Server error(s) occurred while accessing the G/L Entry table: 15336,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Object '"Playground"."dbo"."CompanyName$G_L Entry"' cannot be renamed because the object participates in enforced dependencies. SQL: {CALL [sp_rename](?, ?, ?)}…
-
BLOB transfer from NAV v2.6 to NAV v.90 via SQL Query
I have an ancient version 6.1 database that has a table that contains a BLOB field. The BLOB field is used to store a PDF file. I'd love to use a SQL Query as shown below. INSERT INTO [Nav90Database].[PDF_Storage_Table] ([TableKeyField], [BlobField]) SELECT [TableKeyField], [BlobField] FROM…
-
Schema Sync
Hi experts Just a question: I have noticed that schema sync does take significantly longer in big databases. Do you experience the same? Does sql server need to copy the data into temp tables or something like that? Thanks in advance, kind regards Thomas
-
How to enable Sql server Agent???
I found it disabled in services in sql server configuration manager.
-
Migrating from SQL 2014 32bit server to 64Bit for Nav 2009R2
Hi everyone, Would there be any issues with Nav 2009R2 when we migrate from SQL 2014 32 bit to Sql 2014 64 bit? Any help would be highly appreciated. Thanks in advance.
-
Dynamics NAV support for SQL Server 2017
Just posted details of this on our team blog https://blogs.msdn.microsoft.com/nav/2018/01/11/sql-server-2017-and-dynamics-nav/ Best, Kennie
-
Problems with ADO after upgrade to NAV 2017 / SQL 2014
Hi all, Recently did a test upgrade to SQL 2014 and NAV 2017 and now our encryption function doesn't work anymore. The same function runs perfectly in NAV 2009 classic on SQL 2008. I used Rasheds code example a long time ago (…