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

Found 27 outgoing items to sync...


--- Processing Project ID: 3 ---
Processing Item ID: 2201
  - Updated: Qty 880.00 + 200.00 = 1080.00
  - Updated: Qty 1080.00 + 40.00 = 1120.00
  - Updated: Qty 1120.00 + 200.00 = 1320.00
Processing Item ID: 2202
  - Updated: Qty 440.00 + 170.00 = 610.00
  - Updated: Qty 610.00 + 17.00 = 627.00
  - Updated: Qty 627.00 + 33.00 = 660.00
Processing Item ID: 2203
  - Updated: Qty 14.00 + 3.00 = 17.00
  - Updated: Qty 17.00 + 4.00 = 21.00
Processing Item ID: 2204
  - Updated: Qty 30.00 + 15.00 = 45.00
Processing Item ID: 2205
  - Updated: Qty 90.00 + 29.00 = 119.00
  - Updated: Qty 119.00 + 6.00 = 125.00
  - Updated: Qty 125.00 + 10.00 = 135.00

--- Processing Project ID: 14 ---
Processing Item ID: 2206
  - Updated: Qty 1.00 + 1.00 = 2.00

--- Processing Project ID: 74 ---
Processing Item ID: 2206
  - Created: Qty 1.00 @ Price 45000.00
Processing Item ID: 2207
  - Created: Qty 1.00 @ Price 60000.00

--- Processing Project ID: 724 ---
Processing Item ID: 639
  - Updated: Qty 8.00 + 3.00 = 11.00

--- Processing Project ID: 742 ---
Processing Item ID: 1086
  - Updated: Qty 15.00 + 11.00 = 26.00
  - Updated: Qty 26.00 + 4.00 = 30.00
Processing Item ID: 1088
  - Updated: Qty 20.00 + 15.00 = 35.00
  - Updated: Qty 35.00 + 5.00 = 40.00
Processing Item ID: 2194
  - Updated: Qty 25.00 + 10.00 = 35.00
  - Updated: Qty 35.00 + 15.00 = 50.00
Processing Item ID: 2197
  - Updated: Qty 24.00 + 19.00 = 43.00
  - Updated: Qty 43.00 + 5.00 = 48.00
Processing Item ID: 2198
  - Updated: Qty 12.00 + 12.00 = 24.00

--- Processing Project ID: 820 ---
Processing Item ID: 2134
  - Updated: Qty 200.00 + 100.00 = 300.00

--- Processing Project ID: 903 ---
Processing Item ID: 1265
  - Updated: Qty 25.00 + 25.00 = 50.00

=== Sync Complete ===
Total items processed: 27
New project inventory records created: 2
Existing records updated: 25

=== Project Inventory Summary ===
Project 2: 3 items, Total Qty: 1460.00, Total Value: 60,070.00 AED
Project 3: 5 items, Total Qty: 2181.00, Total Value: 547,164.00 AED
Project 14: 1 items, Total Qty: 2.00, Total Value: 10,000.00 AED
Project 74: 2 items, Total Qty: 2.00, Total Value: 105,000.00 AED
Project 117: 1 items, Total Qty: 5.00, Total Value: 0.00 AED
Project 504: 3 items, Total Qty: 289.00, Total Value: 64,965.00 AED
Project 724: 1 items, Total Qty: 11.00, Total Value: 715.00 AED
Project 742: 5 items, Total Qty: 192.00, Total Value: 8,818.00 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
Project 820: 1 items, Total Qty: 300.00, Total Value: 8,100.00 AED
Project 830: 3 items, Total Qty: 72.00, Total Value: 14,320.00 AED
Project 903: 1 items, Total Qty: 50.00, Total Value: 6,250.00 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 3:
  Item 2201: Qty 1320.00 @ 255.00 = 336600.00 AED
  Item 2202: Qty 660.00 @ 250.00 = 165000.00 AED
  Item 2203: Qty 21.00 @ 59.00 = 1239.00 AED
  Item 2204: Qty 45.00 @ 250.00 = 11250.00 AED
  Item 2205: Qty 135.00 @ 245.00 = 33075.00 AED

Project 14:
  Item 2206: Qty 2.00 @ 5000.00 = 10000.00 AED

Project 74:
  Item 2206: Qty 1.00 @ 45000.00 = 45000.00 AED
  Item 2207: Qty 1.00 @ 60000.00 = 60000.00 AED

Project 117:
  Item 653: Qty 5.00 @ 0.00 = 0.00 AED

Project 504:
  Item 639: Qty 25.00 @ 65.00 = 1625.00 AED
  Item 644: Qty 164.00 @ 310.00 = 50840.00 AED
  Item 1655: Qty 100.00 @ 125.00 = 12500.00 AED

Project 724:
  Item 639: Qty 11.00 @ 65.00 = 715.00 AED

Project 742:
  Item 1086: Qty 30.00 @ 52.00 = 1560.00 AED
  Item 1088: Qty 40.00 @ 135.00 = 5400.00 AED
  Item 2194: Qty 50.00 @ 17.00 = 850.00 AED
  Item 2197: Qty 48.00 @ 5.50 = 264.00 AED
  Item 2198: Qty 24.00 @ 31.00 = 744.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

Project 820:
  Item 2134: Qty 300.00 @ 27.00 = 8100.00 AED

Project 830:
  Item 639: Qty 10.00 @ 65.00 = 650.00 AED
  Item 644: Qty 32.00 @ 310.00 = 9920.00 AED
  Item 1655: Qty 30.00 @ 125.00 = 3750.00 AED

Project 903:
  Item 1265: Qty 50.00 @ 125.00 = 6250.00 AED