Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Transactions missing from Bank Rec module

  • 1.  Transactions missing from Bank Rec module

    Posted 04-17-2026 15:05

    Sage 100 Advanced 2022 (Version 7.10.3.0) 32-bit

    A customer reported several transactions missing from Bank Rec but they were posted to the GL.  The customer has been using Sage 100 since 2017, and this is the first time this has ever happened.  This customer uses Reconcile Bank daily, and so they caught it immediately.  Here's what happened:

    Cash Receipts Journal, Register#: CR-014384, Batch Number: Multiple 

    There are three Batch Numbers - 22053 (Deposit#46792), 22056 (Deposit#46795) and 22052 (Deposit#46787)

    The only batch that posted to Bank Rec is the first batch (22053).

    They do this same process every day, and we cannot find any reason why this happened.  The cash receipts journal lists all three batches with correct deposit numbers, customer numbers, invoices, etc.  The DTR has the correct posting for the GL.  Everything looks right except Bank Rec.

    Has anyone else seen this happen before?



    ------------------------------
    Brian Kelly
    Accounting Systems, Inc. (ASI)
    ------------------------------


  • 2.  RE: Transactions missing from Bank Rec module

    Posted 04-17-2026 15:12

    Were the missing transactions dated after the reconciliation date?  My understanding is that the data purges everything that is marked as Cleared, regardless of the reconciliation date being processed... so mistaken clicks (future dates) can cause this.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Transactions missing from Bank Rec module

    Posted 04-17-2026 15:33

    No sir.  I guess it would have helped if I had provided a little more detail.  These transactions are from yesterday (4/16/2026).  The customer goes into Reconcile Bank daily and checks off the transactions that have posted to their bank account.  This is why they were able to catch these so quickly.  These are deposits in their bank that are not in Bank Rec, but they should be in Bank Rec.



    ------------------------------
    Brian Kelly
    Accounting Systems, Inc. (ASI)
    ------------------------------

    Original Message


  • 4.  RE: Transactions missing from Bank Rec module

    Posted 04-17-2026 15:49

    Did someone inadvertently turn the integration off in setup options? 



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 5.  RE: Transactions missing from Bank Rec module

    Posted 04-17-2026 15:50

    Did they accidentally post to a different bank code?



    ------------------------------
    Dawn Kulbacki
    Capitol Computer Systems, Inc.
    ------------------------------

    Original Message


  • 6.  RE: Transactions missing from Bank Rec module

    Posted 04-17-2026 16:13
    Edited by Brian Kelly 04-17-2026 16:14

    All of this happened during the posting of the cash receipts journal.  No settings were changed, and the bank codes were accurate.



    ------------------------------
    Brian Kelly
    Accounting Systems, Inc. (ASI)
    ------------------------------

    Original Message


  • 7.  RE: Transactions missing from Bank Rec module

    Posted 04-17-2026 16:16

    Blank bank code in GL_Bank?  That has caused weirdness in the past.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 8.  RE: Transactions missing from Bank Rec module

    Posted 04-17-2026 16:25

    @Kevin Moyes There is a blank bank code in GL_Bank.  Is there any danger is simply deleting it?



    ------------------------------
    Brian Kelly
    Accounting Systems, Inc. (ASI)
    ------------------------------

    Original Message


  • 9.  RE: Transactions missing from Bank Rec module

    Posted 04-17-2026 16:54

    Whenever I see an initial blank/bad Bank Code, I remove it from gl_bank via DFDM.



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


  • 10.  RE: Transactions missing from Bank Rec module

    Posted 04-17-2026 17:03

    Just delete the blank record.  We do it all the time.  It is in our standard instructions for rebuild sort files on BR.  The blank record corrupts the data in real bank codes.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 11.  RE: Transactions missing from Bank Rec module

    Posted 04-17-2026 17:10

    Thank you @Brett Zimmerman and @Kevin Moyes.  I have deleted the blank record.  I will report back next week if the weirdness continues or if it is resolved.



    ------------------------------
    Brian Kelly
    Accounting Systems, Inc. (ASI)
    ------------------------------

    Original Message


  • 12.  RE: Transactions missing from Bank Rec module

    Posted 04-18-2026 10:08

    BR_Transaction may have the deposits with a blank Bank Code. 



    ------------------------------
    Bob Pfahnl
    Manager - Silicon Valley
    DSD Business Systems
    ------------------------------

    Original Message


  • 13.  RE: Transactions missing from Bank Rec module

    Posted 04-20-2026 10:58

    Thanks @Bob Pfahnl.  I have confirmed there are no transactions with a blank Bank Code.



    ------------------------------
    Brian Kelly
    Accounting Systems, Inc. (ASI)
    ------------------------------

    Original Message


Related Content