Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Break up database for a financial year in OpenERP

    @dinesh.singh
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 252
    Comment on it

    1. Create backup for the database first.

    2. Restore again in a new database, with whatever name or with new financial year succeeding the name.

    3. Now perform the following tasks:

      • delete all the sales order from the sale_order table.
      • delete all the invoices from account_invoice table.
      • delete all the vouchers from account_voucher table.
      • delete data from claim tables, res_log table, purchase order tables. add_penalty, remove_penalty, tables.

    4. Check all the sequences in the Settings/Configuration/Sequences, they should be starting from 1, so set them all to one, except for the journal entries, if you want to reset them from some number to 1, then first change manually in database too and later you can reset them too.

    OpenERP
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: