-
Physical Inventory Check
We have made a pretty nifty collection of objects (and procedures) for this, utilising a bar code scanner to get info into Navision ön a rush. anyone interested? Pelle
-
Shop Floor Scheduling
Does anyone know of a 3rd party shop floor scheduler that will interface to Nav. Fin. (Standard Product)? This customer is a Job Shop. Looking for help.
-
Auto numbers
Hello! I just can't figure it out. When I create a new table, I want the Primary key to be a number. I want this number to be automatically generated, using the custom configuration settings of Navision. How do I do that?????????
-
Importing objects
We have a client who is running Navision as hundreds of stand-alone databases that get synchronized with a central database. We're trying to figure out if there's a way to make fixes to all these stand-alone databases without the users just copying in a whole new updated database. Is there any way, for example with…
-
Moving to SQL
I have been trying to create a "new" database using then MS SQL Server Option for Navision but I keep getting the same error message: "An ODBC error occurred, but no error information could be retrieved." Get this message either locally or remotely. If I try to open one of the sample databases it says it is not a Navision…
-
EXTREMELY WEIRD 31 Characters in a 30 Character field
I was doing test restores on the new sql version and have come across something dead weird. I backed up our original db and then tried to restore the database. On the sale shipment header table i got the error The sales shipment header table contains a field with a code or text value that is too large for the SQL server…
-
OnInputChange-Trigger
hi there! I want to trace a input in a textbox (with an global as source-expression). Everytime the input is changed the OnInputTrigger is called - but how can I fetch the value of the field? I want to enter a number (say itemno.) and if I enter a * the code in the OnInputchange should catch that and call a function.…
-
Looking for new NSC
I am the IT Manager for a restaurant equipment distributor. We have purchased Navision Advanced Distribution 3 months ago. Our previous NSC did not work out. I am looking for an NSC with active AD customers and experience in distribution and warehouse management. We will be using the RF based warehouse management in AD. We…
-
Opening another company in Navision
Is there a way to simulate the CTRL+O command in Navision. I want to make a form with a button on it which changes the active company in Navision depending on the values in my globals.
-
AutoLaunch Objects
We are looking for ways to automatically launch programs in Navision. Our intent is to run long updates and reports (such as the Adjust Cost / Post Cost Update in Distribution) during the night. I've tried the product from ExpandIT with no luck. Does anyone else have an idea? Perhaps some type of macro recorder? Thanks in…
-
Using two versions an Excel automation in the same codeunit
Hi all I have a small question on automation between Excel and Navision. I have created a codeunit calling Excel using the Excel Object Library(version 9.0 - distributed with Office 2000). But I need to support the version 8.0 of the library as well(distributed with Office 97). I need to control how to use the codeunit…
-
Order Control
We want to display a confirm message to the user if the current order as not been printed (or other similar checking) like : if [leave current order] and ("# printed" = 0) then if not confirm('The order %1 had never been printed, continue ?') then Don't move ! And to stay on the current order without confirmation. This…
-
Oictures in Documents
Anyone know if it is posible to place a picture on a document such as a company logo on a sales invoice? If so, how would you do it.
-
accessing ORACLE
does anybody has experience on accessing oracle from Navision? I am using NF 2.5 with SQLServer and I can read oracle tables (linked tables) but i get an error when i try to write. somebody told me that it is an ODBC problem but i didn't find any troubleshooting in the MS site until now. thanks for any help…
-
Writing to Navi tables using SQL
Can it be done? I assume there are issues with flowfields, but is it possible to use SQL to put data directly into a Navision table? What does it take? Is this a recommended practice? My client will be using SQL7 with Nav2.50. -Greg
-
form doesnt recognise Control#
What the hell? I've gotten a pretty simple form running, half feeding of a table, half being calculated, and I have an unbound label that I just use to make visible or invisible(to display a message on each case) for some reason, it worked fine before, and now, though there are no compile errors, I always get the message…
-
SQL Stuff
Hello, Anyone have some Discribtions of Navision 2.6 and SQl Server- - How many Clients can work on one (two) SQL Server - Is the SQl Server the same like the Navision Server - Performance (Hardware) , Clients - Stability, Security, ... i am very glad if you can send or post same Fact Sheets ! Best regards Alex Schubert…
-
Retrieve Table No. within C/SIDE
Is it possible to retrieve the table no. of a current record?
-
Primary key
Is it possible to retrieve the primary key of a table within C/SIDE? (I know it's possible with C/FRONT but the Function nextkey does not work in Navision...(very nice...))
-
MS Project 98 & NF
Hello everyone, I've got the following problem: How can I switch from base calendar Standard to Night Shift/24 Hours base calendar? I've only got a button on a form and I just want to change the base calendar from Standard to Night Shift. In MS Project 98 you can find it bij doing the following instructions: Resource…
-
project 2000
I am looking for any example between project 2000 automation and navision finacial too
-
Auto Shutdown of Navision session
I have several questions: 1. Can anyone show example of a code that will auto shutdown Navision client if no activity has beed detected for pre-determined priod of time. My main issue is security. People leave their stations without logging out. I have Nav 2.0 which does not have timer function. I looked at commercial…
-
Passing a variable to a dataport
When calling a dataport, how would you pass a variable such as the name of the template and batch for example.
-
Switching Records in active form
It seems to me that this task should be a simple one, but I cannot find a way to do it. The case: I am in a form (for the sake of argument, the Purchase Order form) viewing a record (for the sake of argument, Type="order", No.=3). Within the code, I have determined that I want to be looking at No.=27 instead. What I want…
-
moving registers between DB with Replicator 3.0
Hello, I need the Replicator 3.0 to move (not copy) registers between data bases. Therefore when the origin table is replicated in the destination table, the registers replicated are deleted from the origin table. Is this possible? How do I do it? Regards. Salu2 Jose A. Saiz [This message has been edited by josi (edited…
-
Navision SQL Option Locking Error
I created a few tables in a Navision 2.50 SQL database. These tables are linked to tables in other SQL database. I have no problem at all modifying these tables in Navision manually. But when I tried to use a codeunit to access these tables and modify them, I got a SQL Server error message, saying "Cannot specify UPDLOCK…
-
Remove or Re-nameDataport Import file
I would like to rename or completely remove the import text file used by a Navision Dataport. This is to insure that the file is not imported again. Any suggestions?
-
Microsoft Project 98 and Navision Financials
Hello, i'm looking for some examples of automation between MS Project 98 and NF. Thanks!
-
Lookup dependant on predefined option
I am a new developer, and I am looking to be pointed in the right direction. I am trying to use a lookup that changes, dependant on an option. Could anyone suggest an object that I could look at for some ideas. Thanks Dean Axon
-
Printing to Barcode Printers
I am trying to write to a TEC B482 printer. Unfortunately the manual is very large and taking some getting through. Has anyone worked with one of these barcode printers before, and if so could you point me in the right direction as where to start, and what has been found to be the best solution. Thanks in anticipation