-
convert numeric numbers to numeric text ??
I am having a little problem with creating a unique file name, what i am doing is creating a file based on hour / mine / sec plus a couple of counting integers X and Z. I have been using the string below to create the files, but i am having problems where Navision is converting the numeric values in FORMAT(z) + FORMAT(x)…
-
Navision-Reports to PDF
I'm searching for a tool that converts Navision-Reports in PDF-Files. It must run under Navision. Have anybody Solutions to this Problem? <img border="0" title="" alt="" src="images/smiles/icon_confused.gif" /> Thanks Stefan
-
CalcTime function ?
We want to display the elapsed time spend to create a report. For example Started at 9:10:00, completed at 9:15:40 = Elapsed 5'40", or Started 23:55:00 and completed next day at 0:10:30 = Elapsed 15'30". C/Side can compute Date2 - Date1 but not Time2 - Time1. Another function should be used to add times, for example one…
-
Creating standard labels in Navision
Has anyone created templates for avery or other standard types of labels for use in Navision. Specifically I am trying to create shipping labels (8.5" x 11" sheets - 2 cdolumns, 3 rows) and having a tough time figuring out how to configure this type of document in the navision "designer". Any help would be greatly…
-
Writing Command codes to text file ?
I am trying to write some command codes to a text file and Navision seems to want add some of its own. My code reads: Variables - ESC Char LF Char NUL Char ESC := 27; LF := 10; NUL := 0; Line 1 := Format(ESC)+ 'C' + Format(LF) + Format(NUL); I expected to get : [ESC]C[LF][NUL] What I got was : [ESC] C [CR][LF][CR][LF] Has…
-
Transportation Management
Has anyone created a transportation management system for Financials? The scenario is a very large company that ships minerals in bulk via rail car and ship and needs to track carrier, container id, schedules, inventory in-transit, etc.
-
Interfacing with Barcode Scanning devices.
As a new Navision Developer I would like advice on the best way to send information from a scanning device to the DB. eg Inventory figures. I am also interested in sending out information eg the Activities Due list from Contact Management. Typically use Symbol Scanners models SPT 1700 ro SPT 2700. thanks
-
How to deal with Arabic in Navision?
I want to shift the cursor position from left to right so I can write in Navision with Arabic language (because in Arabic we write from right to left). This option exists in Microsoft products by taping CTRL shift. Thanks for any advice. Please send answers to rbj_nav@yahoo.com
-
EDI and Kewil
Has anyone developed a dataport/report which outputs a file suitable for Kewil systems EDI software?
-
ODBC & ISAM
I'm trying to access Nav GB2.01B via the CODBC driver 2.11.02.1507. I've installed the driver and set up a DS with the options 1)All Characters and 2)Integers set. The Database name is browsed to and the Company name is set as "CRONUS UK Ltd." without the quotes. The connection is local and the Program Folder box is empty.…
-
More information on Advance Destribution
Dear colleague I would like to know more about Advance Destribution - I’m on the search for an On-Line Manual - Advance Distribution. If you should have one and you don’t mind to share.. please send a copy to me.. I thank you in advance.. Yours truly, Rik Andersen radata@bellatlantic.net
-
Maximum security - disable menu items
Anybody knows a way to disable *all* menu items? One of our customers wants to offer remote access to a specific table in Navision (2.5 SQL), allowing Anonymous Guest logins. We would like to create a GUEST usergroup, having the utmost minimal permissions. Strange thing, however, is that you can't block access to several…
-
Call Center Solution
We are looking for a Call Center solution written in or linking to Navision Financials for one of our clients. Can anyone help? Greg
-
How to change posting date?
I am an end user and am bringing data from another accounting package (Sage) using a mixture of imports & manual entries. I have found that some of my journals have taken the actual date of posting as opposed to the posting date. This is causing me problems as extremely detailed invoices may have to reposted. It would be…
-
VB, ODBC, ADO and Navision
In a VB application using Data Environment I can access my Navision ODBC connection. When trying to access the Navision ODBC connection by programming with ADO, I am getting the error… [Navision Software a/s][Navision Financials ODBC Driver]Expected lexical element not found: <identifier> My Code in the Class is as follows…
-
Navision Financials with SQL
We have a pretty big problem and our Navision Solution Center was not able to help us yet. We have installed the Database on the SQL 7 Server. The installation was done according to the manual. I was able to reproduce this error on the Cronus Database. It is as follows: If you go into the Customers and press F5 and select…
-
Cost problem in Finished Prod. Order ! (2.01b)
Hy, I have some difference in the Cost Evaluation in the Finished Prod Order ... Before, I run Periodic activities in the Inventory 1. Adujust Cost - Item Entries 2. Post Inventory Cost to G/L Periodic activities in Manufacturing 3. Work In progress - Calc and Post Cost Value (for all level) and i repeat for each level…
-
Incoming TAPI 3.0 events
HELP!!!!!!!!! <img border="0" title="" alt="" src="images/smiles/icon_confused.gif" /> A server based telephone exchange brings incoming messages as TAPI 3.0 events... on incoming call I should start a Navision Form with adress of the owner of the incoming phone... Has anybody experiences with such problems? Would be very…
-
How to translate Captions?
I'm using Version 2.60 Swiss-German. If I create a Form using my Swiss Navision License, Multilanguage Captions are stored as DES="My Title" If a non-Swiss User tries to import the FOB in Text-Format he receives an error telling him that he has not the right to use Language "DES" (Deutsch, Schweiz) which makes sense in a…
-
Navision Financials / Manufacturing French Users ...
I would like create one Navision French Team (Belgian, French, ....) for discuss about problem and their solutions on the french version Navision financials / manufacturing (2.01b) Are you ready ? <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" />
-
Financials 2.6 Contact management
We are working on some enhancements to Financials Contact management, like allowing quotes to prospects etc . We have heard rumors that 2.6 (not released yet in the US has many enhancements to Contact management. can any one confirm this and possibly give some highlights. Thanks Steve
-
Siebel Integration
One of my clients is using Siebel for sales quotes. Siebel exports new customers, new quote headers, and new quote details to three text files every two hours. Customer file names have prefix ACCT, followed by year, date, hour and minute. Quote Header file names have prefix QTHR, followed by year, date, hour and minute,…
-
Navision - ODBC - VB
Can someone post some code how to connect to a Navision database using ODBC in a Visual Basic v6 application? I created a ODBC DataSource using the Control Panel (named Navision) and use the following code in VB: Dim connNavision As New ADODB.Connection connNavision.ConnectionString = "DSN=Navision" connNavision.Open…
-
German zip codes needed
Hi everybody, Did someone implement the german zip-codes (Postleitzahlen) in Navision? Including search for Place/Street etc.? Marcus Fabian m.fabian@thenet.ch +41 79 439 78 72
-
C/FRONT and choice of compiler
Hi guys Just some information, if you would like to use a freeware C/C++ compiler to compile your C/FRONT executables. If you're using the C/FRONT interface to Navision, many developers obviously prefer Microsoft compiler as their development tool of choice. But it is possible to use a free compiler under the GNU license.…
-
Tips&Tricks: Excel Automation
I notice that in this forum (and not only ther) the same questions and problems concerning Excel automation are being asked over and over again. So let me share some of my experience with you: --- DECLARATION --- Name DataType Subtype Length xlWorkbooks Automation 'Microsoft Excel 9.0 Object Library'.Workbooks…
-
Navision and Word
Hello, I took the program "NF automation Examples" to do my first program with Word. It doens't works ! I receive this message "Impossible to activate this application". Do you know what it's wrong ? wdApp : Microsoft Word 9.0 Object Library - Application wdDoc : Microsoft Word 9.0 Object Library - Document wdRange :…
-
Translate Navision Objetcs
I search for a tool to translate our add-ons Navision in multi-caption, who would use a file created with tools / translate / export to create other one of it with a second language code. Thanks a lot Etienne PRUVOST GESWAY S.A.
-
MAPI call and Carrige Return
I need to generate a list of items and send this via outlook. The email connection works fine but I cannot send a carrige return/new line with each text item. I have tried asc(10) and chr(10) but Navision sees these as undeclared variables. The following also doesn't work. CR is declared as type character. CR:=10;…
-
Add-on for "Transport of Dangerous goods"
Hi ! Has anyone worked on the Transport of Dangerous Goods issue ? Is there maybe an existing add-on ? I'm interested in any possible information, especially according to the EC rules : Directive 94/55/EC and amendments, packaging and labelling requirements... Thanks for any information