-
Simpe question
Hi friends, I want to mail from the marketing modul,from the campaigns. A button calls a report, based on the campaign-lines. So far so good. But how can I post automaticalle the campaign-number into the requestform of the report? <img border="0" title="" alt="" src="images/smiles/icon_eek.gif" />
-
MS SQL 2000
I use Navision Financials 2.60 on Microsoft SQL Server 2000 and I have problem with sorting text and code fields. I mean, on native db we have e.g. this order: 1, 2, 3, 10, 12, 100, but on SQL order looks as follows: 1, 10, 100, 12, 2, 3. So could someone help me to solve this problem? Please, send answers on my private…
-
Update-Crash after addnew with odbc-connection
Hi there What's wrong, that cause this error:[Navision Software a/s][Navision Financials ODBC Driver]ISAM errorOption must not be blank.Option is missing or invalid in the expression I try to update fields of type "code" or "decimal" in a table by odbc-connection (V2.6d). It's possible to update fields of type "integer"…
-
Bar Coding
One of my future projects involves finding a BarCode/Scanner solution that has been proven to work well with Navision (currently, running v2.5. Planning on upgrading to 3.01 in Q1 of 2002). Anyone out there using barcoding who can point me in the right direction would be greatly appreciated. Thanks!
-
Very long strings
Hi! I write a small Report that delivers some Navision-Tabledata to one of our MySQL-Servers. This is working so far. But... Now i wan't to export a Table with much fields so that the 'INSERT INTO *'-String gets very long (round about 1000 chars). If i try to write the string to a file: FH.WRITE( 'INSERT INTO test…
-
Remote Connectivity
I need some help. I know that remote connectivity has been addressed for Navision Financials, but I needed to know if anybody has found solutions outside citrix or PCAnywhere to setup remote offices. I currently have a 1.5 Mbps DOWN and 128Kbps UP DSL line to my remote location that I am considering turning up to 7.1 Mbps…
-
test part of fixed legnth string
Is there any way to test only part of a fixed length string example : myvar = text test = copystr(myvar,1,8) case test of 'ABC*****' : 'ABCD****' : 'ABCDE***' : end i'am looking for some sort of "joker" sign to use in a textstring '*' do not work Regards Peter
-
Keys
In one of our tables we have 27 active keys. Since the table (I am speaking of table no. 32) is extreme slow I asked our NSC if I should combine keys differently and reduce the number of active keys. The answer was NO, I could keep all indexes active they were not responsible for slowing the table. I thought too many keys…
-
UML and Navision
Hi, Anyone can help me on some samples off the UML notation and Navision? Thanks <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" />
-
Convert report to a text file
Is there a way to convert report to a text file? Basically we want to convert a report to multiple copies of same text file, and then add different contact name, company name and fax number or email address to become the first line of each of the text file. We will save them in the server and the fax or email program will…
-
Printing barcodes from Navision
I could print barcodes from Navsion using both 3 of 9 and 128 fonts, but I could not read 128 barcodes using my WandReader, even if I added * to the beginning and the end of the data. 3 of 9 barcodes could be read but they don't look good. The height is too short and the width is too long. Please help.
-
Outlook Forms
In Outlook 2000 I have put som vba behind a form. This is because we need to categorize each E-mail that is send. But, when I send an E-mail from Financials it doesn't use the form with the code behind. It uses a standard Outlook form. Why? Is it somewhere in the registration database.. Thanks.. <img border="0" title=""…
-
Simulate Button Click
Is there any way to simulate a click on a button through code? Basically what I need is the following: On the Job List the OK button's PushAction is LookupOk. I have another button Sort (on the Job List form) that (on its onPush Trigger) run's some code first, then if it changed the current record on the Job List, I need…
-
ADO
Hi, Please can anyone help me to build a good function to retrieve a recordset in vb with ADO. I can make a connection to the navision data, but retrieve a recordset don't work. He always give me an error. [Navision Software a/s][Navision Financials ODBC Driver]Expected lexical element not found: thanks <img border="0"…
-
Report/Request Form
Is there any way to get the Rec passed to a report using RUNMODAL(REPORT_ID, TRUE, FALSE, Rec) on the Request Form? Even if I can get the filter that shows up (and then I can get the record myself) that would be okay. E.g. If I run the Purchase Order Report from the Purchase Order Form, the Request Form shows the No.…
-
automatic changes on related tables
Hello, Where can i tell NF 2.01b to make changes on my created table, too? You know: when you change the number on table 27 you get automaticly the change on the tables 32, 37, 39 ... How does this work? It is not made by onModify-triggers or i hadn´t found it. Any help? Ralph <img border="0" title="" alt=""…
-
OKI vs WIN 2000
Hello, i have some problems with OKI Matrix Printers under WIN 2000. Theres no chance to print in "German Fanfold" or any other "Fanfold" under NF 2.60. I choose the Printer in Windows as "Default" and the Property "PaperSize" in the Reports, but theres no Change. Then i saw a bad thing: The "default Papersize" in the…
-
Vertical writing in a textbox
Hi ! Has anybody tried to write vertical instead of horz. in a textbox. I'm about to make a report, were I need that functionality. Y.S. Oscar T. Simonsen <img border="0" title="" alt="" src="images/smiles/icon_confused.gif" />
-
Department Filter on Account Schedule Line
I'm looking for a modification that will allow different lines on an account schedule to filter on different departments in 2.60. I realize this functionality exists in Attain but will not be able to upgrade for a while.
-
Printing to PDF... yet again
Ok... This is what I want to be able to do if it is possible. I have the full version Acrobat Reader (i.e. Acrobat Writer... the one you pay for so I can create pdf files). Now, on the request form I want to have an option to e-mail the report. However, I cannot figure out how to automatically print the pdf file (i.e.…
-
SQL setup
Are there some guidelines from Navision about minimum setup for SQL server? If someone have material about SQL setup it would be nice to get a hold of it. Thanks <img border="0" title="" alt="" src="images/smiles/icon_confused.gif" />
-
State and focus of navision windows
Hello Is it possible to get back the state and the focus of windows opened in navision. If it is possible how can one do it from another window, Thank you for your answer, sincerely Benoît.
-
ADO/ODBC ISAM Error
Hi, This is a piece of code Outlook VBA code that should fill a job journal line for a new appointment that is not private. Each time I run this, the navision ODBC drivers returns an ISAM Error on the update statement... Any ideas? Dim WithEvents mcolCalItems As Items Private Sub Application_Startup() Dim objNS As…
-
Outlook automation
I'm reading appointment items form outlook to process in Navision. The start date and time as well as the end date and time are both in a datetime type field in OL. In NF, there is no datatime type <img border="0" title="" alt="" src="images/smiles/icon_rolleyes.gif" />, and it is converted to the date type, hence losing…
-
"partner function"-like question
Hi everybody, I currently am a navision prospect: my company builds and sells mechanical machines. I have two questions for you navisioners: 1) How can I handle a commercial triangulation? That is, very often we sell the machinery to a trader or to a bank, whilst we sell accessories and maintenance directly to the final…
-
Block Item per Customer
We would like to block certain items per customer or even through pricing groups. For instance, all customers in Price Group A can buy any item except item Z. We could just set the price so high that the sales order would go into credit hold, but we'd like to do this some other way. Thoughts? <img border="0" title=""…
-
File text and NF
Hello, How can one create a file text in the root of the hard disk, then he transferred by the data of Navision (example, code and name of the customers) at first time? Next, How can one read it sequential of Navision.? And the end, then how can one destroy it? Thank you for your invaluable help, Benoît.
-
INSERT INTO ADO ODBC
Nearly finished with a small project I am working on to export attachments from Outlook directly into Navision. Through the Navision ODBC I can SELECT, UPDATE sucsessfully but I cannot seem to INSERT rows into the database. The code which is supposed to do this follows: DocID = GetNextNumber() strImagePath =…
-
Posting Batch Job - HOW-TO
I have my own table of documents and want them to be posted to the journal (I also create journal myself) - how to write this posting procedure? I mean, where can I see some examples? <img border="0" title="" alt="" src="images/smiles/icon_confused.gif" />
-
Navison slow on sql 2000
I did a small testprogram to compare the performance of Navision in SQL vs. the native db. This testprogram wrote certain amount of integers in a table and then read them back again. with million integers it took 9 sec to write them and 28 sec to read using the native database. However at the SQL db it was more than 3 min…