-
Navision 2.6B (with 2.6D Hotfix 1) on WS 2003
We are trying to install v2.6 on Windows 2003 server and during install it fails to start the service. Anyone got any ideas on compatability etc? I know v2.6 is old but it's what needs to be done.
-
Error:There is missing a '(' in TableRelation #2000000006.#1
Hi all, When I'm trying to create a new database from my Financials 2.6D client, on a SQL Server, I get the following error message: "There is missing a '(' in TableRelation. #2000000006.#1" I found out that the problem occurs when trying to create a big database, e.g. 8 GB. Does anyone have a clue what the problem might…
-
exact link
the exact link is: http://www.mibuso.com/dlinfo.asp?FileID=332 Bye :D
-
Job scheduler with NAS
Hi :lol: , I need to make a job scheduler with NAS. I use Navision v3.60. An xml config file (config.xml) contains all my jobs and their configurations. So, I use timer automation variables to run a job in a specific time. The problem is: I wand to create these timer variables dynamically, according to the job…
-
Show Certains Columns
hmm Perhaps this Question was discused on other Thread, but i doesn't find it, or i searched with bad words... When I Open a Form the User can still right-click and do a Show Column or Hide Column. If the User puts 3 new columns, this are saved in the Zup File so when he cames back this columns are visible for him. But if…
-
How to Select a date (convert date to format mmmm yy)
I have a small problem. I can't find out the syntax how to convert a date to a specific format. I would like to make some grafs on Excell, but I don't want to select all record with different date. Access SQL provides the next function Select A.AccountNumber, format$(A.date, 'mmmm yy') from ledgerTrans A It doesn't works…
-
DAO 3.6 Object Library
With Navision Financials 2.60B on a windows server 2003, the instruction W1 := E1.CreateWorkspace('','admin','',DbUseODBC) make the system crash. W1 is Microsoft DAO 3.6 Object Library.Workspace automation E1 is Microsoft DAO 3.6 Object Library.Workspace.DbEngine automation The error message is : "Impossible to call member…
-
Creating local Navison database
I use Navision 2.60. When i try to create local database with size 5GB on WinXP FAT32 i receive error: not enough space on disk? though there is more than 10GB free on that disk. So i created database file with size 4,15GB. Earlier i created such a database with size 6GB on WinXp NTFS successfully. Do i really have this…
-
Financials 2.00 and Windows XP
I've searched this forum and on mbsonline.org but still have no answer. Can anybody tell me if Navision 2.00 works on Windows XP? I know, that the official answer is "No".
-
automatic backup
Can any one tell me if there is a program that can can automatically backup navision data periodically?
-
Navision Financials 2.01b NEED SOFTWARE
I hope this is not out of line but... Does anyone know where I can get a copy of 2.01b? I have lost my install disc and need to urgently reload several client computers running it. TIA
-
Business Objects
Is anybody using Business Objects for reporting with Navision Financials? Have you created a Universe for the Navision database? What are your experiences?
-
Financial Exam
Hallo , I am Peter from Athens. Do you have any idea or do you have any question-answers from Financial exam? My e-mail is takisgiann@in.gr Many Thanks.
-
Clearing Out Database Sessions
We are currently using Navision 2.01B and if our Citrix server happens to crash, all of the user sessions in Navision remain open and therefore use up licences. Is there a way in the propriatary version to clear these sessions? This has happened on more than one occasion and the only way to clear them is to stop and start…
-
Validate fields when importing data
Hi. I am importing sales header and sales line from XL into Navision. The thing is the XL only has "Sell to customer No." field, an what I want to do is validate it, in order to let Navision check and complete all other fields acording to the customer No.. I have adde code in the OnAfterImport that does this…
-
Modified control
Hello everybody. I have to make a record of modifications of several forms (tables) in Navision, and I have to know the modified field or control to save it in an auxiliary table. Is there any way to know it by means of code? Thank you very much. :) Alex
-
C/ODBC - SQL syntax
Some of our fieldnames contain spaces and I was wondering what should be used to encapsulate these fields when building SQL for ASP pages (on IIS5) The following SQL will work in Access but not in ASP' SELECT * FROM Item WHERE [PartNo Alt] = 'XYZ1'; What do I need to change to make this work with ASP? TIA Pete
-
GL Budget Entries
:? I have just entered my budget into Navision. I am now wanting to compare the Actuals to the Budget by using the Account Schedules. I have included the GL Budget Entries in the Column type fields and selected the correct filters but I can't get the budget to show up. Please can anyone help? Thanks
-
migration fob from CD
Hi, I need the migration.fob file from the 2.60 CD to do a DB migration from the native format to the SQL format. Does anybody know where i can find this? Or can somebody send it to me? Greetings, GoMaD
-
Costing Method Change.
We have posted Transaction into items with FIFO costing method.how do we change the Costing Method to AVERAGE. We cannot create new items because we are maintaining the same stock catalogue in multiple locations(Installations). :( Thanks in Advance for your help :D
-
Server Crash - Error 1 in module 1
Hi, since last week we have some problems with our Navision-Server (2.60D wiht technical update to 3.7). The server.exe crashes with the following message: Error 1 in module 1. server.c(506) No Backup was running and the .fdb was not included in the Virus-Scan Software. Any help? Ron
-
Check if Item exists.
Hi, i try make a Report based on the Table "Item Journal Line". When I Get the List from this Table appears Items that are not existing in the Inventory Table. Now i would print out a list for this Items that are not located in Inventory Table. But i don't now exactly in what trigger i must put my code. I have try put…
-
Biggest Question - Should we upgrade or not
We have Navision 2.6. Should we upgrade it to 3.7 ? Users who have had experience in both versions please reply.
-
Autosplitkey Property can't find Key
Hi, i have a curiosly Error, wenn i would add a notice line for a customer i get an error that says me: Autosplitkey Property can't find Key between the actual an the before record. This Only occurs when i try insert an new line above the other lines, when i insert a new line belo the other lines, the it's okay. We write…
-
Import & Export Objects
Does anyone know how to control/check the version of Import & Export Objects?
-
Integrating Barcoding with Navision
We are a distrubution company. We use Navision 2.6 and a native binary DB. We are planning to introduce Barcoding solution to automate lot of processes. Right now the picking and packing stuff is being done manually. I guess it is easy to buy equipment like wireless scanners etc.. How to link our navision system to the…
-
Navision Report Writer
Hello, I have a new table created called Sales Analysis, this records all sales activity within the system. I need to create a report that has the following Data Items: Customer Item Category Item The Item Category is on both the Item Category Table and Item Card, but of course not on the Customer so how can I create the…
-
Access rights to new codeunit
I have just created a codeunit containing 3 simple functions. When I run them as a user I get an error message saying that I don't have the access right to run the codeunit. I added the codeunit to the group that every user is in, with exekvation rights, but I still get the error message. Can someone please tell me step by…
-
Insert data in Access via automation
How do I fill in some data in a table in Access via automation? In my Access db, there are 4 tables, and I have to select one then fill in some data, select the next one and so on. Is there anyone who can tell me how to do this ? Thank You. :D
-
Reporting from multiple Navision servers Servers
Our client has 9 Navision 2.6 installations. for in-house technical issues they stick with Native database.Now the problem is that they cannot restore all companies(from 9 installations) into one database because of size limitation on Native database. They want to retrieve database information from the 9 companies in one…