Inventory Overview
Live raw material and supplier snapshot
Materials
—
Stock Value
—
Low Stock
—
Suppliers
—
Supplier Outstanding
—
Materials
Paper, ink, plates, film, packing and other raw materials
Purchases
PO / invoice entry with multiple materials and automatic stock receipt
Integrated flow: Purchase → Material Master → Stock In → Rate History → Supplier Outstanding. One entry updates all linked records.
Stock In / Out
Receive, return and record wastage without manually changing balances
Receive / Stock In
Increase inventory
Material Return
Return from a job
Wastage
Record material loss
Rule: current stock is controlled through transactions. Avoid manually editing Current_Stock in Google Sheets.
Job Material Issue
Issue material against an ICPL Production Job ID
Production database is not modified by this screen. Job ID is recorded as the inventory reference.
Suppliers / Vendors
Supplier contacts, GST, payment terms and outstanding
Supplier Payments
Record supplier payments and reduce outstanding
Material Rate History
Compare previous purchase rates supplier-wise
Low Stock Alerts
Materials at or below minimum stock level
Stock Ledger
Ledger data is maintained automatically in INV_Stock_Ledger
Reports & MIS
Supplier-wise, material-wise, category-wise and date-wise management analysis
Purchase Value—
Stock In—
Stock Out / Consumption—
Supplier Outstanding—
Supplier-wise Summary
Material-wise Summary
Filtered Stock Movement
Activity Log
Who changed what and when — permanent audit trail for employee accountability
Users & Rights
Create separate login IDs and control exactly what each user can access.