| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Social Network (mail)
|
| Technical Name |
account_reset |
| License | AGPL-3 |
| Website | https://opusvl.com/ |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Social Network (mail)
|
| Technical Name |
account_reset |
| License | AGPL-3 |
| Website | https://opusvl.com/ |
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
- Contributions to this module are welcomed via GitHub pull requests. To report a problem please raise an Issue on GitHub.
- Commercial support is available, please email hello@opusvl.com or call 01788 298 450 for further information.
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.
-
Customer Invoices (Validated and Paid)
-
Customer Payments (Posted)
-
Supplier Invoices (Validated and Paid)
-
Supplier Payments (Posted)
-
Journal Entries (Posted)
-
Journal Items (Posted & Reconciled)
-
Chart of Accounts
-
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.
-
Journal Entries (after execution of removal Script)
-
Journal Items (after execution of removal Script)
-
Chart of Accounts (after execution of removal Script)
-
Chart of Taxes (after execution of removal Script)
Support
- Contributions to this module are welcomed via GitHub pull requests. To report a problem please raise an Issue on GitHub.
- Commercial support is available, please email hello@opusvl.com or call 01788 298 450 for further information.
Please log in to comment on this module