{"id":9599,"date":"2014-12-30T05:50:59","date_gmt":"2014-12-30T05:50:59","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=9599"},"modified":"2014-12-30T05:50:59","modified_gmt":"2014-12-30T05:50:59","slug":"stock-aging-report-in-sage-300","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/30\/stock-aging-report-in-sage-300\/","title":{"rendered":"Stock Aging Report in Sage 300"},"content":{"rendered":"

Sage 300 ERP Inventory Module has reports which show movement of inventory items, net change of item quantity on aging basic etc. But there is no inbuilt utility through which companies could ascertain the Inventory in terms of Quantity of the Item in particular period in Warehouse.
\nWe have developed an Add-On which caters this functionality in following manner.
\nWe have provided an Interface that accepts filter criteria and intervals from user.
\nFilter Criteria includes:
\n\u2022 From and To Location
\n\u2022 Age as of Date
\n\u2022 Aging Bucket
\n\"Stock<\/a>
\nFive different date intervals are calculated based on interval length and ending date .Aging period is editable which means you can choose the aging period range while printing reports.
\nBased on the data entered by the user information gets fetched from the database and printed on to the report.
\n\"Report<\/a>
\nThis report considers all transactions by which item quantities in Inventory get affected and display total item quantity for a particular period.
\n0-30 Days:<\/strong> It will display Total quantity of transaction done against the Item in inventory from age of day to 30 days back.
\n30-60 Days:\u00a0<\/strong>It will display Total quantity of transaction done against the Item in inventory for 30-60 days back from age of day
\n0-90 Days:<\/strong> It will display Total quantity of transaction done against the Item in inventory for 60-90 days back from age of day.
\n90 Days and above:<\/strong> It will display Total quantity of transaction done against the Item in inventory for more than 90 days back from age of day.
\nTotal Quantity:<\/strong> It will display Total quantity of transaction done against the Item in inventory on as on date.
\nYou can use this custom I\/C Stock Aging Report to view and print aging of the stockfrom Sage 300 ERP (Accpac) Inventory Control Module.
\nNew Stuff:<\/strong>\u00a0Error while posting GL Batch<\/a>
\nAlso Read:<\/strong><\/em>
\n1. \u00a0Deposit Slips<\/a>
\n2. \u00a0Setting up Salesperson Commission in Sage 300 ERP<\/a>
\n3. \u00a0Shipments to be Invoiced Report<\/a>
\n4. \u00a0Creating payment batches in Sage 300 ERP<\/a>
\n5. \u00a0Report not printing when printer option is set to printer in sage 300 ERP<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Sage 300 ERP Inventory Module has reports which show movement of inventory items, net change of item quantity on aging basic etc. But there is no inbuilt utility through which companies could ascertain the Inventory in terms of Quantity of the Item in particular period in Warehouse. We have developed an Add-On which caters this\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[147,271,1359,2753],"class_list":["post-9599","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-aging","tag-as-on-date-quantity","tag-inventory-reports","tag-stock-aging-report"],"yoast_head":"\nStock Aging Report in Sage 300 - 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\/12\/30\/stock-aging-report-in-sage-300\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Stock Aging Report in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Sage 300 ERP Inventory Module has reports which show movement of inventory items, net change of item quantity on aging basic etc. But there is no inbuilt utility through which companies could ascertain the Inventory in terms of Quantity of the Item in particular period in Warehouse. We have developed an Add-On which caters this\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/30\/stock-aging-report-in-sage-300\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-12-30T05:50:59+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/12\/Stock-Aging-UI.jpg\" \/>\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=\"2 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\/12\/30\/stock-aging-report-in-sage-300\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/30\/stock-aging-report-in-sage-300\/\",\"name\":\"Stock Aging Report in Sage 300 - 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\/12\/30\/stock-aging-report-in-sage-300\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/30\/stock-aging-report-in-sage-300\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/12\/Stock-Aging-UI.jpg\",\"datePublished\":\"2014-12-30T05:50:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/30\/stock-aging-report-in-sage-300\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/30\/stock-aging-report-in-sage-300\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/30\/stock-aging-report-in-sage-300\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/12\/Stock-Aging-UI.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/12\/Stock-Aging-UI.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/30\/stock-aging-report-in-sage-300\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Stock Aging Report in Sage 300\"}]},{\"@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":"Stock Aging Report in Sage 300 - 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\/12\/30\/stock-aging-report-in-sage-300\/","og_locale":"en_US","og_type":"article","og_title":"Stock Aging Report in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"Sage 300 ERP Inventory Module has reports which show movement of inventory items, net change of item quantity on aging basic etc. But there is no inbuilt utility through which companies could ascertain the Inventory in terms of Quantity of the Item in particular period in Warehouse. We have developed an Add-On which caters this\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/30\/stock-aging-report-in-sage-300\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2014-12-30T05:50:59+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/12\/Stock-Aging-UI.jpg","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/30\/stock-aging-report-in-sage-300\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/30\/stock-aging-report-in-sage-300\/","name":"Stock Aging Report in Sage 300 - 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\/12\/30\/stock-aging-report-in-sage-300\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/30\/stock-aging-report-in-sage-300\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/12\/Stock-Aging-UI.jpg","datePublished":"2014-12-30T05:50:59+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/30\/stock-aging-report-in-sage-300\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/30\/stock-aging-report-in-sage-300\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/30\/stock-aging-report-in-sage-300\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/12\/Stock-Aging-UI.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/12\/Stock-Aging-UI.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/30\/stock-aging-report-in-sage-300\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Stock Aging Report in Sage 300"}]},{"@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\/9599","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=9599"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/9599\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=9599"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=9599"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=9599"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}