WDF 2530035 - The Branch Sales Analysis report always exports in a detailed format to the CSV file

WDF 2530035 - The Branch Sales Analysis report always exports in a detailed format to the CSV file

Symptom

The Branch Sales Analysis report always exports in a detailed format when generating a CSV file or copying to Excel using the Copy to Clipboard button.

Reproducing the issue
Prerequisites

You are using Integration Solution version 53.

Scenario:

The Branch Sales Analysis report always exports in a detailed format when generating a CSV file or copying to Excel using the Copy to Clipboard button.

To reproduce the issue, follow these steps:
1. Run the Branch Sales Analysis report located under Sales-A/R Reports.
2. Click the button Export to CSV or Copy to Clipboard, and paste into Excel.

Expected Result:

The Branch Sales Analysis report exports in summary or in a detailed format to a CSV file based on the selection in selection criteria.

Actual Result:

The Branch Sales Analysis report always exports in a detailed format to a CSV file.

Workaround:
Step:1
Attached zip file is to be imported via BizStore Import of Control Center.

1. From your existing environment take the backup of "com.cxs.b1i.ipo" file as per the backup process below:
   
To take the backup of the ipo file, perform the following steps:
  1. Login into Integration Framework 2.0.
  2. Goto Tools -->Control Center --> Maintenance -->BizStore Export.
  3. In the Exporting Content from BizStore, In the selection critera. Select the Dataset button.
  4. In the Choose Dataset, Choose Value "com.cxs.b1i.ipo" and then press Submit button.
  5. Save the file in the relevant folder.
2. Perform the following steps to import the IPO file:
  1. Login into Integration Framework 2.0.
  2. Goto Control Center --> Maintenance -->BizStore Import.
  3. In the Importing Content to BizStore, In the Selection Critera. In the Choose Archive, select the Choose File button. 
  4. Select the IPO file "com.cxs.b1i.ipo.zip".
  5. Select the checkbox Assume File System-Friendly Naming and then Submit.
Step:2
Download the Intercompany (ICO) Version 53 Hotfix Add-On version 53.2 from here. 
Apply the hotfix add-on to all companies across the landscape.

Step: 3
Login into Intercompany Administration Console, navigate to the Landscape, and redeploy the IC solution.

Step: 4
Run the Branch Sales Analysis report.
An additional selection criteria has been introduced, allowing users to choose either the Summary or Detail report. Based on this selection, the report can be exported accordingly.


Solution

The issue described above will be fixed in the Intercompany Integration Solutions version 55 and higher versions.

Product
Product or Product Version
B1 INTERCOMPANY INTEGRATION
SAP B1 10.0 FOR SAP HANA
SAP B1 9.3 FOR SAP HANA
SAP BUSINESS ONE 10.0
SAP BUSINESS ONE 9.3

This document refers to : 
WDF 2550001 - Overview Note for Intercompany Integration Solution Version 55 for SAP Business One