Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Suggest Lines # Bank Reconcillation

Posted on by Microsoft Employee

Hi, 

When our Accountant did the Bank reconciliation in NAV , the Suggest line command is not showing the Entries for Bank charges posted through Journal. I can see the balance for the Bank Account Card and GL Account are different which means that the posted didnt show any change in the Bank Account card Balance but did change the GL Account Balance. Is this because something is missing when posting the Journal or the setup of Bank Account Card. 

Appreciate your Help,

Thanks,

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Suggest Lines # Bank Reconcillation

    As you can see, "Bal. Account Type" & "Bal. Account No.". number is blank. This mean, user has posted the entries without selecting the bank account in the journal.

    You can reverse these entries and ask your finance team to pass the right entry, by selecting the bank account number in the journal.

    Hope this helps.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Suggest Lines # Bank Reconcillation

    GL-eN.JPG

    Hope this will provide the required information

    Regards,

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Suggest Lines # Bank Reconcillation

    Do not filter the G/L Entries by G/L Account No., Instead filter by Document No. and provide the details.

    Navigate the entries by "Document No."...

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Suggest Lines # Bank Reconcillation

    Bal. Account No. is blank and  Bal. Account Type is G/L Account.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Suggest Lines # Bank Reconcillation

    Hi,

    Check "Bal. Account Type" & "Bal. Account No.".. Document No. seems different for both the lines.

     

    Do not filter by G/L Account No., Instead filter by Document No. and provide the details.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Suggest Lines # Bank Reconcillation

    GL.JPG

    Which field do you want me to check ?

    Thanks

    Aron

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Suggest Lines # Bank Reconcillation

    Hi Aron,

    Have you checked the general ledger entries? Is Bank Account selected in the entries?

    Can you attached screenshot for the same here?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Suggest Lines # Bank Reconcillation

    Hi Vishal

    I have checked and no  Bank account ledger entries have been created for the Bank charges,

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Suggest Lines # Bank Reconcillation

    Can you just navigate the Bank charges journal entries (Document No. wise) and see if Bank account ledger entries have been created for the Bank charges?

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!

Community AMA December 12th

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

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans