-
connect Financials 2.60 with Active Directory
I have connected Navision Financials with Active Directory. Run OK if the ID Pre-Windows User is 10 char.s long. In Navision... In table 2000000002 User, the User ID field is 10 char.s long. In table 2000000003 Member of, the User ID field is 10 char.s long. In table 91 User Setup, the User ID field is 10 char.s long. In…
-
Front-end Back-end?
We have a WAN in a hub and spoke configuration, with most remote offices connected via 1.54 frame. A single central Navision server, connected to an EMC for the database, and another Citrix server for the remote users to access Navision. I've posted in here a few times, I may have asked about Citrix alternatives before...…
-
Deleting enterprises in File menu without deleting .zup
I would like to delete the name of the last enterprises in the File menu. The first idea was deleting .zup file, but I need to maintain user´s configuration, so I can´t do that. Thanks a lot.
-
2.6 Backup question
Hi all, Hopefully an easy question to start off with.. We currently run a backup every night of our entire Navision system. We introduced a new fob yesterday and are now wanting to backup the 'application' but not the database.. (The fob went through testing but you never know!) If its possible it would be a much quicker…
-
quiet install minimum
I'm rolling out 3.7a to 50+ clients today, and am trying to figure what command line options to use for an unattended install, without SMS. setup /? says "setup.exe /S /v /qn" Doesn't work though. mentions /v has parameters to pass to installer. I'm trying to do a plain simple network client minimum install. looked though…
-
show information of servername in a report
hello, we use financials 2.60D and have more than one database on different servers (e.g for testing). So this is the problem: How can i print the servername on a header in a report? i can see the information in the main menue (Database / information / servername) but i'm not able to get these information on my own way.…
-
Skipping Record Problem
Hello, I have a proprietry table named sales analysis, my report hierarchy is as follows, Item Category Then the Indented Item Table. Item Category: Following Setrange done. SalesAnalysis.SETRANGE(SalesAnalysis."Item Category Code","Item Category".Code); Item Table: Following Setrange done.…
-
Creating arrays
Hi, is it posible to index an array with a code or I have to use a number always? Thanks regards
-
Problem restoring backup of v2.6 using SQL Server option
Hi all, I am getting the following errormsg when trying to open a database on a SQL Server. [translated from danish:] "There is missing a '(' in TableRelation #2000000006.#1" The table in concern (2000000006) is the company-table. The same problem occurs when i am trying to create a new database on the server. I am using…
-
Delete Order with Total 0
Hi, it's Possible Delete orders with accounting balance = 0 ? e.g. follow Situation: I make an Order , i try, POST -> SHIP after this i see that i have an error in Item Listings, but the order was yet booked as delivered, so i make a new order with the same Items but negativ quantity, now i have two orders. If i booked…
-
Printing Cross Reference item numbers when available
I need to print Cross Reference item numbers on sales reports. The goal: - One cross reference number per item - Not all items have cross reference numbers - The cross reference number should be printed on the line ABOVE the normal item line, in the DESCRIPTION column - If there is no cross reference number, no line should…
-
Password experation
We would like our users to change their password every two months but Navision doesn't record the change date of the password. Is there another way to check the password age? Paul Olivier
-
Password
Hi, is there a way to connect to a navision financials database without to know the user password ?
-
Connection with Oracle
Hello! Could anybody help me? I need to get some data from Oracle table. I create ADO connection through OraOLEDB provider with this code:CN.ConnectionString :='Provider=OraOLEDB.Oracle;';CN.ConnectionString := CN.ConnectionString + 'Data Source=XXXXX;';CN.ConnectionString := CN.ConnectionString + 'User…
-
ODBC connection in c#
Well the problem i would guess is pretty simple. Im using Navision c5 2.1, and i've installed the ODBC driver that followed with the CD. Now, i would like to retrieve data, using a windows application, created in C#. When i try to add the ODBCConnection (Using gui, its faster than writing the entire code), a problem…
-
GL Correcting Entries
I have read in the Help files on Attain 3.1 that it is possible to do Correcting Entries in GL - how do these work - what value arev they. In order to do this it is necessary to insert a feild into the GL Journal called Correcting Entry Y/N using Designer - how is this done. Regards abee
-
urgently help needed
Hi, We are upgrading Navision 2.60 W1 to Navision 3.70 W1 to one of our customers. We are facing some problems. When we post a sales order it displays the following error: The VAT Posting Setup does not exist. VAT Bus. Posting Group='', VAT Prod. Posting Group='' We have created both the posting groups and also the setup.…
-
Microsoft support ends MBS 2.60?
Hello, We are using Nav Financials 2.60 with a lot of customization in the Purchase and Sales Modules. I saw on a US based NSC's website that Microsoft will stop support for all 2.x Navision Products. :shock: Is this information anywhere verifiable? Where? :? Do I need to go to version 3.x ? For what reasons? :?:
-
C/ODBC steals one session and never releases it
I'm a user of NF 2.01A. I'm writing a macro in Excel VBA to obtain data from NF through C/ODBC. To open the database i use the sentence: Set gdbODBC = OpenDatabase("", False, dbDriverNoPrompt, "ODBC;DSN=Sample C/ODBC 32 bit;CSF=Yes;SName=XXX;NType=tcp;Database=XXX.fdb;PPath=c:\Archivos de programa\Navision…
-
Data change register
Can anyone help. We use a data change register in 2.4, similiar to that used in 3.7, to track changes to tables. We track an option field on the sales header which works when changed manually from the sales order form. However we also update this option box while running a report but this change is not registered in the…
-
Import of fob disabled
Our customer is using NF 2.01.A and we have an odd problem at his site. The Import.... and Export.... menu items are disabled. When we try this on our PC's we can't simulate the problem. Has anyone experienced this before ?
-
Sharing Chart of accounts
We have a multi-society database and we'd like to share the charts of accounts between all societies. Does someone have an experience on this ? What could be the process ? What properties should be changed ? What other tables should be shared ?
-
add paper size for printers
Hello, we had a customer with a non-standard paper size. But if we tried to change the paper size in fin.stx we get checsum error. There is a tool to change the fin.stx? Could I add a paper size to navision to put it as default in a report? Any help would be nice? :wink:
-
Problem with Navision application server
Hi, We want to install a NAS in a customer running Navision financials 2.65 on a w2k server. After the installation all seems ok, but when you try to start the nas by service or console we get the error "navision financials is not set up to run in windows" (translated from spanish"navision financials no esta configurado…
-
Problem with navision server 2.65
Hi, We had migrated a customer from 2.60a to 2.65c and now the customer told us that they are working very slow. Any help?
-
start trigger from extern programm! possible?
Hi! I'm new here and have a very important question: I have an application that write data through ODBC/SQL into a Navision 2.6 DB. This works fine. But now to my question: In navision it's possible that I can add triggers to fields, and If I type in some values on the GUI, the triggers are executed!! Is it possible that I…
-
Error 3 in module 9
Hi, I have one of our clients getting Interal error 3 in Module 9, they are on Navision version 2.6 d and Windows Me. Any ideas how to resolve this error? Thanks Best regards Suresh.
-
Maximize the Main Menu and Forms
Hello, with <ALT>+<SPACE> i get the option to Minimize/Maximize/Close the Navision Programm. What must I do for get the Options für the Navision Main Menu, and the Navision Sub Menus and Forms? It's possible create a Shortcut Key (e.g. <ALT>+<ENTER> ) for Maxime the Main Menu and Sub Menus / Forms in Navision? And if the…
-
Open Navision Database in read only mode?
Dear all, is there a way run a Navision Financials 2.60D Database in a read only mode (We want to use the database as a temporary info system only)? I remember there was a parameter for a Navision DOS Database but i cannot find something for the Financials Database. Thanks in advance + rgds
-
Unable to change DBMS Cache setting
Greetings, I'm new to this forum and this is my first post (sorry, quite long). Hope to seek your help regarding changing DBMS cache setting. I'm running NF 2.60.E on a dedicated Windows 2000 server with the following configuration: 1x1GHz processor, 512MB RAM, 4x18GB SCSI HDD with RAID. Clients are of mixed Win98s and…