WDF 2530037 - While canceling the Service A/R Invoice, the corresponding Draft Service A/P Invoice in the participating company is not getting canceled

Symptom

The following error occurs while canceling the Service A/R Invoice, the corresponding Draft Service A/P Invoice in the participating company is not being canceled automatically:

DI error: Invoke of: DoQuery Source: SAPbobsCOM.Recordset.100.0 Description: 1). [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near ";": line 2 col 25 (at pos 67) -The di call #1 did fail.

Reproducing the issue

Prerequisites

You are using Integration Solution version 53 or lower.

Scenario:

The following error occurs while canceling the Service A/R Invoice, the corresponding Draft Service A/P Invoice in the participating company is not being canceled automatically:

Expected Result:

While canceling the Service A/R Invoice, the corresponding Draft Service A/P Invoice in the participating company is successfully canceled.

Actual Result:

While canceling the Service A/R Invoice, the corresponding Draft Service A/P Invoice in the participating company is not getting canceled.

Workaround:

Attached zip file is to be imported via BizStore Import of Control Center.

1. From your existing environment take the backup of "com.sap.b1i.dev.scenarios.design" file as per the backup process below:

To take the backup of the package file, perform the following steps:

Login into Integration Framework 2.0.
Goto Tools -->Control Center --> Maintenance -->BizStore Export.
In the Exporting Content from BizStore, In the selection critera. Select the Dataset button.
In the Choose Dataset, Choose Value "com.sap.b1i.dev.scenarios.design", Choose Group "CXS.IC" and then press Submit button.
Save the file in the relevant folder.

2. Perform the following steps to import the Package file:

Login into Integration Framework 2.0.
Goto Control Center --> Maintenance -->BizStore Import.
In the Importing Content to BizStore, In the selection critera. In the Choose Archive, select the Choose File button.
Select the package file "com.sap.b1i.dev.scenarios.design.zip".
Select the checkbox Assume File System-Friendly Naming and then Submit.

Solution

The issue described above has been fixed in the Intercompany Integration Solutions version 54 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

Related Articles
WDF 2520034 - While canceling the document in the sending company, the corresponding draft document in the receiving company is not getting canceled
Symptom While canceling a document in the sending company, the corresponding draft document in the receiving company may not get canceled if a DI error occurred during the creation of the direct firm document. This issue may occur on the following ...
WDF 2510008 - The document exchange cycle from A/R Down Payment Invoice to A/P Down Payment Invoice is supported
The intercompany solution supports a new additional document cycle, the A/R down payment invoice to the A/P down payment invoice in the intercompany trade. The solution supports the creation of a draft or firm A/P down payment in the receiver ...
WDF 2550001 - Overview Note for Intercompany integration solution Version 55 for SAP Business One
This WDF Note contains information related to Walldorf Intercompany integration solution Version 55, as well as its embedded SAP Business One Integration Hub. Version Installation: This version can be used to directly upgrade, update, or install from ...
WDF 2550023 - The event is unexpectedly recorded in the message log while creating the Draft A/P invoice automatically in the A/R service invoice allocation
Symptom When automatically creating a Draft A/P Invoice during A/R Service Invoice allocation, an unexpected event is recorded in the message log. Reproducing the issue Prerequisites You are using Integration Solution version 54.0 or lower. Scenario ...
WDF 2530031 - A "Not Valid Number" error may occur on the A/R Invoice when modifying and saving the draft A/P invoice in the receiver company
Symptom The following error may occur on the A/R Invoice when modifying and saving the draft A/P invoice in the receiver company: Invoke of: DoQuery Source: SAPbobsCOM.Recordset.100.0 Description: 1). [SAP AG][LIBODBCHDB DLL][HDBODBC] General ...

WDF 2530037 - While canceling the Service A/R Invoice, the corresponding Draft Service A/P Invoice in the participating company is not getting canceled

WDF 2530037 - While canceling the Service A/R Invoice, the corresponding Draft Service A/P Invoice in the participating company is not getting canceled

Related Articles

WDF 2520034 - While canceling the document in the sending company, the corresponding draft document in the receiving company is not getting canceled

WDF 2510008 - The document exchange cycle from A/R Down Payment Invoice to A/P Down Payment Invoice is supported

WDF 2550001 - Overview Note for Intercompany integration solution Version 55 for SAP Business One

WDF 2550023 - The event is unexpectedly recorded in the message log while creating the Draft A/P invoice automatically in the A/R service invoice allocation

WDF 2530031 - A "Not Valid Number" error may occur on the A/R Invoice when modifying and saving the draft A/P invoice in the receiver company