| Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-244488 - Create New Report - UnDeposited Fund as of|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-244488]
* Objective
** Simplify identification of bad data that may be out of balance by showing any records that do not match between systems.
** {color:#e74c3c}Cash Receipts that are posted but not yet deposited are legitimate condition (not errors){color}
*** {color:#e74c3c}We need to see:{color}**** {color:#e74c3c}Posted receipts that are not appearing in Undeposited Fund grids for the selection but have not yet posted to the GL{color}
**** {color:#e74c3c}General Ledger Entries in the Undeposited Fund Account that do not match a cash receipts.{color}
**** {color:#e74c3c}General Ledger Entries that are double posted for the same cash receipts (this may not occur - this is an error condition).{color}
* Requirements
** Create new Undeposited Fund Unmatched Report
*** Add Date Range for Unmatched Timeframe to be used for filtering transactions in CM, AR, GL.
**** Default 1/1/1900 through Current System Date
** Grid to List multiple scenarios of data.
*** List all GL entries that are not linked to an AR Payment, AR Cash Sale, or Bank Deposit or match the same amount
*** List all Bank Deposits that are not linked to a GL or match the same amount
**** {color:#e74c3c}List all the Bank Deposits that do not have a link to a Accounts Receivable/Cash Receipt Transaction.{color}
**** {color:#e74c3c}Some transactions may have same amount. So, it should match by reference number.{color}
*** List all AR Payment, AR Cash Sales that are not linked to a GL or match the same amount
{color:#e74c3c}Below is the expected grid columns with different scenarios:{color}
!pastedImage_d147500_0.png|height=141,width=746!
!pastedImage_d147500_1.png|height=271,width=549!
|