{"id":15682,"date":"2017-04-26T10:37:26","date_gmt":"2017-04-26T10:37:26","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=15682"},"modified":"2024-03-07T13:00:36","modified_gmt":"2024-03-07T13:00:36","slug":"pending-po-grn-report","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/","title":{"rendered":"Extract Pending PO & Pending GRN Report from single screen"},"content":{"rendered":"

In our previous blog of Pending PO<\/a> & Pending GRN<\/a>, you can see there are separate UI for both the reports. Here, we have come up with a more convenient UI for user to extract both reports from a single UI.<\/p>\n

Pending PO & GRN Report helps us to keep track of all the pending POs & Receipt Entries created against particular vendors.<\/p>\n

For this report we have created utility for displaying records in which the PO and GRN is partially completed or not completed in the system.\u00a0This utility provides us both Pending PO & GRN<\/strong> print option to print in one report only. So that the user can print both the reports in a single utility. As shown in below figure:
\n\"\"<\/a>This utility will be helpful for users, as it will give them all the records that they need to capture from database for Pending Purchase & Receipt Entries.<\/p>\n

Pending PO Report:<\/strong>
\n\"\"<\/a><\/p>\n

In the above example of Pending PO Report, a user can create a purchase order entry with quantity of 6 and create a partial receipt of the same. Hence, in this report, we will get the details of the quantity ordered and the quantity received for the same item with their respective Unit Cost. It also displays Item-Wise Entries with their respective Vendors & PO Numbers.<\/p>\n

It will be helpful to the user to keep track of the newly created inventories that are purchased and received for the item.\u00a0It will also help the user to keep track of the item used in this report in which he will know the quantity that is available for the same item for a particular location.<\/p>\n

Pending GRN Report:<\/strong>
\n\"\"<\/a>In the above example, we are displaying records account set wise with their respective Vendors and Year period in which the receipts are being generated.<\/p>\n

This report provides us the pending GRN\u2019s that are partially invoiced with their source amount and functional amount that means the receipt amount and invoice amount respectively.<\/p>\n

Suppose if the user used a specific account set (EUROPE) <\/strong>in the Purchase Order entry and created a receipt entry against the same. Then the receipt, which is partially invoiced, will be displayed in the report.<\/p>\n

The main purpose to write this blog is to provide users a track of all the Pending PO & GRN Report that gives us the exact quantities used in GRN & PO Entries. This report will be helpful to keep track if the PO or GRN is completed or not in the system.<\/p>\n

About Us<\/strong><\/span>
\nGreytrix<\/a>\u00a0a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.<\/p>\n

Greytrix<\/a>\u00a0offers unique GUMU™ integrated solutions of\u00a0Sage 300 with Sage CRM,<\/a>\u00a0Salesforce.com\u00a0<\/a>and\u00a0Magento eCommerce<\/a>\u00a0along with Sage 300 Migration from\u00a0Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works<\/a>. We also offer best-in-class\u00a0Sage 300 customization and development services<\/a>\u00a0and integration service for applications such as\u00a0POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP<\/a>\u00a0and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services \u00a0to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as\u00a0GreyMatrix<\/a>,\u00a0Document Attachment<\/a>,\u00a0Document Numbering<\/a>,\u00a0Auto-Bank Reconciliation<\/a>,\u00a0Purchase Approval System<\/a>,\u00a0Three way PO matching<\/a>,\u00a0Bill of Lading<\/a>\u00a0and\u00a0VAT for Middle East<\/a>.<\/p>\n

For more details on Sage 300 and 300c Services, please contact us at\u00a0accpac@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

In our previous blog of Pending PO & Pending GRN, you can see there are separate UI for both the reports. Here, we have come up with a more convenient UI for user to extract both reports from a single UI. Pending PO & GRN Report helps us to keep track of all the pending\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[1297,1298,1906,1909,1910,2030],"class_list":["post-15682","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-incomplete-po","tag-incomplete-receipt","tag-pending-grn","tag-pending-po","tag-pending-receipt","tag-printing-incomplete-po-grn-in-a-single-ui"],"yoast_head":"\nTake a single screen and extract the pending PO and pending GRN report.<\/title>\n<meta name=\"description\" content=\"Recognize a user-friendly interface that allows the user to retrieve both reports from a single interface.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Take a single screen and extract the pending PO and pending GRN report.\" \/>\n<meta property=\"og:description\" content=\"Recognize a user-friendly interface that allows the user to retrieve both reports from a single interface.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2017-04-26T10:37:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-07T13:00:36+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/04\/IMG-1.png\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/\",\"name\":\"Take a single screen and extract the pending PO and pending GRN report.\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/04\/IMG-1.png\",\"datePublished\":\"2017-04-26T10:37:26+00:00\",\"dateModified\":\"2024-03-07T13:00:36+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"description\":\"Recognize a user-friendly interface that allows the user to retrieve both reports from a single interface.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/04\/IMG-1.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/04\/IMG-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Extract Pending PO & Pending GRN Report from single screen\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Take a single screen and extract the pending PO and pending GRN report.","description":"Recognize a user-friendly interface that allows the user to retrieve both reports from a single interface.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/","og_locale":"en_US","og_type":"article","og_title":"Take a single screen and extract the pending PO and pending GRN report.","og_description":"Recognize a user-friendly interface that allows the user to retrieve both reports from a single interface.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2017-04-26T10:37:26+00:00","article_modified_time":"2024-03-07T13:00:36+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/04\/IMG-1.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/","name":"Take a single screen and extract the pending PO and pending GRN report.","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/04\/IMG-1.png","datePublished":"2017-04-26T10:37:26+00:00","dateModified":"2024-03-07T13:00:36+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"description":"Recognize a user-friendly interface that allows the user to retrieve both reports from a single interface.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/04\/IMG-1.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/04\/IMG-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/04\/26\/pending-po-grn-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Extract Pending PO & Pending GRN Report from single screen"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/15682","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=15682"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/15682\/revisions"}],"predecessor-version":[{"id":25389,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/15682\/revisions\/25389"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=15682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=15682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=15682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}