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

Found 7 site return items to sync...


--- Processing Project ID: 13 ---
Processing Item ID: 1
  - Updated: Qty 1050.00 - 50.00 = 1000.00
  - Updated: Qty 1000.00 - 30.00 = 970.00

--- Processing Project ID: 14 ---
Processing Item ID: 1
  - Updated: Qty 1200.00 - 300.00 = 900.00

--- Processing Project ID: 16 ---
Processing Item ID: 1
  - WARNING: No project inventory found for Item 1 in Project 16
  - WARNING: No project inventory found for Item 1 in Project 16
Processing Item ID: 2
  - WARNING: No project inventory found for Item 2 in Project 16

--- Processing Project ID: 17 ---
Processing Item ID: 1
  - Updated: Qty 614.00 - 500.00 = 114.00

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

=== Updated Project Inventory Summary ===
Project 3: 2 items, Total Qty: 155.00, Total Value: 19,307.50 AED
Project 13: 2 items, Total Qty: 1270.00, Total Value: 0.00 AED
Project 14: 2 items, Total Qty: 1500.00, Total Value: 207,252.00 AED
Project 15: 1 items, Total Qty: 1250.00, Total Value: 95,412.50 AED
Project 17: 1 items, Total Qty: 114.00, Total Value: 0.00 AED
Project 191: 1 items, Total Qty: 1900.00, Total Value: 0.00 AED