Open Forum

Cash Manager - Cash Account Balance Detail (20.200.02)

  • 1.  Cash Manager - Cash Account Balance Detail (20.200.02)

    Posted Apr 23, 2019 06:52 PM
    Hello,

    Curious if anyone has experienced the Total Receipts equaling exactly double their Control Batch Total in Cash Manager - Cash Account Balance Detail (20.200.02). If so, how did you fix it?

    Thanks so much!

    ------------------------------
    Tiffany Kuehn
    CONTROLLER
    Consumer Direct Care Network
    Missoula MT
    ------------------------------


  • 2.  RE: Cash Manager - Cash Account Balance Detail (20.200.02)

    BRONZE CONTRIBUTOR
    Posted Apr 24, 2019 08:05 AM
    Delete the batch and re-enter it.  ( You can copy/paste into Excel first...)​

    ------------------------------
    Tom Schonthaler
    Sr. Financial Systems Consultant
    Raffa
    Washington DC
    ------------------------------



  • 3.  RE: Cash Manager - Cash Account Balance Detail (20.200.02)

    SILVER CONTRIBUTOR
    Posted Apr 24, 2019 09:04 AM
    Have you released the cash manager batch?

    If so, the best option is a CA Integrity check but make sure you back up the database before you do this operation.  Also, I would select just the bank account that the receipts were posted to and also limit the time frame to the period of the problem.

    If the batch has not been released you could take a look in the Batch table and see if CrTot, CtrlTot, CuryCrTot, CuryCtrlTot, CuryDrTot & DrTot are all the same.

    Hope this helps.

    ------------------------------
    Robert Guerriero
    Director of Accounting
    Telephone Electronics Corporation
    Jackson MS
    ------------------------------