-
account schedules
When you are in account schedules and choose print, how does Navision know to run report 10028? I want it to run 10029, the landscape version of account schedules.
-
Employee time capturing module
Hi, I am looking for an employee time capturing module to integrate to 2.6 and to be used in Germany. Any idees ? Gretings, Philippe
-
Using .dll
I have a activex control (.dll) that I have registered and am now trying to use it in Navision. It appears in the list of automation servers and all its methods and properties are visible. My problem is actually using it. Whenever I try to create an instance of it (or ANY automation server), I get the message: "Could not…
-
CFront and Boolean Field (VB)
Hi all, I have problem with the AssignField sub. Nothing happen when I try to update a boolean field. No error message, no update. Help me !!!! <img border="0" title="" alt="" src="images/smiles/icon_confused.gif" />
-
ver 2.60 e sql
Hello friends, can one have the Navision ver. 2.6 E SQL and Windows NT and SQL ver. 7.0? Thank you <img border="0" title="" alt="" src="images/smiles/icon_confused.gif" />
-
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…
-
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…
-
Visio Automation
Is it possible to link Navision (Any version) to a MS Visio sheet. Apparently Great Plains is able to take a Visio diagram with a Bill of Materials and use that within their system. We need to do something similar.
-
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?
-
excel pictures
Somebody knows how i can to attach a picture in Excel from Navision. Thanks!!!
-
Call Windows Calculator from Navision
Hi all, Is it possible to call Window Calculator program from within Navision? Thanks. scott
-
ODBC and Date Format
I've been having trouble with the date format in my ODBC sql statement. I've seen code in here and copied it exactly and still nothing works. I get the error message to the effect of "not correct operator for operand: =". My code is:...... ....AND "Posting Date = {d '2001-01-01'} My sql statement works fine if this…
-
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
-
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" />
-
Code 128
I want to print a code 128 barcode. In 90% of the fiels the scanner can read the barcode but in 10% not. Have anybody an idea why it not work.
-
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…
-
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…
-
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…
-
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…
-
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
-
extend field length for item description
We are about to start to work with Attain and found that the item description field is limited to 30 chars. We maintain a list of about 16.000 items that come via imports from vendor price lists. These price lists have descriptions up to 100 chars and more. So we need this lengt also in Attain. Has anyone ever changed this…
-
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
-
temporrary tables
How can i let a subform show the records of a temporary table (defined in globals as record with property temporary = yes) Thx
-
import text longer than 250 chars to comments
We need to import text from our old CRM system to Navision comment fields wicht are limited to 80 chars. The idea is to split the text to multiple lines but how to deal with a 250+ char string in a dataport. Any ideas? Uwe <img border="0" title="" alt="" src="images/smiles/icon_confused.gif" />
-
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…
-
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…
-
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]
-
Takes too much time to rename a large item table
Hi everyone, Has anyone ever had to rename a whole table of master records such as the Item table where there are many other tables that must get renamed also and where there are many, many items to rename?? I have a clients that wants to rename all the items in the item table - they have 250,000 items and it takes 2-3…