Importing Serial Number from Excel/CSV File on Distribution Screen

By | August 20, 2009

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.

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.

The utility work as follows:

We have modified the ‘Inventory Distribution’ screen and added the ‘Import Serial No’ Button. Refer the below screenshot. This button will be enabled only for the serial item.

On clicking the ‘Import Serial No’ button the new screen will be displayed. In this screen user has to select the appropriate file of that serialize item.

On clicking of the ‘Proceed’ button program will update serial number information in temporary table from source file.

Once all validation are cleared then serialize information will display in detail grid. User has to manually click “Proceed” button for further processing. If user clicks the ‘Cancel’ button then distribution will not be saved.

For further details please contact us at:

About Us
Greytrix 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.

Greytrix has some unique solutions of Sage 100 integration with Sage CRM, and along with Sage 100 Migration from Sage 50 USSage IntacctQuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 100 customization and development services to Sage business partners, end users, and Sage PSG worldwide.

For more details on Sage 100 Services, please contact us at We will be glad to assist you.