iBaan Integration Pack for ERP 5 – MS Office 2.0 Technical Notes

# Table of Contents

- Known Bugs/Issues
- Bugfix overview
- Troubleshooting

# Known Bugs/Issues

· Maximum number of Baan related fields on a template are limited to 100. If a template exceeds this number the message "The template has too many fields (>100)' will be displayed.

· Templates based on a 1 to n relation of Baan tables (f.e. header, lines and deliveries of a sales order) cannot be handled (correctly) by the version 2.0.

# Bugfix overview

This section contains an overview of all bugs that have been fixed in the BaanERP – MS Office Integration 1.1 after the GA release. It provides information in which version what bug has been solved and what Scopus defects, cases and solutions are related to the bugfix.
For all defects solution 127466 is relevant since it is needed to upgrade to the 2.0 version of the iBaan Integration Pack for ERP 5 - MS Office. Therefore Scopus solution 127466 is never mentioned but always applicable.
The current release/version/build number of the iBaan Integration Pack for ERP 5 - MS Office can be found in the (Control Panel) Add/Remove Programs dialog of Windows and the ‘About dialogs’ within the application.

### ID | Description | Scopus Case(s) | Scopus Defect(s) | Scopus Solution(s) | Version required
1 | Dialog for testing templates improved. Datatypes 'Enumerate' and 'Date' can be handled more user friendly. | - | - | - | 2.00.0135
2 | Trying to create a new template on a device that was not ready resulted in a runtime error and aborted the application. | - | - | - | 2.00.0135
3 | On AS400 systems paths were not created correctly. | - | - | - | 2.00.0135
4 | Tables, which were removed in 'Insert Baan Fields' dialog by the option 'Remove Table' could not be added anymore. | - | - | - | 2.00.0135
5 | Update of default selection values in 'Test Baan Template' dialog went wrong in case more than one table was used for a template. The primary index of the related Baan table 'Default values template' (ntwrd050) is extended with the field 'Baan table' (ntwrd050.btbl). | - | - | - | 2.00.0135
6 | Installation (client): - Default component selection changed. Now (only) components for end users are used as default selection. - Sample templates Triton Service as installation component removed. Export/delivery now possible by the new functionality in Baan to exchange Office integration related templates. | - | - | - | 2.00.0135
7 | Divergent problems related to multibyte characters (e.g. Japanese). | - | 115504 | - | 2.00.0135
8 | Processing of data by the ‘Document Creator’ went wrong in case of certain regional number/currency format settings. | - | 121330 124399 | - | 2.00.0135
9 | Adding fields to an already existing template could result in the error message “This key is already associated with an element of this collection". | - | 123992 | - | 2.00.0135
10 | Parameters Baan Automation Server (BAS) cannot be changed in Baan. BAS no longer actual in release 2.0 as middleware. Concerning session(s) expired. | - | 124414 | - | 2.00.0135
11 | When MS Excel templates published with the option "BaanERP sessions only" are copied to a different template and the new template is published with the option "Microsoft Excel only", the new template is accessible from BaanERP sessions. | - | 125518 | - | 2.00.0135
12 | Disabling a filter using the “cell value” option not possible (filter still active) | - | 125615 | - | 2.00.0135
13 | Divergent problems related to the Baan Automation Server. BAS no longer actual in release 2.0 as middleware. | - | 125481 126045 | - | 2.00.0135
14 | Using the update mode (write back to Baan) in MS Excel sheets with more then 99 lines did not update the records after line 99. | - | 126171 | - | 2.00.0135
15 | Path of server directory cannot be changed (changes are not updated in Baan) in the Baan session ‘Office Parameters’ (ntint0500m000). | - | 127131 | - | 2.00.0135
16 | Performance during update mode (write back to Baan) improved. | - | 129950 | - | 2.00.0135
17 | Installation (client): Check on presence of previous installed version(s) added. | - | - | - | 2.00.0136
18 | Installation (client): - Update functionality added. From version 2.00 it is possible to update an already installed version. - Documentation (readme files (html) and user manual (pdf)) added. | - | - | 134254 | 2.00.0137
19 | Table description could not contain multibyte characters | - | 133667 | 132698 134254 | 2.00.0137
20 | Translation miscellaneous questions improved. | - | 136030 | 134254 | 2.00.0137
21 | Miscellaneous improvements related to the processing of (Baan) textfields: - Multiple textlines supported - Maximum length extended from 512 to 1024 positions (incl. separators). | - | 132921 134856 | 134254 | 2.00.0137
22 | Miscellaneous improvements regarding the usage of decimal/thousand symbols (.,) related to the regional settings and the MS Excel cell format. | - | 134686 | 134254 | 2.00.0137
23 | Datafields of type (multibyte) string were during the creation of a document/workbook truncated to a length of 85. Now the maximum output is extended to 256 positions. | - | 132386 | 134254 | 2.00.0137
24 | ‘Index out of dims’ could occur during import of templates (ntint0201m000) | - | - | 135714 | 2.00.0138
25 | Retry handling optimized during ‘Save to Baan’ transaction. | - | - | 135714 | 2.00.0138
26 | Table description not displayed correctly in case of (Baan) language switch. Selected tables and table descriptions were stored (as a kind of MRU-list) in the registry. Switching the (Baan) language setting resulted in an incorrect display of the table description. Now the table description is no longer stored in the registry but determined runtime, so always the most actual (and language related) description is presented. | - | - | 135714 | 2.00.0138
27 | Processing of templates with multibyte characters in template name and/or description implemented. Part of the solution is a change in the domains ‘ntdesc’ and ‘nttmpl’ used in the table ‘Office Templates’ (ntwrd010). RECONFIGURATION IS NECESSARY. | - | 115504 133669 | 135714 | 2.00.0138
28 | Processing records based on a MS Word template with the property ‘multi-document’ resulted in the error message ‘Invalid property value’ for all documents except the first one. | - | 137573 | 135714 | 2.00.0138

# Troubleshooting

· During the installation of the the iBaan Integration Pack for ERP 5 – MS Office 2.0 the system environment variable 'path' is extended with the iBaan Integration Pack for ERP 5 – MS Office installation folder. In some cases (f.e. in the German version of Windows 98) semicolons are replaced by spaces in the added part of the variable ‘path’. Replacing the concerning semicolons by spaces after the client installation or avoiding the use of spaces as installation folder during the installation should solve/avoid the problem.