IMAGINATIVE COLOURS PRIVATE LIMITEDInventory • Purchase • Supplier Management
——

Inventory Overview

Live raw material and supplier snapshot
Materials
—
Stock Value
—
Low Stock
—
Suppliers
—
Supplier Outstanding
—
Low Stock Attention

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.
Recent Stock Transactions

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.
Material Issue History

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.