Opening balances

rohtsh
Member Posts: 13
Hi all,
In Navision Attain 3.6, how to enter the opening balances for ledgers? These are supposed to be the starting entries (either + or -) for individual accounts.
Thanks & regards,
Rohit
New Delhi
In Navision Attain 3.6, how to enter the opening balances for ledgers? These are supposed to be the starting entries (either + or -) for individual accounts.
Thanks & regards,
Rohit
New Delhi
0
Comments
-
Hi,
Make a GL Journal entry for opening balance and post the entry, it would then make a entry in the G/L entry table and the G/Account table will be automatically updated.
Thanks
Suresh
NJ.0 -
HI,
My question was pertaining to the individual accounts (i.e ledgers-vendors,customers) and not accounts from chart of accounts.
Thanks & regards
Rohit0 -
Hi rohtsh,
What Sbhat has said is right.
I guess it just needs to a elaborated.
What u should do is pass a Gen Journal Entry for each Customer/Vendor.
The Account Type will be Customer/Vendor, the account no will be the Customer/Vendor No., the amount will be the balance and the Balancing Account Type will be G/L Account and the Balancing Account will be the Customer?Vendor posting group.
I guess this helps u out...!!!
Regards
TushaarRegards,
Tushaar0 -
Hi Tushar,
This idea works, but please let me know whether we have to do all the entries in one single ledger entry???
I mean All the individual debtors a/c Cr. and a/c receivables Dr each line.
similarly all the ind. cr. a/c dr. and a/c payables cr. each line
and along with all the dr & cr. balances of trial balance in a single entry???
pl reply.Regards,
Deep
India0 -
Deep wrote:Hi Tushar,
This idea works, but please let me know whether we have to do all the entries in one single ledger entry???
I mean All the individual debtors a/c Cr. and a/c receivables Dr each line.
similarly all the ind. cr. a/c dr. and a/c payables cr. each line
and along with all the dr & cr. balances of trial balance in a single entry???
pl reply.
Hi Deep
There are different ways for bringing in opening balances from other systems, each entry on a one to one basis balanced through suspense, if you have lots of entries, then you may want end of last year balances posted and then line by line for the current financial year.
If you are starting with a new year, then you may want Just opening balances for each account.
This is the Customers choice really, but many different ways to reach the same point.
And Customers and Vendors, has been answered in your other post!Analyst Developer with over 17 years Navision, Contract Status - Busy
Mobile: +44(0)7854 842801
Email: david.cox@adeptris.com
Twitter: https://twitter.com/Adeptris
Website: http://www.adeptris.com0
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