-
expanding DB problem
I was running navision 3.01 in single mode, when trying to expand the database from 15Gb to 20Gb. Then, just as it stated to expand the database, the system gave me an, “Error in module 19” type error, and I had to end the navsion task in order to exist/continue. Now the Operation system sees the DB as a 20 Gb file, but…
-
NAS problem
Hi, I have a web application which communicate with Navision via MSMSQ and a application server. Most of the time everything works fine but sometimes (more and more often lately) the application server can't communicate with the Navision server. I get the following error in the event viewer "Your program license does not…
-
Ask before changing boolean value
Hi all, We have a boolean field on the BOM header table called 'BOM incomplete'. What I would like to happen is if a user clicks to change the field, the system prompts them with an 'are you sure' question. If the user says 'yes', the field is changed. If 'no', the field stays as it is. Is this possible?
-
URGENT help needed
Hi, we are victims of hurricane, all is gone and I am trying to restore an office in another city. I am in great need of MICR font file, please email ASAP so we can start printing checks. My email is ccicashmgt@acorn.org Thanks!!!
-
Navision 4.0 to navision 3.7
Hi all, Actually i cought into a postion where I require the members help. The Problem is: I mistakenly converted my Nav 3.7 database to 4.0. How can now I open my 4.0 database in Nav 3.7 client. Please I require the soln. immediatly Aniruddha
-
Quick question (Borders in Reports)
Hi Guys, A quick question. Extremely bizarre but I'm having a problem with printing rectangles in a report section in 3.6 It just doesn't print. I active the "Border" property of a label and check different combinations of it's related properties but... nothing. Any experiences out there? Rgards
-
License File
I am having a problem loading a new license file. Its a C/SIDE Server database. I have renamed the new license to Fin.flf I searched the entire server for Fin.flf and replaced with the new file. I stopped the service and restarted the service. On open of the navision database I still see the old license. What am I doing…
-
Usage while date compressing
Is it safe to continue with normal business operations against the Navision server while date compressing obsolete data? I am looking at date compressing some older years in the near future and am trying to determine the risks. I plan to do this over a weekend while business is closed. However, we have 2 web fronts that…
-
Merging problem
Hi All, Im facing a problem when i do Merging from Navision 3.60 to 4.0 Error message : The specified table(Item Department) is different from the table the form uses(static time Setup) Hope guys all can look into it and give me some opinion on this error. Thanks ](*,)
-
XML import in NAVISION 3.60
I have to import xml files into NAVISION 3.60. I heard that I have to use an OCX cause there's not some native xml port. Is someone can help me, i don't know how it's working. Wich OCX shall i have to use ?
-
Crazy mouse operation
A user has just come to me describing a rather unusual problem. The Navision interface on his machine is acting weird. This is going to be hard to explain so bear with me... When I hover over the horizontal line between rows in the left-hand margin in Navision or Excel, I expect to see the cursor change to the "row resize"…
-
optimizing tables using an automatic procedure
hi there we run into a little problem here regarding performance. we have a customer in retail industry and we had to setup something like 95 or more native navision attain databases. one for each store, that is. version 3.6 for now. after a few months in production and probably because we are using data director from…
-
PopUp Message while creating a new product (Beginner)
Hi everybody, I am quite new in programming Navision. Therefore my question seems a little bit stupid :( I want to apply the following changes during the process of creating new productcodes. I want that the user go direct in the field (with TAB) which should be next. I have sort this out with the option "NextControl". But…
-
Picutre/LOGO/Report Question
We are a trying to be a fulfillment house for 2 internet companies. I have created all the necessary forms, report n such. Now I want to pretty it up a bit and add there logo's to the packing slip(picking ticket). I can easily add one standard pic but I need it to change depending on the company. This special Picking…
-
Permissions problem.
Hi! I have a table and permission filter on it. I must enter new records through c/al into that table. Problem is that my primary key is not "auto increment" so i have to find out max number of it and then increment it manually. How can I find max entry no. while I have permission filters on that table and cannot see that…
-
Purchase orders and credit card transactions
My client purchases stocked items using a credit card. I was thinking I could set up a vendor card for the credit card company. Then set up a vendor, using the credit card as the bill to. When I post the invoice,the transactions would post in accounts recieveable for the cc. I could then print computer checks to the credit…
-
Tax Deduction At Source
hello everybody, i have a problem in TDS. How the TDS setup work is we have combination of assessee type , nature of deduction-- the %details for each type of combination is taken for calculating TDS. so the %mentioned is calculated if amount is above TDS threshold and surcharge threshold, and if not TDS is 0. But in case…
-
CREATE TABLE statement out of navision table
Hello! I want to export some data by using ADO from my navision-db to an external database which is a sql server 2000. Is there a tool or another possibility to create a sql file that contains a CREATE TABLE statement out of my navision-table? So i wouldn't have to create the table for my own, because the table on the…
-
Export as text error
I am trying to export a heap of objects as text so that I can bring them into Source Analyser. When trying to export the table 'Item Ledger Entry' I get the following error message: The type '4988' was not defined for the function. Any ideas/comments welcome. Cheers, Justin
-
Err: SQL Server value outside Navision Attain Range
Our client is getting an error on their SQL dbf with the following message: The Customer table contains a field with a SQL Server value outside the allowable Navision range:" It is followed by a field name and field type. They get the same error message repeatedly but the field and type are random. They get this message…
-
Does anyone know the way to find amount of table field?
The problem set to me is not very simple. I got stuck finding the best solution, and have some doubt it exists. The problem is: User (powerful user) wants to open form (ANY form in navision) , find (focus) field (ANY numeric field that can give a sum) , push shortcut key and see the sum of all chosen record. I know how get…
-
post data in a table or a list
I seek to post data in a table or a list. Which component can I use? thank's
-
FORM.RUNMODAL under 360 FinSQL.exe performs unwanted commits
Hi all ...(except MS that wants a pile of money to be informed of their own errors! :x ) I have discovered a problem with unwanted commits in Navision Attain 3.60 finsql.exe (build 11353). This is most likely an error in the runtime module. At least thats what I think... 8-[ The problem arises when returning from a…
-
Integrate AutoCAD drawings and Navision Item Cards?
Hello, We are looking for a way to associate and integrate documents and/or AutoCAD drawings with item cards in Navision Attain. More specifically, our goal is to, with a single click on an item card, open the item’s respective drawing in an external application (like AutoCAD). Has anybody been able to do something like…
-
Passing a parameter to a Report
Hi everybody, I have made an Invoice Report for a customer and try to print it. Under the Print button of the Posted Sales Invoice Form there is this code: CurrForm.SETSELECTIONFILTER(SalesInvHeader); SalesInvHeader.PrintRecords(TRUE,Rec); No matter which report I try to print to (the original 206 or my new 50002),…
-
Navision Attain 3.60 in a clustered environment
Lots of anecdotal evidence, but nothing conclusive... Has anyone succeeded in installing Attain 3.60 on an active\passive clustered SQL 2000 server? Note active\passive for redundancy, not load balanced clustering. Anyone who's done this, I would appreciate any tips/tricks/pitfall information. Thanks in advance for your…
-
Error while Posting Transfer Order
We are facing awkward problem while posting Transfer Orders containing Items with Item tracking as Lot Specific. While posting the Order the system gives an error that the "Qty to handle (base) must be -XXXX in tracking specification entry No=1". but the quantity associated with that Item is different from the Quantity…
-
PDFMachine
Has anyone tried to send mail to multiple recipients with PDFMachine? I tried setting as autometed code: #_ emailto emailadd1@email.net _# #_ emailto emailadd2@email.net _# but it sends the mail only to second address written. How can I manage to have the mail sent to all the addresses? I don't want to use the cc option.
-
User Portal
I have successfully installed User Portal but i was not able to open a Resource Journal Form through link sytem through ERROR"Invalid xml Format". thnk
-
C/Side documentation
Hello, a little bit a basic question; but who of you has good C/Side documentation since every day I am still learning more in designing reports/forms etc. So I am looking for "Design-documentation". Thank you in advance.