-
issues abt upgrade
Hi.. I want to know major issues regarding upgradition from 2.7 to 3.7. help me in this matter thanks in advance, vikas
-
How can I get all keys from the table referred by the record
Hello! Could anybody help me? How can I get all keys from the table referred by the recordref. For example: In the table are 20 keys. 10 are active and 10 are disabled. First 5 keys and last 5 keys are active. Between them are 10 disabled keys. RecordRef.KEYCOUNT is return the number of active keys (in this case 10). I’m…
-
Reports
Hello All I have two data items, Item and Item Ledger Entry. Sometimes, no records will exist within the Item Ledger Entry. I still want the Item section to be output and my question is therefore, what approach should I take to output a message of "item ledger history does not exist", if no records exist in the Item Ledger…
-
how to make a filtergroup
Hello everybody, nobody know how to make a filtergroup withe a setrange but making or in the setrange? example: filtergroup(2); setrange(..); //i have to do a setrange with 3 fields but no making AND, i have to making OR. i have to look if in field1 or field2 or field3. filtergroup(0); Thanks.
-
The Naivision DB size limitation
Hi, I think the largest size of Navision 3.7 DB is 128GB. But usually the licensed db size to a customer is 64GB. Unfortunately our sale-persons sometimes just forget to remind the customers of this difference. And one of customers feel unhappy of this difference. I mean, he has purchased the license, and he found out that…
-
Slow Data Connections
I just started working with a client that is trying to import a large amount of Navision data to a sql server database from a remote location. The source is the MS business solutions for Navision database - not SQL Server. The data transfer is extremely slow. The communication line is a T1 and pings very fast. I suspect…
-
Create To-do
Hi All, I need to completely redesign the Create to-do form because the Wizard style it has is very boring... BUT... It's very difficult to achieve a good result... Someone here has any suggestion? Do you use this form extensively? Do you activate the Outlook Sync.? Thanks in Avance. Bye GPM
-
Linking Item Entries Table to G/L Entries Table
Can anyone tell me which are the best fields to use to link the item entries table to the g/l entries table in a report? Thanks. AEL
-
OLE access to Word
Hello, we have a Problem to open Wordfiles (*.doc) over OLE in Navision Attain. Sometimes it's successful but we got errors such like "Could not found winword.exe". We have reinstalled this Workstation with Microsoft Office but the error occured agin. Please, could someone help us? With best regards, Markus
-
Quotes and Opportunities
Hello All I have the task of adding the potential value to a report that already provides analysis of quotes. The potential value needs to be calculated via the opportunity that is linked to a particular quote. This needs to be in % i.e. the calculated success. Anyone have any ideas? I might also need to do this for all…
-
Business Analytics
Hi, I installed BA for Navision Attain 3.01 (BA Suite, License and Configuration). Now when I start BA Enterprise Manager the Account failed with permission error. Where can I change the user account ? Thanks for help
-
Template for documentation
How can i find template to made technical documentation, analysis documentation. Thank's in advance
-
Software Industry - Change Request system
Does anyone have any information regarding a Navision add-on for this solution? Our client develops software and is looking for a change request system to process change-orders to their software development process, i.e. workflow process that tracks and routes model changes, code changes etc. Or, does anyone know of a…
-
Levels of C/SIDE Development Access
Is anybody aware of how the increasing levels of access to C/SIDE effect a developers ability to customise? Once your solution contains Form, Report, Dataport, and Table Designer, how far can you customise Navision before you need Application Builder/ Solution Developer? Essentially, what capabilities do Application…
-
Return automation type from function
I have a function in a code unit that creates a word document. I want to return the word document object back to the calling function. Is this possible. I am using WordApp.ActiveDocument in the calling function at the moment to access the open word document but this does not always work. Is there a better way to get a…
-
Automatic Backup - 3.10
Hi, Does anybody know how to set the system to do automatic backup. I know externally it is possible, but can it be automated from within Navision. For eg. set it up to run automatically everynight. Thanx
-
US Sales Tax Posting Problem
I checked out My Sales Taxes Due G/L Account and noticed that it looked rather low. On further investigation, I have noticed that Sales Invoices are posting a negative entry for any taxes that were invoiced to customers. However, I have also noticed that any posted purchase invoices also post a posative amount for any…
-
No Listing of non existant Servers
Hi ! We have removed some servers and on the Navision Client (3.10a) are still the servers visible to select ! How can they be removed ? Theyre not set in the shortcut nor in the hosts or system file. Any other ideas ? Thanks M. Antoni
-
wronge exchange rate crrection after posting
when we posted the sales invoice the exchange rate wrongly mention by the user, which has resulted the huge value(LCY) in the GL entry and therefore all report and statics are not correct. HOW TO CORRECT THESE ENTRIES?
-
Report Papersource
Hi All, Has anyone used Report Papersource to control pages to print in different trays? It seems notworking when printing multipul documents. Like print a banch of invoices. Thanks in advance,
-
getFieldData with Date DataTypes gives un error
Have somebody experience with this error and do you have a solutions for it??? Please help. Regards, Hans
-
MS Excel2000 slowness with Navision 3.70
Has anyone experienced a deterioation of Excel performance since running Navision? The Excel workbooks that I use contains 40 thousand line items and a few worksheets. I also use Lookup and SumIf functions This happened after i installed just client portion. Then I removed client and installet the "typical" with d-base.…
-
Stop code running if a field is not empty
Hi all, I have some code on the Purchase Order form that runs each time a Vendor No. is entered. Basically the code looks at some new fields in the Vendor table where an alternate delivery address can be specified, and copies the contents to the PO header 'Ship-to address' fields. Vendor.GET("Buy-from Vendor No.");"Ship-to…
-
During DB Restoration in SQL, SQL Log increased unexpected
During restoring Navision backup into the SQL Database, happened that the SQL Tranasaction log size increased unexpected. The backup file contain one company book only. There are two files created from Navision backup, and the size is 2,097,152KB and 1,836,799KB. When the SQL Data file size reach 15GB, the transaction log…
-
Two sets of tables in database
Hi. All tables in my DB appears tvo times. For example: Table nr. 3; "payment terms" also appears as: Table nr. 1000000003;"payment terms". I don´t have any access to these tables Does anyone know what is causing this ? I´m running 3.60 on native database.
-
Vendor No. must be specified. Please check that vendor......
"Vendor No. must be specified. Please check that vendor No. are correct for each line.." I check everythings already, everythings OK but I cannot make order.. My consult cannot answer to me... Please...
-
Adcs
Please give me your experiences of working with ADCS in 3.60 or 3.70. If you know of any hidden problems or show-stoppers let us know. I will post details of how we achieve a successful implementation when we have finished!
-
Renumbering Objects in Navision
Hi, I have Imported some of the objects with IDs ranging from say 80000 and we have made use of some of those objects in our module.But the clients license file does not support that range.I tried to renumber the Reports and code units i was successful in that.But when i tried to do the same with the table i am not able to…
-
Netscape vs Outlook
Hi; Does some one know if it is possible and how to use Navision Email with Netscape instead of Outlook? Thanks
-
NotBlank in condition...
Hi to all, I have a rather simple question. What I want to achieve is to force the user to enter a value in some specific fields if a condition is met. More precisely on the order form if the customer is a foreign customer then I want to make sure that the user will fill some specific fields on the order form (ie Sales…