Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jami Laddusaw]

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.
——————————

[Jamie Longnecker]

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
——————————
——————————————-

[Jimmy Yu]

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

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

[Jamie Constantine]

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
——————————
——————————————-

[Alex Apodaca]

?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
——————————
——————————————-

[Jami Laddusaw]

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
——————————
——————————————-

[Jamie Constantine]

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

——Original Message——

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
——————————

[Yusuf Newland]

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
——————————
——————————————-

[Jami Laddusaw]

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
——————————
——————————————-

[Alex Apodaca]

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
——————————
——————————————-