Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Nav 2016 Bank Reconciliation Suggest Lines Missing Open Deposit Entries

Posted on by 65

We're on Nav 2016 Build 9.0.46621.0 (CU10). Recently, during a bank reconciliation, when using the "Suggest Lines", it populated the Deposits/Transfers lines slightly off (Suggest Lines better by 90.13) comparing with from Bank Account Ledger Entries. Of course, it wouldn't balance. I re-ran the "Suggest Lines" option with "Replace existing lines" option checked, this time, it missed (not populating the lines) 25 open deposits! I re-ran it several times, still the same! I deleted the entire bank reconciliation file and ran again, same result. Somehow, it doesn't read the 25 open deposits as open/outstanding. (Cheques lines are ok) I did many bank reconciliations before. This is the first time we ran into a problem. By the way, we have 3 other bank accounts. They are all ok!

*This post is locked for comments

  • Alex Olive Profile Picture
    Alex Olive 20 on at
    RE: Nav 2016 Bank Reconciliation Suggest Lines Missing Open Deposit Entries

    Hey Louis,

    Did you ever figure out what caused this issue?

    thanks

    Alex

  • Louis Li Profile Picture
    Louis Li 65 on at
    RE: Nav 2016 Bank Reconciliation Suggest Lines Missing Open Deposit Entries

    no go. already tried playing with these settings with all the possible combinations.

  • Suggested answer
    tpupko Profile Picture
    tpupko 2,048 on at
    RE: Nav 2016 Bank Reconciliation Suggest Lines Missing Open Deposit Entries

    Hi Louis,

    Please try without option Include checks, system will check Bank account ledger entries

    msdn.microsoft.com/.../hh169007(v=nav.90).aspx

    If you want to suggest check ledger entries instead of bank account ledger entries, select the Include Checks field.

  • Louis Li Profile Picture
    Louis Li 65 on at
    RE: Nav 2016 Bank Reconciliation Suggest Lines Missing Open Deposit Entries

    Yes, I did try all the options "Both", "Deposits", & "Cheques". All rendered the same result. I really think Nav somehow deemed these 25 open deposits as being marked "closed". But, I just couldn't figure out the logic behind it.

  • Suggested answer
    tpupko Profile Picture
    tpupko 2,048 on at
    RE: Nav 2016 Bank Reconciliation Suggest Lines Missing Open Deposit Entries

    Hi Louis,

    Do you use  Include checks option when you run Suggest line function?

    Tatiana

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans