How to increase the range of product serial numbers while creating Miscellaneous Receipt through import/export template

By | September 30, 2019

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 managed product with quantity of 1500 or more than that, you may get two different errors.

Error 1: Function not defined for the value given.

Error while importing file

Error 2: Line not processed

Second error while importing file

Solution:

STEP I: Increase the dimension of activity code.

Navigational Path:Development ->Data and Parameters->Development Setup->Activity code.

Increase the screen size to 3000 as shown in below fig.

Change the screen size of activity code

Follow the same process (Increasing dimension) for activity code SLE and STW.

STEP II: Perform Dictionary Validation.

Navigational Path: Development->Utilities->Dictionary->Validations->Dictionary.

In Filters section, enter activity code ENW and click on OK.

Follow the dictionary validation for activity code SLE, STW.

STEP III: Import file for creating Miscellaneous Receipt using SMR template.

E;19;;AO012;20190919;;;

L;1000;BMS001;3 Sprockets;UN;1500;UN;1500;0;0

S;UN;1;;;;Q0201;A;SERTESTTST0001

S;UN;1;;;;Q0201;A;SERTESTTST0002

Etc. with 1500 serial numbers.

Conclusion: 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.

About Us

Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.

Greytrix caters to a wide range of Sage X3 (Sage Enterprise Management) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3 (Sage Enterprise Management). Currently we are Sage X3 Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit for Sage X3 to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com. We will be glad to assist you.