{"id":8339,"date":"2014-08-04T11:54:38","date_gmt":"2014-08-04T11:54:38","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=8339"},"modified":"2014-08-04T11:54:38","modified_gmt":"2014-08-04T11:54:38","slug":"item-code-change-multiple-changes-in-single-shot","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/08\/04\/item-code-change-multiple-changes-in-single-shot\/","title":{"rendered":"Item Code Change \u2013 Multiple changes in single shot"},"content":{"rendered":"

In our previous blog \u201cItem Code Change<\/a>\u201d we had illustrated the way of changing, combining and copying single item which rather becomes a tedious task when we need to make the changes in range of items.<\/p>\n

Here, to fulfill our requirement we will make use of \u201cImport\u201d feature which is listed in File <\/strong>option shown in the menu bar of Item Code Change screen. To use this feature we have to create an excel sheet in \u201cMicrosoft Excel Comma Separated Values File (.csv)\u201d format and put in the required items into it which we need to work on with their action type.<\/p>\n

New Stuff<\/strong><\/em><\/span>:\u00a0Bulk Posting of Batches in Sage 300 ERP<\/a><\/p>\n

Let\u2019s take an example where we need to combine items \u201cA1-105\/0\u201d and \u201cA1-310\/0\u201d into \u201cA1-106\/0\u201d; and change the item \u201cA1-320\/0\u201d to \u201c*A1-345-0*\u201d.<\/p>\n

Before going ahead, navigate to Inventory Control >> I\/C stock control report and print the stock status report at summary level to check out the impact of this utility before and after the posting of required change list.<\/p>\n

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

Now, create the required sheet in correct format with following information into that:<\/p>\n

1.<\/strong> Old Item Code: This would be an existing item which you would want to manipulate.<\/p>\n

2.<\/strong> New Item Code: This would be a target item which will be affected on posting of import file.<\/p>\n

3<\/strong>. Action Type: In this, you need to enter the numeric value 0 or 1 or 2 as per the action required by you.
\n\u2022 If you will choose \u20180\u2019 then the system will replace the old Item Number with a new Item Number in your Sage 300 ERP data files and an old Item Number will be removed from your database.
\n\u2022 If you will choose \u20181\u2019 then the system will merge the history, data records and transactions of the old existing item into the new existing Item and remove the source item from the sage records.
\n\u2022 If you will choose \u20182\u2019 then the system will quickly establishes a new Item based on an existing Item. But in this case, main point which we need to focus on is that only basic info is copied from source item to target item, no Item activity or history information is copied and source item remains unchanged.<\/p>\n

4<\/strong>. Description of New Item: This would be a description of New item code.<\/p>\n

Below is the screenshot of the excel file which we need to create:<\/p>\n

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

Going further, move to Item Number Change utility and open the screen of \u201cItem Number Change Import\u201d over there to import the already created template of item code change.
\n\"4\"<\/a>
\n <\/p>\n

To import the excel file click on Import in File menu of Item Number Change<\/strong> screen, browse for excel sheet in Import File <\/strong>field present in Item Number Change Import<\/strong> screen and then click on \u201cImport\u201d at the bottom of same screen.<\/p>\n

On clicking Import, following screen will appear wherein you have to click on Done<\/strong> once all the items get accepted. This screen shows the accepted and rejected item\u2019s list with their error log if any.<\/p>\n

\"5\"<\/a>
\nNext, click on Post <\/strong>in Item Number Change <\/strong>screen.
\n\"6\"<\/a>
\n\"8\"<\/a><\/p>\n

At last, you will get the following Information screen showing that all the changed imported by you are posted successfully.\"9\"<\/a><\/p>\n

Again, to check the impact of posted changes reprint the stock summary report wherein you can notice that Opening and closing quantity & cost of items \u201cA1-105\/0\u201d and \u201cA1-310\/0\u201d is combined into \u201cA1-106\/0\u201d; and item \u201cA1-320\/0\u201d\u00a0 is replaced with item \u201c*A1-345-0*\u201d.<\/p>\n

\"11\"<\/a>
\nSo, I hope now you can use this functionality to make the necessary changes in your item master even after posting of transaction for the same. But, make sure you take the back up of your database before doing this activity.
\nAlso Read:<\/strong>
\n1.<\/strong>\u00a0Inventory Control Settings \u2013 Allow Items at All Locations<\/a>
\n2<\/strong>.\u00a0Define Items in SAGE 300 ERP without Inventory Control module<\/a>
\n3.<\/strong>\u00a0Find the A\/R items sales history<\/a>
\n4.<\/strong>\u00a0How to assign unique serial Number to Individual Items in Sage 300 ERP Versions 2014<\/a>
\n5.<\/strong>\u00a0Search and Find Item Option in Transaction UI<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In our previous blog \u201cItem Code Change\u201d we had illustrated the way of changing, combining and copying single item which rather becomes a tedious task when we need to make the changes in range of items. Here, to fulfill our requirement we will make use of \u201cImport\u201d feature which is listed in File option shown\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":[18,79,436,877,1397,1402,2311,2765],"class_list":["post-8339","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-18","tag-accpac","tag-change-list","tag-erp","tag-item-code-change","tag-item-import","tag-sage","tag-stock-summary"],"yoast_head":"\nItem Code Change \u2013 Multiple changes in single shot - 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\/08\/04\/item-code-change-multiple-changes-in-single-shot\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Item Code Change \u2013 Multiple changes in single shot - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In our previous blog \u201cItem Code Change\u201d we had illustrated the way of changing, combining and copying single item which rather becomes a tedious task when we need to make the changes in range of items. Here, to fulfill our requirement we will make use of \u201cImport\u201d feature which is listed in File option shown\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/08\/04\/item-code-change-multiple-changes-in-single-shot\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-08-04T11:54:38+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/08\/Untitled1.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=\"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\/08\/04\/item-code-change-multiple-changes-in-single-shot\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/08\/04\/item-code-change-multiple-changes-in-single-shot\/\",\"name\":\"Item Code Change \u2013 Multiple changes in single shot - 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\/08\/04\/item-code-change-multiple-changes-in-single-shot\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/08\/04\/item-code-change-multiple-changes-in-single-shot\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/08\/Untitled1.png\",\"datePublished\":\"2014-08-04T11:54:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/08\/04\/item-code-change-multiple-changes-in-single-shot\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/08\/04\/item-code-change-multiple-changes-in-single-shot\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/08\/04\/item-code-change-multiple-changes-in-single-shot\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/08\/Untitled1.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/08\/Untitled1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/08\/04\/item-code-change-multiple-changes-in-single-shot\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Item Code Change \u2013 Multiple changes in single shot\"}]},{\"@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":"Item Code Change \u2013 Multiple changes in single shot - 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\/08\/04\/item-code-change-multiple-changes-in-single-shot\/","og_locale":"en_US","og_type":"article","og_title":"Item Code Change \u2013 Multiple changes in single shot - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"In our previous blog \u201cItem Code Change\u201d we had illustrated the way of changing, combining and copying single item which rather becomes a tedious task when we need to make the changes in range of items. Here, to fulfill our requirement we will make use of \u201cImport\u201d feature which is listed in File option shown\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/08\/04\/item-code-change-multiple-changes-in-single-shot\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2014-08-04T11:54:38+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/08\/Untitled1.png","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\/08\/04\/item-code-change-multiple-changes-in-single-shot\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/08\/04\/item-code-change-multiple-changes-in-single-shot\/","name":"Item Code Change \u2013 Multiple changes in single shot - 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\/08\/04\/item-code-change-multiple-changes-in-single-shot\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/08\/04\/item-code-change-multiple-changes-in-single-shot\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/08\/Untitled1.png","datePublished":"2014-08-04T11:54:38+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/08\/04\/item-code-change-multiple-changes-in-single-shot\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/08\/04\/item-code-change-multiple-changes-in-single-shot\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/08\/04\/item-code-change-multiple-changes-in-single-shot\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/08\/Untitled1.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/08\/Untitled1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/08\/04\/item-code-change-multiple-changes-in-single-shot\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Item Code Change \u2013 Multiple changes in single shot"}]},{"@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\/8339","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=8339"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/8339\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=8339"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=8339"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=8339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}