How to Reset Accounting in iDempiere for Retail

Configure the Reset Accounting window in iDempiere to correct posting errors and repost invoices, receipts, and payments for retail accounting.

Introduction

The Reset Accounting window in iDempiere is an accounting utility that clears invalid posting status or removes Fact_Acct entries so eligible documents can be reposted.

Running it correctly keeps financial reports accurate, since incorrect resets can distort ledger balances until documents are reposted.

Business Rules

• Only transactions with an active Posted are eligible for reset. (Also Without Posting not checked)
• When Delete existing Accounting Entries is No only fixes Posted status and Processed status to as unchecked.
• When Delete existing Accounting Entries is Yes resets Posted status and deletes Fact_Acct entries for eligible documents.
• The original business document is never deleted, reversed, reopened, or voided.
• Accounting Period Control determines which documents fall inside the eligible date range.
• Also Without Postings resets documents that have no Fact_Acct entries within the period.
• The Accounting Server must be stopped before running this process.

Process Flow

Prerequisites

• Accounting Schema and Period Control configured for the Client.
• Target document (Invoice, Shipment, Payment, etc.) already completed and posted at least once.
• User role has System Admin access to the Reset Accounting window.
• Accounting Server stopped before starting the process.

Navigation

Menu → Open Items (Financial Movements and Aging) → Reset Accounting

Configuration Steps

Step 1: Select the Table to Reset

Open Reset Accounting. In the Table field, select the document table, for example C_Invoice_Invoice for AR/AP invoices.

Field	Sample Value	Description
Tenant	POTS	Client whose accounting records will be processed.
Table	C_Invoice_Invoice	Restricts the reset to Invoice-related Fact_Acct entries only.

Step 2: Choose the Delete Posting Mode

Leave Delete Posting unchecked for a status-only cleanup, or check it to delete existing Fact_Acct entries and force a full repost.

Field	Sample Value	Description
Delete existing Accounting Entries	Checked	When checked, deletes Fact_Acct rows and resets Posted status for eligible documents.

Step 3: Set the Account Date Range

Enter the accounting date From and To values covering only the affected transactions, such as the current open period.

Field	Sample Value	Description
Account Date From	07/01/2026	Start of the accounting date range considered for reset.
Account Date To	07/09/2026	End of the accounting date range considered for reset.

Step 4: Enable Also Without Postings

Check Also Without Postings if completed documents show a stuck or error Posted status but have no accounting entries at all.

Field	Sample Value	Description
Also Without Postings	Checked	Also resets eligible documents that have no matching Fact_Acct record.
Run as Job	Unchecked	Runs the process immediately instead of scheduling it as a background job.

Step 5: Run and Review the Process

Click OK to execute. Review the result message for reset and deleted counts, then run Post Immediate on the affected documents to repost.

Common Issues and Resolutions

Issue	Cause	Resolution
No documents are reset	Selected date range falls outside the open accounting period.	Adjust Account Date From/To to match an open period in Period Control.
Fact_Acct not deleted despite running the process	Delete Posting checkbox was left unchecked.	Re-run with Delete existing Accounting Entries checked.
Documents with no postings are skipped	Also Without Postings was left unchecked.	Enable Also Without Postings to include documents without Fact_Acct records.

Next Steps

• Review and correct Accounting Schema or Product/Account mappings.
• Run Post Immediate to regenerate accounting entries for reset documents.
• Verify General Ledger balances after reposting.
• Confirm Period Control settings for the affected accounting period.