Symptom
The draft outgoing payment is not generated in the participating branch company based on the incoming payment. The following error occurs:
SAP DBTech JDBC: [257] (at 19): sql syntax error: incorrect syntax near """: line 2 col 11 (at pos 19)
Reproducing the issue
Prerequisites
You are using Integration Solution version 54.0.
Scenario
Incorrect syntax error when creating a draft outgoing payment from the incoming payment. The following are the steps to reproduce the issue:
1. Create an incoming payment in the branch (sending) company.
2. The system should generate a corresponding draft outgoing payment in the participating branch company.
3. Observe that the draft outgoing payment is not created, and the system throws the above SQL syntax error.
Expected Result
The draft outgoing payment is generated successfully in the participating branch company based on the incoming payment.
Actual Result
Incorrect syntax error when creating a draft outgoing payment from the incoming payment.
Solution
The issue described above has been 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