Automatic Distribution of line item during Shipment

By | February 5, 2009

We have developed a customization for one of our clients to automate the distribution (assignment) of serial numbers during shipment process without bring any user interface and on just a click of a button.

Their business problem was they dealt with Serialized inventory with huge transaction quantities, so while doing shipments in MAS 500 the shipper had to distribute (assign) the serial number or lot number manually. So when there are too many lines and large number of quantity the task used to become very tiring and time-consuming resulting into lower productivity.

As a solution to this we did the customization where we added a button labeled “Auto Distribute” that would automatically distribute (assign) the serial numbers and lot numbers to items on shipment, where the process would fetches the serial number according to the first in first out basis.

Below screenshot shows the Custom Button.

On ‘Edit Shipment’ screen we have added the ‘Auto Distribute’ Button. Clicking on this button the process will automatically distributes (Assigned) the serial number or lot number according to first in first out basis. User can view the distribution of particular line item by clicking on the standard ‘Dist…’ button on the screen.

Below is a screenshot showing the line distribution.

For more details, you can contact Greytrix 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 US, Sage Intacct, QuickBooks, 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.