cancel
Showing results for 
Search instead for 
Did you mean: 

CCO - Petty Cash payment receipt not released to B1

sukhbold_altanbat
Active Participant
462

Hi Experts,

We have configured Customer checkout for integrating with B1. However, only cash payment receipt is failed to reach SAP B1 and it results with the following error message.

Exception : DI Error: (-2028) No matching records found (ODBC -2028)-The di call #1 did fail.

In the other hand, Credit card payment is successfully released and posted into SAP B1.

I have tried to find the above issue from SAP notes (#2693418 & #2650591) and check all necessary configurations both in CCO & B1. Such as: cash flow relevancy, payment terms, etc ..

B1 version: 9.3 (CN)

CCO version: 2.7.6

CCO scenario: 3.8.93

I have noticed the following thread having similar issue.

https://answers.sap.com/questions/655525/scc-receipts-were-not-synced-back-to-b1.html

Thanks,

Sukhbold

View Entire Topic
sukhbold_altanbat
Active Participant

FYI,

Today, I have used SQL Server profiler to trace whether there is an issue with SQL.

I have noticed the following select statement which is selecting cash flow line details from OCFW based on parameter1 - P1. However, Paramter1 P1 is taking somehow value '2' and corresponding line number in B1 is title (not active line item) by default.

BTW, I have no idea where this value is coming from. I cannot set cash flow line item '2' in default cash flow in general settings in B1, and assigned different cash flow line in Customer Checkout.

After fixing in MSSQL table, receipt is now smoothly transferred into B1. Make sure to change fatherNum from '2' to '1' for those lines previously pointing '2'.

Thanks,

Sukhbold