{"id":13131,"date":"2025-02-28T04:52:55","date_gmt":"2025-02-28T04:52:55","guid":{"rendered":"https:\/\/jaldi.store\/?p=11911"},"modified":"2026-08-06T05:48:41","modified_gmt":"2026-08-06T05:48:41","slug":"how-to-view-item-wise-purchase-report-in-adempiere-retail","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-view-item-wise-purchase-report-in-adempiere-retail\/","title":{"rendered":"How to view Item Wise Purchase Report in Adempiere Retail"},"content":{"rendered":"\n

A report that shows how many units of each product were bought, when they were bought, and the total cost spent on each product<\/strong> during a specific time period.<\/p>\n\n\n\n

User Access<\/strong><\/h2>\n\n\n\n

Who Can Access<\/strong><\/h3>\n\n\n\n
    \n
  • Admin<\/li>\n\n\n\n
  • Back Office<\/li>\n\n\n\n
  • Purchase Manager<\/li>\n\n\n\n
  • Manager<\/li>\n<\/ul>\n\n\n\n

    What User Can Do<\/strong><\/h2>\n\n\n\n
      \n
    • Track Purchases<\/li>\n\n\n\n
    • Manage Inventory<\/li>\n\n\n\n
    • Control Costs<\/li>\n\n\n\n
    • Generate Records<\/li>\n<\/ul>\n\n\n\n

      Pre-Requisite Activities<\/strong><\/h2>\n\n\n\n
        \n
      • Maintain Accurate Purchase Records<\/li>\n\n\n\n
      • Date Range Definition<\/li>\n\n\n\n
      • Data Synchronization<\/li>\n\n\n\n
      • User Access<\/li>\n<\/ul>\n\n\n\n

        Business Rules<\/strong><\/h2>\n\n\n\n
          \n
        • Unique Item Identification<\/li>\n\n\n\n
        • Complete Purchase Data<\/li>\n\n\n\n
        • Data Integrity<\/li>\n\n\n\n
        • User Authorization<\/li>\n<\/ul>\n\n\n\n

          User Interface<\/strong><\/h2>\n\n\n\n

          STEP 1:<\/strong> Click Purchase Reports Folder.<\/p>\n\n\n\n

          \"TenthPlanet-ADempiere-Item-Wise-Purchase-Report\"<\/figure>\n\n\n\n

          STEP 2:<\/strong> Click Item Wise Purchase Report.<\/p>\n\n\n\n

          \"TenthPlanet-ADempiere-Item-Wise-Purchase-Repor1\"<\/figure>\n\n\n\n

          STEP 3: <\/strong>Choose Parameter From Date, To Date and Click Start Button.<\/p>\n\n\n\n

          \"TenthPlanet-ADempiere-Item-Wise-Purchase-Repor-3\"<\/figure>\n\n\n\n

          STEP 4:<\/strong> Show Columns Details.
          1.Product Code
          2.Product Name
          3.Purchase Quantity.
          4.Land cost Total.
          5.MRP<\/p>\n\n\n\n

          \"TenthPlanet-ADempiere-Item-Wise-Purchase-Repor-3\"<\/figure>\n\n\n\n

          STEP 5:<\/strong> Click Page Down Button Show Columns Details.<\/p>\n\n\n\n

          6.Brand
          7.Department
          8.Category
          9.Sub Category<\/p>\n\n\n\n

          \"TenthPlanet-ADempiere-Item-Wise-Purchase-Repor-5\"<\/figure>\n\n\n\n

          STEP 6:<\/strong> Click Page Down Button Show Columns Details.
          10.Purchase Tax%.
          11.HSN Code.<\/p>\n\n\n\n

          \"TenthPlanet-ADempiere-Item-Wise-Purchase-Repor-6\"<\/figure>\n\n\n\n

          1.Product Code
          2.Product Name<\/strong>
          3.Purchase Quantity.<\/strong>
          The purchase order quantity (PO quantity) refers to the amount of a product or material specified in a purchase order (PO) that a buyer requests from a supplier. It represents the number of units of goods or services that the buyer intends to acquire.

          4.Land cost Total.<\/strong>
          Landed cost refers to the total cost of getting a product to its final destination, and it includes several components beyond the initial purchase price. It accounts for everything involved in bringing goods from the supplier to your location. Here\u2019s how to calculate the landed cost total:

          5.MRP<\/strong>
          MRP stands for Material Requirements Planning<\/strong>, which is a production planning and inventory control system used to manage manufacturing processes. It helps companies determine the quantity and timing of raw materials, components, and sub-assemblies needed to produce finished goods.<\/p>\n\n\n\n

          6.Brand<\/strong>
          The Product Brand Name.

          7.Department<\/strong>
          The Product Department Name

          8.Category<\/strong>
          Product Category Name.

          9.Sub Category<\/strong>
          Product Sub Category Name

          10.Purchase Tax%.<\/strong>
          The “purchase tax%” generally refers to the percentage of tax applied to the purchase of goods or services. This percentage varies depending on the country, region, and sometimes the type of goods or services involved.

          11.HSN Code.<\/strong>
          The HSN code<\/strong> (Harmonized System of Nomenclature) is an internationally recognized system used for classifying traded products. It was developed by the World Customs Organization (WCO) and is used by countries around the world for customs purposes, including trade tariffs and taxes.<\/p>\n\n\n\n


          <\/p>\n","protected":false},"excerpt":{"rendered":"

          A report that shows how many units of each product were bought, when they were bought, and the total cost […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[],"class_list":["post-13131","post","type-post","status-publish","format-standard","hentry","category-jaldi-super-store"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/13131","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=13131"}],"version-history":[{"count":5,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/13131\/revisions"}],"predecessor-version":[{"id":23084,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/13131\/revisions\/23084"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=13131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=13131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=13131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}