{"id":7797,"date":"2014-06-09T08:49:37","date_gmt":"2014-06-09T08:49:37","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=7797"},"modified":"2014-06-09T08:49:37","modified_gmt":"2014-06-09T08:49:37","slug":"inventory-movement-report-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/","title":{"rendered":"Inventory Movement Report in Sage 300 ERP"},"content":{"rendered":"<p style=\"text-align: justify\">In Sage 300 ERP there are many useful inbuilt inventory reports. Let us see today \u201cInventory Movement\u201d report which helps you to manage your inventory efficiently.<\/p>\n<p style=\"text-align: justify\">This report provides a complete movement of the stock including the quantities and extended costs of inventory items that were received in stock and shipped out of stock during the period that is specified.<\/p>\n<p style=\"text-align: justify\"><em><span style=\"color: #993300\"><strong>Greytrix Blog:<\/strong>\u00a0<\/span><\/em><span style=\"color: #993300\"><span style=\"color: #0000ff\"><a title=\"Greytrix Sage CRM Blog\" href=\"http:\/\/bit.ly\/1ocR5V6\" target=\"_blank\" rel=\"noopener\"><span style=\"color: #0000ff\">With Sage CRM you have \u201cBetter Control Over your Customers and your Systems too\u201d<\/span><\/a><\/span><\/span><\/p>\n<p style=\"text-align: justify\">The report displays the stock activity showing each transaction in and out of stock for the period. Users can group items in all locations together or display items in each location separately.<\/p>\n<p style=\"text-align: justify\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/Image.png\" target=\"_blank\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter  wp-image-7798\" alt=\"Image\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/Image.png\" width=\"329\" height=\"287\" \/><\/a><\/p>\n<p style=\"text-align: justify\">Please find below the UI screenshot of the \u201cInventory Movement\u201d report of Sage 300 ERP (Accpac).<\/p>\n<p style=\"text-align: justify\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/Image1.png\" target=\"_blank\"><img decoding=\"async\" class=\"aligncenter  wp-image-7799\" alt=\"Image\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/Image1.png\" width=\"343\" height=\"311\" \/><\/a><\/p>\n<p style=\"text-align: justify\">By viewing UI of the report you can see there are various parameters available, based upon which you can view the report as per your desired requirement.<\/p>\n<p style=\"text-align: justify\">Steps to print the report:<\/p>\n<ul style=\"text-align: justify\">\n<li>Select \u201cTransactions By\u201d. There are two methods for selecting a cutoff date.\n<ul>\n<li>Document Date: Use this method if you want to specify transactions for a specific range of dates.<\/li>\n<li>Year\/Period: Use this method if you want to include all transactions up to the end of a fiscal period. Make your selections in the Year and Period fields.<\/li>\n<\/ul>\n<\/li>\n<li>Print Separate or Consolidated Locations. If you select Separate Locations, the report prints each location on a new page. If you select Consolidated Locations, the report prints a single total for each item for all locations (within the range you specify).<\/li>\n<li>Select Report Currency. In a multicurrency ledger, choose whether you want to see the amount in source or functional currency.<\/li>\n<li>Select From\/To. Indicate the ranges of account sets, locations, and item numbers that you want to include in the report. You can also select a range of values for the field that you use to sort the report.<\/li>\n<li>Select Sort By: You can choose to sort the report by item category, item segment, or by optional field value. You can also choose a range of values for the sort field.<\/li>\n<li>Once done with all click on Print and view the output of the report.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Below is the screen print of the output for Inventory Movement in Sage 300 ERP.<\/p>\n<p style=\"text-align: justify\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/Image2.png\" target=\"_blank\"><img decoding=\"async\" class=\"aligncenter  wp-image-7800\" alt=\"Image\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/Image2.png\" width=\"465\" height=\"335\" \/><\/a><\/p>\n<p style=\"text-align: justify\"><b>Information printed on this report<\/b><\/p>\n<ul style=\"text-align: justify\">\n<li>Reports transactions for a particular period of time, specified using transaction dates or fiscal periods.<\/li>\n<li>Opening and closing balances, as well as inventory-in and inventory out item totals in functional currency.<\/li>\n<li>For each transaction, prints the document number, source ledger (e.g. Order Entry, Purchase Orders, Project and Job Costing), inventory location, unit of measure, inventory-in or inventory-out quantity and cost.<\/li>\n<li>Subtotals by the sorting order field (category, item segment, or optional field).<\/li>\n<li>Report for separate locations, consolidated locations, or items by location.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Through this report you can keep a track on entire inventory, you will also have an update of warehouse wise status. If you know the stock status then accordingly you can process your sales orders and purchase orders. This will lead to prevent the wastage of stock.<\/p>\n<p><span style=\"color: #800000\"><strong>Also Read:<\/strong><\/span><br \/>\n<strong>1.<\/strong>\u00a0<a title=\"Inventory Control Settings \u2013 Allow Items at All Locations\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/06\/inventory-control-settings-allow-items-at-all-locations\/\" target=\"_blank\">Inventory Control Settings \u2013 Allow Items at All Locations<\/a><br \/>\n<strong>2.<\/strong>\u00a0<a title=\"New Inventory Control features in Sage 300 ERP 2014\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/03\/new-features-of-inventory-control-in-sage-300-erp-2014\/\" target=\"_blank\">New Inventory Control features in Sage 300 ERP 2014<\/a><br \/>\n<strong>3.\u00a0<\/strong><a title=\"Inventory Cost Analysis in Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/04\/23\/inventory-cost-analysis-in-sage-300-erp\/\" target=\"_blank\">Inventory Cost Analysis in Sage 300 ERP<\/a><br \/>\n<strong>4.<\/strong>\u00a0<a title=\"I\/C Physical Inventory Reconciliation Process\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/\" target=\"_blank\">I\/C Physical Inventory Reconciliation Process<\/a><br \/>\n<strong>5.<\/strong>\u00a0<a title=\"Adjustment Entry in Inventory Control\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/31\/adjustment-entry-in-inventory-control\/\" target=\"_blank\">Adjustment Entry in Inventory Control<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Sage 300 ERP there are many useful inbuilt inventory reports. Let us see today \u201cInventory Movement\u201d report which helps you to manage your inventory efficiently. This report provides a complete movement of the stock including the quantities and extended costs of inventory items that were received in stock and shipped out of stock during\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/\">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":[171,1345,2360,2764],"class_list":["post-7797","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-and-item-status-in-sage-300-erp","tag-inventory-costing-sage-accpac","tag-sage-300-erp-inventory-movement","tag-stock-status-report"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Inventory Movement Report in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components<\/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\/2014\/06\/09\/inventory-movement-report-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=\"Inventory Movement Report in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In Sage 300 ERP there are many useful inbuilt inventory reports. Let us see today \u201cInventory Movement\u201d report which helps you to manage your inventory efficiently. This report provides a complete movement of the stock including the quantities and extended costs of inventory items that were received in stock and shipped out of stock during\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-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=\"2014-06-09T08:49:37+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/Image.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\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/\",\"name\":\"Inventory Movement Report in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/Image.png\",\"datePublished\":\"2014-06-09T08:49:37+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/Image.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/Image.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Inventory Movement Report 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":"Inventory Movement Report in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","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\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Inventory Movement Report in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"In Sage 300 ERP there are many useful inbuilt inventory reports. Let us see today \u201cInventory Movement\u201d report which helps you to manage your inventory efficiently. This report provides a complete movement of the stock including the quantities and extended costs of inventory items that were received in stock and shipped out of stock during\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2014-06-09T08:49:37+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/Image.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\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/","name":"Inventory Movement Report in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/Image.png","datePublished":"2014-06-09T08:49:37+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/Image.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/Image.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/09\/inventory-movement-report-in-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Inventory Movement Report 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\/7797","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=7797"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/7797\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=7797"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=7797"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=7797"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}