-
Tips&Tricks: Excel Automation
I notice that in this forum (and not only ther) the same questions and problems concerning Excel automation are being asked over and over again. So let me share some of my experience with you: --- DECLARATION --- Name DataType Subtype Length xlWorkbooks Automation 'Microsoft Excel 9.0 Object Library'.Workbooks…
-
Navision and Word
Hello, I took the program "NF automation Examples" to do my first program with Word. It doens't works ! I receive this message "Impossible to activate this application". Do you know what it's wrong ? wdApp : Microsoft Word 9.0 Object Library - Application wdDoc : Microsoft Word 9.0 Object Library - Document wdRange :…
-
Translate Navision Objetcs
I search for a tool to translate our add-ons Navision in multi-caption, who would use a file created with tools / translate / export to create other one of it with a second language code. Thanks a lot Etienne PRUVOST GESWAY S.A.
-
MAPI call and Carrige Return
I need to generate a list of items and send this via outlook. The email connection works fine but I cannot send a carrige return/new line with each text item. I have tried asc(10) and chr(10) but Navision sees these as undeclared variables. The following also doesn't work. CR is declared as type character. CR:=10;…
-
Add-on for "Transport of Dangerous goods"
Hi ! Has anyone worked on the Transport of Dangerous Goods issue ? Is there maybe an existing add-on ? I'm interested in any possible information, especially according to the EC rules : Directive 94/55/EC and amendments, packaging and labelling requirements... Thanks for any information
-
I need new projects/ideas :)
Hi all I'm desperately seeking some ideas/projects that might help Navision customers or NSC. I running out of ideas myself. So if you have any suggestions or ideas on what might be a nice thing to have in combination with Navision, please post a comment on this thread/Forum or send an E-mail to draupner@jubiipost.dk. If…
-
C/SIDE Tips&Tricks
Hi everybody, In march this year, Navision Switzerland started a little competition amongst Fin developers about the most usefull C/SIDE tricks. The result is nothing which would make an experienced Navision programmer jump out of the chair but nevertheless some of the tips might be useful, especially for newbies: ---…
-
Navision 2.6a & SQL Reporting
Greetings All I am Rather new to SQL Server and how it works. So sorry if this is a stupid question. I am trying to generate reports using Crystal Reports 8 directly from the SQL Database. This is fine, but I have a problem with joining tables seeing as (according to Crystal) the key fields available are different on the…
-
Passing Variables / strings to a report at runtime
Hi, I have a report that can be run from two different areas of the sales & Receivables, Sales orders and Sales Shipments. The reports data comes from an area not related directly to sales order line or sales shipment line, but if i run the report from the sales shipment form i want to include three items from the sales…
-
trouble referring to 'Date' virtual table from C/ODBC
I am having problems referring to the 'Date' virtual table using SQL via the C/ODBC driver. Any mean of going around this? [This message has been edited by Jordan Ng (edited 10-07-2000).]
-
How to make corrections?
I would like to delete or change details of invoices once they have been posted. Is this possible without using journals, as is possible in Sage?
-
Planning tool with Navision
Hi all ! I'm looking for a good graphical planning tool (for manufacturing automation) wich works with Navision. Datalink can be ODBC or OCX system, but i want the planning tool has a R/W acces to my Navision data. Do you have experience ?
-
Navision (network)
Hello Folks, We want to use Navision over more the one locations (three), and right now we look for a good solution. Maybe one is to have one Navision server and all the client must connect through a network line 2Mbytes. The other idear is to connect the other clients via Citrix. Have anyone of you some experience in this…
-
SMS from Navision
A customer wants to edit SMS - Messages in Navision and classify them as like the Remarks behind Customers, Projects, Sales... Has anybody realized or does anybody know where I may get an add-on for? <img border="0" title="" alt="" src="images/smiles/icon_confused.gif" />
-
Outlook as Scheduler for Navision
One of our customers would like to use Outlook as Scheduler for Navision Financials or even as a kind of CRM - Tool. Does anybody have experiences with? Thank you for help Christoph
-
Oracle, Informix, Sybase and Navision?
Anyone has heart about this subject? Is Navision planing to develop financials on other platforms besides MS SQL?
-
Tips for intl Excel sheets
Hi programmers, If you create an excel worksheet using Navision Automation, you run into a problem if your application should run in different countries as Excel formulas are language-dependend. This applies for example to the "SUM()" formula which reads "SUMME()" in German Excel. My Tip: Use the Application.International…
-
CALCFIELDS from SubForm?
I have a form with an Flowfield and a subform. I want to calculate the flowfield in the form from the code in the subform! Can anybody solve this problem ?? Sneakyfall
-
Using CFRONT.ocx from within NF2.5
Hi :5) , the following problem : Tried to use cfront.ocx from within navision financials : everything went ok except for the ASSIGNFIELD method which requires {hTable,hRec,FieldNo,FieldData) The problem is with the last VAR : its type is VAR VARIANT. In NF Help it is said that NF converts from/to variant any of the types…
-
Licensed sessions
Does anyone know how I can determine the licensed sessions in the C/AL code? Thanks Thomas
-
ODBC Drivers (inner and outer joins)
Does anybody know of Navision ODBC drivers that can cope with inner and outer joins - besides the Vorsprung ones? I have a client who wants to connect to Business Objects through ODBC. As far as I can see the only option for this is to use the Vorsprung drivers that can only be bought as part of a full reporting product…
-
Deutsches Zahlungsmodul für Schweizer Kunden?? Hilfe!
Hallo Leute, Im Auftrag eines Schweizer Navision-Kunden, der auch Zahlungen über deutsche Banken erledigen muss, habe ich den Auftrag erhalten, das deutsche Zahlungsmodul in die CH Lösung einzubauen (Fin 2.60A). Problem: Mit meiner Schweizer Entwicklerlizenz kann ich die Objekte im Bereich 50019xx nicht ansprechen. Ich…
-
Use of MS Graph in Navision
Hy all ! I want to use the MS Graph Automation but I've got an error message about the license. I don't know if it's a problem with MS license or with Navision license. Could you help me ? Is someone had developed some Navision applications with MS Graph ? I'm trying to find some examples ... Greetings
-
Lotus Notes & Navision Automation
Have anyone tried to send a Lotus Notes Mail by automation from Navision Financials ??? I have tried to do it and it crashes. If someone can help please lmk. A lot of thanks IT Developer MPS Spain
-
Experience with Citrix
Hy all ! I'm looking for someone who has experience with Citrix. How many users have you ? Wich connexion speed do you use ? What about your server ? Thanks !
-
Luc's Chat Room
Hi Guys Why don't we try Luc's Chat Room one day soon?? It would be nice to have a general chat or a Specific Topic! It would just be a matter of what time and when! If it were a success it could be a regular feature! Anyone up for it? Topic/Day/Time ?
-
Object ID
Is there any way of working out the ID of the object the user is running from code?
-
Search trough MS-Word documents
Is there a way ( without doing the search trough openning a file and the read the lines)to search MS-word ( or other) documents on a phrase given by the user. Maybe the Windows search function trough an OCX, or maybe the search function of MS-word trough automation controller? Would be great for document management from…
-
Copy of cells in a Matrix form
Hy all ! I try to implement the F8 function (copy of previous cell) in the right part of a matrix form but I don't know how to do that. Is someone could help me ?
-
Navision and Axapta
Beside of Navision Financials there is another well known danish ERP Solution called Axapta. Did somebody make any experiences with? - What do you think about quality, structure, pricing?