Is there anyway to filter on Bank Reconciliations

(0) Share

Report

Posted on by KellyEnhanced

192

Dear All,

Is there anyway to filter on the bank reconciliation screen under the section Bank Account Ledger entries, as one of my clients is trying to filter to show only unreconciled items. I know the items that are Applied at highlighted in green, but wanted to group them together to work out what they have missed on the reconciliation screen.

Kind regards,

Kelly

All responses (6)

Answers (2)

Sort by

Verified answer

AD-22040756-1 668 on at

Like (0)

Report
Copy link

Link copied!

If you personalize the page you can add the 'Statement Status' field to the Bank Account Ledger Entries Pane. You can then filter this field to only display Open lines. However, I would just sort this field, this way you will have all Open lines right at the top
Suggested answer

Amit 2,563 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Functionally-:

technically-: Make extension and apply filter in AL

Regards

Amit Sharma

www.erpconsultors.com
Verified answer

Alfredo_Iorio 1,268 on at

Like (0)

Report
Copy link

Link copied!

You can use the filter on the lines as others suggested or you can use the action in the document header to show only unmatched.
KellyEnhanced 192 on at

Like (0)

Report
Copy link

Link copied!

Thank you Andy for your reply that worked perfectly. I was being silly as I hadn't clicked to highlight the bank acct ledger entries, so that it highlighted the entire box before doing the personalised option.
KellyEnhanced 192 on at

Like (0)

Report
Copy link

Link copied!

Thank you Amit for your reply, that worked.

Kind regards,

Kelly
KellyEnhanced 192 on at

Like (0)

Report
Copy link

Link copied!

Thank you Alfredo for your reply that is also another good idea.

Kind regards,

Kelly