Want to setup OpenERP Accounting module ?

I am back again after a long time to submit my one more interesting post on OpenERP Accounting module. This time I would like to show you complete implementation of the accounting module instead of discussing the individual small feature.

For that I have prepared the sample requirements specification on behalf of ABC Private Limited, Ahmedabad.

Specifications
  • Company running Indian financial year with Indian chart of account
  • Configurations of Journals 
    • Sales
    • Purchase
    • Expanse
    • Asset
    • Cash
    • Bank
    • Contra
  • Account Charts
    • Configure more accounts
  • List of Opening Account
    • Customers / Receivables
      • China Exports – 50,000 Dr
      • Asus – 36000 Dr 
    • Suppliers / Payable
      • Axelor – 4000 Cr
      • Distrub PC - 3,50,000 Cr
    • Bank (IDBI) – 15,00,000
    • Bank (ICICI) – 4,50,000
    • Assets as per Balance sheet
      • Computer & Laptops  - 7,50,000
      • Furniture (Chair / Tables) – 3,50,000
      • Air-Conditions – 48,000
      • Consumable Stationary – 4,500
      • Car – 1,75,000
      • Cash on Hands - 500
    • Profit carry forward - 2,36,500
    • Tax and Duties Payable - 20,000
    • Capital Account - 20,00,000
    • Bank Loan (Bank of India) as per books - 7,50,000
Look at the Balance sheet as on the 1st April after carry forward all entries to the new financial year 2010-2011
Balance sheet as on 1st April 2010
You can also download the complete configured database. You can also download some of the reports printed from this database. 

My plan is to explain complete implementation process for the movement we have complete the first phase, to import the opening entries as per the ABC Private Limited books as on 1st April 2010. In my next blog i will explain how to working with the transactions like customer / suppliers invoices, and their payment with respect to the payment terms and taxes. Have a look at some of the planned expanse for company

Comments

  1. UnknownMarch 22, 2011 at 8:35 AM

    Mantavya, Thanks for the information as always. Do you have any tips on how to import "open" account receivables and "open" account payables into OpenERP that are part of an opening balance on the asset side, but have already been taken to income in a prior period? Our understanding is that workflow needs to be modified in order to properly reflect a workflow instance. Perhaps a topic for a future blog entry.

    ReplyDelete
  2. Mantavya GajjarMarch 22, 2011 at 11:05 AM

    Hello,

    According to me no need to do any changes in to the workflow if you want to import the entries of the expense, income, payment in the old financial years.

    Its better to prepare the file like Sample file and import that file in the Journal Items. Here are the steps

    Keep your journal configuration in such a way that it should not post the entries directly

    1. Open Journal Items
    2. Select journal in which you want to import the entries (in my case expense journal)
    3. do import the file

    during the import you have to take care for the few things like id should match the name of Account, Period and Partner with in your database.

    Regards,

    ReplyDelete

Post a Comment

Popular posts from this blog

Implement OpenERP for Service company

Image
Team of Professionals Are you working for or running a professional service, like charted accounting, support center, annual maintenance / service contracts, etc. where you have to keep concentrate on your customer communication and service level, to make them satisfy and up to date with the real time updated information. OpenERP is ready to helps you in that case, the generic way of managing customer communications, keep track of projects, tasks and time management, Billing based on the tasks or projects or time spend which is base of any professional services, All this will give you a full control on your professional services. Some Problems Here are some questions which I would like to ask, before you look in to details of OpenERP, If any of the questions is a real problem for you, OpenERP is ready to help you with its open source business model which will offer you solution at comparatively very low cost. Are you professional service provider and you...
Read more

Command Line Mass Mailing Tool

Image
There are lots of tool for mass-mailing, but this tool is the tool for which i am talking about is based on command line. It is a very simple tool with as much as configurations for applications and mail framework properties. Application Settings All application configurations will be given through the  application.properties where you have to provide the settings like password, email list file, email file, return path, log file , debug option, mailer and mail format like text, html, etc.. Email Settings Email settings file mainly contains all email settings which required by the Java Mailing apis , you may fine complete properties list here. some of the important properties ate are host, port, user name etc.. Application folder - contains all files Setup Email List Application property `application.list` used to pass the email list to the application. This file heaving a very simple format one line is equals to one email address . it means if you wanted to send email ...
Read more

Server Action - Improvements

Hello to All, I am happy to Post this that we have revised the server action which is the interesting feature for the new version OpenEPR 5. We change the few configuration for the quick and easy configuration for some important functionalities. like Create Object, Write Object, Send Email, and the excellent is Multi Action to allows to execute the multiple server actions at the same time. Test it your self, get the new revised document that will helps you to configure the all the server action your self.
Read more