{"id":8316,"date":"2014-07-31T12:40:33","date_gmt":"2014-07-31T12:40:33","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=8316"},"modified":"2014-07-31T12:40:33","modified_gmt":"2014-07-31T12:40:33","slug":"splitting-and-combining-lots-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/","title":{"rendered":"Splitting and Combining Lots in Sage 300 ERP"},"content":{"rendered":"

Sometimes in a business scenario, Sage 300 ERP users need to work with inventory lots and split the existing lots into two or more parts, or combine two lots into one.
\nGUMU Solution :<\/strong> <\/span><\/em>Customize Sage CRM Order Screens to Promote Orders into Sage 300 ERP<\/a>
\nIn this blog we will have a look at the feature of Sage 300 ERP, which allows users to split or combine inventory lots in Sage 300 ERP.
\nYou can locate this feature in IC Module. Select I\/C Periodic Processing > Lot Splits\/Combines to display I\/C Lot Split\/Combine form.
\nSplitting Lots:<\/strong>
\nBy following simple steps mentioned below, you can split an existing lot.
\n1. Open I\/C Lot Split\/Combine form as shown in the screenshot below:
\n\"1\"<\/a>
\n2. From the Type dropdown, select the Type as \u201cSplit\u201d and
\n3. Enter item Number of the lotted inventory item.
\n4. Select the Location where the lot you want to split is stored.
\n5. You can also change the Default Transaction Date if it is required.
\n6. In the From section, enter the Lot Number of the lot you want to split, then specify the quantity you want to split.
\n7. In the \u201cTo\u201d section, select the existing lot(s) that you want to add quantities to or can also enter and create new lot numbers and provide it in the To Lot Numbers.
\n8. You can change the Stock Date of the destination lot. You can also enter an Expiry Date if required.
\n9. Click Post to split the lot .
\nExample<\/strong> : Here we take item \u201cA1-900\/G\u201d, Location as \u201c1\u201d and in the From we selected the Lot Number as \u201c00026-April\u201d and Qty.to Split as \u201c6\u201d In the To section we entered the Lot number as \u201c00028-April\u201d and Qty. Split as \u201c6\u201d. We Post the Transaction as shown in the below screenshot.
\n\"2\"<\/a>
\nDue to this transaction a new Lot is generated at location 1 with Qty Available = 6 as shown in the below screenshot:<\/p>\n

\"3\"<\/a>Combining Lots:<\/strong>
\nBy following simple steps mentioned below, you can combine existing lot in single LOT:
\n1. Select I\/C Periodic Processing > Lot Splits\/Combines to display I\/C Lot Split\/Combine form.
\n2. From the Type dropdown box, select the Type as \u201cCombine\u201d and then enter the item Number of the lotted inventory item.
\n3. Select the Location where the lots you want to combine are stored.
\n4. You can also change the Default Transaction Date if it is required.
\n5. In the \u201cTo\u201d section, enter the Lot Number of the destination lot you want to combine items into, and then enter a value in the Qty. to Combine field.
\n6. Enter the Stock Date of the lot that will have quantities added to it from the lot(s) defined in the \u201cFrom\u201d section. You can also enter the Expiry Date of the combined lot if required.
\n7. In the \u201cFrom\u201d section, select the existing lot(s) that you want to take quantities from.
\n8. Click Post to combine the lots as shown in the below screenshot
\nExample: Here we take item \u201cA1-900\/G\u201d, Location as \u201c1\u201d and in the \u201cFrom\u201d we selected the Lot Number as \u201c00027-April\u201d and Qty.to Split As \u201c15\u201d In the \u201cTo\u201d section we entered two Lot numbers as \u201c00026-April\u201d ,\u201c00024-April\u201d and Qty. Split as \u201c6\u201d and \u201c9\u201d respectively. We Post the Transaction as shown in the below screenshot.<\/p>\n

\"4\"<\/a>Due to this transaction a new Lot is generated at location 1 with Qty Available = 38 as shown in the below screenshot:<\/p>\n

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

Note:<\/strong>The total value of all quantities in the Qty. field in Split column must equal the value entered in the Qty. to Split field in the From section, otherwise the transaction cannot be posted.
\nAlso read :<\/strong>
\n1. New Unit Cost field on IC Lot Numbers Inquiry in Sage 300 ERP 2012<\/a>
\n2. Item Status Report<\/a>
\n3. Inventory Cost Analysis in Sage 300 ERP<\/a>
\n4. Item Code Change<\/a>
\n5. New Inventory Control features in Sage 300 ERP 2014<\/a>
\n <\/p>\n

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

Sometimes in a business scenario, Sage 300 ERP users need to work with inventory lots and split the existing lots into two or more parts, or combine two lots into one. GUMU Solution : Customize Sage CRM Order Screens to Promote Orders into Sage 300 ERP In this blog we will have a look at\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":[5,2],"tags":[483,1504,2357,2445,2726],"class_list":["post-8316","post","type-post","status-publish","format-standard","hentry","category-accpac-sdk","category-sage-accpac","tag-combining-lots","tag-lot-numbers","tag-sage-300-erp","tag-sage-accpac","tag-splitting-lots"],"yoast_head":"\nSplitting and Combining Lots 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\/07\/31\/splitting-and-combining-lots-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=\"Splitting and Combining Lots in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Sometimes in a business scenario, Sage 300 ERP users need to work with inventory lots and split the existing lots into two or more parts, or combine two lots into one. GUMU Solution : Customize Sage CRM Order Screens to Promote Orders into Sage 300 ERP In this blog we will have a look at\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/31\/splitting-and-combining-lots-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-07-31T12:40:33+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/17.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=\"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\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/\",\"name\":\"Splitting and Combining Lots 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\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/17.jpg\",\"datePublished\":\"2014-07-31T12:40:33+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/17.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/17.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Splitting and Combining Lots 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":"Splitting and Combining Lots 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\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Splitting and Combining Lots in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"Sometimes in a business scenario, Sage 300 ERP users need to work with inventory lots and split the existing lots into two or more parts, or combine two lots into one. GUMU Solution : Customize Sage CRM Order Screens to Promote Orders into Sage 300 ERP In this blog we will have a look at\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2014-07-31T12:40:33+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/17.jpg","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\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/","name":"Splitting and Combining Lots 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\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/17.jpg","datePublished":"2014-07-31T12:40:33+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/17.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/17.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/31\/splitting-and-combining-lots-in-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Splitting and Combining Lots 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\/8316","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=8316"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/8316\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=8316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=8316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=8316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}