-
SQL table not visible in NAV
Hi, Ik found a table under SQL server in the NAV database, which I cannot find in NAV itself. It's a custom table, made by someone in the past. I suspect it was created in SQL (it's filled through a SP). Is it possible that tables are created through SQL and thus not visible in NAV? Is there a way to include the table…
-
Why do Analysis Services Dimensions need to be linked to tab
les and how to work it around? For example make a Dimension of the Entry Type in Item Ledger Entry. Yeah I could define a view... but isn't there an easier way? I am confused because AFAIK it is just basically a big bunch of SUM - GROUP BY and a normal SQL GROUP BY never needed table relations for the fields grouped by? So…
-
Easy way to find code behind triggers?
Hi, I have a database where some people have written SQL code in triggers of a Navision database. I want to find out where all this code has been written. Is there an easy way (script) to list all triggers/tables that have SQL code? Regards, Arjan
-
RTC
How do identify the role center i m using in RTC?
-
Modifying RTC Report
Hi all I adjusted a report in classic,but the code i added on Pre-section is not executed, how can i make this code executed? Regards
-
NAV on SQL Server - Backup and Restore
Another couple of YouTube clips that I promised to create during one of my sessions at Convergence, about creating backups and restoring databases for NAV database on SQL Server:* NAV backup and Restore * SQL Backup and Restore
-
How to get same Execution Plans in a test-db?
I'm currently trying to optimize indexes based on "expensive" queries found using scripts from Lars Lohndorf-Larsen. (http://blogs.msdn.com/b/nav/archive/200 ... story.aspx) This database is rather big, so I can't just create and drop indexes in the live database, so I would like to do some testing in a test database…
-
Disable
How do i disable filtering on my tabular form?
-
Problems in creating new NAV database on SQL Server
Hi all, I have a problem in creating a new database with NAV 2009 R2 and SQL Server 2008 R2 installed on my laptop with Windows 7 Professional. I have installed the Cronus Demo Database and I can access it without problems with finsql or the RTC; this database has been installed during the installation of NAV (originally…
-
Truncate/Shrink logfile while restoring fbk?
Excuse my ignorance, but is there a command available to truncate/shrink the logfile during a restore of a NAV backup? I'm restoring a customers backup (database is several 100 GB's) on an external 500GB disk. The database was created with the Simple recovery model, but this does not have an effect on the log when…
-
NAV on SQL Server - Maintenance and Setup Essentials
At Convergence 2012 in Houston I'll be part of a session about best practices for NAV database setup and maintenance on SQL Server. In preparation for this session I've created a couple of videos: Essential Maintenance: http://www.youtube.com/watch?v=0KbZkKdyZps Setup Essentials: http://www.youtube.com/watch?v=pOIjde-xpz4
-
email inserted in a blob field
Hi, I am planning on customize e-mail logging funcionality to log in nav emails not stored in exchange server. The customization should be based on standard Microsoft Outlook 12.0 Object Library Automation to retreive from outlook some emails the user places in a certain tray (so the mails "imported" are choosen by the…
-
SQL 2008 Encrypt Database
For PCI purposes we need to use the normal SQL function to Encrypt our NAV database. Anyone ever done this? Does NAV support (we are still classic client but do use web services as well) this or does it not have anything to do with NAV as it is just a back end SQL thing? We are on SQL 2008 but wll be upgrading to SQL 2008…
-
Field AMOUNT in table CUSTOMER LEDGER ENTRY
Dear mibusos, we are just migrating from Navision 4.x (Native Database) to Microsoft Dynamics NAV 2009 (MSSQL) It's up to me to adjust some small interface routines written in VB..... The original source code against the native databse uses: SELECT Entry_No_, ...... , Amount FROM Cust__Ledger_Entry..... WHERE ..... to…
-
Is there an "Option-Field-Translation-Table"?
Me again... ...still migrating our old interface routines (ODBC) from Navision 4.x (native database) to NAV 2009 (MSSQL). All off the old interfaces are using the ODBC drive with the option "OptionFieldType" set to "text" (The "Identifiers" optin is set to "a-z,A-Z,0-9,_" which explains the "additional" underlines in the…
-
TimeStamp Field
I have a client that would like to know the answer to the following question: Does the value in the timestamp field on the G_L Entry table change if there is any change on the record? Is it a standard SQL Server rowversion/timestamp field? Any help would be greatly appreciated.
-
$ndo$shadow trouble
After using the SQL 2008 Copy Database wizard I now have a Copy of the Live database for testing/training etc which will be refreshed every night. I can gain access to the database no problem but when non db owners try to access it using Nav 2009 R2 they get an error The application role does exist and has a password…
-
How identify new records in any navision table?
Hi I'm working with SSIS and the data are daily updating. But I need to retrieve just new records from navision table (it can be any major table). Does there is some approach? How I undirstand the timestamp in navision table just identifying row? Maybe there is some secret table with real unix timestamps and rows…
-
SQL Server 2008 R2- setup cd and license after migration NAV
Hello, we have a customer running NAV 5.0 on a server Windows 2003 Server and SQL 2005 having bought the SQL granules. Now we are migrating all infrastructure in a VM environment and a server Windows 2008 R2 (64 bit) and SQL Server 2008 R2 64 bit. I ask you the best version of SQL Server 2008 R2 64 bit, where to obtain it…
-
table purchase line is locked
Hi, we have NAV 5.0 and we using sql server 2005. In one company when user wants to press F9 Statistics, error appers "The Purchase Line table cannot be changed because it is locked by another user. Wait until the user is finished and then try again". I have checked in file/database/information --> blocking user Id, also I…
-
SQL 2008 R2 & Nav 4.01 SP1
I've read through the forum and see references to requiring at least Nav 4.0 & SP3 to make this work. I'm getting an error message to the effect that Nav can't load the xp_nd0_x64.dll when I try to select the company. Are there techniques other than upgrading? I wnet through the process of installing the dll in SQL with no…
-
SQL Server Role for NAV Users
Hello Following up to this: viewtopic.php?f=23&t=47512 I know, normal users don't need special roles on sql server. My question is: What server role is needed for managing these tasks from within NAV 2009R2 on SQL Server 2008R2: 1: Creating and deleting Windows Logins Imho user must have sysadmin. I wonder why…
-
Error on NAV restore
Hi We are testing a migration with a db containing about 50 companies. If restoring more than ca. 10 companies at a time (NAV internal restore, not sql restore) we get this error: "Die folgenden SQL Server-Fehler sind beim Zugriff auf die Tabelle 'Object' aufgetreten: 701,"42000",[Microsoft][ODBC SQL Server Driver][SQL…
-
SQL permissions writing in a view
Hello all, Im absolutely not an SQL wizard but need some advice on this scenario. I have this situation: Database 1 with a table Order (SQL database) Database 2 with a view to table Order in Database 1 (NAVISION SQL) The user should be able to read and write in the view of table Order in NAV. Now this user gets the message…
-
THANKS! Need a very SImple Update Script
Hi All, I am not a SQL expert but am very aware of the dangers associated with any update script for NAV. I just need to change ONE field value on ONE table (ONE line) from null to the value of "4". (I expect this to be a very benign change and accept the fact that it may not work but want to try it.) I am able to query…
-
List of Fields
Hey Guys, is there an easy way to retrieve a list with fields (for a specific table) from the SQL-Server? I found the object table and hoped there would be a field table too, but i found nothing. ](*,) I hope you can help me.
-
i try to add Catalan language to RTC but not display
Dear I try to add catalan laguage language to RTC but it is not display on language list . please advise
-
SQL server 2008 x64 - problem with posting
Hi everyone, We using navision 5.0 with 17 users and we have sql 2008 x64. Problem is when someone post e.g. Item Journal , Purchase Invoice etc, navision at the end of posting suddenly freeze, after that user must force client to shut down it and start it again to continue with work. Very strange is that entries are…
-
Customer Ledger Entry
Dear i have 1 invoice. and this invoice has 3 times of payment. i want to write some code to filter 3 payment of this invoice. i don't know what column that i can use to filter . Please advise.
-
How to rename / drop company from SQL script
Hello all, We try to automate the backup/restore procedure for our LIVE-to-TEST procedure. We are able to backup/restore everything via SSIS. Now the question remains whether we can automatically:* drop a company within the restored database * rename a company within the restored database Can this be done via a SQL-script…