-
Access Voilation error in Developer Tool kit
Hi I am running Navision developer toolkit version 2.0, for converting 3.1 objects to 4.0 objects, i am facing some error randomly in my machine while running the merge process. 1) Access voilation at address 007E1798 in module 'Dev Tool.exe' . Read of address 0945C000 2) Out of memory can any body tell y this error is…
-
Trigger to insert record
I have been asked to automate the process to create a product order in the Sales Order form. It is usually done using the ORDER menu button -> Planning, then FUNCTIONS menu button -> Create prod. order. I have added a boolean field in the details (Sales Line) and check it in the OnValidate trigger of the table, then run…
-
Reporting Services c /side
We run Navision 3.70 client on 3.01 c / side database and currently use MSQuery to retrieve data to Excel. We will be upgrading to Navision 4.0 sql but in the meantime wanted to begin to use SQL Reporting Services to access our existing data . Does anyone know if Reporting Services will read c / side ?
-
Annual closing operations/closing fiscal year
Hi everyone! When I run Close the Income Statement Batch, and when I post the journal lines the batch creates, the process of closing the fiscal year is supposed to be over. But when I go to the G/L Accounts, all of the Income Statement accoutns are supposed to be 0, but they still show amounts (although they ARE equal) on…
-
Autocalcfield in Navision 3.70b
Hi, Is it possible that the autocalcfields-property does not work anymore on a text-box in a card-type form (Navision 3.70) ? In 2.01 it was OK
-
permissions to create and post certain Journals
Hi, I am +ve that this can be done using Roles and Permissions. All i want to do is set a role giving permissions to create and post CASH RECEIPT, DEFAULT batch journal. So the user who has this role can only create and post CASH RECEIPT jorunals ( no toher journals) and that too only one single batch that is DEFAULT. I…
-
Automatic logout facility
Hi Can any body let me know is there any tool available which could automatically logout the session of user if that particular user is using the navision for defined no of time, utility should automatically kill the session of those user who r idle for let say 5 min. Thanx Amit
-
Base UOM Question: Rock|Hard Place
Nothing is more frustrating than telling someone that the BASE UOM MUST BE FILLED IN and it doesn't happen. So I added the "Mandatory Field" code (which has been discussed here many times (Seach: Mandatory Fields) One of the problems I have is that once 1 ledger entry has been made it no longer allows you to enter a "Base…
-
UK Language Module for 3.7
I can't find an UK 3.7 Language Module (2057). So. should I use a 4.0 2057 language module or a 3.6 attain language module. both are available. We have our own customization which I can deal with but it is the standard navision and indexes I want from a language module. any ideas? thanks. #-o
-
Best practice to upgrade the versions and hotfixes.
Hi, My requirement is to upgrade the one version database to a higher version in navision. Please let me know what are all the tools available to do this, what are the best practice to do such kind of task. Regards Amit
-
Popup message when user apply changes in the system.
I wish to create a popup confirmation message whenever user exit from a screen with changes applied. For example, when a user exit from the Item form while adding a new item or modify the existing item, the system will prompt a confirmation message whether to save the changes. If the user select ‘Yes’ the system will apply…
-
Setfilter Problem
Using a Setfilter i am trying to filter out 2 values that i don't want to pick up but it only filters out the first value. Any ideas how i can do this? I have tried to use SETFILTER(field,'<> value1|value2') but this is not working
-
Navision help files versus time change Daylight saving
Hi, I have another weird issue: One of our clients has a problem when the date changes on the computer like with Daylight Savings Time. Someone with NON Administrator rights cannot log in and an Administrator needs to login in order to fix the problem with the help file: re-indexing the help files. After that the Navision…
-
Update Dimension for G/L Entry
Hi All, I have some problem (it's not a navision bug.). I found that all of Dimension from Purchase Invoice and Purchase Cr.Memo is not going to table "Ledger Entry Dimension" for G/L Entry. Do you have any Idea for transfer the Dimension from Purchase Invoice and Purchase Cr.Memo to G/L Entry? Thank you so much.
-
Cant expand database, even though there is room? HELP PLZ!
Hi, Im a new user of Navision Attain 3.60 Im trying to restore a backup of my database which is 7 gigabytes in size. I have 14 gigabytes available on my server's hard disk. My problem is when I try to expand a "new" database to 7 gigabytes, it says "Your server returned the following message - not enough disk space". How…
-
Copy records from one quote to another
I have been working on additional functionality to the 'copy document' functionality within 3.6 in the below thread. http://www.mibuso.com/forum/viewtopic.php?t=7661 I have got this sorted with some good help. My questions kind of follows on from that above. Each quote within my system has footer comments that can be can…
-
Copy document functionality - ignore blocked items
When you use the copy document functionality can it: 1) Copy the quote description 2) Tell you that there are blocked items (but skip them) but still bring over the rest of the document. Anyone know where in Report 292 I need to change to make this happen? Cheers Jim
-
Windows 2003 sp1 Compatibility problem
I am trying to install Navision 3.01 to Terminal Server with Windows 2003 sp1. When it reaches at about 90%, suddenly it does a rollback and says "Setup is cancelled". Any help please?
-
Add Check(s) Total to Payment Journal
I posted this in the newsgroup http://www.microsoft.com/Businesssolutions/Community/Newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.navision&lang=en&cr=US but will soon be lost forever there. So I'd figure I'd post it here in case someone needs it. PS(Navision Native)…
-
communication between Navision and a Web Portal
Hello, I have one problem in communication between Navision and a Web Portal. I want to know if it's possible to have Navision Application Server and the SQL database in one machine and the webservice in other machine. I think it is not possible because message queuing can't communicate between 2 different machines.…
-
ticket printers and page settings
Hi, I have a problem regarding printing from navision to TEC barcode printers. You all now that when you install a barcode printer the page propertie's must be set correctly. so the width, height of the label + the spacings and borders etc.. if those are not correct you get a paper jam. Now when I do this correctly, (or I…
-
Seeking WW version of 2.6 software
We have a new international client who although located in the states are running World Wide version of 2.6 and they wish to have us upgrade them to World Wide 3.7. I have the 2.6 NA and 3.7 Na but the backup will not restore from WW into NA without errors of some field types. Does anyone have a 2.6 WW version I can get a…
-
Increase description field
I have been reading about this and I have a suggestion: why not creating a new field (full description) of 60 chars (or more) and OnValidate, copy over the first 30 chars to "Description" and the next 30 to "Description 2". OnValidate of "Description" en "Description 2", we build the "Full Description"-field. This way, the…
-
Error, database size used increases 100%
Hello all, I have a big problem with my Navision native database Attain 3.60. I´ve 12GB splitted in several files on RAID 1. I was working with this size a long time without problems with 80% of use. Yeterday the system tells me that is using 100%. I tried to increase several times but it doesent work. Now the database…
-
How to make a report visible or not
Hello, I want to know how I can make a report visible or not depending on the user. Thanks.
-
Temporary Tables
Hi All, In a customization,I have used a temporary table whose data is viewed thru a form.on this table when i try to execute functions like FIND,COUNT they do not give the expected result.I wish to know more about temporary tables and transactions done thru them. Secondly,while displaying the data i have distinguished…
-
cfront.ocx, asp.net, NDBCN
Hi, My web application connects to a NDBCN server via cfront.ocx. I use the following code: CF.ConnectServerAndOpenDatabase("NDBCN", serverName, "TCP", databasename, dbCache, True, False, UserID, Pword). Everything works fine on my machine and one other machine. However when I install the application on any other machine…
-
Navision Attain 4.0 PDF's
Hi all, I want to give the exam in Navision Attain 4.0. Please send me the study material for Navision Attain 4.0. Monika Luthra
-
Pro Forma Invoicing
Has anyone else had an issue with producing Pro Forma invoices in Navision (v3.6)? Whilst I could create a simple report to produce the actual document, that is not where my problem lies. I notice that in the past it has been suggested that an Invoice is created against the G/L rather than an Item to get around the problem…
-
SQL 7 vs SQL 2000
We are considering upgrading to 3.70 from a 3.10 base, and as such would need to upgrade SQL. Can anyone tell me about the performance increases going to SQL 2000?