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

Found 21 outgoing items to sync...


--- Processing Project ID: 1 ---
Processing Item ID: 2105
  - Updated: Qty 1270.00 + 200.00 = 1470.00
  - Updated: Qty 1470.00 + 200.00 = 1670.00
  - Updated: Qty 1670.00 + 100.00 = 1770.00
Processing Item ID: 2109
  - Updated: Qty 6600.00 + 500.00 = 7100.00
  - Updated: Qty 7100.00 + 500.00 = 7600.00
  - Updated: Qty 7600.00 + 1000.00 = 8600.00
  - Updated: Qty 8600.00 + 300.00 = 8900.00
Processing Item ID: 2110
  - Created: Qty 1000.00 @ Price 100.00

--- Processing Project ID: 2 ---
Processing Item ID: 690
  - Updated: Qty 210.00 + 70.00 = 280.00
Processing Item ID: 2110
  - Updated: Qty 2000.00 + 500.00 = 2500.00

--- Processing Project ID: 3 ---
Processing Item ID: 471
  - Updated: Qty 900.00 + 600.00 = 1500.00
Processing Item ID: 512
  - Updated: Qty 900.00 + 500.00 = 1400.00

--- Processing Project ID: 13 ---
Processing Item ID: 1
  - Updated: Qty 60.00 + 30.00 = 90.00

--- Processing Project ID: 14 ---
Processing Item ID: 2
  - Updated: Qty 800.00 + 400.00 = 1200.00

--- Processing Project ID: 59 ---
Processing Item ID: 1
  - Updated: Qty 200.00 + 100.00 = 300.00
Processing Item ID: 2
  - Updated: Qty 200.00 + 100.00 = 300.00
Processing Item ID: 21
  - Updated: Qty 200.00 + 100.00 = 300.00

--- Processing Project ID: 724 ---
Processing Item ID: 211
  - Updated: Qty 2900.00 + 500.00 = 3400.00
  - Updated: Qty 3400.00 + 1500.00 = 4900.00
Processing Item ID: 234
  - Updated: Qty 1400.00 + 800.00 = 2200.00
  - Updated: Qty 2200.00 + 200.00 = 2400.00

=== Sync Complete ===
Total items processed: 21
New project inventory records created: 1
Existing records updated: 20

=== Project Inventory Summary ===
Project 1: 5 items, Total Qty: 12470.00, Total Value: 972,595.00 AED
Project 2: 3 items, Total Qty: 2880.00, Total Value: 11,820.00 AED
Project 3: 2 items, Total Qty: 2900.00, Total Value: 0.00 AED
Project 13: 1 items, Total Qty: 90.00, Total Value: 0.00 AED
Project 14: 1 items, Total Qty: 1200.00, Total Value: 110,796.00 AED
Project 29: 3 items, Total Qty: 950.00, Total Value: 145,000.00 AED
Project 59: 3 items, Total Qty: 900.00, Total Value: 120,300.00 AED
Project 724: 3 items, Total Qty: 7350.00, Total Value: 1,110,000.00 AED

=== Detailed Project Inventory ===

Project 1:
  Item 471: Qty 500.00 @ 0.00 = 0.00 AED
  Item 512: Qty 300.00 @ 0.00 = 0.00 AED
  Item 2105: Qty 1770.00 @ 5.00 = 8850.00 AED
  Item 2109: Qty 8900.00 @ 97.05 = 863745.00 AED
  Item 2110: Qty 1000.00 @ 100.00 = 100000.00 AED

Project 2:
  Item 690: Qty 280.00 @ 6.50 = 1820.00 AED
  Item 2109: Qty 100.00 @ 100.00 = 10000.00 AED
  Item 2110: Qty 2500.00 @ 0.00 = 0.00 AED

Project 3:
  Item 471: Qty 1500.00 @ 0.00 = 0.00 AED
  Item 512: Qty 1400.00 @ 0.00 = 0.00 AED

Project 13:
  Item 1: Qty 90.00 @ 0.00 = 0.00 AED

Project 14:
  Item 2: Qty 1200.00 @ 92.33 = 110796.00 AED

Project 29:
  Item 211: Qty 600.00 @ 200.00 = 120000.00 AED
  Item 234: Qty 300.00 @ 50.00 = 15000.00 AED
  Item 2109: Qty 50.00 @ 200.00 = 10000.00 AED

Project 59:
  Item 1: Qty 300.00 @ 0.00 = 0.00 AED
  Item 2: Qty 300.00 @ 92.33 = 27699.00 AED
  Item 21: Qty 300.00 @ 308.67 = 92601.00 AED

Project 724:
  Item 211: Qty 4900.00 @ 200.00 = 980000.00 AED
  Item 234: Qty 2400.00 @ 50.00 = 120000.00 AED
  Item 2109: Qty 50.00 @ 200.00 = 10000.00 AED