Opening balances

Comments

• Sbhat Member Posts: 301

  2003-08-08

  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
• rohtsh Member Posts: 13

  2003-08-11

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

  0
• tushaar99 Member Posts: 35

  2003-08-11

  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

  Regards,
  Tushaar

  0
• Deep Member Posts: 569

  2006-11-02

  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
  India

  0
• David_Cox Member Posts: 509

  2006-11-02

  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.com

  0