=== Inventory Flow Analysis ===
Total outgoing transactions: 38
Outgoing transactions with project_id: 38
Total outgoing items: 53
Total incoming operations: 24
Total incoming operation items: 34
Total inventory records: 256
Total stock movements: 305

--- Sample Outgoing Transactions ---
ID: 21, Project: 13, Date: 2025-12-08, Status: pending, MRN: MR-20251208-497
ID: 22, Project: 13, Date: 2025-12-08, Status: successful, MRN: MR-20251208-497-INV
ID: 23, Project: 13, Date: 2025-12-09, Status: pending, MRN: MR-20251209-889
ID: 24, Project: 14, Date: 2025-12-09, Status: pending, MRN: MR-20251209-229
ID: 25, Project: 14, Date: 2025-12-09, Status: successful, MRN: MR-20251209-229-INV

--- Sample Outgoing Items ---
Item: 1, Requested: 100.00, Released: 0.00, Project: 13, Status: pending
Item: 1, Requested: 30.00, Released: 30.00, Project: 13, Status: successful
Item: 1, Requested: 1000.00, Released: 0.00, Project: 13, Status: pending
Item: 2, Requested: 1000.00, Released: 0.00, Project: 14, Status: pending
Item: 1, Requested: 1500.00, Released: 0.00, Project: 14, Status: pending

--- Sample Stock Movements ---
Item: 2105, Type: adjustment, Ref: stock_adjustment:0, Qty: 1000.00, Date: 2025-12-10 00:41:56
Item: 2105, Type: adjustment, Ref: stock_adjustment:0, Qty: 1000.00, Date: 2025-12-10 00:43:47
Item: 2105, Type: adjustment, Ref: stock_adjustment:0, Qty: 1000.00, Date: 2025-12-10 00:49:28
Item: 2104, Type: in, Ref: supplier_delivery:1, Qty: 100.00, Date: 2025-12-10 07:21:47
Item: 2105, Type: in, Ref: supplier_delivery:2, Qty: 1000.00, Date: 2025-12-10 03:34:06

--- Site Return Data ---
Return transactions: 0
Return items: 0
Incoming operations (site returns): 9