{"id":5,"date":"2014-07-03T14:03:00","date_gmt":"2014-07-03T14:03:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=5"},"modified":"2024-05-23T07:03:10","modified_gmt":"2024-05-23T07:03:10","slug":"sage-100-open-sales-order-report-by-item","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/","title":{"rendered":"Sage 100 Open sales order report &#8211; by Item"},"content":{"rendered":"<p>The Open Orders by Item Report lists open sales orders by item code to facilitate the tracking of the outstanding orders for each item. This report can be used in conjunction with Inventory Management reports to determine what products should be ordered and the quantities necessary to meet customer commitments.<\/p>\n<p><strong>New Stuff:<\/strong>\u00a0<a href=\"http:\/\/sagemas.blogspot.com\/2014\/06\/sage-100-open-sales-order-report.html\">Sage 100 Open Sales Order Report<\/a><\/p>\n<p>Open Order by Item Report is a report that is sorted automatically by product line and item code. You can include miscellaneous items, special items, and sales kit lines. You can enter a selection of item codes, product lines, and warehouses to print.<\/p>\n<p><strong>Working of the Report<\/strong><\/p>\n<p>To get started with the working of Open Sales Order Report, user should navigate through Reports under the Sales Order Module.<\/p>\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2014\/07\/1-1.jpg\" target=\"_blank\" rel=\"noreferrer noopener\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" title=\"Open Orders by Item Report\" src=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2014\/07\/1-1.jpg\" alt=\"Open Orders by Item Report\" width=\"613\" height=\"344\" \/><\/a><\/center>\n<p>The report also provides an option to make a template of the report and save it for reuse, it can also be printed in summary or detailed format. The detailed version includes the item code; product line number; sales order number; order type; order date; promise date; customer number and name; the item unit of measure; the ship-from warehouse code; the extended order amount; and the quantities ordered, shipped, and back-ordered. Quantity and sales totals are provided by item and by product line. The summary version summarizes totals by item and by product line, with no sales order detail.<\/p>\n<p>Back-ordered quantities on standard sales order types are printed only if the Back-ordered Lines on Back Order Reports check box is selected in Sales Order Options. The sales order lot and serial distribution can be printed on the report if the enable Lot\/Serial Distribution check box is selected in Sales Order Options, and the line items have been distributed in Sales Order Entry.<\/p>\n<p>If the Customer Relationship Management module is set up, selecting to print price quotes allows you to print both customer quotes and prospect quotes. For prospect quotes, the Sage CRM company ID and name are printed in place of the customer number and name. You can also print the Sage CRM user, company, opportunity, and person information on orders and quotes if the fields are added to the form in the Crystal Reports software.<\/p>\n\n\n<p><a rel=\"noreferrer noopener\" href=\"https:\/\/www.greytrix.com\/\" target=\"_blank\">Greytrix<\/a>&nbsp;&#8211; a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.<\/p>\n\n\n\n<p>The unique <a href=\"https:\/\/www.greytrix.com\/gumu\/connectors\/\">GUMU&#x2122;<\/a> integration solutions provided by Greytrix for Sage 100 include <a href=\"https:\/\/www.greytrix.com\/gumu\/sage-crm-sage-100-integration\/\">Sage 100 integration with Sage CRM<\/a>,\u00a0and\u00a0<a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/sage-100-integration\/\">Salesforce.com<\/a>,\u00a0<a href=\"https:\/\/www.greytrix.com\/dynamics-365-crm-sage-100-integration\/\">Dynamics 365 CRM<\/a>, the migration solutions include <a href=\"https:\/\/www.greytrix.com\/sage-100-erp\/#Migration\">Sage 100 Migration from Sage 50 US<\/a>,\u00a0<a href=\"https:\/\/www.greytrix.com\/gumu\/sage-intacct-integration\/\">Sage Intacct<\/a>,\u00a0QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class\u00a0<a href=\"https:\/\/www.greytrix.com\/sage-100-erp\/\">Sage 100 customization and development services\u00a0<\/a>to Sage business partners, end users, and Sage PSG worldwide. Sage 100 product listings by Greytrix include <a href=\"https:\/\/www.greytrix.com\/microsoft-dynamics-365-crm\/\">Salesforce \u2013 Sage ERP integration<\/a> available on <a href=\"https:\/\/appexchange.salesforce.com\/appxListingDetail?listingId=a0N30000000psM5EAI\">Salesforce Appexchange<\/a>, <a href=\"https:\/\/www.greytrix.com\/product\/gumu\/dynamics-365-crm-sage-erp-integration\">Dynamics 365 CRM \u2013 Sage ERP integration<\/a> available on <a href=\"https:\/\/appsource.microsoft.com\/en-us\/product\/dynamics-365\/greytrix.gumu_sage_erp_100_300_x3_intacct_integration?tab=Overview\">Microsoft Appsource (Free Trial)<\/a>.<\/p>\n\n\n\n<p>The GUMU&#x2122; Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button. <\/p>\n\n\n\n<p>For more details on Sage 100 Services, please contact us at&nbsp;<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will like to hear from you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Open Orders by Item Report lists open sales orders by item code to facilitate the tracking of the outstanding orders for each item. This report can be used in conjunction with Inventory Management reports to determine what products should be ordered and the quantities necessary to meet customer commitments. New Stuff:\u00a0Sage 100 Open Sales\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":151,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[105,175,191],"tags":[513,380,390,440],"class_list":["post-5","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-item-report","category-sage-100","category-sales-order","tag-open-sales-order-report","tag-sage-100","tag-sage-100-integration","tag-sales-order"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Open sales order report for Sage 100 - item per item<\/title>\n<meta name=\"description\" content=\"Understand how to incorporate sales kit lines, unique goods, and other items.\" \/>\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\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Open sales order report for Sage 100 - item per item\" \/>\n<meta property=\"og:description\" content=\"Understand how to incorporate sales kit lines, unique goods, and other items.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-03T14:03:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-23T07:03:10+00:00\" \/>\n<meta name=\"author\" content=\"greysagemas\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagemas\" \/>\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\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/\",\"name\":\"Open sales order report for Sage 100 - item per item\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/#primaryimage\"},\"thumbnailUrl\":\"\",\"datePublished\":\"2014-07-03T14:03:00+00:00\",\"dateModified\":\"2024-05-23T07:03:10+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"Understand how to incorporate sales kit lines, unique goods, and other items.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sage 100 Open sales order report &#8211; by Item\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\",\"name\":\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\",\"description\":\"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\",\"name\":\"greysagemas\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/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\":\"greysagemas\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Open sales order report for Sage 100 - item per item","description":"Understand how to incorporate sales kit lines, unique goods, and other items.","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\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/","og_locale":"en_US","og_type":"article","og_title":"Open sales order report for Sage 100 - item per item","og_description":"Understand how to incorporate sales kit lines, unique goods, and other items.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2014-07-03T14:03:00+00:00","article_modified_time":"2024-05-23T07:03:10+00:00","author":"greysagemas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagemas","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/","name":"Open sales order report for Sage 100 - item per item","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/#primaryimage"},"thumbnailUrl":"","datePublished":"2014-07-03T14:03:00+00:00","dateModified":"2024-05-23T07:03:10+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"Understand how to incorporate sales kit lines, unique goods, and other items.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/03\/sage-100-open-sales-order-report-by-item\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagemas\/"},{"@type":"ListItem","position":2,"name":"Sage 100 Open sales order report &#8211; by Item"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/","name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","description":"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728","name":"greysagemas","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/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":"greysagemas"},"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/5","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/comments?post=5"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/5\/revisions"}],"predecessor-version":[{"id":5150,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/5\/revisions\/5150"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=5"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=5"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=5"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}