Receipts are showing cancelled status CCO monitor

[silambarasan_RS]

Dear Experts,

We have implemented Customer Checkout integrated with SAP Business One. one of location posting sales which is showing cancelled status CCO monitor. Error message "001 - Duplicate Receipt Number". is there any setting to be applied

Thanks,

silambu

[silambarasan_RS · Accepted solution]

Thanks Mr. Anderson and Mr. Karol, Issues resolved.

I did the workaround as per SAP experts suggestion

1- We need take backup "CustomerCheckOut" database.

2- Find exact duplicate receipts, please be note , take advice from SAP technical expert.

Ex.

select A."ReleaseStatusCode",A."DuplicateIndicator",A."ExternalID",G1."ErrorMessage" from "CustomerCheckout"."PointOfSaleReceipt" A left outer join 
"CustomerCheckout"."ErrorLog" G1 on (A."POSKey"=G1."ReceiptKey")
where A."CashDeskID"='0801' and A."ReleaseStatusCode"='CAN'
and ADD_SECONDS(TO_Date('1970-01-01'),(A."BusinessTransactionDateTime"+14400))>='2020-01-01' and G1."ErrorMessage"='001 - Duplicate Receipt Number'

3. Update status Inconsistent, remove duplicate and replace receipt no.

Ex.

UPDATE A SET A."ReleaseStatusCode"='INC',A."DuplicateIndicator"='0',A."ExternalID"=A."ExternalID"||'-ABCD' from "CustomerCheckout"."PointOfSaleReceipt" A 
left outer join 
"CustomerCheckout"."ErrorLog" G1 on (A."POSKey"=G1."ReceiptKey")
where A."CashDeskID"='0801' and A."ReleaseStatusCode"='CAN'
and ADD_SECONDS(TO_Date('1970-01-01'),(A."BusinessTransactionDateTime"+14400))>='2020-01-01' and G1."ErrorMessage"='001 - Duplicate Receipt Number'

4- Goto CCO monitor find Receipts are inconsistent status with Receipt number contain "ABCD" which need to release again, it will post.

Thanks,

silambu

[anderson_schmitt]

Hello Silambu,

This message means that the receipt is already posted to the SAP B1.

Log into your SAP B1 and check if the receipt # 0801/19/01384 is posted to the SAP B1.

This is part of the duplicate check implemented in the customer checkout scenarios from the version 3.7.92 onward. Refer to SAP Note #2163033 for further information.

Regards,

Anderson

[silambarasan_RS]

Thanks Mr.Anderson,

I change receipt number Its getting post now.

Kindly let me know how to rectify existing receipts which are lying in CCO monitor with cancelled status, Since two days we have posted many receipts.

Thanks,

silambu

[anderson_schmitt]

Hi Mr. Silambu,

You're welcome.
To have a better understanding about your scenario.

Did you confirm that these Receipts No. are already posted to SAP B1? e.g: Receipt No.0801/19/01384?

You have changed the receipt number in the CCO and from now on the new receipts are posted correctly to SAP B1, is it right?

How many receipts are affected?

Regards,

Anderson

[silambarasan_RS]

Hi Anderson,

Thanks for your attention.

Please check below my answer.

Did you confirm that these Receipts No. are already posted to SAP B1? e.g: Receipt No.0801/19/01384?

Yes. You are right receipt no. 0801/19/01384 already posted in to SAP B1.

You have changed the receipt number in the CCO and from now on the new receipts are posted correctly to SAP B1, is it right?

Yes. I have changed the receipt number 0801/20/01001 in the CCO and from now on the new receipts are posted correctly to SAP B1.

How many receipts are affected?

Around 200 receipts.

Thanks & Regards,

silambu