Open Forum

Expand all | Collapse all

Payment not pulling through on Bank rec

  • 1.  Payment not pulling through on Bank rec

    Posted 15 days ago
    We've been having an issue with certain payments or invoices not pulling through to the bank recs but you can see them on the GL. The specific one I'm looking at has the "open" box checked under the Bank Account Ledger Entry section when I open the related entries where as the other payments from the similar vendor do not. I'm not sure if this is the issue or not, but what would cause a payment to not pull through on the bank rec but show up on the GL? How can you fix this?

    ------------------------------
    Jami Laddusaw
    Mary T. Inc.
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Payment not pulling through on Bank rec

    Posted 15 days ago
    You have to make sure that the balancing account type in the payment journal is "bank account" not "G/L Account".  You can also turn off direct posting for that specific account and it will not allow entries to be posted only to the general ledger for that specific account.

    ------------------------------
    Jamie Longnecker
    GCSES
    Gray
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Payment not pulling through on Bank rec

    Posted 15 days ago
    Are you filtering your Suggest Lines option window?  Something as simple as this often gets over looked.

    ------------------------------
    Jimmy Yu
    Step Energy Services Inc
    AB
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: Payment not pulling through on Bank rec

    SILVER CONTRIBUTOR
    Posted 15 days ago
    Jamie Longnecker is correct.   The Bank Rec relies on the Bank Ledger Entry and Check Ledger Entry tables.  If you do not post to a bank account, the entry will not commit a record to the Bank Account Ledger table and therefore will not show on the bank account rec process.
    Cash General ledger accounts (along with AR and AP general ledger accounts) should be turned off for "Direct Posting", as Jamie said above.





    ------------------------------
    Jamie Constantine
    Columbus Global
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: Payment not pulling through on Bank rec

    GOLD CONTRIBUTOR
    Posted 15 days ago
    Edited by Alex A 15 days ago

    ​Hello Jami,

    Every once in a while I see an issue like this caused by a payment that was added to a Bank Reconciliation statement where the statement was deleted by a user. Depending your NAV version, in this scenario NAV might not show it on a new bank rec because it thinks it's already on one.

    From the Bank Account Ledger Entries screen, select the line you are referring to, and go to Help => About This Page => and view the Table Fields for this line in the Bank Account Ledger Entries view. Check the following fields: Statement Line No, Statement No, and Statement Status to make sure this entry didn't get put on a Bank Reconciliation statement that was deleted.



    ------------------------------
    If my response has helped you please mark the answer.


    Best Regards,

    Alex A
    Sr. NAV Consultant
    Los Angeles, CA, United States
    ------------------------------

    Conference-BCNAVUG_200x200


  • 6.  RE: Payment not pulling through on Bank rec

    Posted 14 days ago
    Hi,

    When I'm in this field, the only things are

    Page: Bank Account Ledger Entries (372)
    Page Type: List
    Page Mode: View
    Source Table: Bank Account Ledger Entry (271)
    Rec: 96832

    The other things that were mentioned have all been checked and are ok. Again, the only thing I can tell different is the "Open" field in the Bank Account Ledger Entry field is checked and I've never seen that before and I don't know what that does.

    Thanks,

    ------------------------------
    Jami Laddusaw
    Mary T. Inc.
    Coon Rapids MN
    ------------------------------

    Conference-BCNAVUG_200x200


  • 7.  RE: Payment not pulling through on Bank rec

    SILVER CONTRIBUTOR
    Posted 14 days ago
    The open field is literally driven by the bank Rec process for bank ledger entries.      So if something is open , it's ready to be reconciled.  

    Jamie Constantine
    570-878-1722



    Conference-BCNAVUG_200x200


  • 8.  RE: Payment not pulling through on Bank rec

    SILVER CONTRIBUTOR
    Posted 14 days ago
    I have also experienced this when doing my Bank Rec.
    if the open field is checked that means it should pull to the back rec
    1. Please check that the you can view the entry through the bank and not through the GL
    2. go to the bank card and select ledge entries and verify that you can see these entries
    3. If you cannot see them then it means that this was posted through the bank GL and not the bank account
    4. Verify that other entries from the same batch are pulling to the bank rec
    5. If you can see it in the bank but it is still not pulling to the bank rec I will suggest you do auto reverse and repost the entry again
    6. Always make sure the bank type is selected and not the GL type for payment
    7. Please check your date filter on the Bank Rec


    ------------------------------
    Yusuf Newland
    MGAC
    Washintgon DC
    ------------------------------

    Conference-BCNAVUG_200x200


  • 9.  RE: Payment not pulling through on Bank rec

    Posted 9 days ago
    Thanks, Yusuf. However, it did not help. I can see it on the bank card and I'm setting my date filter to let everything come through to October 31st. The items that are not pulling through are for August and one for October 4th. I thought I read somewhere that the result of this could be from a bank rec being deleted and the lines not being cleared before deleting. I have not deleted any bank recs, however, in trying to solve this, is there a way to search for deleted bank recs?

    ------------------------------
    Jami Laddusaw
    Mary T. Inc.
    Coon Rapids MN
    ------------------------------

    Conference-BCNAVUG_200x200


  • 10.  RE: Payment not pulling through on Bank rec

    GOLD CONTRIBUTOR
    Posted 9 days ago

    Hello Jami,

    In response to your last message, please review my former response above. If this missing payment is tied to another bank rec (deleted or not) it will be discernible from the Statement No and Statement Line No fields within that Bank Account Ledger payment record. I've excerpted the detail below for your convenience.

    From the Bank Account Ledger Entries screen, select the line you are referring to, and go to Help => About This Page => and view the Table Fields for this line in the Bank Account Ledger Entries view. Check the following fields: Statement Line No, Statement No, and Statement Status to make sure this entry didn't get put on a Bank Reconciliation statement that was deleted.

    Note: Please be sure to click on the Table Fields fasttab to expand it so you can see all the fields related to this record. If you cannot see all the aforementioned fields from the view Table Fields page under Help => About This Page, then you may need to find a SUPER user to be able to see them.



    ------------------------------
    If my response has helped you please mark the answer.


    Best Regards,

    Alex A
    Sr. NAV Consultant
    Los Angeles, CA, United States
    ------------------------------

    Conference-BCNAVUG_200x200


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