=== Site Returns Project Inventory Sync Script ===
Starting sync of existing site returns to project inventory...

Found 4 site return items to sync...


--- Processing Project ID: 74 ---
Processing Item ID: 2206
  - WARNING: No project inventory found for Item 2206 in Project 74
Processing Item ID: 2207
  - WARNING: No project inventory found for Item 2207 in Project 74

--- Processing Project ID: 504 ---
Processing Item ID: 639
  - Updated: Qty 30.00 - 5.00 = 25.00
Processing Item ID: 644
  - Updated: Qty 182.00 - 18.00 = 164.00

=== Site Returns Sync Complete ===
Total site return items processed: 4
Project inventory records updated: 2
Project inventory records deleted (zero quantity): 0
Missing project inventory records (warnings): 2

=== Updated Project Inventory Summary ===
Project 2: 3 items, Total Qty: 1460.00, Total Value: 60,070.00 AED
Project 3: 5 items, Total Qty: 1454.00, Total Value: 364,776.00 AED
Project 14: 1 items, Total Qty: 1.00, Total Value: 5,000.00 AED
Project 117: 1 items, Total Qty: 5.00, Total Value: 0.00 AED
Project 504: 3 items, Total Qty: 289.00, Total Value: 64,965.00 AED
Project 724: 1 items, Total Qty: 8.00, Total Value: 520.00 AED
Project 742: 5 items, Total Qty: 96.00, Total Value: 4,409.00 AED
Project 797: 3 items, Total Qty: 1390.00, Total Value: 55,805.00 AED
Project 810: 4 items, Total Qty: 538.20, Total Value: 98,236.40 AED
Project 820: 1 items, Total Qty: 200.00, Total Value: 5,400.00 AED
Project 830: 3 items, Total Qty: 72.00, Total Value: 14,320.00 AED
Project 903: 1 items, Total Qty: 25.00, Total Value: 3,125.00 AED