{"id":9380,"date":"2014-11-29T11:32:07","date_gmt":"2014-11-29T11:32:07","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=9380"},"modified":"2014-11-29T11:32:07","modified_gmt":"2014-11-29T11:32:07","slug":"seriallot-number-stock-report","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/29\/seriallot-number-stock-report\/","title":{"rendered":"Serial\/Lot Number Stock Report"},"content":{"rendered":"

The Serial\/Lot Number Quantity on Hand report is accessible in Sage 300 ERP, if you have a license of Serialized Inventory and Lot Tracking. This report is useful in stock reconciliation. The output of the report is helpful in reconciling serial\/lot quantities with physical inventory quantities. Here you can find out the summary and detailed report of an item.<\/p>\n

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

New Stuff:<\/em><\/strong>\u00a0Configure Decimals in selling Price<\/a><\/p>\n

Have a look on the below snapshot of UI of the report in Sage 300 ERP.<\/p>\n

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

The Filter criteria in the report are:<\/p>\n

Print:<\/strong> Use this field to print the report for lot numbers or serial numbers.<\/p>\n

Report Type:<\/strong> Summary reports show the serial\/lot numbers assigned to items, the quantities on hand, and any differences. Detailed reports provide also provide the individual serial\/lot numbers for the quantity on hand.<\/p>\n

Location:<\/strong> Specify range of location to include on the report.<\/p>\n

Item Number:<\/strong> Specify range of item to include on the report.<\/p>\n

Sort By:<\/strong> Specify whether to sort the information on the report by item number or location.<\/p>\n

Show Only Items With IC Quantity Variance:<\/strong> After selecting this it will only include the items if physical quantities does not match with the assigned serial and lot number quantities.<\/p>\n

For your reference, go through with the output snapshots of Sage 300 ERP.<\/p>\n

In below snapshot you can see the summary report which is item wise with the count of Lot Quantity.<\/p>\n

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

Where, in below snapshot you can see the detailed report which is item wise and lot wise quantity.<\/p>\n

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

Inventory management is an important discipline for all stock-based businesses. For those in the business of manufacturing, distributing and retailing perishable items, however, it\u2019s an imperative. That\u2019s because perishable items are tagged with batch codes in addition to serial numbers, allowing companies who deal with these kinds of stock to track items that have exceeded their sell-by or best-by dates. This prevents customers from buying them or, in the event of a problem with a product, for all items from that batch to be easily located and disposed of. Once an inventory item has been assigned a lot tracking number, all its movements within the system must use the same lot number – a lot number is required when an item is manufactured or purchased, when it is moved between warehouses, when it is sold and when the product is returned.<\/p>\n

Also Read:<\/em><\/strong><\/span>
\n1.\u00a0Sales History Inquiry in Sage 300 ERP<\/a>
\n2.\u00a0Tax Tracking Report in Sage 300 ERP<\/a>
\n3.\u00a0Kitting Item in Sage 300 ERP<\/a>
\n4.\u00a0Pending Shipments Inquiry in Sage 300 ERP<\/a>
\n5. \u00a0Inventory Movement Report in Sage 300 ERP<\/a><\/p>\n

\n","protected":false},"excerpt":{"rendered":"

The Serial\/Lot Number Quantity on Hand report is accessible in Sage 300 ERP, if you have a license of Serialized Inventory and Lot Tracking. This report is useful in stock reconciliation. The output of the report is helpful in reconciling serial\/lot quantities with physical inventory quantities. Here you can find out the summary and detailed\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":[358,1506,2635,2641],"class_list":["post-9380","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-batch-management-sage-accpac","tag-lot-tracking-sage-300-erp","tag-serial-no-sage-300-erp","tag-serialized-inventory-in-erp"],"yoast_head":"\nSerial\/Lot Number Stock Report - 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\/11\/29\/seriallot-number-stock-report\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Serial\/Lot Number Stock Report - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"The Serial\/Lot Number Quantity on Hand report is accessible in Sage 300 ERP, if you have a license of Serialized Inventory and Lot Tracking. This report is useful in stock reconciliation. The output of the report is helpful in reconciling serial\/lot quantities with physical inventory quantities. Here you can find out the summary and detailed\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/29\/seriallot-number-stock-report\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-11-29T11:32:07+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/11\/popup15.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=\"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\/11\/29\/seriallot-number-stock-report\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/29\/seriallot-number-stock-report\/\",\"name\":\"Serial\/Lot Number Stock Report - 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\/11\/29\/seriallot-number-stock-report\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/29\/seriallot-number-stock-report\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/11\/popup15.png\",\"datePublished\":\"2014-11-29T11:32:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/29\/seriallot-number-stock-report\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/29\/seriallot-number-stock-report\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/29\/seriallot-number-stock-report\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/11\/popup15.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/11\/popup15.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/29\/seriallot-number-stock-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Serial\/Lot Number Stock 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":"Serial\/Lot Number Stock Report - 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\/11\/29\/seriallot-number-stock-report\/","og_locale":"en_US","og_type":"article","og_title":"Serial\/Lot Number Stock Report - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"The Serial\/Lot Number Quantity on Hand report is accessible in Sage 300 ERP, if you have a license of Serialized Inventory and Lot Tracking. This report is useful in stock reconciliation. The output of the report is helpful in reconciling serial\/lot quantities with physical inventory quantities. Here you can find out the summary and detailed\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/29\/seriallot-number-stock-report\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2014-11-29T11:32:07+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/11\/popup15.png","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\/11\/29\/seriallot-number-stock-report\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/29\/seriallot-number-stock-report\/","name":"Serial\/Lot Number Stock Report - 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\/11\/29\/seriallot-number-stock-report\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/29\/seriallot-number-stock-report\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/11\/popup15.png","datePublished":"2014-11-29T11:32:07+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/29\/seriallot-number-stock-report\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/29\/seriallot-number-stock-report\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/29\/seriallot-number-stock-report\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/11\/popup15.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/11\/popup15.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/11\/29\/seriallot-number-stock-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Serial\/Lot Number Stock 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\/9380","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=9380"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/9380\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=9380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=9380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=9380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}