{"id":21665,"date":"2026-08-04T12:03:53","date_gmt":"2026-08-04T12:03:53","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=21665"},"modified":"2026-09-04T10:43:55","modified_gmt":"2026-09-04T10:43:55","slug":"how-does-monthly-invoice-product-report-works-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-does-monthly-invoice-product-report-works-in-idempiere\/","title":{"rendered":"How Does Monthly Invoice Product Report Works in iDempiere"},"content":{"rendered":"\n

The Monthly Invoice Product Report<\/strong> focuses directly on individual items rather than their broader categories.
The report summarizes invoice information by Organization, Product Category, Invoice Month, and Sales Transaction.<\/p>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Retrieves invoice information from the Invoice Line view.<\/li>\n\n\n\n
  • Groups invoice data by invoice month.<\/li>\n\n\n\n
  • Groups records by Organization and Product.<\/li>\n\n\n\n
  • Displays Sales or Purchase transactions based on the Sales Transaction option.<\/li>\n\n\n\n
  • Calculates total Invoiced Quantity.<\/li>\n\n\n\n
  • Calculates Net Amount, List Amount, Limit Amount, Discount Amount, Discount Percentage and Over Limit Percentage.<\/li>\n<\/ul>\n\n\n\n

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

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

    The Monthly Invoice Product Report parameter window allows users to filter invoice records before generating the report.<\/p>\n\n\n\n

    Monthly Invoice Product Report \u2013 Parameter Window<\/strong><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n
    Parameter<\/strong><\/td>Purpose<\/strong><\/td>Filtering Behavior<\/strong><\/td>
    <\/td><\/tr><\/thead>
    From Date<\/td>Choose Invoice From Date<\/td>Filters invoices from the selected date.<\/td>01\/01\/2026<\/td><\/tr>
    To Date<\/td>Choose Invoice From Date<\/td>Filters invoices from the selected date.<\/td>07\/20\/2026<\/td><\/tr>
    Sales Transaction<\/td>Selects Sales or Purchase Invoice.<\/td>Checked shows Sales Invoice unchecked shows Purchase Invoice.<\/td>Checked<\/td><\/tr>
    Product<\/td>Choose Product<\/td>Displays invoices for the selected Product.<\/td>Coca Cola 500ml<\/td><\/tr>
    Run as Job<\/td>Run the report in the background<\/td>Runs the report as a background job.<\/td>Checked<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    The report is executed using the selected parameter values to retrieve matching monthly invoice records by product category.<\/p>\n\n\n\n

    Report Output<\/strong><\/h2>\n\n\n\n
      \n
    • Displays monthly invoice summary by product.<\/li>\n\n\n\n
    • Shows Product, Invoice Month and Organization.<\/li>\n\n\n\n
    • Displays Invoiced Quantity.<\/li>\n\n\n\n
    • Displays invoice amounts, discounts and over limit values.<\/li>\n<\/ul>\n\n\n\n
      \"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

      The Monthly Invoice Product Report focuses directly on individual items rather than their broader categories.The report summarizes invoice information by […]<\/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-21665","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\/21665","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=21665"}],"version-history":[{"count":9,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21665\/revisions"}],"predecessor-version":[{"id":29527,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21665\/revisions\/29527"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=21665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=21665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=21665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}