-
Access to the tables
hi! i have to change values in one field (value '100' to value '900') and that in around 150 tables (around 1,000,000 items)... normaly, i will use report or codeunit and MODIFY... but, i have to every time to change value of REC variable, or to define 150 variables... is there any possibility to access different tables…
-
Transfer of Items from one Bin Location to another Bin Locat
Hi, I need to transfer items from one bin to another bin, both bins are in the same Zone and Location. Thanks for your help SL
-
Set Focus on a Field
Hi, How can I set focus on a Field. Thanks SL
-
Problems using SQL ODBC from Navision to Excel
Hi there, I'm trying to export the chart of accounts (from table 15 G/L Account) to Excel, and I am encountering a few problems. Firstly, I can't use the query wizard because of the fact that some field names contain an "." (Eg. G/L Account No.).. is there anyway around this without having to rename the field name?…
-
excel automation
Hello, I have two problems; 1) How complete the instruction "ExcelApplication.Workbooks.Close" for saving the file whith no prompt question ? 2) How complete the instruction "wdApp.ActiveDocument.MailMerge.OpenDataSource(MergeFileName)" to specify the plage of cells ? many thanks for your help <img border="0" title=""…
-
Internet Explorer Automation
Hello. I use the Internet Explorer automation variable, to call some ASP pages that does some filehandling. While the ASP page is being processed, I use a loop to check when IE.Busy = false, then I close the IE. Once in a while Financial returns an error message. Error on calling Busy, the server returned an unknown error…
-
Interbase to Navision
We have several products written In Delphi using an interbase database and we would like to transfer data bach and forth between databases. We have used dataports and file transfers but would like to use a better way. I have read over all the posts in this section and it appeas we have several choices such as C/Front,…
-
Word automation control
Hello, To put a variable in a mergefield WORD, I use the instruction: WdRange:=wdApp.ActiveDocument.Fields.Item(2).Result; wdRange.Text := ValVar; I would to assign the mergefield by its name in the word document ex: WdRange:=wdapp.activeDocument.Fields.Item(ADRESS).Result; Do you have a solution ? Many tanks <img…
-
Navision Server running on Citrix Server
<img border="0" title="" alt="[Confused]" src="images/smiles/icon_confused.gif" /> I want to install the navision server on a Citrix Xpa Server (W2K). When I start the service I get the error: the service on local System could not start. Error 1 (auf Deutsch: Der Dienst auf "Lokaler Computer" konnte nicht gestartet werden.…
-
Inputbox or something similar
It sounds a litlle bit silly but I'm looking for a very simple input of a string without using a form. Is there any way to do so in Inputbox or something else (like message, but with input). Who knows the command (if there is one) Thanks Chris
-
Run status of Dataport
Hello All, I have a code unit that starts a dataport, ObjDataport.FILENAME:=strFileName; ObjDataport.IMPORT:=TRUE; ObjDataport.RUNMODAL; CLEAR(ObjDataport); How do I know if the dataport has run with out errors I know I can tricks about with deleting the file in the onPostDataport trigga. But I would like to keep all this…
-
Fritz Fax
Hi, My customer wants to generate faxes without entering the fax-numbers manually. So i thought of using an automation control for that. he uses Fritz!Fax Software. Does anyone have experience in this kind of topic ? Thanx for your help <img border="0" title="" alt="[Roll Eyes]" src="images/smiles/icon_rolleyes.gif" />…
-
C/ODBC + Change Company Name
Hello, I'm connecting to a Navision Database with C/ODBC driver. That works fine! But than I try to change the company and get the following error message: [Navision Software a/s][Navision Financials ODBC Driver]Data source rejected establishment of connection First I set the Company Name in my connection string like this:…
-
Specify another USERID for printing report
Hi all Anybody knows if its possible, and then how, to Specify another USERID for printing report. <img border="0" title="" alt="[Confused]" src="images/smiles/icon_confused.gif" /> This is to control the Printer selection when using Post+Print.
-
run report at specific time
Hi all, I want to run a report at certain time.Who can I tell Navision to wait a specific time. Can I use "sleep" command? Thanks a lot
-
Language Module
Hello, I'm using NF NL 2.01. In the object designer I can export and import language modules (Tools-Language Module-Import or Export). How does this work and where can I use it for? I thought it was for the following: I've created a report with several labels. In those labels I have entered a NLG and a ENG CaptionML. Those…
-
OKI vs WIN 2000
Hello, i have some problems with OKI Matrix Printers under WIN 2000. Theres no chance to print in "German Fanfold" or any other "Fanfold" under NF 2.60. I choose the Printer in Windows as "Default" and the Property "PaperSize" in the Reports, but theres no Change. Then i saw a bad thing: The "default Papersize" in the…
-
Labour costs entry possibility ?
Hi Financials experts and users, being new to Navision and end user of version 2.60.C BE I was wondering if there is a easy way of handling labour costs in the CRP module. To my opinion any production of goods consists of: Dir Labour, machine costs, maybe Overhead and maybe indirect costs ( apart from DL all are perfect…
-
Copy to clipboard
Hello, does anyone know how to export a textstring (including CR and LF) to the clipboard to paste this string in Word / Excel / AnyOtherProgram? Actual I open a form wich displays the generated string and the user has to press CTRL-C (to copy). I want to send the string directly into the clipboardwithout this special…
-
Navision and Groupwise
I found a posting from brucem, saying that he has a dll to send e-mail's without using the groupwise client. I have sent him an e-mail, but hist last posting was from 2001 so i don't know if i can contact him or not. So this post here is for the fact that i cant't contact him. Following Problem: Follwing smaple VB6 code…
-
Navision IRC channel
Hi guys, We formed an IRC (Internet Relay Chat==Realtime Chat) channel that's concerned with Navision Software of all sorts. It is located on the old and faithful IRCNET and named #navision. This is of course not a webbased chat and people who are not familiar with IRC might like to checkout www.mirc.com for an easy to use…
-
SAVEASHTML
Hi all, how can i say with Report.Saveashtml wich filename the html fle should have, and on which record it sould run. In the Helpfile there are two methods : [Ok :=] Report.SAVEASHTML(Number, FileName [,SystemPrinter] [, Rec]) [Ok :=] r.SAVEASHTML(FileName) But when i use it in code, an error comes when i usw more then…
-
Analysing bytes for Integer
I need to analyse every byte of Integer (4bytes). How can I divide integer into 4 bytes and assign every byte to another variable? For example, in Visual Basic it is made this way: Dim Sum As Long Dim Mark1 As Integer Dim Mark2 As Integer Dim Mark3 As Integer Dim Instring As Variant If Sum And &H8000& Then Mark1 = &H8000…
-
.fbk export?
How do I export my current .fbk file to either a txt or xls format? Is there a downloadable program for this? Thanks! --KZ
-
Connect to SQL Navision Via SQL Driver ??
Have you seen this before.. I have a machine with Access 97 and Visual studio 6 on it. I am trying to conenct to the navision SQL database on a separate server. I have created a system DSN using the SQL ODBC driver to connect to the database. In visual interdev 6.0 ( serv pack 4) i can create a data connection and show all…
-
Access & Navision
Hi! Im spainsh so i dont know so much English. I hope you understand me. I have to import / export databases between Access and Navision. I just know that I must use "Dataport" and "C/AL" languaje, but i dont have some tutorials or help. Please, let me know how do it, show me resurces like tutorials. Thaks you.
-
OCX for Navision Financials ?
Hi, i'm looking for a ocx that i can use to transfer/receive files from c/al. Exists there one ? Thanks. Best regards, Kai.
-
BLOBS
Does anybody know if I can use a blob object to store the results of filtering a table? I'd like, if it's possible, some example code. <img border="0" title="" alt="[Wink]" src="images/smiles/icon_wink.gif" /> Thank you. Regards from Valladolid.
-
FIFO Method
Hi all , I have problem the " unit cost" calculation using FIFO method when I sold. Example : Purchase 22-06-02 = 5 @ 500 = 2500 Purchase 25-06-02 = 3 @ 550 = 1650 Sale 27-06-02 = 2 @ 600 = 1200 When I sold it , the unit cost become = (2500+1650):8 = 518.75 Isn't right ? It should be the unit cost 500 . How Should I do if…
-
System Date Format
How can I get current system date format (for example dd.mm.yyyy. etc.)?