{"id":18690,"date":"2019-09-30T06:03:05","date_gmt":"2019-09-30T06:03:05","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=18690"},"modified":"2019-09-30T06:03:07","modified_gmt":"2019-09-30T06:03:07","slug":"how-to-increase-the-range-of-product-serial-numbers-while-creating-miscellaneous-receipt-through-import-export-template","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2019\/09\/30\/how-to-increase-the-range-of-product-serial-numbers-while-creating-miscellaneous-receipt-through-import-export-template\/","title":{"rendered":"How to increase the range of product serial numbers while creating Miscellaneous Receipt through import\/export template"},"content":{"rendered":"\n

A serial number is a\nseries of characters that have been assigned to each product in the warehouse\nso that it remains separate and are identified in the warehouse system. Using serial numbers, you can easily track the\nlocation of goods in the warehouse.<\/strong><\/p>\n\n\n\n

While trying to import file for creating miscellaneous receipt for serial managed product with quantity of 1500 or more than that, you may get two different errors.<\/p>\n\n\n\n

Error 1:<\/strong> Function not defined for the value given. <\/p>\n\n\n\n

\"\"\/
Error while importing file<\/strong>
<\/figcaption><\/figure><\/div>\n\n\n\n

Error 2:<\/strong> Line not processed <\/p>\n\n\n\n

\"\"\/
Second error while importing file<\/strong><\/figcaption><\/figure><\/div>\n\n\n\n

Solution: <\/strong><\/p>\n\n\n\n

STEP I:<\/strong> Increase the dimension of activity code.<\/p>\n\n\n\n

Navigational Path:Development ->Data and Parameters->Development Setup->Activity code.<\/strong> <\/p>\n\n\n\n

Increase the screen size to 3000 as shown in below fig.<\/p>\n\n\n\n

\"\"\/
Change the screen size of activity code<\/strong><\/figcaption><\/figure><\/div>\n\n\n\n

Follow the same process (Increasing dimension)\nfor activity code SLE and STW.<\/p>\n\n\n\n

STEP II:<\/strong> Perform Dictionary\nValidation.<\/p>\n\n\n\n

Navigational Path:<\/strong> Development->Utilities->Dictionary->Validations->Dictionary.<\/strong><\/p>\n\n\n\n

In Filters section, enter activity code ENW and\nclick on OK.<\/p>\n\n\n\n

Follow the dictionary validation for activity\ncode SLE, STW.<\/p>\n\n\n\n

STEP III: <\/strong>Import\nfile for creating Miscellaneous Receipt using SMR template.<\/p>\n\n\n\n

E;19;;AO012;20190919;;;<\/p>\n\n\n\n

L;1000;BMS001;3 Sprockets;UN;1500;UN;1500;0;0<\/p>\n\n\n\n

S;UN;1;;;;Q0201;A;SERTESTTST0001<\/p>\n\n\n\n

S;UN;1;;;;Q0201;A;SERTESTTST0002<\/p>\n\n\n\n

Etc. with 1500 serial numbers.<\/p>\n\n\n\n

Conclusion<\/strong>: Now we may know how to increase serial number more than 1000 for product while creating Miscellaneous Receipt. We may increase based on our requirement.<\/p>\n\n\n\n

About Us<\/strong><\/p>\n\n\n\n

Greytrix<\/a> – a\nglobally recognized Premier Sage Gold Development Partner is a one-stop\nsolution provider for Sage ERP and Sage CRM needs. Being recognized and\nrewarded for multi-man years of experience, we bring complete end-to-end\nassistance for your technical consultations, product customizations, data\nmigration, system integrations, third-party add-on development and\nimplementation expertise.<\/p>\n\n\n\n

Greytrix<\/a> caters\nto a wide range of Sage X3 (Sage Enterprise Management) offerings – a Sage\nBusiness Cloud Solution. Our unique\nGUMU™ integrations include Sage X3 for Sage CRM<\/a>, Salesforce.com<\/a> and Magento eCommerce<\/a> along with Implementation and Technical\nSupport worldwide for Sage X3<\/a>\n(Sage Enterprise Management). Currently we are Sage\nX3 Implementation Partner<\/a>\nin East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services<\/a>, integrated applications such as POS<\/a> | WMS<\/a> | Payment Gateway<\/a> | Shipping System<\/a> | Business Intelligence<\/a> | eCommerce<\/a> and have developed add-ons such as Catch \u2013 Weight <\/a> and Letter of Credit<\/a> for Sage X3 to Sage business partners, end users and Sage\nPSG worldwide.<\/p>\n\n\n\n

Greytrix is a\nrecognized Sage Rockstar ISV Partner<\/a> for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace<\/a>; GUMU™ integration for Sage X3 –\nSalesforce is a 5-star app listed on Salesforce AppExchange<\/a>. <\/p>\n\n\n\n

For more\ninformation on Sage X3 Integration and Services, please contact us at x3@greytrix.com<\/a>. We\nwill be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

A serial number is a series of characters that have been assigned to each product in the warehouse so that it remains separate and are identified in the warehouse system. Using serial numbers, you can easily track the location of goods in the warehouse. While trying to import file for creating miscellaneous receipt for serial\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,8,2796],"tags":[2856,2730,2857,1287,1549,2769],"class_list":["post-18690","post","type-post","status-publish","format-standard","hentry","category-configuration","category-sage-erp-x3","category-technical","tag-function-not-defined-for-given-value","tag-import-export-template","tag-line-not-processed","tag-miscellaneous-receipt","tag-products","tag-serial-number"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/18690","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=18690"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/18690\/revisions"}],"predecessor-version":[{"id":18701,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/18690\/revisions\/18701"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=18690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=18690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=18690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}