{"id":3344,"date":"2013-06-13T06:32:25","date_gmt":"2013-06-13T06:32:25","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=3344"},"modified":"2025-07-23T06:06:50","modified_gmt":"2025-07-23T06:06:50","slug":"generate-reports-for-slow-moving-items-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/","title":{"rendered":"Generate Reports for Slow Moving Items in Sage 300 ERP"},"content":{"rendered":"

In Sage 300 ERP (formerly Sage Accpac ERP), you have an option to generate report for Slow Moving Items i.e. items which are not selling well in organization so that you can focus on items which need more attention from the point of sales and marketing.
\nTo run this report in sage 300 ERP, navigate to Inventory Control >> I\/C Stock Control Reports >> Slow Moving items<\/p>\n

\"\"<\/a><\/p>\n

Here, you can sort report in many ways like Item Number, Category, Item Segment, Price and many others including optional fields of item master that you have defined for the items.
\nThen, depending on the criterion that you have selected in \u2018Sort By\u2019, you have to define the range in \u2018From\u2019 and \u2018To\u2019 options to list out the items in output report otherwise by default Sage 300 ERP will generate the report for whole range.
\nAlso Read:<\/strong><\/span>\u00a0Shipping Labels in Sage 300 ERP<\/a><\/em>
\nFurther, you can put some more constraints on items to get slow moving item\u2019s report in exact format which user desires and that are :-<\/p>\n

a. No Sales for More than<\/strong> – \u00a0It defines the number of days for which no shipment of slow moving items were posted in Inventory Control or Order Entry of Sage 300 ERP.<\/p>\n

b. Year-To-Date (YTD) Turnover Less than<\/strong> \u2013 It includes items, which have YTD turnover less than the number of times entered by the user.<\/span><\/p>\n

And, YTD turnover of particular item can be calculated as:<\/p>\n

\"\"<\/a><\/p>\n

c. Period-To-Date (PTD) Turnover Less than<\/strong> – It includes items, which have PTD turnover less than the number of times entered by the user.<\/p>\n

And, PTD turnover of particular item can be calculated as:<\/p>\n

\"\"<\/a><\/p>\n

d. PTD Units Sold Less than YTD Average by More than<\/strong> \u2013 Include items with fewer sales in the current period than the year-to-date average, by the percent you specify. Where,<\/p>\n

\"\"<\/a><\/p>\n

e. YTD Units Sold Less than Last Year’s Average by More than<\/strong> – It Include items with lower average sales in the current year than the last year’s average amount, by the percent you specify<\/p>\n

\"\"<\/a><\/p>\n

f. Average Days between Shipments Greater than \u2013<\/strong> It includes items for which no quantity has been shipped for the average number of days defined by the user.<\/p>\n

Before Printing Report for Slow Moving Item\u2019s Report, you should check beforehand that the \u2018Keep Item statistics option\u2019 is checked in Inventory Control >> I\/C setups >> Options, to generate report for inventory.<\/p>\n

\"\"<\/a><\/p>\n

Hence, after selecting appropriate options, we would get output in following format.<\/p>\n

\"\"<\/a><\/p>\n

You can export this report in excel format by navigating to the export option which is present in the top left most corner of the output report.<\/p>\n

Then, select OK to export the file.<\/p>\n

\"\"<\/a><\/p>\n

Hence, report of Slow Moving Items helps organization to keep track of all goods\/items which needs attention i.e. by analyzing this report you can decide whether you want to have this inventory from the next time or not; or it needs some marketing to be done<\/p>\n","protected":false},"excerpt":{"rendered":"

In Sage 300 ERP (formerly Sage Accpac ERP), you have an option to generate report for Slow Moving Items i.e. items which are not selling well in organization so that you can focus on items which need more attention from the point of sales and marketing. To run this report in sage 300 ERP, navigate\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":[1341,1920,2357,2451,2672,2700,3084],"class_list":["post-3344","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-inventory-control","tag-period-to-date-sales","tag-sage-300-erp","tag-sage-accpac-erp","tag-shipment","tag-slow-moving-items","tag-year-to-date-sales"],"yoast_head":"\nGenerate Reports for Slow Moving Items in Sage 300 ERP<\/title>\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\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Generate Reports for Slow Moving Items in Sage 300 ERP\" \/>\n<meta property=\"og:description\" content=\"In Sage 300 ERP (formerly Sage Accpac ERP), you have an option to generate report for Slow Moving Items i.e. items which are not selling well in organization so that you can focus on items which need more attention from the point of sales and marketing. To run this report in sage 300 ERP, navigate\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-06-13T06:32:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-23T06:06:50+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/06\/1.-IC-Slow-Moving-Items-Report.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\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/\",\"name\":\"Generate Reports for Slow Moving Items in Sage 300 ERP\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/06\/1.-IC-Slow-Moving-Items-Report.png\",\"datePublished\":\"2013-06-13T06:32:25+00:00\",\"dateModified\":\"2025-07-23T06:06:50+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/06\/1.-IC-Slow-Moving-Items-Report.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/06\/1.-IC-Slow-Moving-Items-Report.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Generate Reports for Slow Moving Items in Sage 300 ERP\"}]},{\"@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":"Generate Reports for Slow Moving Items in Sage 300 ERP","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\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Generate Reports for Slow Moving Items in Sage 300 ERP","og_description":"In Sage 300 ERP (formerly Sage Accpac ERP), you have an option to generate report for Slow Moving Items i.e. items which are not selling well in organization so that you can focus on items which need more attention from the point of sales and marketing. To run this report in sage 300 ERP, navigate\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-06-13T06:32:25+00:00","article_modified_time":"2025-07-23T06:06:50+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/06\/1.-IC-Slow-Moving-Items-Report.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\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/","name":"Generate Reports for Slow Moving Items in Sage 300 ERP","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/06\/1.-IC-Slow-Moving-Items-Report.png","datePublished":"2013-06-13T06:32:25+00:00","dateModified":"2025-07-23T06:06:50+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/06\/1.-IC-Slow-Moving-Items-Report.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/06\/1.-IC-Slow-Moving-Items-Report.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/generate-reports-for-slow-moving-items-in-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Generate Reports for Slow Moving Items in Sage 300 ERP"}]},{"@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\/3344","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=3344"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3344\/revisions"}],"predecessor-version":[{"id":32029,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3344\/revisions\/32029"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=3344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=3344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=3344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}