Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / BANK RECONCILIATION
Microsoft Dynamics NAV (Archived)

BANK RECONCILIATION

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello, I went to do a bank rec on one of my accounts.  I did the suggest lines but my checks weren't in there.  I included checks when I got the lines but they weren't there.  So I ran a check register, and they are there, I'm not crazy.  So, then I ran the detail trial balance and all the checks i'm looking for is Open = "NO".   What did I do to make that happen prior to doing the bank rec?  I Have no idea how I could have made that happen but apparently I did.....and is there a way to reverse it.  How can I balance to the bank statement without those checks?

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: BANK RECONCILIATION

    Yea, certain tables can be modified with only developer license.  At times, even it is not allowed to do so in newer versions. Hence you would require to do it via SQL server only.

    Ideally it is not allowed to do any modifications in the ledger tables.

     

    Anyway, lot of people are managing Bank Reco in NAV system quite easily. I really don't see challenges quite often in it...

    Best Regards,

    Vishal Salot

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: BANK RECONCILIATION

    This is why it is better to just do the reconciliation outside of NAV and upload the verified check status information.  Especially if your bank data is full of keypunch errors, missing check numbers, etc.

    Why does NAV make it so hard to say whether a check is open or cleared?  You need a developer's license to do that?!

     

    Really miss Quickbooks.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: BANK RECONCILIATION

    I just checked them and they weren't on the last statement.  They were written in July and my last statement was december.  They weren't on there.

  • mmv Profile Picture
    mmv 11,465 on at
    RE: BANK RECONCILIATION

    Hi,

    Did you check whether those are already been used in the other Bank Reconciliation which is already been posted?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: BANK RECONCILIATION

    If you can't modify the table from NAV using developer license, Try to modify the records from SQL. Be careful - select the proper records in Check Ledger Entry Table and modify the same. PLEASE check the results in test environment first...

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: BANK RECONCILIATION

    yes, that is correct.  I can't include those checks in the bank rec.

    Where is the check ledger entry table?  I went to check ledger entries but there's no where to modify.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: BANK RECONCILIATION

    Hi,

    Are you saying that, you are not able to include the certain checks in Bank Account Reconciliation  page?

    Try to modify the Open Field in Check Ledger Entry Table to TRUE for the relevant entries and see the results (suggested in test environment first).

    Let me know, if it helps.

    Regards,

    Vishal Salot

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans