-
Dataport to ignore empty lines
Hi I have a client who wants me to change a dataport so it ignores empty lines. I tried setting the DataItemSeparator to '<None>' but then it just goes into an endless loop. If I set the the DataItemSeparator to something that will never occur (i.e. '1hdf345') the dataport will actually read past the empty line but instead…
-
Crash recovery and upgrade senarios
We are in quite a jam here. We have been running FIN 2.0 (almost) without incident. We find ourselves with a crashed server (we DO have a backup) and no way to immediately replace the box. We want to move the server to another machine temporarily but after install we cannot open the database. We get a message about "cannot…
-
Renaming A Record In Code
Hi, In my app, customers are coded based on their customer type - FINance, RETail, COMmercial, so Customer No. is FIN, RET or COM plus an incrementing number. e.g. FIN-0030 When a user changes the customer type field in a record I need to change the primary key to reflect their new account no. Presently I have the…
-
ActiveX Message
Two of our clients ran into the ActiveX warning messages after installation of Navision 4.0. That ActiveX warning message appears every time a user opens Navision Help on a computer. We found that Update 1 for Microsoft Business Solutions - Navision 4.0 was supposed to fix this problem. However, after we installed the…
-
Print to file problems
When I try to make a file instead of a print, I use the "send to file" option in WIN printer . The file is generated but I can't read it. There is no extension, so I cannot open the created files. I would wish to create word files. What can I do to make this possible ? Thanks in advance
-
Date Compression
Morning All, We are just about to begin migration to a new Navision solution from fin 2.6 and have decided the best policy will be to date compress everything in the Item Ledger Entry table up to year end 2003, and then port that across to the new Db. A suggestion has been made to remove/ disable all the keys that aren't…
-
asp and navision
Hi there, I'm using IIS 5.0 and am having hell of a time feeding info to my asp page from navision 2.6. I tried the c/ocx route using c/front and though I can develop a vb application that retreives info from nav 2.6 a dll doing the same doesn't work as advertised. I tried the c/odbc route and though I am able to populate…
-
Inserting into MS Access from Navision
I'm trying to insert data from Navision 2.60 E into MS Access. I'm using the following code:// DataConn is an Automation datatype and is a 'Microsoft ActiveX Data Objects 2.7 Library'.Connection// DataRSet is an Automation datatype and is a 'Microsoft ActiveX Data Objects 2.7 Library'.Recordset CREATE(DataConn);…
-
Internal error 10 in module 45
In Navision 2.60E I get a strange error message when I call an automation object returning an empty string. The call works perfect when the returned value contains an actual string but when it is empty an error occurs : Internal error 10 in Module 45. (13)(13) :?: Clueless....
-
NAD 2.60 F BE : could not open the demo database
Ye all !! I try to install a old Demo DB (version 2.60F BE with Advanced Distribution). But ... in the DB, they are some defined users, so I could not open the DB (I dont' know UserId & Password used). The DB is coming directly from the official Navision CD ... Any idea about the user to use ? Or a trick to open the DB ?…
-
dynamically change text box background color?
I am currently running Navision Financials 2.6 .. is there a way to dynamically modify the background color of a text box on forms? :?:
-
Rounding off of decimalfields when importing to Excel
I have problem when importing data with C/ODBC 2.60 from Navision to Excel. The currency field is rounded off to 5 decimals wich couses a calculation error when I will se the invoicing amount in local figures. When I analyse the currency figures they will have 17 decimals. Do anyone have any solution to my problems?
-
report problem with array
Hi to all, i have a problem with a report. I hope, one of you can help me ?! I have a job and many resources for this job, about 8 resources. I want to print the job with the resources. The resources are printed in an array of 8 dimensions, but one resource is in one line, so the report need 8 lines. :cry: I want to print…
-
Resealing STX File after changes
To whom it may concern, We are currently in the process of re-implementing a current Navision Installation for one of our clients in Tunisia. (Navision 2.6.D W1) Due to the clients requirements we need to make changes to the current STX file. - Default rounding should be 0.001 - Default decimal view should be 0.001 as…
-
Performance problems 2.65 10-15 sametime users
I have a performance problem on my Navision server. I think it is related to my harware. I run the Native DB. I run the server on a W2K IBM server with 4 disks running IBM:s raid 1E. 756 MB RAM and 2x1 Ghz processors. I suspect that the bottleneck is the harddrives. How many disks would be optimal for my kind of system?…
-
Encode International letters, characters
Hi All, I have a big problem with the international characters. I use Navision 2.6 v. When I imported data with dataport from other countries (for example: from Portugal), I get strange letters. Some letters are unknown for the Navision and in this case the system fill up with "empty square" letter. Can I resolve this…
-
dbCALLFIELDCODE
Anyone knows the function dbCALLFIELDCODE?
-
Combine Multiple Companies in same database
We have a client that wants to combine several companies data into one master company to continue business in. They want to retain past data in this master company and continue business within this 1 master company. Any ideas for an easy way to combine these (3) multiple companies into (1) master company? They have at…
-
Excel Automation (Navision 2.60.E)
Hi, I have read a few articles around this site explaining how to use automation within Navision, however I have come across a few problems. When i try to assign the activeworkbook variable to my own workbook variable i get an assignment error. xlWorkbooks := xlApplication.Workbooks;xlWorkBooks.Add;xlWorkbook :=…
-
Adv. Distribution upgrade from 2.00 to 2.60
Hi, I would like to know the steps to upgrade an Advanced Distribution 2.00 database to 2.60 (as a temp. step to finally upgrade to 3.70). The steps are basically: - Restore 2.00 backup in 2.60 version. - Import upgrade1.fob and run for duplicate names. - import 2.60 object set (mods included). - Import upgrade2.fob and…
-
opening entry
hello everybody, i want to know how to post opening entries while starting a new company. say i hv created a new company ,all the setups have been done but no amount against any head in chart of accounts . now the organisation for whom i have done this setup have some amounts in their balance sheet against each and every…
-
Login Problems
Hello, I got a Problem with login into Navision Financials 2.60. I am running a Navision Server (Windows 2K) on this Server are 16 Session licensed. The first 10 Useres can login without Problems. If i go to the Database Information I see: Active Sessions 10 Licensed Sessions 16 If now a nother User wants to log in he gets…
-
Problems with Citrix / fin.hmt / Win98 / Win200 Clients
Hi there We have some problems with Navision 2.00 runnig on Citrix. If a Win98 client has open first navision on the Citrix, no Win200 Client can open Navision now (Error: The fin.hmt file allready exists¨). The same "shit" happens to the win98 clients, when a Win2000 Client was logged-in first. Are there any solutions for…
-
Automation classes explanation
Hi guys, when i use an automation as data type variable and then i select the subtype, when i select the subtype it gives me the classes which i can use them in my code. But i am not sure what each class or fuction do, is there any where i can get information on those functions. Like if i click on F1 or something like…
-
Navision 2.6 over SQL Server performance problem
Hi, I have Navision 2.6 Runing over SQL Server and some times I have huge performance problems, mostly when two users are using the same option at the same time, one process is blocked until the other process finishes, I'am thinking it is because table blocking, but I'am not so shure. Can someone help me?
-
Navision 2.00 Database Corruption. Please Help!!!
Hi all We have a big problem. We copied the database files while the database was in use, and now we can´t open it. Is there a way of fixing this corruption and being able to open the database, or at least recover the information? This is the only copy we have of the database, so we need to open it any way! Thanks in…
-
Upgrade - HRP Conversion
I am currently working on the payroll portion of an upgrade from vers 2.5 to 3.7. When I step through the HRP Conversion Wizard (codeunit 87200) and hit the convert button I get a permissions error: "You do not have permission to write in the Payroll Register table...". I've checked everything I can think of (ie. user…
-
Extension *.fob
Hello, possible a stupid question,... but for what is the definition of the extension *.fob Perhaps Financials Object? Thanks Piter
-
Change between 2.01 and 2.6
Hello, I must upgrade à NF 2.01 company to my NF 2.6 My NSC can't give me the difference between the 2 version !! ... Is it possible to have the change log between the 2 versions ?? for example, on CU80, I see some change, but I don't have clean database (without personal change) to compare it.
-
Current date in C/ODBC
Hello, how to select the current date with C/ODBC-SQL ? I want to create a query like this: select * from customers where insert_date = TODAY; How is the right syntax for TODAY? The second question is how to concatenate two fields in a query like this "select text_1 + text_2 form table;" Best regards Rainer