{"id":21637,"date":"2026-08-04T12:03:46","date_gmt":"2026-08-04T12:03:46","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=21637"},"modified":"2026-08-21T06:37:40","modified_gmt":"2026-08-21T06:37:40","slug":"how-does-invoice-transactions-acct-report-works-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-does-invoice-transactions-acct-report-works-in-idempiere\/","title":{"rendered":"How Does Invoice Transactions (Acct) Report Works in iDempiere"},"content":{"rendered":"\n

The Invoice Transactions (Acct) Report<\/strong> provides a detailed list of invoice transactions based on the Accounting Date<\/strong>. It displays invoice documents together with accounting information, customer details, payment information, and invoice amounts for the selected accounting period. The report helps users verify invoices that have been posted to the General Ledger and supports financial reconciliation and accounting verification. It is commonly used by the Finance, Accounts, and Audit teams during period-end closing, financial reporting, and accounting analysis.<\/p>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Retrieves invoice transaction information from the RV_C_Invoice<\/strong> database view.<\/li>\n\n\n\n
  • Displays invoice records based on the selected Accounting Date<\/strong> range.<\/li>\n\n\n\n
  • Allows users to filter records by Organization<\/strong> and Sales Transaction<\/strong>.<\/li>\n\n\n\n
  • Supports both Sales<\/strong> and Purchase<\/strong> invoice transactions.<\/li>\n\n\n\n
  • Displays accounting-related information including Accounting Date, Document Number, and Document Status.<\/li>\n\n\n\n
  • Retrieves Business Partner information associated with each invoice.<\/li>\n\n\n\n
  • Displays payment information such as Payment Rule and Payment Terms.<\/li>\n\n\n\n
  • Shows financial values including Charge Amount, Total Lines, and Grand Total.<\/li>\n\n\n\n
  • Displays only records that match the selected report parameters.<\/li>\n\n\n\n
  • Provides a transaction-level accounting report for financial verification, reconciliation, and audit purposes.<\/li>\n<\/ul>\n\n\n\n

    Report Parameters<\/strong><\/h2>\n\n\n\n

    Parameter Window<\/strong><\/h3>\n\n\n\n

    The Invoice Transactions (Acct) Report parameter window allows users to filter invoice records before generating the report.<\/p>\n\n\n\n

    Invoice Transactions (Acct) Report \u2013 Parameter Window<\/strong><\/p>\n\n\n\n

    \"TenthPlanet-iDempiere-Accounting-Invoice-Transaction-Acct-1\"<\/figure>\n\n\n\n
    Parameter<\/strong><\/td>Purpose<\/strong><\/td>Filtering Behavior<\/strong><\/td>Sample Value<\/strong><\/td><\/tr><\/thead>
    Organization<\/td>Choose Organization<\/td>Filters by organization.<\/td>POTS Chennai Store<\/td><\/tr>
    From Account Date<\/td>Choose From Accounting Date<\/td>Filters from selected accounting date.<\/td>07\/01\/2026<\/td><\/tr>
    To Account Date<\/td>Choose To Accounting Date<\/td>Filters up to selected accounting date.<\/td>07\/31\/2026<\/td><\/tr>
    Sales Transaction<\/td>Show Sales Transactions Only<\/td>Shows Sales or Purchase invoices.<\/td>Checked<\/td><\/tr>
    Run as Job<\/td>Run report in background<\/td>Runs report as background job.<\/td>Checked<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Report Output<\/strong><\/h2>\n\n\n\n

    The report provides a detailed list of invoice transactions based on the selected accounting period. It displays accounting information together with invoice details, customer information, payment details, and financial amounts. Users can verify invoices posted to the accounting system, review accounting transactions, and reconcile financial records before period closing. The report is useful for accounting verification, financial auditing, General Ledger reconciliation, and statutory reporting.<\/p>\n\n\n\n

    The report displays information such as:<\/strong><\/p>\n\n\n\n

      \n
    • Organization<\/li>\n\n\n\n
    • Accounting Date<\/li>\n\n\n\n
    • Invoice Number (Document No)<\/li>\n\n\n\n
    • Invoice Date<\/li>\n\n\n\n
    • Business Partner<\/li>\n\n\n\n
    • Payment Rule<\/li>\n\n\n\n
    • Document Status<\/li>\n\n\n\n
    • Charge Amount<\/li>\n\n\n\n
    • Total Lines<\/li>\n\n\n\n
    • Grand Total<\/li>\n\n\n\n
    • Currency<\/li>\n\n\n\n
    • Sales Transaction<\/li>\n\n\n\n
    • Sales Representative<\/li>\n\n\n\n
    • Business Partner Information<\/li>\n\n\n\n
    • Description (if available)<\/li>\n<\/ul>\n\n\n\n

      This report enables users to analyze invoice transactions from an accounting perspective and ensures that only invoices posted within the selected accounting period are included in the report.<\/p>\n\n\n\n

      \"TenthPlanet-iDempiere-Accounting-Invoice-Transaction-Acct-2\"<\/figure>\n\n\n\n
      \"TenthPlanet-iDempiere-Accounting-Invoice-Transaction-Acct-3\"<\/figure>\n\n\n\n
      \"TenthPlanet-iDempiere-Accounting-Invoice-Transaction-Acct-4\"<\/figure>\n\n\n\n
      \"TenthPlanet-iDempiere-Accounting-Invoice-Transaction-Acct-5\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

      The Invoice Transactions (Acct) Report provides a detailed list of invoice transactions based on the Accounting Date. It displays invoice […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,78],"tags":[],"class_list":["post-21637","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-sales"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21637","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=21637"}],"version-history":[{"count":4,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21637\/revisions"}],"predecessor-version":[{"id":27001,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21637\/revisions\/27001"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=21637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=21637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=21637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}