=== Project Inventory Sync Script ===
Starting sync of existing outgoing transactions to project inventory...

Found 12 outgoing items to sync...


--- Processing Project ID: 13 ---
Processing Item ID: 1
  - Updated: Qty 970.00 + 500.00 = 1470.00
  - Updated: Qty 1470.00 + 200.00 = 1670.00
  - Updated: Qty 1670.00 + 100.00 = 1770.00
  - Updated: Qty 1770.00 + 100.00 = 1870.00
Processing Item ID: 2
  - Updated: Qty 300.00 + 30.00 = 330.00
  - Updated: Qty 330.00 + 30.00 = 360.00
  - Updated: Qty 360.00 + 50.00 = 410.00

--- Processing Project ID: 14 ---
Processing Item ID: 1
  - Updated: Qty 900.00 + 500.00 = 1400.00
Processing Item ID: 21
  - Updated: Qty 600.00 + 100.00 = 700.00

--- Processing Project ID: 15 ---
Processing Item ID: 1
  - Updated: Qty 1250.00 + 250.00 = 1500.00

--- Processing Project ID: 17 ---
Processing Item ID: 1
  - Updated: Qty 114.00 + 307.00 = 421.00

--- Processing Project ID: 191 ---
Processing Item ID: 1
  - Updated: Qty 1900.00 + 700.00 = 2600.00

=== Sync Complete ===
Total items processed: 12
New project inventory records created: 0
Existing records updated: 12

=== Project Inventory Summary ===
Project 3: 2 items, Total Qty: 155.00, Total Value: 19,307.50 AED
Project 13: 2 items, Total Qty: 2280.00, Total Value: 0.00 AED
Project 14: 2 items, Total Qty: 2100.00, Total Value: 250,369.00 AED
Project 15: 1 items, Total Qty: 1500.00, Total Value: 114,495.00 AED
Project 17: 1 items, Total Qty: 421.00, Total Value: 0.00 AED
Project 191: 1 items, Total Qty: 2600.00, Total Value: 0.00 AED

=== Detailed Project Inventory ===

Project 3:
  Item 1: Qty 90.00 @ 114.50 = 10305.00 AED
  Item 2: Qty 65.00 @ 138.50 = 9002.50 AED

Project 13:
  Item 1: Qty 1870.00 @ 0.00 = 0.00 AED
  Item 2: Qty 410.00 @ 0.00 = 0.00 AED

Project 14:
  Item 1: Qty 1400.00 @ 24.50 = 34300.00 AED
  Item 21: Qty 700.00 @ 308.67 = 216069.00 AED

Project 15:
  Item 1: Qty 1500.00 @ 76.33 = 114495.00 AED

Project 17:
  Item 1: Qty 421.00 @ 0.00 = 0.00 AED

Project 191:
  Item 1: Qty 2600.00 @ 0.00 = 0.00 AED