{"id":15285,"date":"2025-07-17T06:35:56","date_gmt":"2025-07-17T06:35:56","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=15285"},"modified":"2026-09-01T04:17:53","modified_gmt":"2026-09-01T04:17:53","slug":"how-to-view-consolidated-po-report-in-adempiere-retail","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-view-consolidated-po-report-in-adempiere-retail\/","title":{"rendered":"How to view Consolidated PO Report in Adempiere Retail"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">A <strong>Consolidated PO Report<\/strong> summaries multiple Purchase Orders (PO) in a single report, helping to view total purchases, item-wise or vendor-wise data, and overall procurement trends in one place.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>User Access<\/strong><\/h2>\n\n\n\n<h3 id=\"block-2e001b9a-7bc2-4aee-a6c3-b1ae6e3f74a2\" class=\"wp-block-heading\"><strong>Who Can Access<\/strong><\/h3>\n\n\n\n<ul id=\"block-dda15f9a-edbb-4961-857e-c509cfc7226c\" class=\"wp-block-list\">\n<li>Back Office<\/li>\n\n\n\n<li>Purchase Manager<\/li>\n\n\n\n<li>Manager<\/li>\n\n\n\n<li>Admin<\/li>\n<\/ul>\n\n\n\n<h3 id=\"block-5948e64b-e342-4555-be47-87b799fdfec3\" class=\"wp-block-heading\"><strong>What User Can Do<\/strong><\/h3>\n\n\n\n<ul id=\"block-a79d34b6-618f-484f-8192-92c2a766c83a\" class=\"wp-block-list\">\n<li>To enter a From date<\/li>\n\n\n\n<li>To enter a To date<\/li>\n<\/ul>\n\n\n\n<h2 id=\"block-9a00e635-75e6-4b9c-a08e-312431f8e3ef\" class=\"wp-block-heading\"><strong>Pre-Requisite Activities<\/strong><\/h2>\n\n\n\n<ul id=\"block-ed555272-a1fc-44f6-9c81-05091184a943\" class=\"wp-block-list\">\n<li>Ensure POs are properly entered and approved<\/li>\n\n\n\n<li>Vendor and item master must be maintained<\/li>\n\n\n\n<li>PO status should be updated regular<\/li>\n<\/ul>\n\n\n\n<h2 id=\"block-ed437644-93e3-4ad6-a271-b6ee8e01f943\" class=\"wp-block-heading\"><strong>BUSINESS RULES<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Report pulls only from approved or valid POs<\/li>\n\n\n\n<li>Cancelled or deleted POs are excluded<\/li>\n\n\n\n<li>Totals must match the PO records without manual edits<\/li>\n\n\n\n<li>Filters must be applied accurately to avoid mismatches<\/li>\n\n\n\n<li>Data must be refreshed before generating the latest report<\/li>\n<\/ul>\n\n\n\n<h2 id=\"block-1bf93bd6-decc-424b-a504-d28fefe1ddd0\" class=\"wp-block-heading\"><strong>User Interface<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"block-bff275f2-b24f-49d8-84ca-c127b87e2c53\"><strong>Step 1 : <\/strong>To Select a Branch in Menu.Then to click a consolidated Po.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"637\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO.png\" alt=\"\" class=\"wp-image-28249\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO-300x187.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO-768x478.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO-400x250.png 400w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 2 :<\/strong> To enter the date value for From date and To date.Then to click a start check box.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"647\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO-1.png\" alt=\"\" class=\"wp-image-28250\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO-1.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO-1-300x190.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO-1-768x485.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 3 :<\/strong> Once to complete the process and to show the report based on the given data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1.Reference_doc no<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2.po_date<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3.Org_Code<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4.Line<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5.Vendor Name<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">6.Product_Code<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">7.Product_Name<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">8.Branch product_id<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">9.Qty<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">10.Po no<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11.Po_Line_no.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"687\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO-2-1.png\" alt=\"\" class=\"wp-image-29106\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO-2-1.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO-2-1-300x201.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO-2-1-768x515.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"711\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO-3-1.png\" alt=\"\" class=\"wp-image-29108\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO-3-1.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO-3-1-300x208.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/07\/TenthPlanet-ADempiere-Report-Consolidate-PO-3-1-768x533.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>A Consolidated PO Report summaries multiple Purchase Orders (PO) in a single report, helping to view total purchases, item-wise or [&hellip;]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32,80,90],"tags":[],"class_list":["post-15285","post","type-post","status-publish","format-standard","hentry","category-jaldi-super-store","category-adempiere-purchase","category-adempiere-reports"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/15285","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=15285"}],"version-history":[{"count":5,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/15285\/revisions"}],"predecessor-version":[{"id":29115,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/15285\/revisions\/29115"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=15285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=15285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=15285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}