-
ODBC 1.30 problems in Lotus 1-2-3
Hi all! I'm trying to fetch data into a Lotus 1-2-3 spreadsheet using the ODBC 1.30. But the only fields I've managed to import is boolean and date fields. Does anyone have a possible solution to my problem? Regards Andreas
-
Excel Error after automation
Hello, I have following problem, i use the code below: CREATE(xlApp); xlBook := xlApp.Workbooks.Add(-4167); xlsheet := xlApp.ActiveSheet; xlsheet.Name := 'Projekt Statistik'; ....... ...... .... xlApp.Visible := TRUE CLEAR(xlApp); And if all datas are exportes to excel i get an Dr. Watson ( Error) afer i close Excel…
-
Discussion of Mandatory fields
To create mandatory fields in NF there are three concepts I have tested, all with some bad effects: 1. Using the OnInsert or OnModify Trigger. If you enter values in several fields and one mandatory field is missing all input is reseted. You have to type all fields again. <img border="0" title="" alt=""…
-
NF service crashes :(
Dear all, We still have a problem in one customer site, were NF service stops from time 2 time several times a day. Installation: TCP/IP, 30 - 40 users, WinNT SP4-6. Terminal Server is connected. Below is some technical details. Navision says that the reason is "bad network packages". Any help would be appreciated. Dainius…
-
Help for customer modifications
Let's say you make an add-on. how do you create help for that add-on?
-
Automation to Access
Did you use automation access to Microsoft Access? May be you know the syntax of record to the field. In Access I can write !FieldName = xxxx In NF I can't use '!'. What can I do for seting of the field value?
-
Multi Connections via C/ODBC ?
I'm trying to transfer TableData between 2 Databases via ODBC , but I can not connect to 2 different DSN via ODBC. Is there any solution?
-
Making appointments in someone elses calendar
I can use Automation to make a appointment ion my calendar. Is there a way to do this in someone elses calendar ?? Is there also a way to set a end time to an appointment ?? Thnx
-
Performance Problems after Database Backup
Hello everyone, We run a 14GB Database (V2.00C) with 13GB Data in it. The backup is running online and it creates two backup files with 2GB and 140MB in size. After the backup the performance decreases and Windows Taskmanager on Server says that used memory for the server process increases slowly from a low value to the…
-
FIFO costing
Hi all! Anybody who has sucessfully implemented a solution to get rid of the batch for calculation inventory cost? It should be pretty easy to do the calculation when posting item jnl.lines, but before we start coding I might as well ask if someone else done it before. Rgds //Lars Westman
-
Navision Server Configuration
Modify the Srvstrat.bat We have following code ion the batch: server nettype=tcp, database=e:\financials\server200\db\d1.fdb,installasservice Now my qouestion: could i paste following code server nettype=tcp, database=e:\financials\server200\db\d1test.fdb,installasservice to have a demodatabase to test ?! But how can i…
-
CF: eliminating Solution Developer granule
Any body elemineted Solution Developer granule? If I want to write by using CF to protected tables (17,21..) I need this expencive granule. Any sugestions ? I need ability to write to G/L table using CF. [This message has been edited by db (edited 11-12-1999).]
-
MS Project 98 and Navision
I'm looking for some experiences between MS Project and Navision. Thanks
-
MS Outlook Automation
I have to export contacts from NAVISION to Outlook - OLEAutomation works fine, but the contacts are exported in general contacts folder in Outlook. Is there a way to force Outlook from NF to select a different folder e.g. subfolder of CONTACTS?
-
US Sales Tax Module
Does anybody has experience with US Sales Tax stuff? I've tried it and I have problems posting TAX of type EXCISE (on sales/purchase line)? And the other problem is when calculating amounts on line with TAX when you have different currency than LCY - I think the calculation is wrong. Any ideas?
-
Exchange Rate Adjustment [periodic activities]
Have anybody noticed a case of not reported inconsistency of the general ledger when using this periodic activity ? No Err found by cod12,but the Debit and Credit amounts are not equal...