Inventory Details

Back to Stock Overview

Fresh Produce · Apples

Fuji Apples

1 kg pack · Green Valley

SKU FR-APL-0012 Barcode8901234567013 Supplier Green Valley Farms

Edit Transfer

Current stock

148units

In Stock

Stock levelmin 40 · reorder 60 · target 178

Current Stock

148

units on hand

Opening Stock

120

as of Sep 01

Stock Received

+180

3 purchase orders

Stock Sold

−146

≈ 6.3 units / day

Stock Adjusted

+12

1 adjustment · Sep 23

Damaged Stock

$12.60 loss

Expired Stock

$25.20 written off

Available Stock

136

148 on hand − 12 reserved

Stock movement · September

Opening Stock

120

Purchase

+180

Transfer

± 0

60 moved between stores

Sale

−146

Adjustment

−6

+12 count · −6 damage · −12 expiry

Current Stock

148

On-hand stock · this month

Sep 01 – Sep 23

Stock by location

Warehouse A · Central62

Store A · Main Branch30

Warehouse B · Cold Chain20

Store B · Downtown19

Store C · Riverside12

Store D · Northgate5

Unit cost: $2.10

Selling price: $3.20

Margin: 34%

Stock value: $310.80

Minimum level: 40 units

Reorder level: 60 units

Tax: 5% GST

Last purchase: Sep 20, 2026

Movement	Details	Reference	Change	Balance	By
Adjustment Sep 23, 2026	Stock count variance	ADJ-1052	+12	148	Arjun
Sale Sep 22, 2026	POS sales · 5 invoices	INV-10470…	−22	136	Arjun
Sale Sep 21, 2026	POS sales · 9 invoices	INV-10437…	−44	158	Priya
Purchase Sep 20, 2026	Received from Green Valley Farms	PO-8801	+60	202	Arjun
Sale Sep 16, 2026	POS sales · 6 invoices	INV-10344…	−27	142	Arjun
Damage Sep 15, 2026	Crushed cartons in aisle 2	DMG-0498	−6	169	Mateo
Expiry Sep 14, 2026	Batch B-260830-A past use-by	ADJ-1031	−12	175	Neha
Sale Sep 12, 2026	POS sales · 7 invoices	INV-10310…	−31	187	Priya
Purchase Sep 09, 2026	Received from Green Valley Farms	PO-8760	+60	218	Arjun
Sale Sep 06, 2026	POS sales · 5 invoices	INV-10201…	−22	158	Arjun
Purchase Sep 03, 2026	Received from Green Valley Farms	PO-8712	+60	180	Arjun
Opening Stock Sep 01, 2026	Opening balance	ADJ-1008	+120	120	Daniel

Transfer	Date	Route	Quantity	Status
TRF-3027	Sep 22	Warehouse A → Store B	60	In Transit
TRF-3024	Sep 20	Warehouse A → Store B	40	Received
TRF-3019	Sep 16	Warehouse A → Store A	48	Received
TRF-3012	Sep 09	Warehouse B → Store C	24	Received

Adjustment	Date	Type	Change	New stock	Reason
ADJ-1052	Sep 23	Stock Increase	+12	148	Stock count variance
DMG-0498	Sep 15	Damage	−6	169	Crushed cartons in aisle 2
ADJ-1031	Sep 14	Expiry	−12	175	Batch B-260830-A past use-by
ADJ-1008	Sep 01	Opening Stock	+120	120	Opening balance

Purchase order	Date	Supplier	Qty	Unit cost	Total	Status
PO-8853	Sep 24 (exp.)	Green Valley Farms	60	$2.10	$126.00	Ordered
PO-8801	Sep 20	Green Valley Farms	60	$2.10	$126.00	Received
PO-8760	Sep 09	Green Valley Farms	60	$2.05	$123.00	Received
PO-8712	Sep 03	Green Valley Farms	60	$2.10	$126.00	Received

146

units sold

$467.20

revenue

$160.60

gross profit

Invoice	Date	Customer	Qty	Unit price	Total
INV-10482	Sep 23 · 10:42	Meera Nair	2	$3.20	$6.40
INV-10479	Sep 23 · 09:31	Walk-in Customer	1	$3.20	$3.20
INV-10474	Sep 22 · 11:36	Lena Fischer	3	$3.20	$9.60
INV-10468	Sep 22 · 09:02	Omar Haddad	4	$3.20	$12.80
INV-10461	Sep 21 · 05:48	Priya Sharma	2	$3.20	$6.40

Earliest batch B-260908-A reaches its use-by date in 17 days — sell first (FEFO) or move to a high-traffic store.

Batch	Received	Expiry	Units	Days left	Shelf life used
B-260908-A	Sep 08	Oct 10	40	17 days	32%
B-260916-B	Sep 16	Oct 17	62	24 days	12%
B-260920-A	Sep 20	Oct 21	46	28 days	8%

Inventory Details

Fuji Apples

Adjust Stock

Inventory Filters

Adjustment ADJ-1052

Damage Report DMG-0521

Batch B-260901-A