Resolving Orphaned Records in Accounts Receivable: Batch Payment Processing

Information

To resolve issues with the Accounts Receivable: Batch Payment Processing caused by orphaned records in the WEB_PAYMENTS table, follow these steps:

1. Identify Orphaned Records:

   SELECT wp.*
   FROM web_payments wp
   LEFT JOIN ccards cc ON wp.CARD_ID = cc.CARD_ID
   WHERE cc.card_id IS NULL;
               

2. Backup the WEB_PAYMENTS Table:

   SELECT * INTO WEB_PAYMENTS_BACKUP FROM WEB_PAYMENTS;
               

3. Delete Orphaned Records:

   DELETE wp
   FROM web_payments wp
   LEFT JOIN ccards cc ON wp.CARD_ID = cc.CARD_ID
   WHERE cc.CARD_ID IS NULL;
               

4. Regenerate Encryption Keys:

   After deleting the orphaned records, run the Key Management tool (KeyMgmt.exe) to regenerate the encryption keys.

Following these steps should resolve the issue with the Batch Payment Processing. If further issues arise, please contact support for additional assistance.