web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Nav 2016 Bank Reconcil...
Microsoft Dynamics NAV (Archived)

Nav 2016 Bank Reconciliation Suggest Lines Missing Open Deposit Entries

(0) ShareShare
ReportReport
Posted on by Louis Li 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

I have the same question (0)
  • Suggested answer
    tpupko Profile Picture
    tpupko 2,048 on at

    Hi Louis,

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

    Tatiana

  • Louis Li Profile Picture
    Louis Li 65 on at

    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

    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

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

  • Alex Olive Profile Picture
    Alex Olive 20 on at

    Hey Louis,

    Did you ever figure out what caused this issue?

    thanks

    Alex

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans