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

Found 9 outgoing items to sync...


--- Processing Project ID: 742 ---
Processing Item ID: 1086
  - Updated: Qty 19.00 + 11.00 = 30.00
  - Updated: Qty 30.00 + 4.00 = 34.00
Processing Item ID: 1088
  - Updated: Qty 25.00 + 15.00 = 40.00
  - Updated: Qty 40.00 + 5.00 = 45.00
Processing Item ID: 2194
  - Updated: Qty 40.00 + 10.00 = 50.00
  - Updated: Qty 50.00 + 15.00 = 65.00
Processing Item ID: 2197
  - Updated: Qty 29.00 + 19.00 = 48.00
  - Updated: Qty 48.00 + 5.00 = 53.00
Processing Item ID: 2198
  - Updated: Qty 24.00 + 12.00 = 36.00

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

=== Project Inventory Summary ===
Project 2: 3 items, Total Qty: 1460.00, Total Value: 60,070.00 AED
Project 504: 3 items, Total Qty: 407.00, Total Value: 91,095.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

=== Detailed Project Inventory ===

Project 2:
  Item 2011: Qty 900.00 @ 42.00 = 37800.00 AED
  Item 2030: Qty 300.00 @ 40.00 = 12000.00 AED
  Item 2032: Qty 260.00 @ 39.50 = 10270.00 AED

Project 504:
  Item 639: Qty 45.00 @ 65.00 = 2925.00 AED
  Item 644: Qty 232.00 @ 310.00 = 71920.00 AED
  Item 1655: Qty 130.00 @ 125.00 = 16250.00 AED

Project 742:
  Item 1086: Qty 34.00 @ 52.00 = 1768.00 AED
  Item 1088: Qty 45.00 @ 135.00 = 6075.00 AED
  Item 2194: Qty 65.00 @ 17.00 = 1105.00 AED
  Item 2197: Qty 53.00 @ 5.50 = 291.50 AED
  Item 2198: Qty 36.00 @ 31.00 = 1116.00 AED

Project 797:
  Item 2011: Qty 300.00 @ 42.00 = 12600.00 AED
  Item 2030: Qty 300.00 @ 40.00 = 12000.00 AED
  Item 2032: Qty 790.00 @ 39.50 = 31205.00 AED

Project 810:
  Item 12: Qty 108.20 @ 102.00 = 11036.40 AED
  Item 53: Qty 360.00 @ 72.00 = 25920.00 AED
  Item 457: Qty 60.00 @ 88.00 = 5280.00 AED
  Item 1122: Qty 10.00 @ 5600.00 = 56000.00 AED