Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Bank Reconciliation-Outstanding Check

Posted on by 60

I am trying to post a bank reconciliation in Microsoft Navision 2009. I have an outstanding check that has been entered into the system yet the vendor has not cashed it yet, this is making the bank rec not equal zero. I read that I can delete the line by right clicking but I do not have a delete function when I right click.

How can post the bank recon with an outstanding check?

*This post is locked for comments

  • TWBlaisdell Profile Picture
    TWBlaisdell on at
    Re: Bank Reconciliation-Outstanding Check

    Hello Tera,

    Thank you for confirming that the North America Database and Bank Reconcilation is in place.  

    The deletion of an uncleared check on a Bank Reconciliation is a step to complete in the W1 Version Bank Reconcilation and possibly other country versions.  The North America Version uses the Cleared flag. The link attached below is to Customer Source Training Material for Financial Management. On this page, there is a link to the North America Training material and other specific country version materials.  The North America zip file link includes instructions and material to cover the specific steps of the Bank Reconciliation with the North America Version. 

    mbs.microsoft.com/.../course80041.htm

    When a check is not selected as Cleared. it should be shown as a deduction amount against the "Balance on Statement" to get to the Ending Balance as adjusted for the outstanding check total (i.e. Checks not cleared). This should then help tie to the Ending G/L Balance, which would include the check as already being deducted based on the check posting.to the G/L Entries through the Bank Ledger to calculate the G/L Balance Total.

    I hope this helps. Thank you for your patience while I worked through getting the details of the installation.

    Thanks

    Tom

  • TC72 Profile Picture
    TC72 60 on at
    Re: Bank Reconciliation-Outstanding Check

    Hi Tom,

    I'm not sure to which "line 1 and line 2" you are referring. I right clicked on the program and went to properties which only shows one line that says, "Microsoft Dynamics NAV 2009 R2," my boss also told me that we have the American Version.

    My version is 5 Smart Tabs in the RTC.

    Thanks,

    Tera

  • TWBlaisdell Profile Picture
    TWBlaisdell on at
    Re: Bank Reconciliation-Outstanding Check

    H4135.2009R2_2D00_NA-BankRecRTC.JPG"Microsoft Dynamics NAV 2009 R2" on line 1 and then "Version US Dynamics NAV 2009 R2 (6.00.#####) (where ##### is the build no of the system files). The key is "Version US" on Line 2.

    The NA Version includes 5 tabs for each section in the Classic Client.

    Or, 5 Smart Tabs in the RTC:

    Please confirm the information to make sure the Version we are dealing with is correct.

    Thanks

    Tom

  • TC72 Profile Picture
    TC72 60 on at
    Re: Bank Reconciliation-Outstanding Check

    Hi Tom,

    Thank you for your reply.

    I believe it is the North American Version, it is called Microsoft Dynamics Nav 2009 R2. I do have to check the box to say that payments have cleared, so when I leave the box unchecked it shows my outstanding check in the top of the bank reconciliation window.

    Thanks,

    Tera

  • TWBlaisdell Profile Picture
    TWBlaisdell on at
    Re: Bank Reconciliation-Outstanding Check

    Hello TC72,

    Thank you for posting on the Microsoft Forum.

    Please confirm the country/localized version of NAV 2009 database that you are using.  In the North America Version, the line item is set to Cleared = FALSE to indicate that the check is still outstanding. I know that the W1 Version doesn't include the North America Version functionality with the Cleared flag, so we need to confirm what county version of the database that you are using.

    Thank you,

    Tom

    For more information, please see the following link to training material on Customer Source that may help you resolve the issue. The Financial Management material is country specific and has multiple links for the respective country's version of the material.

    https://mbs.microsoft.com/customersource/training/trainingmaterials/student/course80041.htm?printpage=false

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,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans