-
UPS 128 barcode
Hello, Does anybody know how a "UPS 128" barcode is calculated?? Perhaps he/she can tell me where I can find an example. With kind regards, Maikel
-
Citrix Display Issue
We have recently installed Navision Financials version 3.01 on our Citrix Metaframe XP server (which has service pack 1 installed) running on Windows 2000 SP2. On some user's Windows 95/98 computers, when they run Navision as a published application they recieve screens that are all covered in black blocks and you cannot…
-
Adding Keys to Tables
Hi there, I am just wondering what effect (performance wise) adding a new key to a table would have. The reason is, our client heavily uses the Job Budget Line table, yet a report that they desire would require me to add another key to this table. A co-worker doesn't want me to do this because he believes the more keys in…
-
Hardware requirements for new Server
Hello, our Company has about 45 Clients on Navision Financials 2.6. Our Database is about 1,5 Years old and has now about 14 Gigs. Now we need a new Server, and we will get Attain in next two Month. Can somebody tell me what for a Server will be the best for us. I think about a: Single Xeon 2,2 1,5 Gig of memory 8 HDD`s…
-
Consolidated F/S-Jet Reports
Have any of the Jet Report users had success with Consolidated Financial Statements? I have seen a demo, they showed me where each company statement can be shown on a separate worksheet, we would like to see all companies on 1 worksheet. All of our companies are in 1 database and our chart of accounts are synchronized.…
-
Printing problem
This problem is a little hard to put into a subject but I'll try. Our database is a Navision 2.60 Version, however we made a technical update to Navision Attain. We are using Windows XP as system enviroment. Our Navision Server is running on Windows NT. Since our technical update we have problems printing invoices. The…
-
Printing part of text in BOLD in Navision
Hi Folks, I need to print a part of the text in Bold. For Example : In the Job table under description field i have a text 'Job No. 5000 is assigned to David Copperfield'. When i print a report i need to print the words 'David Copperfield' from the above text in BOLD. Any input is highly appreciated. Thanks Best regards…
-
access odbc-capable DB through C/AL ?
Hello, Does anybody know, if it is possible to access any odbc-capable database through Navision C/AL-Code? We have to access a Document Managment System which is separate from Navision-DB. We could write a program in SQL, but this query needs too much time.
-
Random numbering
Hello guys (and girls), I hope one of you can help me out with the following problem: For our batch numbering i've created a new no. serie where i make use of the default numbering (automatically). This because the batch no. has to be unique. Example: A001, A002, A003...... The problem is that i would like to use a random…
-
Dollar Signs on Navision Invoice
I have a request from a customer to add dollar signs to the fornt of the Subtotal and Total fields on the Navision Sales Invoice. What is the easiest way to do this?
-
word automation from a report
I want to run a report that will dump certain Job information straight into a Word Template for each record that the report runs through. To do this I am using the following Word Automation Globals: Name DataType Subtype Length wdApp Automation 'Microsoft Word 9.0 Object Library'.Application wdDoc Automation 'Microsoft…
-
SETRANGE with Datefilter
Hello, In the SETRANGE in the code of an ITEM report i would like to use the values of the datefilter. Does anybody know how i can solve this problem? For example: Item.SETRANGE(Datefilter,X); In this case is X the value the user enters in the field Datefilter when he tries to run the report. I've tried to make a variable…
-
If Keypressed(shift) Then ...
Is there any way to check from within the C/AL-Code if any key is pressed? Thanks 4 help Peter
-
Compare Tool
Hello, I hope someone can help me out. I'm using the compare tool (NF 2.01) to compare two objects (one of the cronus and one of the production DB). I've exported both objects as text files and placed them in the SOURCE and TARGET folder. Both files are for example called Tab100.txt. When I compare them a log file is…
-
running system objects
hi all, i need help if possible in two things: 1) anyone knows how to use a global variable with System DataType? I could define a global variable with System DataType, typing 'System' manually, but after create it, pressing F5 to show Symbol menu this variable has no properties or methods. I want to know if anyone knows…
-
Little Help wierd setup re ODBC
We run NF USA version 2.00.A (2.00.C) 2 ways: on a Win 2K server (our "Live" multi-user, main database) on a Windows box (right now on Win 98SE, test databse, single-user mode - use this one to really muck things up :D ) Been working on a "little" :wink: project, and to finish it off need to set up accessing NF from Excel…
-
AutoCad
Can any one tell me if there is an Auto CAD reviewer which can be fired from Navision forms? Thanx
-
Autocad automation
Hello, We are trying to open AutoCAD drawings using Automation controller. We are using AutoCAD version 14. When we are trying to create an instance op the Application or Document object using the Navision CREATE command we get the error that it was not possible to create the instance and the advice to check the…
-
Check pressing cancel in a dialog
Is there any way to I check if a user has pressed the cancel button in a dialog ? My current code is: dlg.open('Waiting for PDF-Printer @1@@@@@');repeat counter := counter + 1; dlg.update(1, counter);until exists(filename) or counter > 9999;dlg.close.... // do something with PDF-File i Thanks for any hints
-
problems with ODBC
Hello everybody. I have a problem when I'm using ODBC of Navision. When I try to make an update on a field of a table through the ODBC, with visual basic code, the following error appears: "ODBC --update on to linked table 'test' failed". Somebody has any idea that fixes it?.
-
Shell
Hi everybody, I'm having a problem with the function SHELL. First I tried to rename "test1.txt" into "test2.txt". This was correct. But when I tried to rename the file "test 1.txt" into "text 2.txt", it did not work. And I think the spatial is the cause of this. So my question is: How can I rename the file? With kind…
-
Run dataport from report
I've created a report to make some changes in the item table. On post report i want to run a dataport. Therefore a i've put the following code in the OnPostReport section of the report : DATAPORT.RUN(DATAPORT::"Import Verkoopbudget Stukprijs",TRUE); In the properties of the dataport the propertie UseReqForm is set to Yes.…
-
Automation with Navision 2.6
Does anyone have experience working with automation in Navision. Specifically, I am trying to execute an SQL Server stored procedure using the 'command' object of the Microsoft ActiveX Data Objects Library. According to the C/AL symbol menu, this takes a string for an argument, according to VB it takes a connection object.…
-
MatrixBox
Can anybody show how to make a form with matrixbox that shows Customers from Customer table and money amount for every customer in every date? It's very hot needing <img border="0" title="" alt="[Confused]" src="images/smiles/icon_confused.gif" /> Help
-
Help on C/ ODBC Conecction
Hi All I would like to retrieve and return datas from and to navision database using C/ODBC , How can i...? Regard's Prem
-
Assigning Printer bin problem
I'm having a lot of trouble trying to assign a specific report to a specific printer bin. The problem is that I can't access the third tray on my HP4100N's with 2 extra trays. Whenever I select tray 3 in my printer bin selection screen in Navision, it goes to tray 4. Has anybody ever encoutered the same issue?
-
Request Form
Can anybody help me with the following problem.... I want to run a (label)report from the customer form. I've put a field on the request form of the report where the user can adjust the number of labels he wants to print. All is working perfect but i want the field on the request form to have a default value that is…
-
Navision Crash, Win XP
Hello all NF Users, since one week we have several problems with our NF-Clients. In contrast to the time before is, that now between 60 and 80 agents work with NF (before about 6). NF crashs in variably situations (no complex process like "Mega"-Reports running). Anybody knew the problem? and a way out? or have an idea?…
-
cfront and table locking
Does anyone have an idea what would happen to a third party application trying to write to a table that is locked for modification within navision?
-
Automation & win 2000
Hi! I hope someone can help me: I'm experiencing such a problem, when I try to declare an Automation type var in C/AL Globals my Navision Attain 3.60 client hangs or almost seems to loop indefinitely and I can't see any Automation servers list, I have to kill fin.exe process! Maybe I have some problems with my win 2000 sp3…