Erase test accounting transactions

Overview

This module enables the user to erase certain accounting transaction records and safely ‘zero’ the Odoo account chart easily. The accounting transaction records which will be deleted are as specified below:

  • Journal Entries
  • Journal Items
  • Customer Invoices
  • Customer Payments
  • Customer Refunds
  • Supplier Invoices
  • Supplier Payments
  • Supplier Refunds
  • Complete Chart of Accounts
  • Complete Chart of Taxes

Purpose

The purpose of this module is to remove accounting transactions and 'zero' the accounts chart. It is used during the development and test stages of an Odoo project to remove financial data that was created whilst testing. As this module is designed to remove transactions, it should not installed or used after go live as live data will be removed. See roadmap for planned developments below.

This module reduces the development overhead of purging each transaction manually and then verification of the charts.

If test data is not removed after testing, it will interfere with live customer data.

Key Features

  • Provides the facility to select the company for which transactions need to be erased
  • Option to mandate a second user’s confirmation before the rollback can be executed
  • Provides Odoo permission control to access the erase function

Key Benefits

  • Reliable and repeatable transaction removal function
  • User friendly web interface allows all users to navigate the system, regardless of technical ability
  • Controls and permissions can be set as needed to ensure security
  • Multi-user validation can be optionally configured

Future roadmap

  • Start and end date ranges to allow for more accurate selection of records
  • Automatic minimum retention policy (UK rules require 6 year retention)

Support

Erase test accounting transactions

How to install

  • Firstly, ensure that the module file is present in the add-ons directory of the Odoo server
  • Update Modules list so that it appears in the UI within Apps store
  • Look for the module within Apps store and click on Install.
  • Additionally, make sure that the required user has been assigned to the user group 'Accounts Reset'. This will enable the concerned user have access of all the functionalities brought through this module.

Step by Step Instructions

1) The below screenshots depict the current state of accounting transactions, Journal entries, Chart of taxes and Chart of accounts in Odoo system before execution of the removal script.

  1. Customer Invoices (Validated and Paid)

  2. Customer Payments (Posted)

  3. Supplier Invoices (Validated and Paid)

  4. Supplier Payments (Posted)

  5. Journal Entries (Posted)

  6. Journal Items (Posted & Reconciled)

  7. Chart of Accounts

  8. Chart of Taxes

2) Now, execute the script using the following steps:

Go to Accounting → Configuration → Reset Accounts. A help wizard will then open.

3) Select the 'Company' for which accounting entries needs to be erased.

4) Tick the checkbox to confirm you understand the implications of this action

5) Click on 'Reset Accounts' button

This will trigger the execution of script at the back end and all the accounting entries will be rolled back to 0

6) Provided below are the screenshots after execution of the removal operation which shows the entries are rolled back to 0.

  1. Journal Entries (after execution of removal Script)

  2. Journal Items (after execution of removal Script)

  3. Chart of Accounts (after execution of removal Script)

  4. Chart of Taxes (after execution of removal Script)

Support