{"id":112,"date":"2009-08-20T09:04:00","date_gmt":"2009-08-20T09:04:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=112"},"modified":"2025-04-23T06:38:50","modified_gmt":"2025-04-23T06:38:50","slug":"importing-serial-number-from-excelcsv-file-on-distribution-screen","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/","title":{"rendered":"Importing Serial Number from Excel\/CSV File on Distribution Screen"},"content":{"rendered":"\n<p>The client have huge volume of transaction and need to distribute\/enter serial numbers in MAS 500 system then user can used Inventory Distribution screen and defined the specific range of serial numbers for that. BUT if the serial numbers are not in range (like 11111, 12755, 17555 etc) then user has to entered each serial number separately which is time consuming task.<\/p>\n\n\n\n<p>To make this task easy and efficient for the users, Greytrix has developed the utility that will read the Serial number from the excel file, apply the business validation against each and populate the grid with the serial number. This utility will work for all type of transaction like Shipment, PO Receipts and all the inventory transaction type.<\/p>\n\n\n\n<p>The utility work as follows:<\/p>\n\n\n\n<p>We have modified the \u2018Inventory Distribution\u2019 screen and added the \u2018Import Serial No\u2019 Button. Refer the below screenshot. This button will be enabled only for the serial item.<\/p>\n\n\n\n<p><img fetchpriority=\"high\" decoding=\"async\" id=\"BLOGGER_PHOTO_ID_5371970120075638866\" title=\"\u2018Inventory Distribution\" width=\"320\" height=\"189\" border=\"0\" class=\"alignnone\" style=\"display: block; margin: 0px auto 10px; text-align: center; cursor: hand; width: 320px; height: 189px;\" src=\"https:\/\/2.bp.blogspot.com\/_A6_b0zkYeSY\/So0SXL8e-FI\/AAAAAAAAAhs\/IehFWZPTcdc\/s320\/Invt+Dist.JPG\" alt=\"\u2018Inventory Distribution\">On clicking the \u2018Import Serial No\u2019 button the new screen will be displayed. In this screen user has to select the appropriate file of that serialize item.<\/p>\n\n\n\n<p><img decoding=\"async\" id=\"BLOGGER_PHOTO_ID_5371970129392667762\" title=\"Import Serial No\" width=\"320\" height=\"180\" border=\"0\" class=\"alignnone\" style=\"display: block; margin: 0px auto 10px; text-align: center; cursor: hand; width: 320px; height: 180px;\" src=\"https:\/\/3.bp.blogspot.com\/_A6_b0zkYeSY\/So0SXup1jHI\/AAAAAAAAAh0\/bu31XrT0IEo\/s320\/Serial.JPG\" alt=\"Import Serial No\">On clicking of the \u2018Proceed\u2019 button program will update serial number information in temporary table from source file.<\/p>\n\n\n\n<p>Once all validation are cleared then serialize information will display in detail grid. User has to manually click \u201cProceed\u201d button for further processing. If user clicks the \u2018Cancel\u2019 button then distribution will not be saved.<\/p>\n\n\n\n<p><img decoding=\"async\" id=\"BLOGGER_PHOTO_ID_5371970132656517186\" title=\"Import Serial No\" width=\"320\" height=\"218\" border=\"0\" class=\"alignnone\" style=\"display: block; margin: 0px auto 10px; text-align: center; cursor: hand; width: 320px; height: 218px;\" src=\"https:\/\/2.bp.blogspot.com\/_A6_b0zkYeSY\/So0SX6z_8EI\/AAAAAAAAAh8\/CIW1mXQj1s8\/s320\/inport.JPG\" alt=\"Import Serial No\">For further details please contact us at:&nbsp;<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>.<\/p>\n\n\n\n<p><strong>About Us<\/strong><br><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>&nbsp;is a one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.<\/p>\n\n\n\n<p>Greytrix&nbsp;has some unique solutions of&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-100-erp-integration\">Sage 100 integration with Sage CRM<\/a>,&nbsp;and&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/gumu-100-salesforce-integration\">Salesforce.com<\/a>&nbsp;along with&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/sage-50-us-sage-100-migration\">Sage 100 Migration from Sage 50 US<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/intacct-apps-and-products\/gumu-sage-intacct-sage-100-migration\">Sage Intacct<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/quickbooks-sage-100-migration\">QuickBooks<\/a>, Sage Business Vision and Sage Business Works. We also offer best-in-class&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-100-erp\">Sage 100 customization and development services&nbsp;<\/a>to Sage business partners, end users, and Sage PSG worldwide.<\/p>\n\n\n\n<p>For more details on Sage 100 Services, please contact us at&nbsp;<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The client have huge volume of transaction and need to distribute\/enter serial numbers in MAS 500 system then user can used Inventory Distribution screen and defined the specific range of serial numbers for that. BUT if the serial numbers are not in range (like 11111, 12755, 17555 etc) then user has to entered each serial\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/\">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":[68,89,93],"tags":[],"class_list":["post-112","post","type-post","status-publish","format-standard","hentry","category-distribution","category-import","category-inventory-management"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Importing Serial Numbers from Excel\/CSV Files to Screen<\/title>\n<meta name=\"description\" content=\"Know more about the\u00a0tool that\u00a0supports all types of transactions, including shipments, PO receipts, and inventory transactions.\" \/>\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\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importing Serial Numbers from Excel\/CSV Files to Screen\" \/>\n<meta property=\"og:description\" content=\"Know more about the\u00a0tool that\u00a0supports all types of transactions, including shipments, PO receipts, and inventory transactions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2009-08-20T09:04:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-23T06:38:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/2.bp.blogspot.com\/_A6_b0zkYeSY\/So0SXL8e-FI\/AAAAAAAAAhs\/IehFWZPTcdc\/s320\/Invt+Dist.JPG\" \/>\n<meta name=\"author\" content=\"greysagemas\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagemas\" \/>\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\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/\",\"name\":\"Importing Serial Numbers from Excel\/CSV Files to Screen\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/2.bp.blogspot.com\/_A6_b0zkYeSY\/So0SXL8e-FI\/AAAAAAAAAhs\/IehFWZPTcdc\/s320\/Invt+Dist.JPG\",\"datePublished\":\"2009-08-20T09:04:00+00:00\",\"dateModified\":\"2025-04-23T06:38:50+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"Know more about the\u00a0tool that\u00a0supports all types of transactions, including shipments, PO receipts, and inventory transactions.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/#primaryimage\",\"url\":\"https:\/\/2.bp.blogspot.com\/_A6_b0zkYeSY\/So0SXL8e-FI\/AAAAAAAAAhs\/IehFWZPTcdc\/s320\/Invt+Dist.JPG\",\"contentUrl\":\"https:\/\/2.bp.blogspot.com\/_A6_b0zkYeSY\/So0SXL8e-FI\/AAAAAAAAAhs\/IehFWZPTcdc\/s320\/Invt+Dist.JPG\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importing Serial Number from Excel\/CSV File on Distribution Screen\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\",\"name\":\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\",\"description\":\"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\",\"name\":\"greysagemas\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/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\":\"greysagemas\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importing Serial Numbers from Excel\/CSV Files to Screen","description":"Know more about the\u00a0tool that\u00a0supports all types of transactions, including shipments, PO receipts, and inventory transactions.","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\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/","og_locale":"en_US","og_type":"article","og_title":"Importing Serial Numbers from Excel\/CSV Files to Screen","og_description":"Know more about the\u00a0tool that\u00a0supports all types of transactions, including shipments, PO receipts, and inventory transactions.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2009-08-20T09:04:00+00:00","article_modified_time":"2025-04-23T06:38:50+00:00","og_image":[{"url":"https:\/\/2.bp.blogspot.com\/_A6_b0zkYeSY\/So0SXL8e-FI\/AAAAAAAAAhs\/IehFWZPTcdc\/s320\/Invt+Dist.JPG","type":"","width":"","height":""}],"author":"greysagemas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagemas","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/","name":"Importing Serial Numbers from Excel\/CSV Files to Screen","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/#primaryimage"},"thumbnailUrl":"https:\/\/2.bp.blogspot.com\/_A6_b0zkYeSY\/So0SXL8e-FI\/AAAAAAAAAhs\/IehFWZPTcdc\/s320\/Invt+Dist.JPG","datePublished":"2009-08-20T09:04:00+00:00","dateModified":"2025-04-23T06:38:50+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"Know more about the\u00a0tool that\u00a0supports all types of transactions, including shipments, PO receipts, and inventory transactions.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/#primaryimage","url":"https:\/\/2.bp.blogspot.com\/_A6_b0zkYeSY\/So0SXL8e-FI\/AAAAAAAAAhs\/IehFWZPTcdc\/s320\/Invt+Dist.JPG","contentUrl":"https:\/\/2.bp.blogspot.com\/_A6_b0zkYeSY\/So0SXL8e-FI\/AAAAAAAAAhs\/IehFWZPTcdc\/s320\/Invt+Dist.JPG"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/20\/importing-serial-number-from-excelcsv-file-on-distribution-screen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagemas\/"},{"@type":"ListItem","position":2,"name":"Importing Serial Number from Excel\/CSV File on Distribution Screen"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/","name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","description":"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728","name":"greysagemas","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/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":"greysagemas"},"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/112","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/comments?post=112"}],"version-history":[{"count":3,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/112\/revisions"}],"predecessor-version":[{"id":6218,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/112\/revisions\/6218"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}