-
Install Nav License on a server vs on PC's
Hi there! Our technical guy is not available and I would like to have steps to install Navision license version 2.01 ( or 2.10 ) on our customer SERVER and on some local Pc's ( about 5). Please can someone gives me steps to do that locally and on the server? Thanks
-
TCP/IP error ETIMEDOUT
Hi, I have a strange problem concerning one single user of Navision Financials 2.60D. Very often the user experience being logged off by navision after being showed the error message (TCP/IP error ETIMEDOUT) We have checked the linespeed between the users pc and our navision server and it should be ok. Furthermore we have…
-
Fiscal Year Closing
As this is the first time for us to use the application and it's almost the end of the year, does anyone know how to close the fiscal year? Thanks in advance!
-
Actions Table (99001509)
Hi, I am still quite new to Navision and i'm wondering if there is anything associated with the Actions table within version 2.6.03. For our system table 99001509 contains fields such as... Entry No. Source Counter Location Group Filter Action Table No. Key I'm not quite sure if this table is something that has been setup…
-
Posting Periods / Ultimo Postings
Hi all, we would like to use more than 13 (Jan..Dec + Ultimo 31.12) posting periods in our G/L. Has anyone expierience if this is possible in Navision 2.6? Thanks in advance for feedback. Rgds
-
Connecting to Navision from .NET C# App
Hi everyone I am currently working on a .NET app that must be able to connect to Navision systems (Financials and Attain in various versions) and do so without making any preparations within Navision (treat it as a black-box). I am considering to make my own wrapper for CFront.dll, as I can see others are working on as…
-
mail + attachment
Hallo, I still have a Problem and I don't know what i can do. I want to send a html File with Navision but not as Attachment.... I try to send it as mail..the html-file has to be the mail-body. Is there anybody who can solve my Problem??? Here are the CODE: MAPISession.DownLoadMail := FALSE; IF MAPISession.SessionID = 0…
-
Job cost / Price group codes -> Job usage on invoice
I have items we set the Price according to the vendor we purchase it from. We have Price Group codes for these items but do not use the codes on the customer card. We issue a PO and include a job number so the material costs are posted to the job. Since Price Group Code is not available on a PO, I can not figure out how to…
-
2.6 standard DB migration into SQL DB
During a test run of a SQL upgrade of our Navision 2.6 product we encountered some bad dates (expressed as 01/01/0025, etc). We have come to learn (from reading these forums) that this has happened to several other users as well. In response to this problem a codeunit 104015 was developed contained within the migrate.fob…
-
Navision 2.60 and ORACLE Warehouse Builder 10g
Hi: I'm trying to read Navision 2.60 data into ORACLE Warehouse Builder 10g (OWB). The system was quite difficult to set up because the ORACLE database is in a Linux machine. But we managed to make all the connection thru an OpenLink ODBC-ODBC bridge. We test the connections in OWB, with an Oracle Link, and it works... I…
-
Recently converted from Proprietary DB to SQL DB
We recently converted our 2.60f database from proprietary navision (50 GB) to SQL Server 2000. Our end users in areas that are more transaction intensive (for example: Manufacturing-BOM Certification, Inventory-Item Journal Posting & Manufacturing-Releasing Production Orders from Sales Orders) are experiencing slower…
-
Considering Navision
Hi All I am new to this forum. We are a company that is considering purchasing Navision as our ERP solution. We would very much like to contact some existing users to gauge their opinions on the product. If anyone would be prepared to contact me, please email me on stephen.connor@halian.com Thanks & Best Regards Steve
-
Exporting to Excel
I have a report that I export to excel and it was fine till I added to the output. I am trying to add a lot of text to one cell (up to 20 lines of 200 characters) with this code. The labelline variable has a dimension property of 20. My problen is it bombs out with 'There is not sufficient available space in the C/AL stack…
-
Navision 2.60 ODBC small problem with a SELECT
Hi! How are you doing? We have a small problem and I wonder if someone here could give us some idea... it's not very important anyway but... curiosity killed the cat From SQL Server 2000 DTS we're accesing Navision Financials via ODBC (2.60). We do normal selects to one table to extract its data. No problems here. Now we…
-
OnNextRecord trigger
I have found that if I put any code in the OnNextRecord trigger (eg: on the Customer card) this stops the PgUp/PgDn functionality. Does anyone know how the internal Navision trigger works? Are key codes being captured to determine the step requirement? If I knew how this worked then I could repeat the code and add my own…
-
Credit memos??
Hi all!!! Maybe this will be obvious question, but still I need to know that. Who can tell me how to make credit memos of sales invoice and purchase invoice? Can you tell me where I can find any quide about this topic? Best regards
-
Navision opens unfocusable Windows in Background
Hi Guys, here i got a nifty problem from now 2 customers of mine, i can't figure out by myself. Description: Navision opens a new window by command, e.g. someone is pressing the menueitem Item in the Inventory-Menu. Navision opens the itemcard, but place it in BACKGROUND! The new open Window is visible over the…
-
Linked Server
HELLO!! In Sql Server I have a problem setting up a linked server to the navision DB using C\ODBC. i can read data, select * from OPENQUERY(SERV,'SELECT * FROM TEMP_REFERENCIA') runs ok but statement insert like this is bad. INSERT INTO OPENQUERY(SERV,'SELECT * FROM TEMP_REFERENCIA')…
-
License Warning
Hi, Everytime I open the Navision, I get a warning message saying "Warning. Your license expires in 330 (etc.) days." Anyone has an idea about that? I think it begins to warn when 1 month left. Best Regards, Ufuk
-
Extra Report Currency
Does anyone know of an error in Extra Report Currency in version 2.01B (2.01A), that makes it impossible to activate this feature at all ? When it is activated it is not possible to book any orders at all. Codeunit 80 stops at COMMIT with the error that the G/L entry (Table 17) will become INCONSISTENT What do I do, is…
-
How can I use date format for display date field
Hi all, Please help me, I would like to set format date to some date field like this " October 31,2005 " How I use date format for date field.???? thank for every advance :P Klum
-
Lockbox application in Navision
Does anyone have an function in Navision for dealing with a lockbox account? As in, sweeping the postings from the lockbox and applying them to A/R? Great Plains has a well developed one. I am hoping someone in the Navision community has done this also. Thanks for any help.
-
Using Dead Stock Report in 2.60
We have a client using Nav 2.60 who are trying to run the Dead Stock List report and are running into a permissions error. I tried running it with a UserID that has the Super role and could not do it. I could only get it to run when I used my developer license, leading me to believe it is a license issue. They actually…
-
Automated Credit Reports on new customers
Has anyone developed a mechanism to acquire credit reports on new customers, requested from Navision and/or bringing them into Navision, perhaps via XBRL?
-
how to dynamicaly change the ODBC connection in SQLServ DTS?
Hi: One question... Our client's Navision has 10 companies, so we have set an ODBC for each one of this companies. We want to read data using SQL Server 2000 DTs, so we set 10 ODBC connections and we extract data from each of this ODBC connections without problems. What's the (small) problem? If we change a field in one…
-
Algerian Country Layer
Hi there, we are working on a vertical solution for the automotive market based on Navision 2.60. We have a customer in Algeria and we work on the country layer, did any of you did something for the Algerian Market ?
-
Client Crash with Windows XP SP2
We have approximately 40 users, most are using Windows 98, the rest are remote users (Citrix). We recently got a DELL workstation with XP preinstalled, as well as a workstation I built with XP SP2 and they crash under the following conditions: Print a report, then go to Page Setup before actually printing. The error is…
-
Tif from Navision
Hi all I have a form which shows records in table 38. For each record there is a tiff file, which i would like to see in a viewer. but every time I move from one record to the next an new session of the viewer starts up, instead of using the one already open.. Tried it with Brava Reader, Office image viewer, IE.... Any…
-
Registering OCX on Navision 2.60E
Can anyone help me? I am registering a Tposx100.dll on a Navision 2.60E client Windows XP Pro. Eveything runs smoothly - the form/codeunit runs ok - if I do not close the client. However if I close and open again the client - I can not run my form anymore - the client freezes. But the form/codeunit compiles and the…
-
How can i make dataports work for me?
i have been trying to import some data with dataports but it is not workin and i tried to export as well it didn't work. i am wondering if they actually work.has anyone really used dataports to import a comma-separated text data file into a table before? if yes how did you do it.i really need your help to save my head…