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) / How to extract opening...
Microsoft Dynamics NAV (Archived)

How to extract opening balance from 200r2 navision

(0) ShareShare
ReportReport
Posted on by S Shambhu 444

Hi,

Please let me know I can extract all outstanding invoice and g/l account wise opening balance in 2009R2.

We have closed all transaction in 2009r2 know I have to bring all g/l, customer & vendor invoice wise opening balance in to 2016.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi

    Combination of Data Migration in 2009R2, Rapidstart in 2016 and some of the reports in 2009R2.

    An example would be open customer ledger entries. This will be trade debtors on your TB so use Balance By Dim (cumulative) for the TB and then copy and paste into excel. Use Excel to convert this data and then once formatted in the right column layout copy and paste into Nav Gen Jnls. The detailed customer ledger entries can either be exported to excel using the Aged Accounts Receivable report (tick export to excel box which works on Nav 2009r2 on detail only) and then convert data to copy and paste into excel / use rapidstart or by using Data Migration tool in 2009R2 to export open entries only.

    Hope this helps.

    Neil

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,698 on at

    You need to extract ooen customer ledger entries,open vendor ledger entries ,fixed asset and trial balance

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    You need to transfer all the open balance sheet accounts, at the level of opened documents:

    - vendors by open invoices and not closed prepayments (for that, refer to open vendor ledger entries for suppliers)

    - customers by open invoices and not closed prepayments (for that, refer to open customer ledger entries for suppliers)

    - open bank balances (refer to bank cards balance at date)

    - open Fixed Assets (transfer both initial value and accumulated depreciation)

    - open employees transactions

    - open stock by items

    - open loans received and given

    - other balance sheet accounts (charter capital, etc.)

    - etc.

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