Prerequisites
- The raw material must be set up as an Item in CGIC.
- Ensure the item has Has Batch enabled
1.0 Enable Expiry Date Tracking for an Item
- Navigate to the Item List (
Stock > Items > Item). - Select the raw material item.
- Under the Inventory section:
- Ensure Has Batch is checked.
- Check Has Expiry Date to enable expiry tracking.
- Save the item.
1.1 Assign Expiry Dates to Batches
A. During Batch Creation
- Go to the Batch list (
Stock > Batch). - Click New.
- Fill in:
- Batch ID: Unique identifier (e.g.,
BATCH-RAW-2024). - Item: Select the raw material item.
- Expiry Date: Set the expiration date (mandatory).
- Batch ID: Unique identifier (e.g.,
- Save.
B. During Stock Receipt (Purchase Receipt)
- Create a Purchase Receipt (
Stock > Purchase Receipt > New). - Add the raw material item and batch:
- If Automatically Create New Batch is enabled, the system will prompt you to enter the Expiry Date for the new batch.
- Submit the receipt.
2.0 Monitor Expiry Dates
A. Batch List View
- Go to Batch list (
Stock > Batch). - Use filters or the Expiry Date column to identify batches nearing expiration.
B. Expiry Report
- Run the Stock Ageing Report (
Stock > Reports > Stock Ageing). - Filter by Item and Batch to view expiry dates and remaining shelf life.
3.0 Set Up Expiry Alerts
- Navigate to Stock Settings (
Settings > Stock Settings). - Under Expiry Alerts:
- Enable Notify Before Expiry.
- Set Alert Days (e.g., 30 days before expiry).
- Assign Users/Roles to receive notifications.
4.0 Handle Expired Batches
- Block Usage: Expired batches are automatically excluded from being selected in Stock Entry or Production transactions.
- Write Off: Create a Stock Entry with purpose Material Transfer to move expired batches to a scrap warehouse.