Business objects INTERCOMPANY 5.1 FIXPACK 3 RELEASE NOTES 09-2008 User Manual

SAP BusinessObjects Intercompany Release Notes
SAP BusinessObjects Intercompany 5.1 FixPack 5
windows
Copyright
© 2009 SAP® BusinessObjects™. All rights reserved. SAP BusinessObjects owns the following United States patents, which may cover products that are offered and licensed by SAP BusinessObjects and/or affiliated companies: 5,295,243; 5,339,390; 5,555,403; 5,590,250; 5,619,632; 5,632,009; 5,857,205; 5,880,742; 5,883,635; 6,085,202; 6,108,698; 6,247,008; 6,289,352; 6,300,957; 6,377,259; 6,490,593; 6,578,027; 6,581,068; 6,628,312; 6,654,761; 6,768,986; 6,772,409; 6,831,668; 6,882,998; 6,892,189; 6,901,555; 7,089,238; 7,107,266; 7,139,766; 7,178,099; 7,181,435; 7,181,440; 7,194,465; 7,222,130; 7,299,419; 7,320,122 and 7,356,779. SAP BusinessObjects and its logos, BusinessObjects, Crystal Reports®, Rapid Mart™, Data Insight™, Desktop Intelligence™, Rapid Marts®, Watchlist Security™, Web Intelligence®, and Xcelsius® are trademarks or registered trademarks of Business Objects, an SAP company and/or affiliated companies in the United States and/or other countries. SAP® is a registered trademark of SAP AG in Germany and/or other countries. All other names mentioned herein may be trademarks of their respective owners.
2009-02-04

Contents

About this patch 5Chapter 1
Installing Intercompany 5.1 FixPack 5 7Chapter 2
Corrections in FixPack 5 9Chapter 3
Local currency values not written during invoice export............................10
Export format limited to Unicode UTF-8....................................................10
Amounts wrong in the Difference Analysis Reports..................................10
Problem with zero balance suppression....................................................10
No scroll bar on the counterparty contact page.........................................11
Different user language can affect amount digits during import................11
Pages associated with companies or accounts with a high ID are
unavailable.................................................................................................12
Corrections in FixPack 4 13Chapter 4
An error occurs for an LDAP account with no UID....................................14
For an LDAP authentication, you cannot use a search string consisting of
more than 64 characters............................................................................14
Balance update by invoice only.................................................................14
Imports of files must be .txt or .csv............................................................15
Fault tolerant configuration for the SQL Server database was not
possible......................................................................................................15
Corrections in FixPack 3 17Chapter 5
Too many invoice child account transactions can generate an error
message....................................................................................................18
SAP BusinessObjects Intercompany Release Notes 3
Contents
Distinguish name limitation in the LDAP authentication............................18
Intercompany 5.1 does not support BOE XI 3.0.1 ....................................18
Field headers in invoice reports.................................................................18
Invoice date formats incorrectly changed after export and import.............19
Corrections in FixPack 2 21Chapter 6
Corrections in FixPack 1 23Chapter 7
Index 25
4 SAP BusinessObjects Intercompany Release Notes

About this patch

1
About this patch
1
This patch corrects problems detected in version 5.1 of BusinessObjects Intercompany.
This document contains:
Technical details on installing the patch.
Details on the corrections made in the patch.
6 SAP BusinessObjects Intercompany Release Notes

Installing Intercompany 5.1 FixPack 5

2
Installing Intercompany 5.1 FixPack 5
2
To install Intercompany 5.1 FixPack 5:
1. Uninstall the current version on the server.
2. Install the latest version of Intercompany.
3. In the Intercompany Files Folder panel, select the same folder location
as in the previous installation.
For example, if your Intercompany files were in C:\IntercompanyFiles\ for the current installed version, then you need to select the same folder for FixPack5.
4. Run the Intercompany database upgrade tool to install the latest version
of the stored procedures.
5. Manually update the database schema by running the SQL statements
below:
For SQL SERVER:
ALTER TABLE tblExternalAuthenticationInfo
ALTER TABLE tblExternalAuthenticationInfo
ALTER TABLE tblExternalAuthenticationInfo
ALTERCOLUMN [primaryHost] [NVARCHAR] (300)NULL
ALTERCOLUMN [accountAccessLDAP] [NVARCHAR] (300)NULL
ALTER COLUMN [searchString] [NVARCHAR] (300) NULL
For ORACLE:
ALTER TABLE tblExternalAuthenticationInfo
MODIFY (primaryHost NVARCHAR2(300));
ALTER TABLE tblExternalAuthenticationInfo
MODIFY (accountAccessLDAP NVARCHAR2(300));
ALTER TABLE tblExternalAuthenticationInfo
MODIFY (searchString NVARCHAR2(300));
8 SAP BusinessObjects Intercompany Release Notes

Corrections in FixPack 5

3
Corrections in FixPack 5
3

Local currency values not written during invoice export

Local currency values not written during invoice export
Local Currency values are not written to the target file when exporting invoices.
(ADAPT01085172)

Export format limited to Unicode UTF-8

Problems occur in ICS export files containing special characters due to Export format limited to Unicode UTF-8.
(ADAPT01099701)

Amounts wrong in the Difference Analysis Reports

On Oracle platforms, in the Difference Analysis Report, the amounts for Parent accounts and Calculated Total retrieved are wrong and do not match with the amounts entered in balances.
(ADAPT01133379)

Problem with zero balance suppression

When you apply the "suppress zero balances" option in the balance page, even the zero balances containing invoices are no longer displayed.
(ADAPT01156764)
10 SAP BusinessObjects Intercompany Release Notes
Corrections in FixPack 5

No scroll bar on the counterparty contact page

No scroll bar on the counterparty contact page
On the balance page, when you click the counterparty contact, the page displays a list of contacts with no scroll bar and so you cannot reach the items off the screen.
(ADAPT01139111)

Different user language can affect amount digits during import

The amount digits are managed differently depending on the language selected by users at login time. The problem occurs when importing amounts with thousand and/or decimal separators in a language different than the one they have been exported. As a result, the amounts can be wrongly imported.
3
As of FixPack 5, you can force SAP BusinessObjects Intercompany to always use the format you specify for all users, no matter what language they are using.
To resolve the issue, the ExpectedNumberGroupSeparator and Expected
NumberDecimalSeparator settings need to be added to the appSettings
section of the SAP BusinessObjects Intercompany Import Service configuration file (ImportService.exe.config) as shown below:
Sample:
<appSettings>
<add key="Interval" value="5000"/> <add key="ExpectedNumberGroupSeparator" value="."/> <add key="ExpectedNumberDecimalSeparator" value=","/> <add key="LogFilePath"
value="D:\ICS5\Dvt\ics5\Cartesis.ICS.ManagmentServices\ ISlog4net.xml"/>
</appSettings>
Note:
You need to define the appropriate value according to your needs for the
two separators.
SAP BusinessObjects Intercompany Release Notes 11
Corrections in FixPack 5
3

Pages associated with companies or accounts with a high ID are unavailable

You need to restart the SAP BusinessObjects Intercompany Import Service
for the modification to take effect.
(ADAPT01175538)
Pages associated with companies or accounts with a high ID are unavailable
Balance and invoice pages associated with companies and/or accounts with an ID greater than 32767 are unavailable.
(ADAPT01178128)
12 SAP BusinessObjects Intercompany Release Notes

Corrections in FixPack 4

4
Corrections in FixPack 4
4

An error occurs for an LDAP account with no UID

An error occurs for an LDAP account with no UID
If an LDAP account does not contain the attribute UID, the external login page generates the following error if you use the account:
"Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index"
(ADAPT1151032)

For an LDAP authentication, you cannot use a search string consisting of more than 64 characters

When you select the LDAP option for the "Authentication Type" in the Control Panel "Authentication" tab, you cannot use a search string consisting of more than to 64 characters.
If you enter more than 64 characters and click Apply, the string is truncated in the database and the connection to Intercompany fails or an error message appears. (ADAPT1135419 )

Balance update by invoice only

In the "Invoice Level Matching" page, when you activate the Invoices Update Non Editable States option, balances can only be updated by invoice.
After installing Fixpack4, if you want to allow users to update balances only by invoice, make sure that Update Non Editable States is activated in Menu > System > Global Parameters > Invoice Level Matching. Otherwise you need to make sure that the option is deactivated. (ADAPT1135424)
Note:
This option is available when you activate Invoices Drive Balances.
14 SAP BusinessObjects Intercompany Release Notes
Corrections in FixPack 4

Imports of files must be .txt or .csv

Imports of files must be .txt or .csv
Intercompany imports are possible only when the file to be imported has the
.txt or .csv extension, and the extension must be written in lower case.
(ADAPT1140773)

Fault tolerant configuration for the SQL Server database was not possible

Fault tolerant configuration for the SQL Server database is now available. This configuration needs a Windows cluster configuration to host the Import service. Contact SAP Business Objects if you want to put in place such a configuration.
To allow for a fault tolerant configuration, the Intercompany import service will reset certain database flags every time it is started. (ADAPT01142097)
4
SAP BusinessObjects Intercompany Release Notes 15
Corrections in FixPack 4
Fault tolerant configuration for the SQL Server database was not possible
4
16 SAP BusinessObjects Intercompany Release Notes

Corrections in FixPack 3

5
Corrections in FixPack 3
5

Too many invoice child account transactions can generate an error message

Too many invoice child account transactions can generate an error message
In the Invoice Child Account page, if there are a lot of transactions, the following error message appears when you click to delete an invoice:
value was either too large or too small for an int16
(ADAPT01121596)

Distinguish name limitation in the LDAP authentication

For an LDAP authentication it is not possible to specify a Distinguish Name consisting of more than 64 characters in the Authentication tab of the Control Panel. (ADAPT01110218)

Intercompany 5.1 does not support BOE XI 3.0.1

The reference platform for Intercompany 5.1 is part of the FPM 7.0 Suite, but was based on BOE XI R2. The FPM 7.0 Suite is based on BOE XI 3.0.1 Fixpack 1.
If the BOE XI 3.0.1 client is installed on the Intercompany 5.1 server, BOE authentication does not work. (ADAPT01103579)

Field headers in invoice reports

In invoice reports, the header for Invoice Text, Invoice Date, and Invoice Amount field columns is always the default one, not the alternative names created by the administrator. (ADAPT01099711)
18 SAP BusinessObjects Intercompany Release Notes
Corrections in FixPack 3

Invoice date formats incorrectly changed after export and import

Invoice date formats incorrectly changed after export and import
When you export invoices in French or German, the date formats are changed to US. When you reimport the invoices, the system expects a French or German format and rejects the lines.
If you have a problem with the wrong export and import date format appearing, the ExpectedDateFormat setting needs to be added to the
appSettings section of the Intercompany Import Service configuration file
as shown in the sample below.
Sample:
<appSettings>
<add key="Interval" value="5000"/> <add key="ExpectedDateFormat" value="dd/MM/yyyy"/> <add key="LogFilePath"
value="D:\ICS5\Dvt\ics5\Cartesis.ICS.ManagmentServices\ ISlog4net.xml"/>
</appSettings>
5
Note:
You need to restart the server for the modification to take effect.
The value of this setting has to follow certain rules (see http://msdn.mi
crosoft.com/en-us/library/az4se3k1(VS.80).aspx) but in most cases you can
use dd for day, MM for month and yyyy for year. (ADAPT01107347)
SAP BusinessObjects Intercompany Release Notes 19
Corrections in FixPack 3
Invoice date formats incorrectly changed after export and import
5
20 SAP BusinessObjects Intercompany Release Notes

Corrections in FixPack 2

6
Corrections in FixPack 2
6
Manual Invoice Matching
The Manual Invoice Matching functionality was not functioning properly. (ADAPT01021281)
Invoice state
The invoice group state changed when clicking the update button, even if its members had not been modified. (ADAPT01021288)
Invoice Addition/Adjustment
Errors occurred when editing invoices with attached files whose ID was higher than 32767. (ADAPT01041220)
22 SAP BusinessObjects Intercompany Release Notes

Corrections in FixPack 1

7
Corrections in FixPack 1
7
Control Panel
An error occurred when using either the BusinessObjects security, ActiveDirectory or LDAP authentication modes with an Oracle database. (cqics00004409)
Documentation
Some sections of the online help in English were not accessible. (cqics00004421)
Invoice Addition/Adjustment
The Invoice Edit page incorrectly displayed non-integer amount values.(cqics00004059)
24 SAP BusinessObjects Intercompany Release Notes

Index

A
appSettings
ExpectedDateFormat 19 ExpectedNumber GroupSeparator 11
authentication modes
with Oracle 24
B
balances 12
updating 14 zero balances 10
BOE authentication 18
C
child accounts
transactions 18
clusters
fault tolerance configuration 15
counterparty contact page
no scroll bar 11
D
export files
containing special characters 10
F
files
importing 15
I
IIS settings
amount digits 11 import file extensions 15 installation 6 installation procedures 8 invoice reports
field headers 18 invoices 12
date formats 19
exporting 10
invoice group state 22
invoice IDs 22
manual invoice matching 22
updating balances 14
zero balances 10
Difference Analysis Reports
amounts 10
E
ExpectedDateFormat 19 ExpectedNumberGroup Separator 11
L
LDAP accounts
attribute UIDs 14 LDAP authentication
distinguish name limitation 18
search strings 14
with an Oracle database 24 local currency values 10
SAP BusinessObjects Intercompany Release Notes 25
Index
N
non-integer amount values 24
O
online help 24 Oracle 24
Difference Analysis Reports 10
S
SQL servers
fault tolerance configuration 15
U
unicode UTF-8 10
26 SAP BusinessObjects Intercompany Release Notes
Loading...