-
a small prob
Hi all out there, I have a flow field in a table. In the properties under Calcformula there is Sum(Debitorenposten."Restbetrag (MW)" WHERE (Offen=CONST(Ja),Debitorennr.=FIELD(Nr.),Kostenstellencode=FIELD(Kostenstellenfilter),Kostenträgercode=FIELD(Kostenträgerfilter),Fälligkeitsdatum=FIELD(Datumsfilter),Währungscode=F…
-
trigger “onTimer” and the property “timerinterval”
Hello, I shall like to know how use the trigger “onTimer” and the property “timerinterval” in the form. I look for examples, thank you. Benoît
-
Indexing an array in C/AL
Hello, i wan't to do the following: 3 dimensional Text Array 1 2 3 1 Debitor No. integer 2 Debitor Name text And so on. This means, array[1][1] => Debitor array[1][2] => No. array[1][3] => integer Now i wan't to do the following to get the value: val := array[1][1].array[1][2]; means val := Debitor."Nr."; But how can i…
-
I need insert the sama value in two tables, how?
I everybody, I have two tables table1 and table2, and when I insert a value in field field1 in table1 I want that value was automaticly inserted in field10in table2. I think that's possibly but I don't know how do that. Somoene can help me? Obs.: table1.field1 is primarykey and table2.field10 isn´t, that's metter? Thank's…
-
Run a dataport from a batch file
Hi everyone, Can you please tell how can I run a dataport (Import data) without getting into Navision? Is there any command for example: RUN Command DatabaseName User/Password filename ETc Thanks SL
-
Call Windows Calculator from Navision
Hi all, Is it possible to call Window Calculator program from within Navision? Thanks. scott
-
VB, ODBC, ADO and Navision once again
Hi, I try to invent a complete connection to a Navision database through ODBC with ADO. Through this connection I want to acces a table and add, delete and change a recordset. My Code : Set cnODBC = New ADODB.Connection cnODBC.Open "DRIVER={C/ODBC 32…
-
problem in sql
Dear friends, I have a problem with Navision financials 2.6 SQL, I execute a listing of products and of each product I consent to the table 32 of mov. of products to take out certain information (with a repeat_____until, reset in each product of the chart 32), the first time it leaves me well, but I throw it without…
-
Duplicate Payment
We have encountered a problem with a duplicate payment on a vendor card. This payment did not actually occur but b/c of our setup is appearing on the vendor card. Does anyone know how to correct this problem?
-
Navision F. and sending faxes
I have a customer who wants to send faxes from his NF clients. for example, sending purchase orders. The problem is : he wants them to be faxed automatically with the fax number of the supplier. Then I thought to Zetafax (i had read it in navision.net). But the NF clients are on NT TSE without Citrix. The french Zetafax…
-
SQL - Retrieving Current Balance (simple or not?)
In Navision you can use SIFT technology to obtain for example, the current balance for any given "G/L Account" as this is a flowfield into the "G/L Entry" table. We have a client with 2 million records in "G/L Entry". They want to write their own SQL utilities to retrieve the current balance and merge it with other data…
-
Document height with automation control
Hello, I want to get the height (in mm) between the top of the first line and the bottom of the last line of a word document with automation control. Can anybody help me ? Many tanks <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" />
-
Print twice
Hello I need to print invoices twice like discribed below: If there is 2 pages in 1 invoice , I would like to print twice the first page and then twice the second page . It is working well if I write 2 copies in the printer window. But if I don't want to go threw the printer window (FALSE) how can I manage? Thanks in…
-
Dae format
Hello, I used a date function : STRSUBSTNO('%1',DATE2DMY(TODAY, 2)) So for example when it is the first of January, i get 1. This is jsut my problem when the day is smaller than 10, the function always returns 1 digit. So in this case i have to get 01. Of course I first can do a test IF value < 10 then ....; But i Want it…
-
Convert text values to number or char, how?
I there, I'm new to Navision (I have NF 2.6) and I need make an expression and I have a problem! I have a string and I need multiply each position in that string. well, what I try to do is COPYSTR("my string",1,1) * 10 but that give me an error, and that´s correct. So, how can I convert the result of COPYSTR in a number or…
-
report design
Can anybody help? I'm a new user of Navision trying to assemble my first report - I have built it to the point of adding a subtotal per section but I need to add a grand total at the end - how do I do this? Any advice would be welcome. Thanks Neil
-
Simpe question
Hi friends, I want to mail from the marketing modul,from the campaigns. A button calls a report, based on the campaign-lines. So far so good. But how can I post automaticalle the campaign-number into the requestform of the report? <img border="0" title="" alt="" src="images/smiles/icon_eek.gif" />
-
Date Field via ODBC
Hi All, can anyone please tell my, why the folling SQL statement using ODBC doesn't work? <BLOCKQUOTE><font size="1" face="Verdana, Arial">code:</font><HR><pre> select "Artikelnr_" from Artikelposten where Buchungsdatum = '11.12.01' </pre><HR></BLOCKQUOTE> Buchungsdatum is a Date field. thanks in advance Markus
-
Navision 2.6 Performance
We are seeing performance issues that have only surfaced afteran upgrade from NF 2.01 to 2.6b. It seems to hit only after prolonged periods of low activity (e.g. in the am) and when loading up objects (not running codeunits e.g. posting). Have already checked for ommission of set keys or dodgy keys. Database size os 3GB.…
-
Navision Financials on Windows XP
Ok, basically I am running a test side on an xp machine we recently purchased, or trying to atleast. Whenever I try to Expand the database so that I may restore a backup of the live side to this test side it gives an error refering to insufficient disk space... I am not sure if this is an xp issue or a Navision issue, but…
-
Outlook Forms
In Outlook 2000 I have put som vba behind a form. This is because we need to categorize each E-mail that is send. But, when I send an E-mail from Financials it doesn't use the form with the code behind. It uses a standard Outlook form. Why? Is it somewhere in the registration database.. Thanks.. <img border="0" title=""…
-
Sales Tax Updates
Does anyone know of a company that supplies sales tax update files to import into Navision? (Advanced Distribution)Do you have a dataport to bring this in? cmj@implementing.com[/EMAIL]
-
test part of fixed legnth string
Is there any way to test only part of a fixed length string example : myvar = text test = copystr(myvar,1,8) case test of 'ABC*****' : 'ABCD****' : 'ABCDE***' : end i'am looking for some sort of "joker" sign to use in a textstring '*' do not work Regards Peter
-
Bar Coding
One of my future projects involves finding a BarCode/Scanner solution that has been proven to work well with Navision (currently, running v2.5. Planning on upgrading to 3.01 in Q1 of 2002). Anyone out there using barcoding who can point me in the right direction would be greatly appreciated. Thanks!
-
MS SQL 2000
I use Navision Financials 2.60 on Microsoft SQL Server 2000 and I have problem with sorting text and code fields. I mean, on native db we have e.g. this order: 1, 2, 3, 10, 12, 100, but on SQL order looks as follows: 1, 10, 100, 12, 2, 3. So could someone help me to solve this problem? Please, send answers on my private…
-
Keys
In one of our tables we have 27 active keys. Since the table (I am speaking of table no. 32) is extreme slow I asked our NSC if I should combine keys differently and reduce the number of active keys. The answer was NO, I could keep all indexes active they were not responsible for slowing the table. I thought too many keys…
-
Update-Crash after addnew with odbc-connection
Hi there What's wrong, that cause this error:[Navision Software a/s][Navision Financials ODBC Driver]ISAM errorOption must not be blank.Option is missing or invalid in the expression I try to update fields of type "code" or "decimal" in a table by odbc-connection (V2.6d). It's possible to update fields of type "integer"…
-
Very long strings
Hi! I write a small Report that delivers some Navision-Tabledata to one of our MySQL-Servers. This is working so far. But... Now i wan't to export a Table with much fields so that the 'INSERT INTO *'-String gets very long (round about 1000 chars). If i try to write the string to a file: FH.WRITE( 'INSERT INTO test…
-
INSERT INTO ADO ODBC
Nearly finished with a small project I am working on to export attachments from Outlook directly into Navision. Through the Navision ODBC I can SELECT, UPDATE sucsessfully but I cannot seem to INSERT rows into the database. The code which is supposed to do this follows: DocID = GetNextNumber() strImagePath =…
-
Convert report to a text file
Is there a way to convert report to a text file? Basically we want to convert a report to multiple copies of same text file, and then add different contact name, company name and fax number or email address to become the first line of each of the text file. We will save them in the server and the fax or email program will…