-
automaticly logon
Hi, i want to create some program for automatic logon to NAVISION (Attain 3.60). I need to know ID of editbox for name and password, but I don't know it. I need to send text (name and password) to this logon window and run some import and export process. Or is other way to automatic logon? thx Brano
-
Cost Application column in the Item Application Entry table
Good Day Can anyone tell me what the Cost Application field in the Item Application Entry table is for? The reason why i ask is that if i look on the Item Ledger Entry table and go to Application and Applied entries i can't see any applied entries. I looked at the code that runs on this button and found the filters and…
-
QAS integration
I'm looking at integrating the QAS 4.02 PRO interface into Navision. I've created an automation dll which references the functions in QAUPIED.DLL The code successfully returns an address line for a specified postcode, which is good Then, the Navision client crashes (no messages) which is very bad. Anyone any similar…
-
Display picture in a form
I want to show picture in the picture box on a form. However, BMP file is stored at c:\pictures\xxxx.bmp. It is easy to show picture from a BLOB field of a table but how to show it by exporting from the above path. I tried with bitmaplist property but get an error "Invalid Device-independent Bitmap file" Is it doable and…
-
How to Enter Ascii-Code 29 in Textbox on Form?
How can I enter an Ascii-Code 29 in an Textbox on a Form? If I enter it by ALT and 29 on the numlock only a Question Mark appears. If I scan it thru an Barcodescanner it is entirely omissed. To Explain the question: We would like to scan an Ean128 into a Textfield in Navision. In an Ean128-Code every field with variable…
-
Setting properties of an image in a picture box
I need to print a picture on a report, but if possible I want to change the size of this picture, i.e. the picture in the database could be 640x480 pixels, but on the report I want to change the display size to 320x240. Is this possible or should I really change the size of the image in the BLOB?
-
problem with odbc driver - datefields (access linked tables)
I just convert from a 2.00 to a 3.7 version I use the 3.7 odbc driver to link some tables in an access database I have no problem to see all of the informations, it work fine Problem happend if i use filter on date field, i receive the error "Invalid operand for operator : #1023" Have anyone some experience with this…
-
Reports
Hello All Within a sales order for example, when you print order confirmations, the order number is automatically populated within the report. However, within the report itself, I want to use the order number that is passed through to the report in the request form. My question is, how do I retrieve the order number that…
-
Relationship Mngmnt: Hd Qrtr customer w/ multiple locations
I need to set up a headquarter company in Contacts with multiple locations, and people in each location. Right now, we are entering each location as a separate company and adding the city name to the end of the company name. For example Nokia-Santa Clara, Nokia-SF, etc. Is there any way I can link these customers/contacts…
-
Selecting Job No. in General Journals
Hi ; I want to post an invoice or payment from General Journals, which is related to Job No; Of course it must effect the ledger entries fo that job.(Job Ledger Entry Table) Bu whenever I select a Job No. in General Journals, it is returning an error while posting. The error is "You must not specify Job No. in Gen. Journal…
-
Go to a record without using 'Find'
Hi all, What I'd like to be able to do is to go to the Sales Order form, scan a barcode that has a sales order (SO) number in it, then jump straight to that record. Is that possible? I know how to scan the barcode in and store the result in a variable, but how do I tell the Sales Order form to go to that record? Hope I'm…
-
is there a 'find' and 'replace' for a column?
In an upgrade, two of our columns in a table were not converted correctly...if i wanted to change 'P-MV' in an entire column to 'O-MV' is there an easy way or tool to do that? thanks, Trint
-
How to see Navisio table relations in SQL Server 2000
Hi all, How can I see the diagram of Navision table relations in SQL Server 2000 ? Thanks to all
-
Changecompany
I have a txt file which contains informartion for 2 companies from Navision and I want to imported in one step in both companies (each with his own values) using Validate trriger. How can I do it? (I've with table.CHANGECOMPANY but when Validate trriger is calles the correlated tables remains on work company) Cristina
-
A multi-user system?
Hey guys, I've got a little but important question if anyone knows.. I work for a company that has just merge from an old system, wich is As400, to Navision. Navision works well, and offer lots of opportunities but there is a glitch, the software seems kinda slow and I think we know what is the cause, and I'm asking you...…
-
Stop form closing
Is there a way to force a form to stay open if someone clicks the close button and a condition is not true. For example if I checked for a condition of the onClose trigger of the form can I then say if this is not true then keep the form open.
-
Report
Hi Experts, Plz help me out from this probs, i need 2 group multiple fields ,with multiple table in a single report, N number of grouping is possible while using single table in a "report wizard",but multiple tables cant be declared in a wizard will u plz help me imme.. i have explained it in detailed........ Table 1 Grp 1…
-
Rectification invoices in Spain.(Spain users)
[Non-English text removed by Administrator]
-
run Microsoft SQL 2000 & Navision on Linux..
can or cannot,tell me please. Thanks
-
CODBC and VB HELP!
I've read several posts on CODBC and there seems to be some conflicting info on wether or not you can read AND write to the navision database. We have a CSide Nav DB and I have created a dataenvironment in VB and can read the tables just fine. I have removed the "read only" check box in the CODBC DSN configuration, but I…
-
Disabling Tabs in Forms
Hi, In a customer card if I dont want the foreign trade and commerce portal tab, how do I make it invisible. Similarly how can I add new Tabs to any existing form. Regards Rajesh
-
DTS package Schedule with C/ODBC
Hello everybody, We are facing problems downloading Data from Navision DB to SQL Server via C/ODBC. We have create a single DTS package that runs fine as far as it´s executed from the package designer. If I try to schedule it , the job will terminate with error "Table not found" (SQL Server 2000) :( Whats wrong ?
-
solution price
hi everyone, can somebody tell me an average price of the solutions sold. i use the granule configurator but i think some setting might be wrong. i am interesting for a price in EUR. or how much is the whole package, all the granules???? thanks. Mada.
-
Eship - Reprinting UPS Label
When I go into posted packages (or Misc. Posted Packages) and click on Package->Labels I see 1 UPS Label (for example) On the Bottom when I click on the label Button i have two choices. 1)Print Package label 2)View with Notepad View with notepad works fine. When I click on Print Package Label it goes to a command prompt:…
-
how do i install navision on SQL server 2000
hello, i have to set up a test server to test the time it takes to make a software upgrade from 2.6 to 3.1 problem: i have already set up a machine with sql 2000 and the correct sorting-properties. then i installed the xp_ndo.dll in the SQL-BINN-directory, also the stored procedure. but when i try to open the database with…
-
Upgrading From Nav version 3.1 to Version 3.7A
Hi Guys, I have the task of upgrading from Navision version 3.1 to version 3.7a. before i start to do this, i want some suggestions from you guys. What is the best approach to accomplish this task with minimal effort. Thanks Naveen.
-
String Conversion
Hi, perhaps a simple question, but i found not useable in the online Help and nor here in the Forum search. I have a String.... Str := 'My Bicycle. My Car. My House'; What must i do for separate this String on the "." (Point). Its Possible do it? So that i have: Str1 := 'My Bicycle'; Str2 := 'My Car'; Str3 := 'My House';…
-
How can I run external Application from Navision
Where can I find example of run external Application from Navision. I think I should using RunObject -> RunCommand but don't know format of this string parametr. Thanx.
-
exporting output of a record
hi people, can anyoane give me a hint as to how to export the output of a record in Excel or Access. To be more exact report 16102. thanks in advance. Mada.
-
How to get users and roles from a backup
Hi all, How to get users and roles from a backup of SQL Server Navison database after its restoration ? Thanks for all