{"id":1040,"date":"2012-06-13T10:57:50","date_gmt":"2012-06-13T10:57:50","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=1040"},"modified":"2025-06-17T05:03:16","modified_gmt":"2025-06-17T05:03:16","slug":"sort-items-by-picking-sequence-in-order-entry-screen","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/","title":{"rendered":"Sort Items by Picking Sequence In Order Entry Screen"},"content":{"rendered":"

We recently read a requirement on the Sage Accpac forum<\/a> about this topic so thought to share about what we have done so if anyone needs something similar they do not need to create one from scratch.
\nPicking Sequence is normally used to specify bin\\aisle number or logical ordering of the items for printing the picking slips.
\nIn Item master screen user can specify the default picking sequence.
\n\"\"<\/a>
\nBut after picking sequences are setup for individual items; it doesn\u2019t assist order entry clerk to sort the entered details by their picking sequence. If the sorting is done; then shipper will exactly know the order of individual items prior to posting the shipment or printing the picking slips.
\nIn order to ease the above situation; we have enhanced the Order Entry screen by providing the custom button at the bottom of the screen named \u201cSort Details\u201d.
\n\"\"<\/a>
\nSay if the items are entered in above mentioned sequence i.e;<\/p>\n\n\n\n\n\n\n\n
Item Number <\/strong><\/td>\n<\/tr>\n
10<\/td>\n<\/tr>\n
100<\/td>\n<\/tr>\n
1000<\/td>\n<\/tr>\n
1001<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

If we sort the details by their picking sequence then they should be sorted in chronological order. i.e.;<\/p>\n\n\n\n\n\n\n\n
Item Number <\/strong><\/td>\nPicking Sequence<\/strong><\/td>\n<\/tr>\n
1000<\/td>\n1<\/td>\n<\/tr>\n
100<\/td>\n2<\/td>\n<\/tr>\n
10<\/td>\n3<\/td>\n<\/tr>\n
1001<\/td>\n4<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Using the \u201cSort Details\u201d button the details can be sorted.
\n\"\"<\/a>
\nThe same feature can also be provided on Shipment Entry screen.
\nIf you are looking for similar customization then please get in touch with us at accpac@greytrix.com.<\/p>\n","protected":false},"excerpt":{"rendered":"

We recently read a requirement on the Sage Accpac forum about this topic so thought to share about what we have done so if anyone needs something similar they do not need to create one from scratch. Picking Sequence is normally used to specify bin\\aisle number or logical ordering of the items for printing the\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":[1925,2629],"class_list":["post-1040","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-picking","tag-sequence"],"yoast_head":"\nSort Items by Picking Sequence In Order Entry Screen<\/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\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sort Items by Picking Sequence In Order Entry Screen\" \/>\n<meta property=\"og:description\" content=\"We recently read a requirement on the Sage Accpac forum about this topic so thought to share about what we have done so if anyone needs something similar they do not need to create one from scratch. Picking Sequence is normally used to specify binaisle number or logical ordering of the items for printing the\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-13T10:57:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-17T05:03:16+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/imgItems.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\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/\",\"name\":\"Sort Items by Picking Sequence In Order Entry Screen\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/imgItems.jpg\",\"datePublished\":\"2012-06-13T10:57:50+00:00\",\"dateModified\":\"2025-06-17T05:03:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/imgItems.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/imgItems.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sort Items by Picking Sequence In Order Entry Screen\"}]},{\"@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":"Sort Items by Picking Sequence In Order Entry Screen","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\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/","og_locale":"en_US","og_type":"article","og_title":"Sort Items by Picking Sequence In Order Entry Screen","og_description":"We recently read a requirement on the Sage Accpac forum about this topic so thought to share about what we have done so if anyone needs something similar they do not need to create one from scratch. Picking Sequence is normally used to specify binaisle number or logical ordering of the items for printing the\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2012-06-13T10:57:50+00:00","article_modified_time":"2025-06-17T05:03:16+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/imgItems.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\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/","name":"Sort Items by Picking Sequence In Order Entry Screen","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/imgItems.jpg","datePublished":"2012-06-13T10:57:50+00:00","dateModified":"2025-06-17T05:03:16+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/imgItems.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/imgItems.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/13\/sort-items-by-picking-sequence-in-order-entry-screen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Sort Items by Picking Sequence In Order Entry Screen"}]},{"@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\/1040","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=1040"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/1040\/revisions"}],"predecessor-version":[{"id":35425,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/1040\/revisions\/35425"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=1040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=1040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=1040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}