SuperMart ERP

Inventory

Stock on hand, reorder levels, batch expiry and valuation

Stock Value

Rs. 8.4M

1.8%valued at cost

Units on hand

184,320

3.2%all locations

Low Stock

38 Items

below reorder level

Expiring Soon

17 Items

within 30 days

Stock ledger

16 items shown

SKUItemLocationOn handLevelReorderBest beforeValueStatus
SKU-1001

Anchor Milk Powder 400g

Dairy

Main Store214
602027-02-14Rs. 252,520Active
SKU-1002

Anchor Milk Powder 1kg

Dairy

Cold Room96
402027-01-08Rs. 267,840Active
SKU-1003

Highland Fresh Milk 1L

Dairy

Back Store32
502026-08-29Rs. 12,160Low Stock
SKU-1004

Highland Yoghurt 80g

Dairy

Warehouse A480
1202026-09-05Rs. 29,760Active
SKU-1005

Coca-Cola 1.5L

Beverages

Main Store268
802027-05-20Rs. 112,560Active
SKU-1006

Coca-Cola 400ml

Beverages

Cold Room640
2002027-04-11Rs. 75,520Active
SKU-1007

Munchee Chocolate Cream 200g

Biscuits

Back Store18
602026-11-30Rs. 3,690Low Stock
SKU-1008

Munchee Lemon Puff 200g

Biscuits

Warehouse A152
602026-12-18Rs. 28,880Active
SKU-1009

Maliban Marie 400g

Biscuits

Main Store88
402027-03-02Rs. 29,040Active
SKU-1010

Maliban Cream Cracker 190g

Biscuits

Cold Room0
502027-01-22Rs. 0Out of Stock
SKU-1011

Dilmah Ceylon Tea 100 Bags

Beverages

Back Store124
402028-06-10Rs. 110,360Active
SKU-1012

Dilmah Premium Tea 400g

Beverages

Warehouse A41
302028-02-15Rs. 50,840Active
SKU-1013

Araliya Nadu Rice 5kg

Grocery

Main Store210
602027-07-01Rs. 304,500Active
SKU-1014

Prima Atta Flour 1kg

Grocery

Cold Room175
502026-10-12Rs. 46,375Active
SKU-1015

Sunlight Detergent 1kg

Household

Back Store92
402029-01-01Rs. 58,880Active
SKU-1016

Signal Toothpaste 120g

Personal Care

Warehouse A26
402027-09-19Rs. 9,880Low Stock