How to adjust the Serial-Lot quantity variance in Inventory Control in Sage 300 ERP

By | February 23, 2015

In our previous blog on Serial/Lot Stock report, we discussed finding out the variance between actual serial/Lot inventory and the quantity on hand present in the inventory.

New Stuff: Optional Fields in Sage 300 ERP

In the industries where they strictly use the serial and lot inventory management, if they find a difference between actual quantities on hand in the warehouse and serial and lot number present in the ERP system, then they will have to adjust the serial and lot variance without affecting the actual inventory quantity on hand. In this blog post, we will see how to do just that.

Before adjusting the variance, you first need to find out the variance in serial and lot quantity with Inventory Control–>IC Stock Control Report–>Serial and Lot Qty. on Hand
LOt1lot2In above report for the Serialized item number A1-103/R, actual quantity on hand is 6 and the total number of serial numbers in the system is 2. This means that 4 serial numbers must be added to the system to match the actual quantity on hand and serial number in the system.

In order to adjust the serial number you need to go to Inventory Control–> I/C Periodic Processing–>Serial Lot Reconciliation
lot3In this screen, if there is a serial/Lot item with positive variance, then you need to select the Receipt as a transaction type so as to add the serial/Lot number in the system to match the Quantity on hand. Also if there is a serial/Lot with negative variance, then in order to remove the serial/Lot number from the system, you need to select the transaction type as Shipment.

In above example, as there is a positive variance for below serial item at Location 1, we need to add that number of serial numbers in the system.

Item Number Serial Number Quantity on hand Variance
A1-103/R 2 6 4
A1-105/R 3 8 5

Refer below screenshot
lot4Now when you count actual inventory and the Serial number in the system, the numbers will match.
lot5About 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 offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrix, Document Attachment, Document Numbering, Auto-Bank Reconciliation, Purchase Approval System, Three way PO matching, Bill of Lading and VAT for Middle East.

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