{"id":16090,"date":"2017-07-07T10:49:35","date_gmt":"2017-07-07T10:49:35","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=16090"},"modified":"2024-12-02T06:39:44","modified_gmt":"2024-12-02T06:39:44","slug":"material-reservationmo-report","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/","title":{"rendered":"Material Reservation\/MO Report"},"content":{"rendered":"<p>Enterprise Resource Planning is an important enterprise application that integrates all the individual department functions into a single software application.<br \/>\nERP makes it easier to track all the information and transactions that are done from multiple modules so that the user is able to view all detail in Provided MO screen.<br \/>\nHowever, sometimes a user may require all item related information from multiple Module on a single screen. For this type of requirement, we have developed a utility called MO Report that displays the data like item number, Open PO Quantity, Transferred Quantity according to filter criteria applied by the user.<br \/>\nNew Stuff:\u00a0<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/\" target=\"_blank\" rel=\"noopener noreferrer\">Automation on PO Quantity<\/a><br \/>\nThis report has been developed for one of our client with a required filter criteria (filter criteria may change as per your requirement)<br \/>\nFilter:-<br \/>\n\u2022 from and to Item number<br \/>\n\u2022 from and to Location (we will consider Location finder for on hand Quantity only)<br \/>\nSuppose a user selects from and to item from finder with location from and to once user clicked on processing button then below field display with respective values:<\/p>\n<ul>\n<li>Item number:- this will be component number field from MO Scree<\/li>\n<li>On Hand Qty:- item on hand Quantity as per selection of Location<\/li>\n<li>Reservation:- Required Qty field from MO order Material tab<\/li>\n<li>Open Po:- sum of Open Po Qty<\/li>\n<li>Available to Use:- calculated as On Hand &#8211; Reservation &#8211; Transferred Qty<\/li>\n<li>Transferred Qty :- Transferred Qty field<\/li>\n<\/ul>\n<p>Refer below screen<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/07\/MO11.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-16095\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/07\/MO11.png\" alt=\"\" width=\"597\" height=\"308\" \/><\/a><br \/>\nAs per the above screen all item related Information like item No, On hand Quantity, Reservation Quantity, transferred Quantity etc. user can able to Read all the data from single provided Mo screen.<br \/>\nIf you observe carefully, we are displaying total sum of quantity in each column that have multiple transactions for respective item. To know the summary of total number of transactions for particular item, you just need to click on total quantity column &amp; you will get one pop-up window which will show you total number of transactions exists for respective item.<br \/>\nPlease Refer below screen for more clarification:-<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/07\/MO22-1.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-16098\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/07\/MO22-1.png\" alt=\"\" width=\"598\" height=\"358\" \/><\/a><br \/>\nNOTE: &#8211; We have provided this functionality (Pop-up) on Reservation, Open PO, Transferred fields.<br \/>\nWith the help of this utility, user can keep record from multiple modules using single Utility.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Enterprise Resource Planning is an important enterprise application that integrates all the individual department functions into a single software application. ERP makes it easier to track all the information and transactions that are done from multiple modules so that the user is able to view all detail in Provided MO screen. However, sometimes a user\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/\">Read More &raquo;<\/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":[1423,1487,1575,1657,1959,2896],"class_list":["post-16090","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-item-wise","tag-location-wise","tag-material-reservation","tag-mo-report","tag-po-quantity","tag-transferred-quantity"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Material Reservation\/MO Report<\/title>\n<meta name=\"description\" content=\"MO Report displays the data like item number, Open PO Quantity, Transferred Quantity according to filter criteria applied by the user.\" \/>\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\/07\/07\/material-reservationmo-report\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Material Reservation\/MO Report\" \/>\n<meta property=\"og:description\" content=\"MO Report displays the data like item number, Open PO Quantity, Transferred Quantity according to filter criteria applied by the user.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2017-07-07T10:49:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-02T06:39:44+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/07\/MO11.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=\"3 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\/07\/07\/material-reservationmo-report\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/\",\"name\":\"Material Reservation\/MO Report\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/07\/MO11.png\",\"datePublished\":\"2017-07-07T10:49:35+00:00\",\"dateModified\":\"2024-12-02T06:39:44+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"description\":\"MO Report displays the data like item number, Open PO Quantity, Transferred Quantity according to filter criteria applied by the user.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/07\/MO11.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/07\/MO11.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Material Reservation\/MO Report\"}]},{\"@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":"Material Reservation\/MO Report","description":"MO Report displays the data like item number, Open PO Quantity, Transferred Quantity according to filter criteria applied by the user.","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\/07\/07\/material-reservationmo-report\/","og_locale":"en_US","og_type":"article","og_title":"Material Reservation\/MO Report","og_description":"MO Report displays the data like item number, Open PO Quantity, Transferred Quantity according to filter criteria applied by the user.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2017-07-07T10:49:35+00:00","article_modified_time":"2024-12-02T06:39:44+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/07\/MO11.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/","name":"Material Reservation\/MO Report","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/07\/MO11.png","datePublished":"2017-07-07T10:49:35+00:00","dateModified":"2024-12-02T06:39:44+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"description":"MO Report displays the data like item number, Open PO Quantity, Transferred Quantity according to filter criteria applied by the user.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/07\/MO11.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/07\/MO11.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/07\/07\/material-reservationmo-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Material Reservation\/MO Report"}]},{"@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\/16090","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=16090"}],"version-history":[{"count":3,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/16090\/revisions"}],"predecessor-version":[{"id":35375,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/16090\/revisions\/35375"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=16090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=16090"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=16090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}