Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Manage old database to new database in PostgreSQl (OpenERP)

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 565
    Comment on it

    In OpenERP if users manage old database to new database and delete all record in old database and use this database in new financial year so using database query in Postgresql framework to manage database. This is very helpful for new financial year because all entry is new in next financial years. And all command used in Postgresql  and than prepare sale and account module in new financial year

    Use this command show in below:

    select * from sale_order;
    delete from sale_order;
    
    select * from account_invoice;
    delete from account_invoice;
    
    select * from account_voucher;
    delete from account_voucher;
    
    select * from account_move;
    delete from account_move;
    
    select * from purchase_order;
    delete from purchase_order;
    
    select * from stock_picking;
    delete from stock_picking;
    
    select * from stock_move;
    delete from stock_move;
    
    select * from procurement_order;
    delete from procurement_order;
    
    select * from stock_inventory_line;
    delete from stock_inventory_line;
    
    select * from add_penalty;
    delete from add_penalty;
    
    select * from merge_partner;
    delete from merge_partner;
    
    select * from remove_partner;
    delete from remove_partner;

     

 0 Comment(s)

Sign In
                           OR                           
                           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: