Open Forum

Cash Manager Bank Reconciliation Report

  • 1.  Cash Manager Bank Reconciliation Report

    BRONZE CONTRIBUTOR
    Posted Jun 06, 2017 05:15 PM

    I just finished my Bank Rec in Cash Manager, and it is saved and X Reconciled.

     

    Now I am trying to print my Bank Rec Report.

    Report/Bank Rec/Detail

    Report Date 05/31/17

    Print Preview  

    I enter my Date Range and my Bank account and when I generate the report comes up blank.

     

    I must be missing a step/doing something wrong…can anyone help?

     



    ------------------------------
    Misty Schaefer
    Accounting Manager
    Inside Edge CIS
    Eagan MN
    ------------------------------


  • 2.  RE: Cash Manager Bank Reconciliation Report

    SILVER CONTRIBUTOR
    Posted Jun 06, 2017 05:41 PM
    I know we work for the same company but I thought I would also respond here in case someone else has this issue.

    There's a bug in the date entry screen, but if you TAB through the fields instead of clicking on the date pickers - the report does work.

    A hotfix has been released... and I'll be applying that soon.

    https://mbs.microsoft.com/customersource/northamerica/SL/downloads/hot-fixes/SLHotFixList

    ------------------------------
    Drew Skwiers-Koballa
    Director of IT
    Inside Edge CIS
    Eagan MN
    ------------------------------



  • 3.  RE: Cash Manager Bank Reconciliation Report

    Posted 28 days ago
    Is there a way to add enable the "Print Notes" checkbox for this screen?

    ------------------------------
    Tim James
    Business Analyst 3
    Tennessee Housing Development Agency
    Nashville TN
    ------------------------------



  • 4.  RE: Cash Manager Bank Reconciliation Report

    BRONZE CONTRIBUTOR
    Posted 27 days ago
    If you add the SNote table to the report, Crystal will detect that notes are included on the report, and enable the checkbox.  Sounds simple enough, but with your situation there is a catch.  The Bank Rec report is primarily built from temporary tables (WrkCABalances & WrkCADetail).  So, not sure which notes you want to add to the report (Bank Rec notes, CA transaction notes, etc.), but the Wrk tables don't have any NoteID fields.  The CashSumD table exists, and has a NoteID field, but that table just stores the daily Cash Balances.

    You would have to determine which notes you want added to the report, and possibly add those table(s) to the report, and link the SNote table to one of those tables.

    ------------------------------
    Mark Ehleben
    President
    QBI Consulting, LLC
    Warminster PA
    ------------------------------