IC Serial/Lot Stock Listing report to know the detailed information of Lot Inventory

By | August 24, 2023

Inventory management is a critical skill for all stock-based enterprises. It is, however, a need for individuals in the manufacture, distribution, and retailing of perishable commodities. The perishable commodities are marked with batch codes in addition to serial numbers, allowing businesses who deal with this type of stock to track things that have passed their sell-by or best-by dates. This stops customers from purchasing them and allows all goods from that batch to be quickly traced and disposed of if there is an issue with a product. Once an inventory item has been issued a lot tracking number, all of its movements within the system must utilize the same lot number – a lot number is required when an item is created or acquired, when it is sold, and when it is returned.

Sage 300 ERP provides us with various reports to track down the Lot and Serial Inventory. One such report is the IC Serial/Lot Stock Listing report. This report provides us with the details of lot wise quantity sold or the serial numbers sold which helps to track the quantity of the Lot/Serial inventory. Also the report has the provision to filter the lot/serial number based on the sold stock, reserved stock or the expired stock. In this blog we will see the report details for Lot Inventory.

New Stuff: – Trading Order Overview

Below is the screenshot of UI of the IC Serial/Lot Stock Listing report in Sage 300 ERP.

IC Serial/Lot Stock Listing Report
Fig1: IC Serial/Lot Stock Listing Report

Following are the filter criteria’s available to print the report:

Print: Use this field to print the report for lot numbers.

Report Type: This field provides the option to filter the report for Sold Stock, Reserved Stock or Expired Stock.

The Sold stock report provides details for the lots/serial numbers used in the transactions and their quantity.

The Reserved stock report provides details for the lots/serial numbers that are kept in the reserved category.

The Expired stock report provides details for the lot/serial numbers that have expired and cannot be used further in any transactions.

Date: Depending upon the report type selected the date filter changes for Sold Date, Reserved Date or Expired Date and the report can be extracted by selecting the particular date criteria

Location: Specify range of location to include on the report.

Item Number: Specify the range of item numbers to be included in the report.

Lot Number: Specify the range of lot numbers to be included in the report.

Sort By: Specify whether to sort the information on the report by item number or location.

In the below screenshot you can see the Stock Sold report which gives count of Lot Quantity sold.

Screenshot for Sold Stock
Fig2: Screenshot for Sold Stock

Below is the screenshot for the reserved lots for a particular item

Screenshot for Reserved Stock
Fig3: Screenshot for Reserved Stock

Below is the screenshot for the expired lots for a particular item and the document number in which the lot was generated.

Screenshot for Expired Stock
Fig4: Screenshot for Expired Stock

Thus with the help of this report lot and serial numbers for a particular item can be easily tracked.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged 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 competence.

Greytrix offers unique GUMU™ integrated solutions of  Sage 300 with Sage CRM, Salesforce.com (listed on Salesforce Appexchange), Dynamics 365 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 services for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and for Sage 300c development services we offer, upgrades of older codes and screens to new web screens, latest integrations using sData and web services  to Sage business partners, end users and Sage PSG worldwide.

Greytrix offers 20+ addons for Sage 300 to enhance productivity such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East. The GUMU™ integration for Dynamics 365 CRM – Sage ERP is listed on Microsoft Appsource with easy implementation package.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

For more details on Sage 300 and Sage 300c Services, please contact us at accpac@greytrix.com, We will like to hear from you.