{"id":20189,"date":"2026-08-04T12:03:00","date_gmt":"2026-08-04T12:03:00","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20189"},"modified":"2026-08-17T07:11:54","modified_gmt":"2026-08-17T07:11:54","slug":"how-to-reset-accounting-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-reset-accounting-in-idempiere\/","title":{"rendered":"How to Reset Accounting in iDempiere"},"content":{"rendered":"\n

Configure the Reset Accounting window in iDempiere to correct posting errors and repost invoices, receipts, and payments for accounting.<\/p>\n\n\n\n

Introduction<\/strong><\/h2>\n\n\n\n

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.<\/p>\n\n\n\n

Running it correctly keeps financial reports accurate, since incorrect resets can distort ledger balances until documents are reposted.<\/p>\n\n\n\n

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

    Process Flow<\/strong><\/h2>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

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

      Navigation<\/strong><\/h2>\n\n\n\n

      Menu \u2192 Open Items (Financial Movements and Aging) \u2192 Reset Accounting<\/p>\n\n\n\n


      Configuration Steps<\/strong><\/h2>\n\n\n\n

      Step 1: Select the Table to Reset<\/strong><\/h3>\n\n\n\n

      Open Reset Accounting. In the Table field, select the document table, for example C_Invoice_Invoice for AR\/AP invoices.<\/p>\n\n\n\n

      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Tenant<\/td>POTS<\/td>Client whose accounting records will be processed.<\/td><\/tr>
      Table<\/td>C_Invoice_Invoice<\/td>Restricts the reset to Invoice-related Fact_Acct entries only.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Step 2: Choose the Delete Posting Mode<\/strong><\/h3>\n\n\n\n

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

      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Delete existing Accounting Entries<\/td>Checked<\/td>When checked, deletes Fact_Acct rows and resets Posted status for eligible documents.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Step 3: Set the Account Date Range<\/strong><\/h3>\n\n\n\n

      Enter the accounting date From and To values covering only the affected transactions, such as the current open period.<\/p>\n\n\n\n

      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Account Date From<\/td>07\/01\/2026<\/td>Start of the accounting date range considered for reset.<\/td><\/tr>
      Account Date To<\/td>07\/09\/2026<\/td>End of the accounting date range considered for reset.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Step 4: Enable Also Without Postings<\/strong><\/h3>\n\n\n\n

      Check Also Without Postings if completed documents show a stuck or error Posted status but have no accounting entries at all.<\/p>\n\n\n\n

      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Also Without Postings<\/td>Checked<\/td>Also resets eligible documents that have no matching Fact_Acct record.<\/td><\/tr>
      Run as Job<\/td>Unchecked<\/td>Runs the process immediately instead of scheduling it as a background job.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Step 5: Run and Review the Process<\/strong><\/h3>\n\n\n\n

      Click OK to execute. Review the result message for reset and deleted counts, then run Post Immediate on the affected documents to repost.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      Common Issues and Resolutions<\/strong><\/h2>\n\n\n\n
      Issue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>
      No documents are reset<\/td>Selected date range falls outside the open accounting period.<\/td>Adjust Account Date From\/To to match an open period in Period Control.<\/td><\/tr>
      Fact_Acct not deleted despite running the process<\/td>Delete Posting checkbox was left unchecked.<\/td>Re-run with Delete existing Accounting Entries checked.<\/td><\/tr>
      Documents with no postings are skipped<\/td>Also Without Postings was left unchecked.<\/td>Enable Also Without Postings to include documents without Fact_Acct records.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Next Steps<\/strong><\/h2>\n\n\n\n
        \n
      • Review and correct Accounting Schema or Product\/Account mappings.<\/li>\n\n\n\n
      • Run Post Immediate to regenerate accounting entries for reset documents.<\/li>\n\n\n\n
      • Verify General Ledger balances after reposting.<\/li>\n\n\n\n
      • Confirm Period Control settings for the affected accounting period.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

        Configure the Reset Accounting window in iDempiere to correct posting errors and repost invoices, receipts, and payments for accounting. Introduction […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,58],"tags":[],"class_list":["post-20189","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-accounting"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20189","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=20189"}],"version-history":[{"count":6,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20189\/revisions"}],"predecessor-version":[{"id":27036,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20189\/revisions\/27036"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20189"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}