Opening balances

rohtsh

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

Sbhat

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.

rohtsh

HI,

My question was pertaining to the individual accounts (i.e ledgers-vendors,customers) and not accounts from chart of accounts.

Thanks & regards

Rohit

tushaar99

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
Tushaar

Deep

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.

David_Cox

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!