-
Using a Dataport to modify non-Dataport fields
I'm fairly new to development in Navision, so if this is something really easy that I've just overlooked, I apologize. I'm working on a dataport to pull in our order information from our barcode scanning system into Navision. However, there are a few fields I'm trying to write to the database based on values in the…
-
Permissions
Hi there, I was wondering if anyone out there knows exactly how assigning explicit permissions to a Report or Form works within Navision? For example.. only a select few ppl have been given access to a User Role that has modify permission to the custom table 50001 Contracts... however.. I need to allow almost all users to…
-
Print Defaults
Hello...I have a fairly simple (I hope) inquiry. Does anyone know how to change the default number of copies when printing forms (e.g., invoices)? Thanks
-
Scanning for messages
Hello, I'm working on a program that should react when a certain button is pressed in Navision. I have experience in VB but I do not know how to go about this. I know I should scan for a message and if this message is found, the program should react. What I would like to know, is which message I should scan for, to know…
-
Reading information on a website
I've made a small report to check if the VAT number is correct, using an EU database: (Report --> On after get record of the relation tabel) LinkTxt:='http://europa.eu.int/comm/taxation_customs/vies/cgi-bin/viesquer?MS='+ DELCHR(COPYSTR(Relatie."BTW-nummer",1,2))+'&VAT='+ DELCHR(COPYSTR(Relatie."BTW-nummer",3))+'&Lang=NL';…
-
Navision and Zetafax
I need help for send various purchase orders automatically. how can i do?, what code i need? i tried open a internet explorer and print for zetafax printer but its a bite slow. can somebody help me?? thx Vísperas. ======
-
Excel automation
Hi there, Does anybody know how I can turn the page orientation around in Excel? From landscape to portrait and vice versa. MaikelJ
-
Pdf417
Hello, I would like to print PDF417 barcodes from Navision. I've searched for information on the internet but i can't find any starting points. Can anybody help me or does anybody have experiences with PDF417 and Navision? Thanks, Henry
-
Formating numbers in reports
Hi! I have a problem - I need to format numbers in report so, that they are without seperated thousands, e.g. 13000 instead of 13 000. Have you any idea if I can do it and how can I do it?
-
Automation server
What do I need if I want to use the automation server function. I know that such a thing exists, but that is it. I have never done any programming using it. Do I need Visual Basic knowledge? Thanks Regards Sandra
-
Using Break Command
I trying to use break command to exit from a loop in a data item, but it causes the exit from the all trigger and not return control to the statement inmediately follows the loop. any idea why?, I´m using 2.00 ver of NAVISION. Thanks a lot.
-
upgrade navision version ES 2.00 C
Hi, I would like to upgrade navision (ver. 2.00) to other version. Is it easy to do?, is it necessary reprogramming? Thanks.
-
Word automation
Can anyone help me with the following problem? I've created a report that uses automation to export data to MS Word. I want the text placed at the boomark to be bold. For this i wrote the following code: NameBookmark := 'BookmarkA'; WordBookmark := wdDoc.Bookmarks.Item(NameBookmark); WordBookmark.Select();…
-
C/ODBC Crystal Reports Citrix
When I use my Crystal Reports Report on a Windows NT desktop everything works fine. When I try to use the same Crystal Reports Report over Citrix I get an ODBC driver error: "Unable to do Order By". Can anyone help?
-
Running Reports at night
Hi there, One of our international client's run reports for heaps of different states, and therefore when they run them at the same time during the day, this slows down the whole network quite dramatically. The client would like to overcome this problem by having Navision automatically run a batch job (eg. 7pm each night)…
-
C/ODBC ADO & SQL problems
Tried importing data (Posted Invoice & Cr Memo tables & Posted lines tables) to bring data in from NF 2.00 into Excel 2000, using C/ODBC and First case: using SQL (following example on Navision CD) Problem here was that no matter what I tried I could not get it to bring in more than 16384 lines. MS says 16384 is max number…
-
Errors
Hallo, who knows that Error? Other activities have use the space that was reserve for this activity. This situation usally ocurre if long transactions runnig. In the error were told, to make more space! But space is not my problem! In the past, i had this problem and within 2 hours the database was break! At this time I…
-
Navision Finacials 2.60 on AIX 5L V 5.1 (P630) ?
Hello, we wan't to upgrade our Hard/Software :) So we decide to buy a new P630 from IBM. Also we decide to use AIX 5L V 5.1. Are there any problems known with this Version of AIX and Navision Financials 2.60 ? Thanks for your afford :wink: Best regards, Kai.
-
MS Project time
In MS Project there is a date/time called finished. Want to write and read this property of the task, but I can only get and set the date. How do I control the time part of this property? :?: Thanx.
-
CODBC/ADO/ISAM Errors: What I have learned so far...
I have been researching what has been causing unexplained ISAM errors in our internal VB software that interfaces with Navision Financials (US 2.00). When the ADO Update method is used, an ISAM Error is returned from the Navision ODBC driver. Reading the database works fine, but writing to it causes this error. After…
-
Impossible to Write in the C/Side db with ODBC
Hello. I explain what i want to do. We have a Web site to take orders .... What we want is to make a communication between the Web db (in SQL server 2k) and the navision's database. I try the C/ODBC connector whitch is on the install CD -Navision 2.01A FR -C/ODBC 2.11.00.924 So, the update of the SQL server db with…
-
Have to use C/ODBC?
I know this has probably been asked before, but do you have to use a C/ODBC driver to access NF 2.00? Have C/ODBC version 2.10.00.10 - it works Just wondering: 1. If one has to use a C/ODBC driver, if not, what else is good? 2. If have to use C/ODBC, is there a better version for NF 2.00?
-
Access Navision Tables via SQL ODBC
When you want to access pe. the item table stored in a SQL Navision via SQLODBC to a access database you probably have problems with the the field Item no. because a . is not an allowed character. Also some customers of us have problems with the table names because they contain a $. I tried different options but none seems…
-
FINANCIALS 2.6 and CITRIX XP display problems
We have recently installed Navision Financials client v2.6 on our Citrix Metaframe XPa server(which has Future Release 2 installed) running on Windows 2000 SP2. When citrix users run Navision as a published application they recieve screens that are all covered in black blocks and you cannot read the dialogue boxes or…
-
W-2 Form for 2002 problem
I have a problem with the state withholding on my W-2 forms for 2002. Are the Payroll Tax Form Classes (codes) loaded each year as the forms change?
-
Print report on site preview?!?!
:?: Why it is not possible to print some reports from the print preview? Message : "Please close the preview and then print directly" Before i checked the reports, the "LoopCopy" - DataItem was the reason, but in this report there's no one. Can someone help us?. THX
-
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.…
-
IDAutomation
Help, is anybody using IDAutomation fonts to print barcodes?
-
Importing a JE
I am new to Navision, but I have worked with other systems (PeopleSoft, Great Plains, etc) I am looking for help on Dataport. I have two requests which I think should be fairly easy. The 1st is importing a GL Journal entry. The second is importing cleared checks. Any examples would be greatly appreciated.
-
Barcodes with IDAutomation fonts
Did anybody use IDAutomation? I bought the fonts do I need to buy the DLL in addition? Does anybody have some experience?