-
control of validity on a checkbox
Hello, I look for an information concerning a control of validity on a checkbox (on form). Indeed, OnDeactivateForm() IF ("Budget saisi"<>TRUE) AND ("Planning de facturation"<>TRUE) AND ("Plan généré"<>TRUE) THEN BEGIN ERROR('Le projet n° %1 n''a pas de budget saisi ou planning de facturation ou de plan généré',"N°");…
-
Dynamic Field captions on reports
Anyone know how to change a field caption within c/side on a tabular form?
-
Cache
The first user who is logon to NF wait a ling tine. I read that the problem can be a too big cache size. The size is 158208 KB on a NT4 TSE derver with 256 MB intern memory. How can I reduce the cache size by starting NF permanent to a lowet cache and what is best one you advise
-
Accesing Nav from Linux
Hi ! First, I see this forum is Nav 3.x related to. Sorry for asking about 2.01. I would like access to navision own DB ( Not SQL ) from Linux. I want to use PHP to access Nav DB via ODBC. What must I do on NT Server ? What must I do on Linux box ? Is this possible ? Is there any one who success with this ? I will thanx…
-
Navision and MS-Excel
I am a young user of Navision. When I one makes copy to stick of a table Navision or board Navision towards a Excel Sheet, the data type of value is not recognized by Excel (like decimal). I tried to realize a macro in VB, without excess of success. There is it a method to import data of tables towards Navision. Thank you.…
-
Accessing Navision DB from Perl via ODBC
Okay, here's my problem. I'm currently running a Navision 2.01b database on an NT 4.0 server and the 2.01b client on a W2k box. I have the Navision ODBC driver installed on the w2k box and I'm using the Perl ODBC module to access the Navision database. My problem with this, is that whenever I query the database (i.e.…
-
NF 2.01 and word-table
Hello, i searched hours for a hint or an example how i can create and fill a word table. Can anybody help me? In the past there must be something to download - but i can´t find it. greetings Ralph
-
Advanced search-method
Does anyone have any experience with search-methodes? I'm importing customer-names within Navision. When for example the name ‘smith’ is imported, the following names should be found: smith, smyth, smit. Is there a solution for this problem. Thanks in advance, Elwin van den Bergh
-
average costing
We've just gone live with Navision and realised that costs on purchase orders do not update the inventory item average cost field until the purchase invoice is posted; nor do subcontract costs get added to jobs. The purchase invoice may not be received for several weeks after the sale of the item/job resulting in over…
-
Modify Document Number in Item Jnl (2.60)
Hi all! I hope someone is working today and can shoot me some much needed help in a hurry. I have an item journal populated by a custom report. It's huge, almost 30,000 lines. Unfortunately the report has inserted tranasction numbers in the document number field of the item journal. I now need to modify the document number…
-
Prospects/Contacts relationship
Moin: I try to understand how it is realized in Contact Management that the menu button Prospect|Contacts shows a table with only the contacts of this very prospect. Can anybody explain what mechanism are behind this? I looked at the code behind and the properties but until now I didn´t find any clue. Regards Kolja
-
phone number format ?
Hello, I am a young developer end user in an entrepsise which uses Navision (v. FR 2.01). The users wish to have all the fields of phone number in the size(format) "99 99 99 99 99", at the level of tables. What is best method? Thank you. Benoît Durand
-
The Server is not responding anymore (TCP/IP error)
We have started getting the following error when runing a backup or a large report from a client: The Server is not responding anymore (TCP/IP error ECONNRESET). Try the following things in the specified order: 1. Start the client again. 2. Start the server and the the client again. 3. Check the TCP/IP installation.…
-
cannot access ftp site
hi guys, I cannot access ftp site from navision. The message always "Windows cannot access this folder..." My system admin never put limitation to my account. Did anyone have idea how I get out from this trouble? My OS is Win 98.
-
c/odbc with java
I'm trying to get the jdbc to odbc bridge to talk with c/odbc, has anyone got any info or examples in this area. I'm new to Navision so any info on just c/odbc could be of help.
-
bank reconciliation
Probably very simple, but for some reason I can not transfer differences to gen. journals to be posted with the "transfer to general journal"command. When I select the journal with the batch and later look into that the line I expect ( difference) is not there. How do I get it there?Do i manually have to enter the diff…
-
ShowColumn on the fly?
Does anyone know how to be able to not show certain columns based on user permissions? I have set the visible := false; but, the user can still right-click and do a showcolumn. I need to be able to remove the column based on user permissions. Does anyone have any ideas?
-
Calling MS Word from a report
Hi: I have a client where each invoice includes a 2-page cover letter (invoices are for annual membership fees). The text of this letter changes, so I'd prefer not to create all the text inside a Navision report. Has anyone been able to call MS Word from inside a report or codeunit, and pass name and address information…
-
External Login
We would like to be able to start Navision from an external source by passing the UserID and Pasword that have been previously setup in Navision. This would bypass the login screen, still use security, and take the user directly to ther main menu. Any ideas?
-
Totals in a sorted report
I am trying to write a report based on the employee file with the Payroll Ledger as secondary. The report should print out in any sort order (Keys) available to the employee file. This works, but when I attempt to total by employee it works correctly only when the fields listed in GroupTotalFields equal the fields in the…
-
Gross database size v2.6 Native v SQL
I would like to know what differences in database size can be expected for a v2.6 database running on the Navision database engine compared to the SQL engine. Can anybody help? TIA David
-
Subforms
I have this slight dilemma. The thing is I have to run 16 forms at the same time, every form is the same, but none can overlap each other, i.e. they all have to be in order. I decided to run a form with 16 subforms, eastablishing the order I want. Now, how can I set each subforms visability to false or true depending on…
-
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
-
Outlook 2000 Automation - Create one Task
Hi, I would like create one task from Navision in Outlook 2000 client ... This task, must create by a push button in "Prod. Order Form" based on "Routing Lines" ... I know a few automation command on Excel and Word but nothing in Outlook ... How to code this ? Thanks in advance ! Fabrice Ps : Sorry for my poor english ;-)
-
Access to Navision with Asp
Is anybody Know if it´s possible to access Navision Database with an asp page using C/ODBC?
-
ms word mail merge
Hi.. Is it possible connection data form navision to ms word Exampe : I want to send a newsletter to our customer then I create with ms word with mailmerge function tools, can we take the record from customer in navision financial such as name, address, address2 and etc.. Regards AKO
-
Large Order Processing Examples
I have been evaluating NAD for the last six months or so. I'm looking to speak with users/developers/anyone who have large order processing experience. Specifically, is anyone aware of a company using NAD to process 1000 or more orders per day? It would be especially helpful to find someone under this load in a…
-
Navision and Citrix - how to keep individual views?
We are currently publishing navision as a citrix application (metaframe 1.8, fr1, tse 4.0). The problem is, when users view a job, they all view the last job that anyone worked on. They don't see the last one they worked on individually. Also, when they customize their tables, the settings aren't saved; the next time they…
-
NF-Server 2.50 and 2.01a on one machine
Hello, for developement we use a nf server version 2.50. Cause we also wan't to use the Impulse Workbench, we have to install also a nf server version 2.01a on this machine. I edit the file services (name of 2.01a is ibench so i enter ibench 4211/tcp and try to start the second server...but it failed. But i can't find the…
-
Vorsprung Payroll
We have recently installed a Navsion System complete with Vorsprung payroll. I would be interested in anyone's comments or experiences with this product as we are experiencing some difficulties in using the system. Thanks in anticipation Kennedy Fraser LT Scotland