Syntax Error in XL Reports

[Former Member]

Dear All, i am getting the following error while executing XL Reports

Definition Parsing Failed

Syntax erro near 2002001 at cell $16

Syntax erro near 2002001 at cell $17

Syntax erro near 2002001 at cell $18

Syntax erro near 2002001 at cell $19

How this problem could be resolved.

[former_member186095]

Hi,

here is the note:

Error in report definitions after upgrading to Add-On 2005
Symptom
After upgrading XL Reporter AddOn from 2004 SP 02 to 2004 SP02 patch 1 or newer, one or more of the old report definitions can stop working. The error message "An error occurred while Executing report! Description: Definition parsing failed. Details: Syntax error near: ( at cell $B$25" or similar appear.
Other terms
Business One, XLR, Report Organizer, Report Designer
Reason and Prerequisites
XL Reporter has earlier divided Business Partner into two objects: Customer(CUS) and Vendor(VEN). Since this is not how Business One operates, CUS and VEN has been merged into one object, Business Partner (BPA), in XL Reporter 2004 Addon SP02 Patch 1 and subsequent releases.This causes old reports using attributes or selections on VEN or CUS to fail.
Solution
Edit the old report definitions in Report Designer and replace all selections and attributes based on CUS or VEN with BPA.
SAP Note Number	883875 Display	Print
Note Language	 		
Version	 

Anyway, have you just upgraded the SAP B1 XL addon ?

Rgds,

[candice_ren]

Dear Haroon Baig,

For this error message, please kindly refer to note no. 883875.

As per note no. 883875 the cause for this error is : XL Reporter has

earlier divided Business Partner into two objects: Customer(CUS)

and Vendor(VEN).

Since this is not how Business One operates, CUS and VEN has been merged into one object, Business Partner (BPA). This causes old reports using attributes or selections on VEN or CUS to fail.

You need to edit the old report definitions in the Report Designer and

replace all selections and attributes based on CUS or VEN with BPA.

In order to do this please right click on the report in the report

designer then edit the report as per note no. 883875.

Hope this can help you.

Regards,

Candice Ren

SAP Business One Forums Team

[Former Member]

Dear All,

My XL Reporter Patch level is 6.80.01.30. Is there any latest patch level because in this pl the object is only business partner.

Regards,

Haroon Baig