Coworking:Reset Accounting

Back to Coworking:Financial Management

Introduction

The reset accounting process allows to totally or partially remove the ledger entries of an organization. The ledger entries can be massively re-created again by using the "Accounting Server Process" or the "G/L Posting by DB Tables" process. The manual changes done for the accounting entries description will obviously be lost after running this process

The aim of this process is to massively fix accounting errors due to a not proper accounting configuration.
For instance a vendor liability account wrongly assigned to a vendor (in the vendor accounting tab of the Business Partner window) which makes that the posting of all the purchase invoices of that vendor to the ledger is not correct.

As shown in the image above the "Reset Accounting" process allows to:

• totally remove from the general ledger all the organization's ledger entries if no Table is selected in the field "Table" and no filter by dates are selected in Starting Date and Ending Date.
• or remove from the general ledger a given type of journal entries if a specific Table is selected in the field "Table" and no filter by dates are selected in Starting Date and Ending Date.
  In our example the "C_Invoice" table (purchase and sales invoice table) would need to be selected in the field "Table"

In both cases the "Delete existing Accounting Entries" checkbox needs to be selected.

The reset accounting process also allows to reset the accounting transactions set as "Disable for Accounting" to "Posted" = No, therefore the Accounting Server Process if scheduled can take them once again to get them automatically posted.
In this case the "Delete existing Accounting Entries" checkbox does not have to be selected.

Let's take for instance a supplier which never asked for a prepayment but at a given point in time due to whatever kind of reason. It could happen that the prepayment transaction can not be posted in the Payment Out window because a Vendor Prepayment account was not configured by mistake.

In that case the prepayment transaction is set to "Document Disable for Accounting" as shown in the image below:

At that moment it is possible to assign a "Vendor Prepayment" account to the vendor and get the transaction shown above manually posted to the ledger.
However it is also possible to fix this kind of situation as explained below if the accounting server process is scheduled:

• configure the vendor prepayment account in the vendor accounting tab of the Business Partner window
• run the reset accounting process for the FIN_Payment table (Payment Out and Payment In) without selecting the check-box "Delete existing Accounting Entries"
• let the accounting server to automatically take this transaction/s once again and get it/them posted.

Back to Coworking:Financial Management