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

Found 3 site return items to sync...


--- Processing Project ID: 1 ---
Processing Item ID: 2105
  - Updated: Qty 1720.00 - 50.00 = 1670.00
Processing Item ID: 2110
  - Deleted: Qty 200.00 - 300.00 = 0.00 (removed record)
  - WARNING: No project inventory found for Item 2110 in Project 1

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

=== Updated Project Inventory Summary ===
Project 1: 4 items, Total Qty: 11370.00, Total Value: 872,095.00 AED
Project 2: 3 items, Total Qty: 2880.00, Total Value: 11,820.00 AED
Project 3: 2 items, Total Qty: 2900.00, Total Value: 0.00 AED
Project 13: 1 items, Total Qty: 90.00, Total Value: 0.00 AED
Project 14: 1 items, Total Qty: 1200.00, Total Value: 110,796.00 AED
Project 29: 3 items, Total Qty: 950.00, Total Value: 145,000.00 AED
Project 59: 3 items, Total Qty: 900.00, Total Value: 120,300.00 AED
Project 724: 3 items, Total Qty: 7350.00, Total Value: 1,110,000.00 AED