-
Description in Charts of Accounts
Hi, I have a problem to get the correct description on my charts of accounts when e.g. invoices are booked through the Purchase & Payables, orders & invoices routine. When these orders/invoices are posted a description in my charts of account occurs like: invoice 8-011 or something similar. At invoice entry a description…
-
Migrating data from Great Plains Dos 9.5
I have a prospect that is wanting to convert 5 years of history from the 9.5 dos version of Great Plains to Navision. It seems that the only way they are able to extract data is saving reports in a text file which is close to useless. Does anyone know of a way or some existing routines or add-on software that can extract…
-
NCR Paper and Reports
Hello, We have a client that is printing multi-part documents with different color pages. NCR paper comes (white,yellow,pink) sheet and so on. Navision will print OK to this as long as the document doesn't exceed the first sheet of paper. When the first sheet is exceeded we need to print another white sheet, but in our…
-
SELECT Field with Points and Special characters
Hi! I want to Select a Field with Special characters like "." and "-" from an externally Program. I want to do that with SQL and JDBC but it dosn`t work. For Example: "SELECT 'No.', Description, Class FROM Item"; When I start the Program then this SELECT I get the Error: java.sql.SQLException: Column name: No. cannot be…
-
Navision 2.01A and EASY-Archiv 3.11
Hi there, does anyone have experience with EASY-Archiv 3.11 accessing the Navision-DB trough ODBC? I am trying to setup an index form in EASY with a DB lookup to the Navision table 122 (posted invoice). The big problem is that Navision is not able to produce views on the data fields in that order I need them for EASY. My…
-
Automatic execution of Navision
When I connect on our Navision, I should enter the user code and the password of the first window. I created an user (LANCESOIR) without password, which can launch only one : special automatic calculation of the accumulations of StatsExplorer report, which should be to execute every day; created so a service under Windows…
-
Tune Performance (Navision 2.51)
Hi, we use a very fast machine for our developer system (NF 2.51) on Windows NT 4.0 (SP6). We use a 32gb database (our database usage is currently 72% of 32gb). I have a small (?) problem: If i do the following stepts: 1. Format partition where to create new db 2. Create db (32 gb) 3. Resore Backup from mainsystem Step 1.…
-
How to create an automatic report
Hello, I desire to create a procedure allowing me to throw(launch) a report automatically, without passing through the Resquest Form of the options with validation. I have to try in several ways like OnInit() ACTION::OK; without succes... Thank you. Benoît formateur@ideaa.com
-
Statement of table of n positions.
Hello, I begin in the programation c/AL navision, and I do not know how to declare in global variabla a table of [n] position, could use to me, thank you. Benoît formateur@ideaa.com
-
Optionfields with CFRONT
I’m trying to import data into Navision via cfront. Everything goes well, except for the option fields. When I import the integer value with the function AssignField my VB exe crashes. When I try to import the text value of the option string Navision cfront ocx gives me an dataconversion error. I don’t understand where…
-
Navision and FRX
Has anyone (NSC) had any luck in getting Navision Financials 2.6 to work with FRX? I realize that FRX does not support Navision's GL. But I thought one of you wizards out there might know of someone who has written something that works. Our client has bought Navision Financials with Analyst, but they like the trees in FRX,…
-
ODBC error 3423
I am running Navision Financials on a C/SIDE database with version 2.01 objects, 2.5 executables and v2.5 C/ODBC. I have an Access97 database that is ODBC linked to the Production Order Routing Line table in Navision as part of a time/labor gathering program. We have 5 locations throughout the country and I am trying to…
-
Filtering table in subform
Hey all, i need to filter data shown in a subform. The subform simply contains telephone-call-data. In the mainform exists a control where the user can select a certain phonenumber, so only the call-data from this certain number shall be shown in the subform. That means i have to filter the data in the subform and to…
-
User of StatsExplorer for Navision
Hello, I look for users NAVISION of Add-on: STATSEPLORER to distribute by the company GESWAY France, because I like knowing how one can launch the update of the accumulation of the statistics automatically. Thank you Benoît Durand formateur@ideaa.com
-
Excel
Hello, How to open a file already existing Excel. I thought of this code, but unsuccessfully : CLEAR(App); OPEN(App); App.Visible(FALSE); Book := App.Workbooks.Add(); Sheet := Book.Worksheets.Add(); ... thank you, Benoît
-
Selecting Table
I am trying to create a utility that will allow me to change the text case from All Upper to Upper/Lower. I have created a Codeunit to do this but now I need to create a utility that will allow me to select a Navision Table and specify field names on the fly and then apply the codeunit. Any ideas as to how to dynamically…
-
Print PDF file with automation code ?
Hy, It's possible to print PDF files directly from Navision with automation code ? No problem with Word, excel ... but with Acrobat Reader ?! Please, help me ! Fabrice (from Belgium)
-
Mobile Solution for Pocket PCs, PDAs, or laptops
Check it out at www.simcrest.com Go to Products, then click on ExpandIT Mobile Solution.
-
Report 10040 - Aged Accounts Receivable
I need an Accounts Receivable Aging Report that prints only accounts with balances over 90 days with the ability to age off of due date. Has anyone written a report that would accomodate this request? The Base Navision Report only goes up to 60 days past due.
-
Palm Integration
I'm looking at a handy development environment for Palm OS. It's Satellite Forms (avaliable at http://www.pumatech.com). This is a high level dev.env. with possibilies to build applictions for the Palm with relations between tables,scripting, filtering and so on. One nice thing is that it's shipped with an OCX that can be…
-
Large Proprietary Mfg installations?
Is anyone running Navision Financials with Manufacturing (15,000 items) on the proprietary (C/SIDE) database (not SQL) with more than 200 users? We were advised to go with the SQL server for more than 70 users. During our testing, we have discovered performance challenges running the "Calculate Regenerative Plan" (MRP…
-
SQL space error
We are trying to restore a navision backup (NF 2.60 D) into a Navision Sql database (SQL 2000 on Win 2000) the size of the normal navision database is 20 GB there is 45 GB free space on the drive where the sql database is located, but we still got a "not enough space error" sql error. if you have any idea on how to solve…
-
MAPIMessages Actions
I'm looking for a list of MAPIMessages Actions. I want to be able to cancel one of several mail messages in a loop. Currently, when I do I receive the "User cancelled Process error". I'm thinking that any additional error handling code should go in the 397 codeunit with this: IF OpenDialog THEN MAPIMessages.Action(2) //…
-
C/AL vs. other progr.lang.
Hello, I'm a newbye in NF. Although c/al is a proprietary language, could it be learned studying another similar language? Thanks a lot. fan
-
Avoiding "Find as You Type"?
Does anyone know how to prevent the find dialogue property "Find as You Type" from being set to True automatically when the dialogue is invoked by a user typing on a non-editable field?
-
How can I update a SubForm?
I have a problem with the CurrForm.UPDATE command. I make a Form with 1 Mainform and 3 SubForms. Now I try to update my Mainform if the Customer modifies the SubForm. But It does not work. Who has a solution for this Problem? Dietmar
-
Statsexplorer
I have Work Type Code as 4:th sorting. In the statistic it shows just one line with Work Type Code km (kilometer)((Cronus Demodata)). The resource (Thomas) has rows with km and rows without Work Type Code. I registered two new rows with codes plan and riv. The statistic shows both new as plan. I want to see km, plan, riv…
-
X A L
Hi, Since I haven't been able to get into the XAL forum :-( I appologise for asking: how different is XAL from Nav.Financials? are both packages going to be merged in the near future, like their mother companies? Thanks. Fan
-
Warning On License NF
Hi.. I've got this message on my navision when I run more than 2 user,.... "Your program license does not permit more user to work simultaneously wait until another user has quit the program, contack your system manager if your want to allow more simultaneous user on your system"... On Our Customer site, Just for…
-
Avoid changing company
Hi I'd like to prevent some users from changing company in NF2.01. I know I can assign permissions by company, and control the opening of companies that way; but I'd like to forbid some users the _view_ of the companies list that is shown by pressing CTRL+O. Anyone can help? Toni