Missing Transaction in CM Clear Entries

Sometimes a transaction you are expecting to see in CM Clear Entries doesn't display in the grid. Here are a few things to check when what you see is not what you are expecting. 

Steps

1. Check your Display Through Date.
2. Check the Check Items to Display box to see what is being shown in the grid.
3. Make sure you are not posting directly to a GL Account that is tied to a CM Account.
4. Use the CM Transactions report to verify that there are CM transactions in the period you are reconciling
5. When you first open the CM Clear Entries form and select a CM Account, the field for "Display Through Date" defaults to the Statement Date. Sometimes you are looking to clear an entry that has a later date, such as a CM Outstanding Entry that may have a date later than the statement date. Change the Display Through Date to a later date and click Refresh to show additional transactions.
6. The "Check Items to Display" box allows you to limit what is displayed in the grid.
7. The first four entries: Checks/EFT, Deposits, Adjustments & Transfers show their respective transactions, but only when either "Outstanding Entries" or "Cleared Entries" is also checked. NOTE: If only "Outstanding Entries" is checked and none of the first four items, the grid will be blank.
8. When you look at Check Items to Display you must select a minimum of one from the first four and one from the bottom two. Your selection here will determine what shows in the grid. For example, if you want to see only outstanding deposits, you would select Deposits and Outstanding Entries, then click Refresh. 
9. If the item still does not appear, search for the CM Ref #, by double clicking on this column heading so they sort by number and look for it that way. *The filter does not work here.
10. If the Deposit # of an AR Cash Deposit, which is also the CM Ref #, is not unique it will lump the checks with the same Deposit # together into one lump sum amount, so the check may be combined with another check amount. If you want the deposits to show separately in CM Clear Entries, you will need to enter unique Deposit #'s.

CAUTION: Only transactions created in AP, AR, PR or CM will show in Cash Management.

1. Transactions created in GL with a journal entry will not post to Cash Management.

2. AP Transactions or AR Miscellaneous Receipts where the GL entered is the same as the GL for a cash account will not post to that CM Account, only to the account indicated by the CM Account Number.

3. CM Outstanding Entries posting directly to a GL account that is tied to another CM Account will not post to that CM Account, only to the originating account. Use CM Transfers instead. Review CM Transfer Batch, and if it was corrected in CM Accounts or CM Co fields - Delete the Transfer and Post a New One. 

Cause

Wrong CM Transfer Date

Wrong CM Account

Corrected CM Transfer Transaction