Transfering of Opening balances

pranita
Member Posts: 6
Hi All
I am in the learning stage of Navision
Could any one help me how to transfer the opening balances while implementation is done
I am in the learning stage of Navision
Could any one help me how to transfer the opening balances while implementation is done
0
Comments
-
The best way to handle it is to use a general journal, or sales journal and change your posting groups so that both the debit and the credit hit the same account, this way the customer, vendor, and bank ledger entries can get entered but don't change the g/l
for the gl, best to use the general journal, what we did, because we wanted to have several years of comparision entries, we entered the month end balance for each account for two years, if your data is in a format you can import, then bring it into a journal and post the journal, otherwise hire a few people and do the data entry right into the journals0 -
Which opening balances do you want to transfer? Opening Balances for inventory, vendor, customer and G/L accounts.0
-
Hi all,
I would like to know how to do an opening balance for a new bank account on a live Navision system?
The bank account exists with a balance, but never entered onto Navision (for some reason!).
Cheers0 -
make general journal entries for all open items (items, not already cleared by a previous bank reconciliation)
you make the entry to the bank account and the balancing entry to the same G/L account that the bank post to. This way there is a debit and credit to the same G/L account, and thus no effect on the G/L and the bank accounts gets the entries so they are now there for your reconciliation.0 -
How do I get the balance to show on the G/L for the bank account? The balance is fine on the actual bank account, but because the debits and credits have balanced = 0 in the G/L.
I think I am missing an obvious trick!!??0 -
you must map all accounts first. All debit balances & credit balances and then post it. Alternatively, you may also create a suspense account to match small balances, but is not a very advisable solution. Before posting, sensible is chart all debit & credit account balances on an excel sheet & then post the entries into navision(when debit & credit balances are nullified)0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions