-
RENAME FILE Before Import
Hallo, my problem is very simple, but not the answer :-) I get lots of csv-files with a timestamp.... but idon't know if i can import a file with changing filename automaticlly!?!?!? Example: imp_deb_best_20061203120512.csv and so on can somebody help me??
-
g/l conistency error
Please can someone help. I am using Navision 2.6 and getting the following error when trying to post and invoice in purchase and payables THE TRANSACTION CANNOT BE COMPLETED BECAUSE IT WILL CAUSE INCONSISTENCIES IN THE G/L ENTRY TABLE.... i know that this stems from code-unit 12, and its an inbalance in the g/entry most…
-
Navision 2.60B Windows 98 Client Crash (Divide Error)-UPDATE
We just upgraded our server that runs the database server from NT4 to Server 2003. Our Win98SE clients are crashing with "FIN caused a divide error in FIN.EXE" when they try to print orders to our dot-matrix printers. (2 Epson DFX-5000's and an Epson LQ-2090). The are installed on our file and print server (Also Server…
-
2.50 czech needed!
Please, have someone Navision 2.50 CZECH? (or least W1)? Thanks...
-
How to select the fields I want to export with a dataport
Hello, Is it possible to create a dataport where I can select the fields I want to export at run-time ? Thx.
-
Using different keys in form and search window
Hi, I have a form using key #1. However, if my users searching a record using Ctrl+F or the binoculars the system should use key #2. Is there a way to do something like that? :-k We are using Nav 2.60 Thanks in advance. Manfred
-
Using period calculation in the recurring frequency field
Does anyone know if there is a way to set the recurring frequency in the recurring journal to be a period in length (1P does not work) rather than day, week, month, quarter or year
-
Switching between several companies in a Database
I have several companies in a database, how do i switch between them programmatically
-
How to Update a Table in Navision Database from SQL Server.
Hi We are using Proprietary database and we want to extract data from sql server to update navision table(s) without using text files to import. What means can we use to achieve this ?
-
Backup and Restore Process
Does anyone know what the Navision backup and restore process is when creating an FBK file? What i mean is how is the data arranged within the FBK file. I know when you restore a backup it appears to be quite a speedy process until Navision gets to creating the indexes. I'm just curious as we have often had problems when…
-
Two Users Same Batch
Hi There; I have two users working on the same batch in the general journal window with the same no. series, those two users are getting the same document no., how can I make those users work on different document no. automatically? I know I can do it manually but I'm sure that Navision can do better than that. Thanks for…
-
Sending e-mail with NF1.30 (Error 3 in module 115)
A customer with an old Financials 1.30 installation has this weird problem. They can usually send one document as an e-mail, but when they try to send the next, they get and Internal Error 3 in Module 115. MSMAPI32.OCX is registered. I have found 3 other incidents like this in the old danish support base, but it has never…
-
Problem with SELECT
Hello, i will make export tools from our Navision Financials 2.0 to MySQL database. I connect to Navision via ODBC driver and develop with Delphi. I make Query like this: Query2.SQL.Add('SELECT Nr_, SUM(Amount) as Amount'); Query2.SQL.Add('FROM Cust WHERE ... '); But as results become Amount without comas, etc. if result…
-
New W2 format for Navision 2.6
Hi there, Does anyone have this form pre-built yet for 2.6?? If so, I'd love to chat! Thanks, :)
-
Character set/128C barcode
Apparantly, Navision's native character set does not include these 2 characters: ¨ and © (Diaeresis and copyright symbol). Most windows fonts have these characters; they have values of A8 and A9 (hex), or 168 and 169 (decimal) respectively. In order to print a 128C barcode, I need to be able to print these characters. For…
-
Reverse Incorrect G/L Entry Posting Date
This is probably a simple one, but coming from a more technical than fiscal background I thought I'd throw it out. At yearend, one of our users posted several G/L Journal entries with a date of 12/28/06 instead of 12/28/05. As a techie, my first thought would be to make a change to the G/L table records correcting the…
-
Error after upgrading to windows 2003
We recently upgraded to windows 2003 enterprise server. Most other services start fine but 1 service does not want to start and we get an error code 1 invalid function when starting it. We uninstalled the service and reinstalled it. Still wont work. Then seen post on memory size and adjusted memory size and still getting…
-
Dilemma with permissions
Hi all. I hope somebody can help me. I have a small customer on 2.60, who just hired a new employee. This will be the first user, who isn't a superuser. The new user must be able to perform a number of tasks, but he must be restricted from seeing G/L Accounts, which is TableData 15. If I try to remove read rights for…
-
Working with Novell
hi All, I have to do a server intallation on a clients System. He's using Novell Netware 5.0. I'm a bit confuse how to go about it. Can someone help? Its urgent. thanks micromortu
-
TCP/IP communication problem but correct settings
Hi All, I'd like to get some help in this topic: We have many clients (navision 2.6) and that clients are works good .... but in some days, some of them is not operate any longer, meanwhile the hosts and services files are set correctly. No any new program is installed, no external intervention, nothing! in this case the…
-
Removing department codes / cause for concern?
We are in the process of revamping the way our company uses department codes. We are significantly reducing the number of departments we use and would like to delete the obsolete codes. We will not be changing the department codes on historical items. I have tried to “test” this in our “play” database and have not found…
-
Navision 2.6E performance problem
:cry: I hope someone can Help me!!! :cry: I'am using Navision Financials 2.6E with Microsoft SQL Server 2000 and I'am experiencing a lot of performance problems and some times Navision stop responding for a long time I'am very shure that it must be locking isues, and I know that the SQL command SET LOCK_TIMEOUT can help me…
-
Problems with a QUERY using C/ODBC into Navision 2.60
Hi, I have a problem with SQL I want to Sum of the multiply of 2 Columns SELECT "P"."Cód_ familia" AS "IDFAMILIA", SUM("MP"."Cantidad facturada" * "MP"."Precio unitario" ) AS VENTAS FROM "Mov_ producto" "MP", "Producto" "P" WHERE "P"."Nº" = "MP"."Nº producto" AND "MP"."Tipo movimiento" = 1 AND "MP"."Fecha registro">={d…
-
Voiding a reconciled and applied check
How do I void a cheque that has been reconciled in a bank recon and applied? It is in ver. 2.60. It is no longer open in the Check Ledger Entries. The vendor has received the cheque but has not yet presented it to the bank. The User has done the bank recon in a hurry and posted it in error. In stead of writing journals, is…
-
Character set problem
We are keeping our product specifications in different languages within one Navision database. As de languages are getting more exotic and use different character sets we are having problem with storing, retrieving and making visible texts in Polish, Greek, Czech etc. Does anybody know a solution how to store all texts…
-
New table
We don't have import text file liscence. Right now I create a new table based on the existing table and after I created the new table and no data is there. How can I put the data in the new table? Thanks in advance!
-
How to downgrade an Attain Add-on to Financials 2.60.07
Any ideas? So far I have found that you can import .fobs from attain 3.01.02 into a Financials 2.60 database but when you try to compile them the runtime crashes. Changing VAR ID's from @10000000001 to something like @1001 solves some problems but I still get the occasional crash from several objects when I try to compile…
-
Unable to create a dataport
I'm trying to do some tests and I want to create a dataport for item file from an exel file and CSV file into Navision. What I did now was to create a new dataport, assign an ID and a name but when i try to use the import option nothing happen, the screen is still blank. Any idea? BTW , i'm not a technical person so dont…
-
Purchase orders linked to jobs with a status of “complete”
We have some purchase orders that have been received and not invoiced with a job number on the line. The jobs had the Status changed to complete. We are not able to invoice or delete the purchase order since the receipt has the job number and we are unable to change the job status. Any ideas?
-
Questions on Navision performance
Hi guys! I need some advices. I have acustomer who has nav 2.10 and have some performance problems. How that can be resolved?? I know that you can compress some data to ave more space. Is it possible with that version? If yes, how to do that? And the performance problem can be resolved with that? Thanks to help me as I am…