-
Mandatory field - OnNextRecord & OnQueryCloseFo
Hi all, I have a field called status and I need this field to be manadatory (as best navision can do). Now I can add the following to OnQueryClose and OnNextRecord IF Status = '' THENERROR('Please insert a value into the Call Status field'); This works fine when trying to close the form, but when they try and navigate to a…
-
Permissions/roles?
Is there a simple way to see what permissions are needed for a user to complete a task (i.e. posting). Currently I have an issue where a user is trying to use an export command in a payment journal and they are getting a message saying that they don't have permissions. I have had a looked at the permissions that I feel…
-
Color and controls?
I know that UPDATEFORECOLOR can be called only from OnFormat trigger so my question is: Is there any way to (dynamically) change button or label font color?
-
Attain 3.10 Migrate to SQL Server 2000
Attain 3.10 - I have done a migration from Navision Application Server to SQL Server 2000. We have a 150 user site and running on SQL Server has created some serious performance problems. Too many table locks, reports take forever to run and system generally very slow. Can somebody please give me some advise on the…
-
Decimal overflow error in Inventory batch job
I'm using Navision Attain 3.10 with all Hotfixes. The problem is when executing batch job "Inventory => Periodic Activities => Adjust Cost - Item Entries" Decimal overflow error runs. This error runs for only one item. Any suggestions :?:
-
(Wrong forum)error trying to drop a message in m...
Im having some throuble simply just throwing a msmq message into a Queue on a remote computer....maybee i got the syntax mixed up or something.. Not sure im totally correct here but this should work under a button in a form right? (assuming i have a XML loaded in the XMLDoc) it's a Public Queue called fromNavision on the…
-
How to change the datatype of a field, when there is data.
Dear All, How can I change the data type of a field, when there is data in it? for example, An integer filed in a table contains data, Now I would like to change the data type of it to Decimal with out affecting data in it? how can I achieve this?
-
Var in Codeunit
Hello, sorry that I cannot speak english that good, so I will explain my problem in German. Maybe here's someone who speaks German. Ich möchte in einem VK-Report die Daten aus "Item Ledger Entry" auslesen. Dabei filtere ich auf einen bestimmten Datumsbereich, den der User wählen kann. Nun möchte ich zu jeder der…
-
Sell?
We have been using Navision 3.10 for several years (and still owe a ton of money yet) but our business has gotten a lot smaller in the last few years and Navision is a way over-kill for us. Is there a way to actually sell our license or something? Just curious and checking out our options. :-k (BTW, we do like Navision,…
-
Navision Database Size increasing very rapidly
Hi I had implemented navision 3.7 version with navision database to one of my client, problem is that database size is inreasing very rapidly, size is now more than 4GB, can any body tell is there any database tunning or optimization is available for navision database or what could be the reason why my database is…
-
XML childnodes
Hi there I have a problem extracting XML content, and insert it into a Navision table. The code looks like this:XMLDocument.loadXML(RecordSet2.Fields.Item(xmlstring).Value); XMLNodeList := XMLDocument.getElementsByTagName('CUBE/khoved')); XMLNode := XMLNodeList.item(0); REPEAT MESSAGE(FORMAT(XMLNode.nodeTypedValue));…
-
Upgrade 3.6 to 3.7 executables only
Hi all, This is my first time posting on this form - just wanted to start with an "hello" - it's nice to be nice :D Anyway I am upgrading a Navision Native 3.60 to Navision Native 3.70 and was told it's as easy as a backup and restore to the new client (we are not re developing the DB so there should be no object changes)…
-
Problem with CFRONT OCX !! HELP ME
Hi All I have been trying to get rid of this problem since yesterday and still there are so many things that i cannot make out. :x I am developing an utility in VB 6.0 that will copy data from a table in one company in a database to another in different database. I first tried to read data from one navision database. It…
-
How to format decimal..?
I have a decimal number(field in report) and I tried to use DecimalPlaces property of the field 0:0, because I need numbers before decimal separator: example: I have: 26,154.97 and I need: 26,154 and 0:0 doesn't do that.......after that I tried with ROUND: SalesAmount[j] := ROUND(SalesAmount2[k],1,'>'); and with this I got…
-
Conditional printing of an extra invoice supplement
Hi there I would like to be able to print a kind of invoice supplement for certain customers. The supplement contains additional information on historic invoices for that customer, so it's also based on the sales invoice header table. Depending on a boolean field on the customer card, I can choose whether a supplement…
-
How to get whole record from lookup table, not only a field
Hello everyone, pls help I have a table XYZ with option field. The selected option determines which table will be use for lookup, and it works. The problem is when i raise the lookup table, and select a record, a certain value is inserted in tbl XYZ in field2, and I would like automaticallly to fill one more field in tbl…
-
MAPI Handler to SMTP
I need to change our bulk email code from MAPI to SMTP. When we send bulk emails from Navision Outlook pops up a message for each email. From what I understand I need to change the code from MAPI to SMTP. Unfortunately I am still learning the code but I need to make the changes. Can anyone help me with this. I need to…
-
POS fin.exe error
I use LSRetail for Navision 3.60, an two POS connected to a server, each with it's own printer. I input data on a POS, and before it is commited on the server, it's sent to the printer. Everything works OK on both POS. But when I attempt to do the same thing almost at the same time, meaning that the second POS starts a…
-
Compiling problem !!!
I imported an object-fob and want to run it. The 3.70 client says 'the C/AL object was not saved in a compiled form'. When I compile it with F11, there's no error message whatsoever and I can go into design mode if I want to. But it DOES NOT compile, because the error message occurs every time when I try to run it. Help !…
-
Outlook integration over TS
Does anyone see a way to integrate Navision and Outlook over Terminal Server when the end-user logs ito TS using the same credentials as Outlook? Is that feasible? Thanks, Ch.
-
PictureConvertor - are there any options ?
Hello to all, I use the pictureConvertor in Navision 2.6. It works very well, and now I can view my Jpg in many forms in Navision. Now, I'm looking for a similar program that converts the PDFs to BMP using the same system of Picture Convertor. Since now I find a Shareware program, and I'm testing it (PDF2IMG). This program…
-
Footer on the BOTTOM of every page
How can I do it?
-
SOX compliant roles and user security
hello folks, as part of building sox compliant roles, we need to create a role (say, USER ADMIN) that, if given to a particular user, will allow them to: a) insert/update/delete a user b) insert/update/delete a role c) assign/unassign roles to other users. d) assign table/form/object access rights to roles. This may sound…
-
Quick one about reports!
How can I print something like this: "Page 1 of 17" I know about the current page (CurrReport.PAGENO) but how to get total No of pages?
-
faxing
Hello all, does anybody know a fax software for windows pcs that can be used as automation servers from within navision 3.6 in a way that i can pass the fax number to the software without having to pop the fax window to the user? thanks
-
Dataport imports only 1 record
Hi I have to import a bunch of records from a TAB-seperated file (generated via 'save as' in Excel). However, the dataport only imports the first line of the file. There's no error message, it just cycles through the lines of the importfile without importing. I think it has to do with the recordseparator. At the moment it…
-
Background Color change inside a form
I am using Navision 3.7 and can't change the color of the background (in order to do shading) on any form. When I choose grey color (click background) and make sure foreground is a different color I still get a white background and black text. Can anyone tell me how to change the background color for a form (ie Invoice,…
-
Report layout in navision 3.6
I'm having a problem with reports, when i change the font color of a textfield or a label it still previews in black , and it prints in black please note that color pictures show and print in color so it's not a problem with my printer setting. can anyone help me with that? thanks saro
-
Can we pass parameter into the report?
Can we pass a parameter from a processing only report to a normal report? My scenario : I have 2 report, let say the processing only report as Report 1 and normal report as Report 2. Report 1, which require ReqFilterField to be entered by the user. After the running the report 1, Report 2 need to be printed. The Report 2…
-
3.01 : User can not log in due to TCP/IP connection
Hi All, My customer has been using the PC for sometime, Navision native version. However, recenty the user is not able to log in to Navision. Message prompted as belwo : "TCP/IP connection's 'host' is not answering (TCP/IP error ECONNREFUSED) You can see how to make changes to your 'hosts' and 'services' files in the…