[CM] Troubleshooting Missing Transactions in CM Clear Entries

Sometimes expected transactions do not appear in CM Clear Entries. Follow these steps to identify and resolve the issue:

Steps to Check

1. Verify Display Settings:

   • Check the Display Through Date; it defaults to the Statement Date. Adjust to a later date if needed.

   • Review Check Items to Display:

     • First four options: Checks/EFT, Deposits, Adjustments, Transfers

     • Bottom two options: Outstanding Entries, Cleared Entries

     • To see transactions, select at least one from each group and click Refresh.

     • Example: To see only outstanding deposits → select Deposits + Outstanding Entries → Refresh

2. Use Sorting and Filtering:

   • If transactions still don’t appear, sort by CM Ref # to locate them.

   • Note: Filters may not work for CM Ref #.

3. Check Deposit Numbers:

   • Duplicate Deposit # (also CM Ref #) may combine multiple checks into a single line.

   • To display separately, use unique Deposit #s.

4. Confirm Source Transactions:

   • Only transactions created in AP, AR, PR, or CM will appear in Cash Management.

   • Transactions created in GL via journal entry will not post to CM.

   • AP or AR transactions posted directly to the GL of a cash account will not post to that CM account.

   • CM Outstanding Entries posted directly to the GL tied to another CM account will only post to the originating account; use CM Transfers instead.

5. Verify CM Transfers:

   • Check CM Transfer Batch.

   • If corrections were made in CM Accounts or CM Co fields, delete and repost the transfer.

Common Causes of Missing Transactions

• Wrong CM Transfer Date

• Wrong CM Account

• Corrected CM Transfer Transaction