Open Forum

Expand all | Collapse all

Checkbook Balance

  • 1.  Checkbook Balance

    GOLD CONTRIBUTOR
    Posted 15 days ago
    Edited by Dawn Schwarz 15 days ago
    Hello

    I am working with a client who had a payroll check to void last week.  It kept locking up when attempting to void the check.  We learned that a pay code on the check did not have a frequency, thus causing error.  We corrected and attempted to void yet again with more errors.  We corrected tables as we thought we should to allow them to void in GP. Upon doing this noted that the transaction added back to the CM20100 table 388 times and we are thinking only one transction should be showing there for the void.  WeI looked at the Checkbook balance and noted the cash account is off by 403,000+ dollars the transaction we had voided was for 802.21 and that times 388 is 311,000+.  I ran check links and it removed all but one entry in the CM20100 table as expected.  However, the checkbook balance did not change at all.  Does anyone know what might need to be done to allow the checkbook to reflect the correct balance?  I assume we can make a bank transaction to get it back in sync however not sure what the future implications of that may be.  I do see the transaction in the CM50508 table, but not sure why it is there either.

    Thanks in advance for any suggestions.

    Dawn

    ------------------------------
    Dawn Schwarz
    Senior Consultant
    Wipfli
    Madison WI
    ------------------------------
    GPUG Summit - Post


  • 2.  RE: Checkbook Balance

    GOLD CONTRIBUTOR
    Posted 15 days ago
    Hi Dawn,

    I think when it comes to the checkbook balance (CM00100.CURRBLNC), you would need to update the field directly.
    You can probably match it against the totals in CM20200 (i.e. + deposit, +increase adjustment, - check, -withdrawal, - decrease adjustment, +/- bank transfers). You would also want to check if there was a checkbook beginning balance that was entered.



    ------------------------------
    Ryan Galang
    BTP Technologies LLC
    Chantilly VA
    ------------------------------

    GPUG Summit - Post


  • 3.  RE: Checkbook Balance

    GOLD CONTRIBUTOR
    Posted 15 days ago
    Edited by Dawn Schwarz 15 days ago
    @RyanGalang thanks for the input I do appreciate it.  They have been reconciling the checkbook for a few years so I do have the last reconciled balance that can be used to calculate the 5/31 balance I think, but I am not sure why the system did not calculate it accurately after the checklinks.  I am feeling like it is still looking at the transactions somewhere in SQL to get the incorrect balance.

    Thanks
    Dawn

    ​​

    ------------------------------
    Dawn Schwarz
    Senior Consultant
    Wipfli
    Madison WI
    ------------------------------

    GPUG Summit - Post


If you've found this thread useful, dive deeper into User Group community content by role