-
How to display multiple totals in one section of the report?
Hi, I am currently creating a report that will display the totals, the item no.(s) and names of the "Sales Invoice Line". My primary dataitem is "Item", and obviously, my secondary dataitem is "Sales Invoice Line". The grouptotal field is "Unit of Measure Code", and the total field is "Quantity". The user will be able to…
-
setting up the users with user portal
With Navision Financials I set roles in LoginDatabase for my user;then I set up the user in SetupUserPortal specifying the Activity Centers; but when I access data in Navision Financials from a Web browser sometimes I have no permission to access Web part ("You are not authorized to view this page") or sometimes I can…
-
NF2.6 + SQL + TermServer Question
Hi there! I will have to build a site with 25 stores that should have direct access to the headquarter. there will be also 10-20 clients running in the headquarter using lan-connect. because of the geographic distance of the stores we will use a terminalserver to avoid problems with the bandwidth. because the stores will…
-
Validating a Form
I would like to validate our Sales Order Form. I have put some code on the OnQueryCloseForm trigger which checks certain fields to make sure they aren't blank, for example: If "shipment method" = '' then begin currform."shipment method".activate; error('Please enter a value') end; This works great if someone closes out of…
-
Automation variable
We have Financial ver. 2.01. We have a codeunit Word, which have three Automation variables. Whenever I need to use an automation variable, I have to copy this Codeunit and delete all the code, because if I declare a new variable, I cannot choose Automation as a variabletype. Why is this? And what version do we need to…
-
MSI RIS
I was wondering as we are migrating to a complete windows 2000 native environment, if it is posible to make MSI file of Navision Financial 2.01 so that we can make a roll out to all the clients. Or what version of Navision do we need?
-
Automation datatypes
I need to create a C/AL global of automation datatype to create a report in excel. The problem is that I don't have an automation datatype. Does anybody know who I can to add automation? Our Navision license include the 1750 granule. <img border="0" title="" alt="[Confused]" src="images/smiles/icon_confused.gif" /> Thanks…
-
OLAP + SQLSVR2000 + NF2.6
Hello again, Is it possible to access a NF2.6 database on a sql2000 svr via the default odbc driver or do I need a ODBC driver from Navision. I only see like 2-3 tables now in the Analysis Manager (MS OLAP tool), It could also be a relational matter or what ??? Any ideas ??? Thanks, - Arnar
-
Different header on first page
I'm trying to have different header on the first page in report and other pages. I have tried to put a code in presection on the header for the first page: curreport.showoutput(curreport.Pageno = 1)and in presection for the header to display on other pages: curreport.showoutput(curreport.Pageno > 1). But i get always an…
-
Notes email with NF
I've been testing Notes 5 with NF 2.6 and the contact mail buttons give me a resolve name error when there is data in the email field, if there is no data it opens the notes new mail message. Is this a known issue and I should give up trying to use Notes or has someone solved this problem?
-
XML
Hi, Anyone can help me to read an XML file into a table in Navision Thanks anyway
-
Credit Card Verification
We currently are running IC Verify (modem)for third party Credit Card Software. We need a third party solution that uses the web. I've heard of Webauthorize but don't know much about it. During our busy season we expect about 10,000 tranactions (combo of preauthorizations and charges) a day. Any sugestions?
-
CFRONT modifying an existing table
Hi, I’ve written a program in VB that inserts data into a user defined navision table. These tables need two control fields that if not exits the program should create. A datefield and a Boolean. I made a function that checks if these two fields already exist, if they don’t the program tries to add them to the table. I’ve…
-
News...
Hello, this is probably not the right forum to post to but if the moderator sees this interesting he can move it to the appropriate forum or point out to me the correct one.... Anyways I just got back from a technical/sales briefing with some Navision people (Christian Pedersen product director of Attain and Henrik Brorsen…
-
Connection to NF Thru MS Access
Hi Everyone, I just bought the C/ODBC Granule, Installed the C/ODBC Driver for NF and Created the DSN file. I have no problem to have access to the NF tables from Excel. BUT, I having some difficulties to Link the Table from Access. Did I miss Something? Can someone tell why Is it working with Excel and not Ms Access.…
-
Receiving XML
Here is a code snippet.... Im using XML4 from Microsoft. //GET XMLHTTPServer.open('GET', URL_t, FALSE, User_t, Pass_t); XMLHTTPServer.send; //LOAD response into document XMLDocument.loadXML(XMLHTTPServer_laut.responseText); //<--fails fails because the response is more than 250 chrs. How can I do this??? - Arol
-
Upgrading Financials
Ive moved my navision fin server from one machine to another and at the sametime upgraded it and the clients ODBC driver. On a new client I open excel and it says it cannot access the link, then the ODBC config options comes up with the old data not the newly confgiured ODBC link. What am i doing wrong ?
-
Installing client for 2.6 in Windows 3.51
I am doing a client executables only upgrade from 2.00a to 2.60e. Everything was great until they tried to install the client to their Citrix WinFrame server. Unfortunately, they have not kept this application current & it will not run on NT. Of course, the 2.60e client will not install on anything below Windows 95. We…
-
Customer Database
hi new here, and not a programmer or even a terribly competent computer tech. i work for a small manufacturer in california, wherein i'm the default IT guy entirely because i'm younger than anyone else; as such, any acronyms or tech jargon used to answer my question probably won't be understood. i need to take whatever…
-
Decimal
I have a customer who needs to type in 6 decimal places. Everything I try is giving me a '5 Decimal' limitation. This client is on 2.6. Any suggestions? I know that this could be done in the past, what caused this change.
-
how can read a Excel file.
Hello, I succeed in writing in a Excel file. I wish to read a column of cells, of Excel sheet, and then to show the contained in message box. Thank you. Benoît
-
Installing multiple 2.6 services
We want to install 2.60 server multiple times on a server so that the working database for the client is located in a central place and consultants can work on an up to date database at all times. The problem that I am having is that when you go to intall another server, it only gives you the option to repair or remove.…
-
Warning before exiting Navision
Our users sometimes exit out of Navision inadvertently by closing the Navision window. Can they be asked to confirm before exiting? If so, where should the code be placed? There is already a posting about this, but it only works if the user closes the main menu form before exiting. In our case, the user is just closing the…
-
Word Wrap in text fields
Has anyone developed code that will allow word wrap in a text field within a table (i.e. the user simply types the text and Navision automatically enters a new line once the maximum allowable characters has been entered)?
-
List of Files in a directory
Hi, I would like to know how can I get the list of files in a specific Directory. Thanks for your Help <img border="0" title="" alt="" src="images/smiles/icon_rolleyes.gif" /> SL.
-
C/SIDE documentation
Can anyone send me the documentation of the c/side developer license. someone know recommendable books to start developing in navision financials? I´m really motivatet to develop in this application for my new company (our managing direcor is navision fan ;) ) - up to now I developed only in visual basic - I speak German &…
-
case with option string
Is it possible to use an option string in a optionstring ? eksamble myvar optionstring = a,b,c case myvar of myvar::a: begin end; . . end; or case myvar of 'a': begin . . I can't compile any of these eksampels any ideas regards Peter
-
Date Format Problem
Hi All, I use Navision Financial in a VPN with Terminal Services. When I connect with a client all Date format is in the format MM/DD/YYYY instead I want the DD/MM/YYYY one. Any Idea ? P.S. Of Course I set the Regional Options in the client, but nothing happened...
-
C/AL: Setfilter (Nav. 2.6)
Hallo, I want to filter all date fields, were a date value is entered and the date is lower than a special value. The correct filter is <>''&<01.01.2001 How can I do this in C/AL? Setfilter(datefield, '<>''&<01.01.2001'); does not work. Thanks Mario
-
Hyperlink
I Have made a hyperlink from Navision to run an ASP page, which does some file-handling. But the user doesn't need to see Internet Explorer. That is, is it possible to run the ASP page hidden from the user. So that when the ASP page has completed it shuts down Internet Explorer.