{"id":18158,"date":"2026-01-30T12:30:58","date_gmt":"2026-01-30T12:30:58","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=18158"},"modified":"2026-07-07T07:38:10","modified_gmt":"2026-07-07T07:38:10","slug":"how-transaction-detail-report-works-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-transaction-detail-report-works-in-idempiere\/","title":{"rendered":"How Transaction Detail Report Works in iDempiere"},"content":{"rendered":"\n

The Transaction Detail Report in iDempiere provides a complete, line-by-line history of all material transactions associated with a product.<\/p>\n\n\n\n

The Transaction Detail Report focuses on the individual movements<\/em> that produced those balances. It captures every receipt, shipment, production issue, inventory adjustment, or internal movement, displaying them chronologically along with the associated product, locator, movement type, lot\/serial information, and the document that generated the transaction.<\/p>\n\n\n\n

How the Transaction Detail Report Works<\/strong><\/h2>\n\n\n\n

When a user opens the transaction detail report, they can filter results by movement type, date range, product category, product, locator, lot, lot number, or serial number. Each material movement in iDempiere creates a transaction entry, and the report displays these entries exactly as stored.<\/p>\n\n\n\n

Each row represents a single movement of a single product in a specific locator, for a specific quantity, tied to a specific document and line. Because the system records every increase and decrease in stock, the report becomes a complete audit trail that can be followed from the earliest record to the most recent.<\/p>\n\n\n\n

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

Every transaction line shown in the report includes<\/strong><\/h2>\n\n\n\n
    \n
  • The product<\/strong> and its descriptive information such as category, classification, and description.<\/li>\n\n\n\n
  • The attribute set<\/strong>, lot<\/strong>, serial number<\/strong>, and attribute instance<\/strong>, allowing full traceability for batch-tracked or serialized products.<\/li>\n\n\n\n
  • The locator<\/strong> where the stock was moved from or into.<\/li>\n\n\n\n
  • The movement date<\/strong>, which determines when the transaction affects stock and costing.<\/li>\n\n\n\n
  • The movement type<\/strong>, such as customer shipment, material receipt, production, internal use inventory, movement, or physical inventory.<\/li>\n\n\n\n
  • The quantity moved<\/strong>, shown as positive for receipts and negative for issues or shipments.<\/li>\n\n\n\n
  • The document reference<\/strong>, linking back to the transaction source, such as:\n
      \n
    • Material Receipt<\/li>\n\n\n\n
    • Customer Shipment<\/li>\n\n\n\n
    • Inventory Count<\/li>\n\n\n\n
    • Production Order<\/li>\n\n\n\n
    • Movement Document<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      How Quantities Are Interpreted<\/strong><\/h2>\n\n\n\n

      The quantity (Qty) column uses a simple rule:<\/p>\n\n\n\n

        \n
      • Positive quantities<\/strong> indicate increases in stock<\/li>\n\n\n\n
      • Negative quantities<\/strong> indicate decreases in stock<\/li>\n<\/ul>\n\n\n\n

        By reading the report line by line, users can reconstruct the stock history exactly as the system recorded it.<\/p>\n\n\n\n

        How the Report Connects to Other Modules<\/strong><\/h2>\n\n\n\n

        Every movement listed in the report originates from one of iDempiere\u2019s operational processes:<\/p>\n\n\n\n

          \n
        • Purchasing<\/strong> \u2192 Material Receipts<\/li>\n\n\n\n
        • Sales<\/strong> \u2192 Customer Shipments<\/li>\n\n\n\n
        • Warehouse operations<\/strong> \u2192 Inventory Moves, Physical Inventories<\/li>\n\n\n\n
        • Manufacturing<\/strong> \u2192 Production Issues and Receipts<\/li>\n\n\n\n
        • Internal consumption<\/strong> \u2192 Internal Use Inventory<\/li>\n<\/ul>\n\n\n\n

          Because the report links each line back to its originating document, it becomes a bridge between inventory, costing, sales, purchasing, and production.<\/p>\n","protected":false},"excerpt":{"rendered":"

          The Transaction Detail Report in iDempiere provides a complete, line-by-line history of all material transactions associated with a product. The […]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[37],"tags":[],"class_list":["post-18158","post","type-post","status-publish","format-standard","hentry","category-inventory"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18158","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\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=18158"}],"version-history":[{"count":1,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18158\/revisions"}],"predecessor-version":[{"id":19755,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18158\/revisions\/19755"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=18158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=18158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=18158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}