Few old entries are still remaining in "New" status in checkout monitor

[Tharindu]

Dear Experts,

Greetings ….!

Thanks for always caring and supporting on our queries .

Recently we noticed that a few old entries in the CCO monitor shows the status "new" while all other entries are releasing without any issue . Here is a screenshot for your kind reference ,

No any information displays to check why these entries aren't releasing . Usually if any new batch remains we check the TID Panel to see any Incommit or Inrolleback entries to delete and restart the integration service . This time those are also blank .

So we wonder why these few entries still remains . Really appreciate if anyone would advise on this .(V2.0 FP14 PL02) (SAP Business one 10 2111)

Best Regards,

Tharindu.

[gunther_sandtner2 · Accepted solution]

Dear tharindu,

Steps resolve this:

1. Connect to HANA studio or SQL Server management studio respectively
2. Find the CCO Monitor database (usually “CustomerCheckout”)
3. Run query SELECT ID FROM PointOfSaleReceipt WHERE ReleaseStatusCode = 'NEW'
4. Confirm these are the receipts you want to release to B1 and save the result
5. Run query UPDATE PointOfSaleReceipt SET ReleaseStatusCode = 'INC' WHERE ReleaseStatusCode = 'NEW'
6. Open the SAP Customer Checkout monitor UI
7. Find the - now Inconsistent - receipts you saved in step 4
8. Mark receipt rows and select the “Release” button

The receipts should now be processed by B1if in the usual manner.

Kind regards,

Gunther

[Tharindu · Accepted solution]

Dear Gunther,

Thanks a lot for your support . The given solution has worked … !

Best Regards,

Tharindu .