-
How to calculate Navision SQL database size by each table?
Dear all, :lol: I am current working on a prospect who may use Navision for the accounting, inventory, sales and purchase operations. Attached please find the sizing information collected from the prospect and appreciate your advise if there is any ballpark estimation for the hard disk requirement or should there be any…
-
How to handle long addresses
As we extend our international business we need more space for adresses. The navision world version has 2 address fields (address and address 2) but for many international addresses this is not enough (e.g. for building name). I can't believe that there is no standard for countries where these long addresses are usual. Can…
-
User Group Specific Menus/Forms
Hi, is there a way to get User/User Group specific Menu/Forms in Navision 3.7? i thought it had been implemented, or was that just a 3rd party bit of code? cheers
-
Navision 3.70 + Amyuni pdf v. 2.08 = Paper orientation fails
Hi Overview I’m using Amyuni pdf converter ver. 2.08 to generate a pdf file when printing a report from Microsoft Business Solutions-Navision 3.70 (Navision). The reports are requested from and presented on a website (WebVision by NovaVision Software A/S). In a system running win 2000 (sp1) or win XP Pro (sp1) as operation…
-
Reports
Hello All, Within a report I have created, within Sales Header I have selected No. as a required filter field but when you run it no lookup appears to the right. But when i select Salesperson code as a field, the lookup arrow key does appear. Ideas? Thanks
-
navision attain programming exam
Hi... I want to be a techinical certified in navision attain programming. but i dont know how to prepare for it. and wht will be the type of question paper. so can any one help me in this regard. if anyone as model question papers then please send it to me. it will be a great help. waiting for ur replies... thanks in…
-
Developers Toolkit 1.04
i am currently working on a Navision Upgrade, Has anyone been able to Successfully export Objects from the Developers toolkit merge process, or am i wasting my time here? Should i just use this tool to ID the areas where i need to manually change my objects? Does anyone have any suggestions. After exporting a Table and…
-
Data overriding rules
Hi everbody, I started newly writing code in navision. I want to ask something, if anybody can help me, I'll be much glad. The question is very simple :D ; Does navision provide multiple types of data overriding rules? Thanx a lot.
-
Navision 2.0 to 3.7 payroll upgrade slow HELP?
we are upgrading a client from Navsion 2.0 to 3.7 and the upgrade toolkit has worked fine with a few bumps up until the H/R Payroll portion of the upgrade which is running awefully slow. Codeunit 87200 has been running for nearly 10 hours with no end in site.... is this normal? I know that there were some keys we could…
-
Multiple Users on Same Record
Hi, We have many users who are entering Sales Orders, and one person with proper permission releasing them. Our problem is, if one particular Sales Order is currently being modified by a Sales Agent, how can it be prevented from being released. In other words, what would be the best approach to highlight if a particular…
-
Subform/sub-table called func. doesn't refresh main form
Hi, I'm an experienced programmer but haven't written a lot of Navision code recently (I'm a bit rusty). For a customer, I've added a new field to the sales header table called 'Credit Hold'. It's an option field with the values 'good', 'held', 'released'. The concept is if the customer has a credit problem, rather than…
-
Configuration tool
Hello :D Does anybody know if there is a tool that could automatically import/export the configuration parameters of a company (export to an excel file for example) thx in advance for any help
-
ADCS post problem
Hi have a problem using ADCS I have the need to manage lot no. I have modified the pick minifor, but when I try to post vai Hyperterminal the system give me this message: You cannot use C/AL variables of type form when runnig the navision application server Can you help me? :cry:
-
how to run crystal report by using OCX
Hi, I am using to run the crystal report in 3.6. For my understanding, I need to use OCX to connect to the crystal report in order to run. I wonder if anyone can provide the simple C/AL code example, for example, what OCX should be defined, how to call the crystal run in navision. Thanks, Rich
-
Call Center in Attain
If anybody has practice of Call Center organisation under Attain? How to use TAPI? If there any examles?
-
TempRec.MARKEDONLY Error using SQL
Hi! Help please. There is a problem :( : We have a temporary record. There is also a form for this record. When i try to set markedonly filter (not important from C/Al o from intarface) there is an error 1 in module 43. If using the Native DB option, error is absent, my code works excelent. But i need to do this for SQL...…
-
C/ODBC not returning all records from a table
I'm using C/ODBC from Java trying to get all records from the G/L Entry table. Everytime I pull all non-numeric fields, I get all records. When I try and get the Amout field, I don't get all records and get an ODBC error that says: UNKNOWN ODBC ERROR - NAVISION FINANCIALS. Does anyone have an answer for pulling amount…
-
Dataport Problem
Hi, I am new to navision and i am trying to make a dataport to import data from an ascii file. One of the fields that i have to fill in is an option field and i use one of the field options in the dataport as the value. i.e. VarReccord.SETRANGE("Field Name",VarReccord."Field Name"::"Field Option"); and i get back : "The…
-
Configure Navision Attain
Hello :D Does any of you great guys out there know if a guide to configure Navision Attain 3.70 exits anywhere. By configuring I mean setting up diverse posting groups, dimensions and so on. Like a cook book to support the check list? As usual, when it comes to Navision, any kind of documentation would come in handy :lol:…
-
urgent help needed
hi... wht is the proces of migrating data from 2.6 to 3.7 please help ASAP...
-
"Invalid Receipient" error when using SMTP email O
Hi: I'm trying to use the SMTP email OCX discussed here. The one difference is that this site uses Exchange Server. Here is my code: SMTPMail.NewMessage('ron@client.com','Subject: SMTP Test'); SMTPMail.SetWorkMode(); SMTPMail.SetHost('CBH-EXCH-01'); SMTPMail.SetUserID('cbh'); SMTPMail.AddLine('This is a test message.');…
-
Up-/crosselling or scoring
Hello, I have two querstions. I have got a project on my University to install Navision in a Client-Server solution. My professor want it for a simulation of CRM. I although want to realize a scoring method an an up-/cross selling method. Is this generelly possible in Navision 3.7 without having a developer license. Can I…
-
Double insert
Hi Everyone! I've got a problem: There is a table (Rec) I need to make double insert when user inserts a new string in a form, something like this: Rec.RESET; Rec.SETFILTER(Field1,Value1); Rec.SETFILTER(Field2,Value2); IF NOT Rec.FIND('-') THEN BEGIN Field1:=Value1; Field2:=Value2; INSERT; END; Rec.RESET;…
-
Can I do a OR filter on multiple fields?
I have a problem and it would very simple to solve it if I could something like this: Eg: Rec.SETFILTER("No.", '>100" OR "Name",'George') meaning that recordset should have all recors with "No.">100 and those whose name equals "Gerorge", nevermind their "No." Does this make sense, and if it does can someone help me ?
-
Save as HTML - Send
Is there a simple way in Navision xxx to find out if somebody is sending a file by email. (Preview, File, Send). I want to keep a log if somebody Previews a report and then clicks File, Send
-
Can a Template of Chart of Accounts be maintained.
I want to maintain 5 companies in a database and all the 5 companies has uniform GL heads. Will it be possible to maintain a Chart of accounts as template where if i create a GL head all the five will be updated and uniformity will be maintained. How can i implement that.
-
Revaluation Journals in 3.70
I am doing a Revaluation Jnl in 3.7, I am getting negative stock values in my Jnl. Can anyone tell me which values are added together to get this valuation quantity?
-
Navision Attain 3.60 freezes on W2003
HELP IF U CAN.. We are using Navision 3.60 build 14060. Since Monday 02.02.04 our servers kept on freezing every 20 or 30 minutes... Users could connect but after a while the servers freeze... all users were disconnected from there session. As we were testrunning XPe on W2003 we moved all users from one farm to the other.…
-
Can't write date/time values via ODBC
I'm using ODBC from Lotus Notes trying to set a date and a time value with the record below. Other records a working well. Does anyone have an answer for my problem? UPDATE Tab01 SET MyTime='12:12:00' WHERE Adrnr='12345' or UPDATE Tab01 SET MyDate="12.12.2004' WHERE Adrnr='12345' I also tried date with "." and with "/",…
-
Outlook Synchronization strange feature
Hi All, I discovered a strange but VERY USEFUL (I think) Navision habit... It's a little long post but interesting (I hope). I did this test: 1 - I activated the Outlook synchronization function from within a salesperson card (A). Filling all the required fields. 2 - I activated the Outlook synchronization function from…