CCO - Petty Cash payment receipt not released to B1

[sukhbold_altanbat]

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

[sukhbold_altanbat · Accepted solution]

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

[sukhbold_altanbat]

FYI,

I have tried to look into the error log in integration framework. CCO scenario stops at the step sap.POS.POSTB1Invoice.Atom13 (DI_Payment) and the following error appears.

I have no clue what it is.

Regards,

Sukhbold

[sukhbold_altanbat]

Hi Balakumar,

Thank you for the response.

I am also guessing same thing. Meantime, I have added new credit payment option as cash payment and blocked default cash payment by setting maximum petty cash amount to least amount irrespective of selection of customer and block the receipt exceeding the limit. (Settings=>POS Systems=>Sales screen).

Thanks,

Sukhbold

[kvbalakumar]

Hi,

I think this issue is related to the SBO localization.

I'm having two installations of CCO and CCOm. One pointing to SBODemoGB where all the transactions are working fine. Another one pointing to MENA localization where the cash receipts only fails.

Anyway, I raised a Support Incident to SAP and waiting for their reply. Once I have a reply/solution, I'll update this answer.

Regards,

Bala

[sukhbold_altanbat]

BTW,

I have redirected CCO to SG Demo company with localization SG, and it is working fine for cash payment receipt.

Our B1 license is only applicable for CN (China) localization.

Is the error related to localization?

Sukhbold