-
Export data from PROIV Version 5.50 to Navision 3.70
Anyone exported data from PROIV Version 5.50 to a format that can be read into Navision 3.70? We are interested in subcontracting this task. Thanks, Ed
-
3.01a users
Any 3.01a users out there that are using MRP?
-
GoPro
Posted - 2004 Apr 19 : 12:27:57 HI ALL, I need help on the following points related to GoPro: 1. I have mapped fuctions keys with the menu keys on the POS screen.Any idea how to map and use up and down keys on the POS csreen? 2. How to go about with amount rounding in sales transactions and in statement posting. ? 3. In…
-
Field Class "FlowField"
Hey people! I have moved Navision Attain from Navision database to SQL-Server. Some of mye stored procedures uses fields that have field class "FlowField". These fields does not appear on SQL-Server. The table name is "Purchase Header", column "Completely Recieved". Table 38. Is there any way to get this field? I need to…
-
Forms
Hello All I have setup a new button within the Customer card. When i press this button it opens my new form that I have fitered on Salesperson Code. Simple question I know - How do I automatically populate the Salesperson code on the new form with the salesperson code on the master form automatically? Second question - I…
-
Undo Posted Invoice
Posting date was incorrect on an invoice. I was wondering the best way to back it out, and create another one. I know that I can write reversing entries, recreate the order and post again, but was not sure of all the entries to make, and wanted to know if there was a better solution than that. Thanks, Mike
-
Linking forms from forms
Hello All, Having a very bad morning as I cannot get something very simple to work. I have setup a new command button on a form and set the properties to run object and also created the relevant link. When I click on this, the correct form loads as do any existing entries for that customer for example. However, I am only…
-
Filter in RecordRef
Hi, I try to import/export data to/from any table. I create a dataport, and his DataItems is table, which I created. This table serve as archive table. And where is problem? I want to set filter on RecordRef so that I start to export the data from the particular table from values which I set for individual fields in…
-
Changing Caption
Hi, I tried to change the caption for the purchase line header in the Form 54 Purchase Order Subform but couldn't manage to do so.. or rather, i just don't know how :oops: ... I wanted to change the word 'Direct Unit Cost Excl. SST (for my localized version) to just 'Unit Cost'. But how? I have tried to change the Direct…
-
new error list
here is an updated error list in an excel file. each tab is a different range of modules http://www.geocities.com/powerofthenight/Errors_List.xls
-
Interfacing 3.7 SQL with .NET and odbc
I saw a reference in these forums that Navision should not be modified via ODBC, just C/ODBC, or database corruption may occur. I'm in design phase of an application that handles return authorizations, and product tracking for repairable items to ensure timely returns to the customer. I've been basing my plans on ODBC, and…
-
Problem With Serial N°
Hy when I make a transfer order of an item from a location to an other location the system loose the serial N° of the item when I try to receve it, the problem seams to be that atain lose the serial N° in the transit location! does some one see this problem before :?:
-
Navision Improvement 44 to the rescue!
if you have a problem with one or more of the items listed. Then this fix is now available... Product Navision Attain Reference No: 044 Product Area: General Ledger, Purchases & Payables, Sales & Receivables, Warehouse Management, Inventory Discovered In: NA 3.70 Introduced In: Not released in current version. Brief…
-
Run dataport from form button
I have a dataport that I want to run dynamically from a form. The form knows the file name I want to import. I do not want the dataport request form to pop up where I have to enter the filename. The dataport properties I think are significant are as follows: Import: <Yes> FileName: C:\default.txt (I read that leaving it…
-
compile error in the original database
Hi. I tried to compile all objects in a HU3.70.A database (from product CD). At the end of the process Navision said 'there were errors in 9 objects'. No object names, error kind, nothing useful information, just the OK button. In object designer, the compiled field of all objects are true. There is the same error in the…
-
How to perform a LEFT OUTER JOIN in C/ODBC Navision 3.10
I want to perform the following query: SELECT sc.Code as code, sc.Description as Naam, jt.Type FROM "Source Code" as sc LEFT OUTER JOIN "Gen_ Journal Template" as jt on jt."Source Code"=sc.Code C/ODBC does not support the LEFT OUTER JOIN syntax. Therefore i reconstructed the query to: SELECT sc.Code as code, sc.Description…
-
max database size for 3.70
I was under the impression that Nav 3.70 supports a max database size of 128 gigabytes but I have also heard that it supports up to 256 gigabytes. Does anyone know what the max size actually is?
-
Looking for new server - opinions needed.
Any thoughts on this configuration? Does anyone else use an IBM Server. Our database is at 7gb & grows about 1 Gb every 2-3 months. I see comments about 6 disks can this be done only on rack mounts? IBM xSeries 345 Form factor Rack Processor type Xeon Processor speed 3200 MHz Processor cache 1024 KB Hot swap HDD Yes Memory…
-
Slow performance on MS SQL 2000 SP2 option
We have a problem with MS SQL 2000 (SP2) option. Client worked with Navision server, but the database reached 64GB. We migrated to MSSQL. Users are about 40. database size is: 72GB. Server specification: Xeon 2.5GB 512K/2M cache x 4, 4GB RAM, 8 x 73GB HDD (RAID1 and RAID 10 for data). Disk queue length on data HDD is…
-
Setting balance accounts
When I post an invoice (or another doc), this is reflected in GL through the Posting Groups (Business, Product etc). Where can be set up a "Balance account no" which can be automatically introduced in GL toghether with "GL account no"?
-
Navision Attain Programming Exam
Can someone give me some info. for the programming exam?
-
Attain 3.01A command-line switches
Hello all, I am interested insetting up the Job Scheduler to start up automatically one a dedicated PC has been installed. I know about the feature, but I also want to enter the username, password, database name, company name and get it to start up automatically. Is there a list of start-up switches that allows me to do…
-
How to create a Test Company!
I'm trying to create a test company with the same data as the real company. Does anyone know how I can go about doing this? Thanks in advance for all your inputs! Kevin
-
grouping/totals
Hi, I'm new at this and I have a question about making a report. I have the following problem. The report has an item no. a code and a number. With every line goes an value. line 1: no. number value line 2: Code value I want it grouped like the two lines above. The value in the first line is the total for the unique…
-
backup in 3.60 and restore in 3.70
Hi, I did a backup of a company (in a database 3.60), then I did a restore of this company (in a database 3.70). It seems everything ok. I'd like knowing if there are other things to do before starting to use. Could you help me? Where can I find information about backup and restore? thanks in advance Alberto
-
Navision Database from outside
Hi All, can we access navision database from external applications ? i know we can use C/Front for the same. can we access the navision database from applications like Excel .. so on.. looking forward for the solutions
-
Navision Siebel Connector
Does anyone know where can we download Navision Siebel Connector?
-
import chart of accounts - how?
Hi everyone! Can anyone tell me how can I import a chart of accounts in Navision from a file (excel, txt ...)?
-
Showing certain sections on reports
Hello All I had a look through the history but cannot find anything with regards to allowing the user to decide before running a report, on whether they want to see the report in detail or summary. i.e. If I have three sections: Customer, Sales Header, Sales Line, how do i not show the section corresponding to Sales Line?…
-
Connected sessions
Hi! I increased our sessions from 12 to 18. Of course I placed a new licence file "fin.flf" in the server location. Why am I still receiving a error message from my Navison Attain 3.60 which informs me of exceeding the number of licenced sessions all though licence information file indicates licence session number =18? Am…