-
How is the Navision database handled?
I'm not the developer for Navision, but I'm helping the team solve a performance problem that is affecting the users. So please bare with my ignorance of the software. Currently the database is spread across 3 partitions - each on mirrored drives. It is split into 16 files. Each file is about 2GB in size. Apparently each…
-
Internal Error 1355 in Module 19
Hi all! In the late months i get a message: "Internal Error 1355 in Module 19". It pops up, and the user can not close it. It is an often phainomenon to the terminal server users. I have win2003 sp1. But this happened also with Win2000. I tried to delete the zup file or restart the server, but after some days it happens…
-
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…
-
In a jam with 2.6......
Trying to help a customer out with an upgrade and he lost the Navision media. He is licensed up to 4.0 but for what I am doing I need the 2.6 media. I need to find v2.6 media somewhere and have been unable to get it. Can anyone help?
-
Looking for Nav 2.60E Contact Manager (CRM)
We have had an inquiry about training for Navision 2.60E, specifically Contact Manager. I have looked for the download on PartnerSource without any luck. Does anyone know where I might find it?? Thanks!
-
Repost - Writing data from 1 file in 2 tables
It is indeed perhaps better to start a new topic concerning this issue. ok, I'm quite new to Navision but I'm working on it. I wrote the dataport that does indeed read the information from 1 CSV file into 2 tables, had to fiddle a bit with global vars, but makes perfect sense now. However it only works if the information…
-
Sending emil via Novell GroupWise
Hi One of my clients wants to bo able to send direct email from Navision 2.60 via Novell GroupWise email client. They have a GroupWise version 6.5. I belive that I need a similar automation file like MSMAPI32 for Outlook - is there anyone who can help me with this ?
-
DTS and Navision SQL
Hi I created a DTS, to transfer data from an Access to a Navision SQL temporal table. After, I must modify transfered data to create a diary. (All is OK) My question is, how can I say if the DTS has finishes transfering data ?? If I execute a Shell , Navision continue executing next instructions and doens't wait to Shell…
-
problm in dataport
Hi, I have a query regarding dataport. I have a text(csv) file which looks like this No,Name,Address Item No,Quantity,Price Now i want to push 1st line to the customer table & 2nd line to the item table. Please help me in this regard. Thanks, Vikas S. Shettar
-
Short cut keys Navision 2.60
Hello I am looking for some kind of document or alike with an overview of the short cut keys availible in Navision 2.60. Does anyone know where I can find this? Thanks in advance /Miros
-
budget vs actual dynamic report
Have anyone come accross making a budget vs actual report with columns Jan to June(let us say this is current month) actuals, jul to Dec budget? The current month should be selectable and changed by the user. Thanks for any pointers. I don't want to use export, modify, import from Excel.
-
Datatype problem with ADO
Hi Guys, I am trying to get data from Mysql database into navision, everything works good but when i try to get data from BIGINT datatype from Mysql navision is giving a error saying it doesnot support this data type. Is there any way to get the data from BIGINT from Mysql to navision using ADO. Error is generated at this…
-
C/ODBC from ASP/VBScript -> INNER JOIN?
So I'm using NF 2.60 with the C/ODBC driver and it seems I cannot use INNER JOINS. Seems odd to me, but no matter how simple, it errors out saying that INNER and/or JOIN are invalid tokens. Is there a way around this? Here's the query I want to run: SELECT sle.No_, sle.Open, rh.Name, rh.Address, rh.City, rh.State, rh.""ZIP…
-
update NAV 2.60 to NAV 4.0
we want to update our NAV!!! Have anyone some information how i started to plan this think???? are there any standard procedures for upgrade???? we have all programmer license, but no praktical know how, but i will try it alone!!! Thanks for inforamations???
-
Re-class Items into New Item Division Code...
Hi, I would like to re-class all the items from a division code (e.g:14002) into new item division code. Can I know what is the process flow to convert item under Division code 14002 to new Division code? What are the system impact once all the item reclassified in term of sales, inventory, report & account? Thanks..
-
Connection string for importing tables to access from Native
Does anyone know how the connection string should look if you would like to automatically import a table from a Native database to MS Access? Best regards Patrik D
-
Database size 2.60F
Hi all, we use Navision Financials 2.60F in company and licensed DB size is 64GB. Current size of native DB is 27GB, but somebody told me, that limitation of version 2.60 is only 32GB. Is it true? I have splitted DB in 16 files (16x2GB). Max count of files is 16, but I would like to ask you, if we can resize files for…
-
missing temp file on startup
Hello I have a problem with a user, who can't startup navision 2.60D The problem occurs at startup and resolve in an error stating the system is missing ex. the following file in the navision directory: __TEMP__.C4F or __TEMP__.JJP I can't find any temp files in the navision directory. Please help me solve the problem if…
-
Problem using Linked server and C\ODBC
Hi, We have a problem setting up a linked server to the navision DB using C\ODBC. When I call a stored procedure, it returns the data. But I can only do this 1 or 2 times and then I get the following error: OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: [Microsoft][ODBC Driver Manager]…
-
Automatic navision back up
Hello, Can anybody tell me whether there is a way to make the navision back up in a night run or something like that. We use a version 2.60g and a c/side database. So we do not need a hotcopy from the database, but a real navision back up, which can be started at a certain time, with parameters added as "Including…
-
Sales invoice creation
New to all this 1.How do i go about creating ZERO value sales invoices,what we are trying to do is send out replcement orders Can someone tell me how to achieve this? RKM
-
How to Import Picture in Navision Financial 2.6
Hi all , I am trying to create a new functionality for Importing Picture into the Database , but I am unable to find the Object (Picture Table) .The same object can be found in 3.7. Please Help
-
Pagebreaks in reports
I would like to add a pagebreak after a section in a report, so that the report continues on a new page. How can I do this?
-
Creating a cover letter
I need to create a cover letter for a client. They would like to be able to choose from a drop down for default paragraphs to compose the cover letter. I have the extended text granule available and a word wrap add-on. I'm wondering if extended text can be modified be used with another table beside those listed in the…
-
Writing into a NF 2.01 table from an external program
I´m a NF 2.01 user. Is it true that the ODBC driver that comes with NF is a Read-only driver? I have tried to make a program in Visual Basic to write data into a NF table usin DAO and ODBC. I get the error message '[Navision Software A/S][Navision Financials ODBC Driver]Data source is read-only'. If it is true that is…
-
Problem with license file
Dear all. I have the following problem. I have created a database with the developer's license, which gives me full permissions. Using the developer's license, i have inserted data in various tables, such as Customer, Item, Invoices etc. Later, I have decided to change the license to the client's license. When I tried to…
-
Installing Navision Financials Server in a Windows 2003 (Err
Hi, did anybody get any error message installing the 2.6D in a Win2003 server about now having enough rights althrough doing it with the administrator and so on having them all? And if someone did, any solutions out there? Thanks!
-
problem with excel and chartwizard
Hello, here is a example code: Range := Worksheet.Range(CalcExcelCell(2,3)+':'+CalcExcelCell(3,LineNo-1)); Chart := Excel.Charts.Add; Chart.ChartWizard(Range, {Bereich} -4100, {Diagrammtyp 7,9,11 oder -4100} 1, {Format 1 bis 10} 2, {1 Zeilen oder 2 Spalten} 1, {Gibt die y-Achse an} 0, 0, Worksheet.Name, 'customer', 'still…
-
Range DataType
GD, i couldnt set a range, i try: int16, int32, byte[], char[], string, bool (c# datatypes).. a error message is always : "Type mishmash" when i call property range type, is 4 a reply (DBL_Type_BLOB?) thx
-
data selection
Hi, how could i get data from table (navision :) ) with cfont? iv connect to server, logined, opened db, opend company .. and now i cant find a reason to open table and get data :( thx a lot