Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Opening Balance

Posted on by Microsoft Employee

We are going Live with NAV 2016 however the closing Trial Balance is not ready.

For example Our GO-LIVE date is 01 Nov 2018 and would like to upload opening balances as on 31 OCT 2018. However we may need to record all the transactions till 31 Oct 2018 in legacy system and may take time till 10 Nov 2018.

Can we upload opening balances in NAV after 15 Nov 2018.

If yes please let me know how can we do this backdated.

*This post is locked for comments

  • Verified answer
    subhashis Das Profile Picture
    subhashis Das 577 on at
    RE: Opening Balance

    Hi

    You can do that, there is no restriction for uploading opening in backdated . You need to take note following points :
    1. In Gen Ledger setup must allow the transaction date .(i.e. 30th October 2018)

    2. For inventory opening must change the posting account 

    3. During the upload time all user must log- out from the system .

    Regards

    Subhashis 

  • Verified answer
    Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Opening Balance

    I've never was in the same situation, but I'm tend to say "yes, but I would avoid it".

    You can apply the Posting Date to be 31st Oct, when uploading the transactions into a General Journal after the 15th Nov.

    The drawback for your plan is, that you should consider to limit the activity in the new system to Sales Order/Purchase Order transactions only.

    Of course, working with Sales Orders implies that you import inventory on the 1st Nov.

    Other transactions like reminders, payments, inventory valuation, bank reconiliation etc. are based on the finance accounts. You would have to wait with these until you have all transactions imported.

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans