-
little Dataport prob
Hi, dos anyone know how to import data (Decimal) wich is in following format in a text file 000098.40 Navision imports it as 9840,00 When i change the Text file into 000098,40 then Navision imports it right as (98,40). Is there a way to say Navision to use the point as decimal separator ?? Thanx for you help Ronnie
-
Space Allocation
Hi All, Can anybody shed any light in this…… We performed a complete Navision Backup, built an empty database and ran a Navision Restore. The following 2 tables then looked like this.... Table G/L Entry No Of Recs 2,432,752 Record Size 590 Size 1,400,784 Optimization 97.1 Table Cust Ledger No Of Recs 2,214,314 Record Size…
-
Server Time
Hello, How as it is could get back in a form, the hour of the Navision server (Windows NT4). Thank. Benoît
-
Open Database
Installed NV on new computer. Runs 2 test databases (Cronus plus another) off the hard drive. Can't open our main live database on Server. Multi-user environment. Other users have no problem. Not at /over user limit. Other server services/files/computers work fine. Positive connected to network. usually get following mess:…
-
OCX for Navision Financials ?
Hi, i'm looking for a ocx that i can use to transfer/receive files from c/al. Exists there one ? Thanks. Best regards, Kai.
-
Suppressing sections in a report
I am reporting off a single table, the G/L Entry table. My body contains debit and credit entries, which are grouped by Document No. and totaled in a Group Footer. If the group footer total = 0 for the document, meaning the debit and credit entries offset for that document, I want to suppress the G/L Entry Body section and…
-
VAT
Hi guys, I have problem for setting VAT. In navision if I using the normal VAT like this : VAT RATE = 10 % Sales = 100 AR = 100 + (10% X 100) = 110 My problem if the total AR alredy including VAT, How shoud I setting up in navision ? Thanks a lo of BR Uli
-
database rename / copy
I tried to restore a copy of our database on a other location/disk on the server. The database is made of 2 parts. company_1.fdb and company_2.fdb I want to use this database in my test environment under a different service. This is running with a one part older database, I want a fresh copy and use the current database…
-
Convert Code to Integer
Hello all, Who can I convert Code data type into Integer? Is it possible? Thanks
-
Import C-side DB in SQL-Server
I want to build a new database for OLAP with SQL-Server 2000. What is the final way to import and replicate the database. I need only some tables. Is the C/ODBC-driver fast enough? (One table counts 3 Mio. lines). What are the alternatives? (OLE DB?) Thomas
-
Re-numbering FOBS
Hi all Does anyone have any experience in re-numbering a lot of Objects all in one go. I wish to re-order them. The problem i see being that the links within the forms, reports etc do not automatically update when you change the Object number. the only way i can see to do it is to export all the Objects to a txt file and…
-
OnInputChange
Hello, does anyone know how to get a hold of the text in a textbox on its OnInputChange Trigger ? The textboxes sourceExpr is a global variable but everytime this trigger fires the global variable is empty... So how do I get a hold of the data in the textbox on this trigger ? - Arol
-
Reading barcodes via handheld
Hello I have a problem <img border="0" title="" alt="[Smile]" src="images/smiles/icon_smile.gif" /> Im runnin a navision client on a handheld through cirix. The handheld has a barcode reader.. now when I read barcodes navision doesnt treat the tab character as keyboard input so i always have to delete the last char and…
-
Oracle and Navision
Hello everybody ! I'm searching informations about access from Navision to an Oracle DB in real time. Is it possible to have some details for such connection ? Thanks for all.
-
Error on Rec delete
hi I have problem ... In the OnOpenForm() trigger is needed to delete the active record (Rec). I have done it with DELETE command but on trigger exit it runs error message (There's no such record in the table TTT) and closes the form. However record is deleted from table and on next start of the form everything is ok. So…
-
C/ODBC and Permissions
Hi. I have a client that wants to give me read only permission to connect through C/ODBC using SQL Server to copy table data. She has given me read and execute permission on all of the tables that I need to read. But I still can't connect (No Permission) unless I use an account with full permission. I have no knowledge of…
-
SQL Server Linking to Navision C/side
I have Navision with a C/side db and am building a new application in Sql Server 2000. The idea is to look-up tables in Navision from Sql Server. When performing a query from within SQL Server the following error message is returned on Code fields. select No_ from openquery(NAV,'Select No_ FROM Resource') Server: Msg 7347,…
-
Searchin for OCX Control
I am searchin for an OCX Control for a balance. Its called Minipond 25-PMN ? Does anyone have an ocx for this balance or does anyone know how to programm OCX'es, or know someone who programms ocx'es for low price ? Thanks for your help Greetings Ronnie
-
Data Archiving
Our client is using Navision Financials (2.5) with an add on. Problem? Database size grows fast and impedes performance. We need a method to archive data on a quarterly basis. Has anyone experiance with doing this in this environment, and if so what do you suggest is the best approach? Thanks.
-
Acrobat PDF Writer - save as
Hi, I want to use the Acrobat PDF Writer to send PDF invoices to our clients by email. Therefore I want to save the invoice as 'invoicenumber.pdf', but I can´t find out, how to pass over the 'save as' dialog and set the filename directly. After some time I found a way to set the path fix in the windows registry. Now I can…
-
Mail and Automation
I'm using codeunit 397 (Mail) successfully, except when the outlook send dialog opens, the user can't click around the rest of outlook unless they close the send window. They can't even minimize the send window. Is there a setting where I say whether or not I want that send dialog to open modally or not? Additionally, how…
-
Manipulating printers in Navision
Hey, I need to be able to print reports on different printers without using the printer selection window. Is there anyone out there who knows how to do this ?
-
Reservation
Hi, I try to reserve spesific item for spesific customer in Sales Order . After that, I get confirm customer and agree, then I want to make Order - Shipment. How should I do to change the reservation become Order ? Could you anyone help me ??? Thanx for you help BR Uli
-
Create a PDF File with Navision Fiancials
I would like to create a PDF file by running a report (p. ex. 206 sales invoice) and then e-mail the new file. How could I do that?, Is it possible?, Thank you all
-
Hand Held Devices/WAP
Has anyone ever used a hand held device or WAP to connect to Navision? The interface needs to allow sales invoices to be put into Navision.
-
Printing Reports with colors
I can't print reports with colors. I change colors in the report but always appers black and white.Why? Thanks and sorry but my english's very poor.
-
Table keys in Symbol Menu
Hi, everybody! Does anybody know if it is possible to view list of keys for some Record variable in Symbol Menu, like it is done for Field names? It seems that is not possible (you should go through Object Designer -> Tables -> Keys, etc.) to copy it), which is inexplicable.
-
Warehouse Automation
Has anyone created an interface between Advanced Distribution and a robotic stock picking device? The concept is to have Navision send quantites and bin coordinates to a device that will pick the order and report the results in a manner that will update the warehouse document. If anyone has accomplished this, I would…
-
Printing Reports
I want to run a report without using the request window but the report has two dataitems and I need to set filter for the second dataitems. How can I set filters for the second dataitem at runtime?
-
Choosing a File from the Normal Dialog Window
Hi, In my Dataport, I would like to let the user choose his own file Name, but I have also several criteria on the same form. When I run the Dataport, My Dialog Box for the Selection of the Window is not open. I donot have the OCX License. Please advise how can I enable the Seletion of Filename from my Request Form. Thanks…