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)