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

Found 2 site return items to sync...


--- Processing Project ID: 504 ---
Processing Item ID: 639
  - Updated: Qty 45.00 - 5.00 = 40.00
Processing Item ID: 644
  - Updated: Qty 232.00 - 18.00 = 214.00

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

=== Updated Project Inventory Summary ===
Project 2: 3 items, Total Qty: 1460.00, Total Value: 60,070.00 AED
Project 504: 3 items, Total Qty: 384.00, Total Value: 85,190.00 AED
Project 742: 5 items, Total Qty: 233.00, Total Value: 10,355.50 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