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

Found 112 outgoing items to sync...


--- Processing Project ID: 332 ---
Processing Item ID: 45
  - Updated: Qty 200.00 + 100.00 = 300.00
  - Updated: Qty 300.00 + 100.00 = 400.00
Processing Item ID: 56
  - Updated: Qty 1.00 + 1.00 = 2.00
  - Updated: Qty 2.00 + 1.00 = 3.00
Processing Item ID: 57
  - Updated: Qty 1.00 + 1.00 = 2.00
  - Updated: Qty 2.00 + 1.00 = 3.00
  - Updated: Qty 3.00 + 1.00 = 4.00

--- Processing Project ID: 532 ---
Processing Item ID: 116
  - Updated: Qty 5.00 + 5.00 = 10.00

--- Processing Project ID: 619 ---
Processing Item ID: 87
  - Updated: Qty 3.00 + 3.00 = 6.00

--- Processing Project ID: 624 ---
Processing Item ID: 45
  - Updated: Qty 700.00 + 300.00 = 1000.00
  - Updated: Qty 1000.00 + 400.00 = 1400.00
Processing Item ID: 56
  - Updated: Qty 4.00 + 4.00 = 8.00
Processing Item ID: 57
  - Updated: Qty 4.00 + 4.00 = 8.00
Processing Item ID: 82
  - Updated: Qty 1000.00 + 1000.00 = 2000.00
Processing Item ID: 83
  - Updated: Qty 1000.00 + 1000.00 = 2000.00

--- Processing Project ID: 664 ---
Processing Item ID: 256
  - Updated: Qty 5.00 + 5.00 = 10.00

--- Processing Project ID: 665 ---
Processing Item ID: 188
  - Updated: Qty 5.00 + 5.00 = 10.00
Processing Item ID: 189
  - Updated: Qty 10.00 + 5.00 = 15.00
  - Updated: Qty 15.00 + 5.00 = 20.00
Processing Item ID: 192
  - Updated: Qty 5.00 + 5.00 = 10.00

--- Processing Project ID: 682 ---
Processing Item ID: 184
  - Updated: Qty 1.00 + 1.00 = 2.00
Processing Item ID: 209
  - Updated: Qty 6.00 + 1.00 = 7.00
  - Updated: Qty 7.00 + 1.00 = 8.00
  - Updated: Qty 8.00 + 1.00 = 9.00
  - Updated: Qty 9.00 + 3.00 = 12.00
Processing Item ID: 219
  - Updated: Qty 6.00 + 6.00 = 12.00

--- Processing Project ID: 692 ---
Processing Item ID: 27
  - Updated: Qty 25.00 + 25.00 = 50.00

--- Processing Project ID: 706 ---
Processing Item ID: 27
  - Updated: Qty 5.00 + 5.00 = 10.00
Processing Item ID: 29
  - Updated: Qty 1.00 + 1.00 = 2.00

--- Processing Project ID: 709 ---
Processing Item ID: 45
  - Updated: Qty 60.00 + 60.00 = 120.00
Processing Item ID: 56
  - Updated: Qty 2.00 + 2.00 = 4.00

--- Processing Project ID: 713 ---
Processing Item ID: 85
  - Updated: Qty 1.00 + 1.00 = 2.00
Processing Item ID: 87
  - Updated: Qty 15.00 + 15.00 = 30.00
Processing Item ID: 98
  - Updated: Qty 250.00 + 250.00 = 500.00
Processing Item ID: 126
  - Updated: Qty 1.00 + 1.00 = 2.00
Processing Item ID: 129
  - Updated: Qty 20.00 + 20.00 = 40.00
Processing Item ID: 130
  - Updated: Qty 33.00 + 33.00 = 66.00

--- Processing Project ID: 720 ---
Processing Item ID: 209
  - Updated: Qty 5.00 + 5.00 = 10.00

--- Processing Project ID: 724 ---
Processing Item ID: 160
  - Updated: Qty 500.00 + 500.00 = 1000.00

--- Processing Project ID: 727 ---
Processing Item ID: 209
  - Updated: Qty 8.00 + 5.00 = 13.00
  - Updated: Qty 13.00 + 3.00 = 16.00
Processing Item ID: 219
  - Updated: Qty 20.00 + 20.00 = 40.00

--- Processing Project ID: 733 ---
Processing Item ID: 209
  - Updated: Qty 3.00 + 1.00 = 4.00
  - Updated: Qty 4.00 + 2.00 = 6.00

--- Processing Project ID: 742 ---
Processing Item ID: 184
  - Updated: Qty 1.00 + 1.00 = 2.00
Processing Item ID: 209
  - Updated: Qty 2.00 + 1.00 = 3.00
  - Updated: Qty 3.00 + 1.00 = 4.00
Processing Item ID: 219
  - Updated: Qty 10.00 + 10.00 = 20.00

--- Processing Project ID: 745 ---
Processing Item ID: 209
  - Updated: Qty 4.00 + 3.00 = 7.00
  - Updated: Qty 7.00 + 1.00 = 8.00
Processing Item ID: 219
  - Updated: Qty 15.00 + 15.00 = 30.00

--- Processing Project ID: 753 ---
Processing Item ID: 184
  - Updated: Qty 2.00 + 1.00 = 3.00
Processing Item ID: 209
  - Updated: Qty 1.00 + 1.00 = 2.00

--- Processing Project ID: 767 ---
Processing Item ID: 184
  - Updated: Qty 5.00 + 5.00 = 10.00
Processing Item ID: 209
  - Updated: Qty 18.00 + 5.00 = 23.00
  - Updated: Qty 23.00 + 3.00 = 26.00
  - Updated: Qty 26.00 + 4.00 = 30.00
  - Updated: Qty 30.00 + 6.00 = 36.00
Processing Item ID: 210
  - Updated: Qty 10.00 + 10.00 = 20.00
Processing Item ID: 219
  - Updated: Qty 30.00 + 30.00 = 60.00

--- Processing Project ID: 775 ---
Processing Item ID: 68
  - Updated: Qty 34.00 + 34.00 = 68.00
Processing Item ID: 81
  - Updated: Qty 3.00 + 3.00 = 6.00
Processing Item ID: 82
  - Updated: Qty 100.00 + 100.00 = 200.00
Processing Item ID: 83
  - Updated: Qty 100.00 + 100.00 = 200.00

--- Processing Project ID: 781 ---
Processing Item ID: 209
  - Updated: Qty 5.00 + 5.00 = 10.00
Processing Item ID: 242
  - Updated: Qty 38.00 + 38.00 = 76.00
Processing Item ID: 257
  - Updated: Qty 10.00 + 10.00 = 20.00

--- Processing Project ID: 800 ---
Processing Item ID: 160
  - Updated: Qty 500.00 + 500.00 = 1000.00

--- Processing Project ID: 810 ---
Processing Item ID: 160
  - Updated: Qty 1000.00 + 1000.00 = 2000.00

--- Processing Project ID: 820 ---
Processing Item ID: 209
  - Updated: Qty 6.00 + 2.00 = 8.00
  - Updated: Qty 8.00 + 1.00 = 9.00
  - Updated: Qty 9.00 + 3.00 = 12.00

--- Processing Project ID: 889 ---
Processing Item ID: 12
  - Updated: Qty 900.00 + 900.00 = 1800.00
Processing Item ID: 19
  - Updated: Qty 300.00 + 300.00 = 600.00
Processing Item ID: 124
  - Updated: Qty 46.00 + 46.00 = 92.00

--- Processing Project ID: 900 ---
Processing Item ID: 27
  - Updated: Qty 50.00 + 50.00 = 100.00

--- Processing Project ID: 903 ---
Processing Item ID: 188
  - Updated: Qty 5.00 + 5.00 = 10.00

--- Processing Project ID: 914 ---
Processing Item ID: 209
  - Updated: Qty 5.00 + 1.00 = 6.00
  - Updated: Qty 6.00 + 4.00 = 10.00
Processing Item ID: 210
  - Updated: Qty 2.00 + 2.00 = 4.00
Processing Item ID: 219
  - Updated: Qty 50.00 + 30.00 = 80.00
  - Updated: Qty 80.00 + 20.00 = 100.00
Processing Item ID: 225
  - Updated: Qty 20.00 + 20.00 = 40.00
Processing Item ID: 240
  - Updated: Qty 9.00 + 9.00 = 18.00

--- Processing Project ID: 919 ---
Processing Item ID: 184
  - Updated: Qty 5.00 + 5.00 = 10.00
Processing Item ID: 190
  - Updated: Qty 5.00 + 5.00 = 10.00
Processing Item ID: 209
  - Updated: Qty 5.00 + 5.00 = 10.00
Processing Item ID: 219
  - Updated: Qty 15.00 + 15.00 = 30.00

--- Processing Project ID: 928 ---
Processing Item ID: 89
  - Updated: Qty 92.00 + 92.00 = 184.00

--- Processing Project ID: 939 ---
Processing Item ID: 209
  - Updated: Qty 6.00 + 1.00 = 7.00
  - Updated: Qty 7.00 + 3.00 = 10.00
  - Updated: Qty 10.00 + 1.00 = 11.00
  - Updated: Qty 11.00 + 1.00 = 12.00
Processing Item ID: 210
  - Updated: Qty 1.00 + 1.00 = 2.00
Processing Item ID: 219
  - Updated: Qty 40.00 + 20.00 = 60.00
  - Updated: Qty 60.00 + 20.00 = 80.00

--- Processing Project ID: 942 ---
Processing Item ID: 89
  - Updated: Qty 69.00 + 46.00 = 115.00
  - Updated: Qty 115.00 + 23.00 = 138.00

--- Processing Project ID: 961 ---
Processing Item ID: 209
  - Created: Qty 1.00 @ Price 214.08

--- Processing Project ID: 962 ---
Processing Item ID: 209
  - Updated: Qty 5.00 + 5.00 = 10.00
Processing Item ID: 210
  - Updated: Qty 2.00 + 2.00 = 4.00
Processing Item ID: 219
  - Updated: Qty 20.00 + 20.00 = 40.00

--- Processing Project ID: 972 ---
Processing Item ID: 209
  - Updated: Qty 3.00 + 3.00 = 6.00

--- Processing Project ID: 973 ---
Processing Item ID: 63
  - Updated: Qty 2.00 + 2.00 = 4.00
Processing Item ID: 64
  - Updated: Qty 2.00 + 2.00 = 4.00
Processing Item ID: 65
  - Updated: Qty 2.00 + 2.00 = 4.00
Processing Item ID: 125
  - Updated: Qty 2.00 + 2.00 = 4.00

--- Processing Project ID: 975 ---
Processing Item ID: 188
  - Updated: Qty 15.00 + 15.00 = 30.00
Processing Item ID: 189
  - Updated: Qty 10.00 + 10.00 = 20.00
Processing Item ID: 192
  - Updated: Qty 10.00 + 10.00 = 20.00

--- Processing Project ID: 976 ---
Processing Item ID: 82
  - Updated: Qty 500.00 + 500.00 = 1000.00
Processing Item ID: 83
  - Updated: Qty 500.00 + 500.00 = 1000.00

=== Sync Complete ===
Total items processed: 112
New project inventory records created: 1
Existing records updated: 111

=== Project Inventory Summary ===
Project 332: 3 items, Total Qty: 407.00, Total Value: 0.00 AED
Project 532: 1 items, Total Qty: 10.00, Total Value: 0.00 AED
Project 619: 1 items, Total Qty: 6.00, Total Value: 0.00 AED
Project 624: 5 items, Total Qty: 5416.00, Total Value: 0.00 AED
Project 664: 1 items, Total Qty: 10.00, Total Value: 3,450.00 AED
Project 665: 3 items, Total Qty: 40.00, Total Value: 0.00 AED
Project 682: 3 items, Total Qty: 26.00, Total Value: 4,200.24 AED
Project 692: 1 items, Total Qty: 50.00, Total Value: 0.00 AED
Project 706: 2 items, Total Qty: 12.00, Total Value: 0.00 AED
Project 709: 2 items, Total Qty: 124.00, Total Value: 0.00 AED
Project 713: 6 items, Total Qty: 640.00, Total Value: 0.00 AED
Project 720: 1 items, Total Qty: 10.00, Total Value: 2,150.00 AED
Project 724: 1 items, Total Qty: 1000.00, Total Value: 0.00 AED
Project 727: 2 items, Total Qty: 56.00, Total Value: 10,157.36 AED
Project 733: 1 items, Total Qty: 6.00, Total Value: 1,286.34 AED
Project 742: 3 items, Total Qty: 26.00, Total Value: 3,616.76 AED
Project 745: 2 items, Total Qty: 38.00, Total Value: 5,856.06 AED
Project 753: 2 items, Total Qty: 5.00, Total Value: 428.16 AED
Project 767: 4 items, Total Qty: 126.00, Total Value: 7,618.96 AED
Project 775: 4 items, Total Qty: 474.00, Total Value: 0.00 AED
Project 781: 3 items, Total Qty: 106.00, Total Value: 14,430.00 AED
Project 800: 1 items, Total Qty: 1000.00, Total Value: 0.00 AED
Project 810: 1 items, Total Qty: 2000.00, Total Value: 15,200.00 AED
Project 818: 1 items, Total Qty: 5.00, Total Value: 0.00 AED
Project 820: 1 items, Total Qty: 12.00, Total Value: 2,574.48 AED
Project 889: 3 items, Total Qty: 2492.00, Total Value: 0.00 AED
Project 900: 1 items, Total Qty: 100.00, Total Value: 0.00 AED
Project 903: 1 items, Total Qty: 10.00, Total Value: 0.00 AED
Project 914: 5 items, Total Qty: 172.00, Total Value: 15,909.90 AED
Project 919: 4 items, Total Qty: 60.00, Total Value: 6,122.50 AED
Project 928: 1 items, Total Qty: 184.00, Total Value: 0.00 AED
Project 939: 3 items, Total Qty: 94.00, Total Value: 16,095.80 AED
Project 942: 1 items, Total Qty: 138.00, Total Value: 0.00 AED
Project 961: 1 items, Total Qty: 1.00, Total Value: 214.08 AED
Project 962: 3 items, Total Qty: 54.00, Total Value: 7,903.20 AED
Project 972: 1 items, Total Qty: 6.00, Total Value: 1,290.00 AED
Project 973: 4 items, Total Qty: 16.00, Total Value: 0.00 AED
Project 975: 3 items, Total Qty: 70.00, Total Value: 0.00 AED
Project 976: 2 items, Total Qty: 2000.00, Total Value: 0.00 AED

=== Detailed Project Inventory ===

Project 332:
  Item 45: Qty 400.00 @ 0.00 = 0.00 AED
  Item 56: Qty 3.00 @ 0.00 = 0.00 AED
  Item 57: Qty 4.00 @ 0.00 = 0.00 AED

Project 532:
  Item 116: Qty 10.00 @ 0.00 = 0.00 AED

Project 619:
  Item 87: Qty 6.00 @ 0.00 = 0.00 AED

Project 624:
  Item 45: Qty 1400.00 @ 0.00 = 0.00 AED
  Item 56: Qty 8.00 @ 0.00 = 0.00 AED
  Item 57: Qty 8.00 @ 0.00 = 0.00 AED
  Item 82: Qty 2000.00 @ 0.00 = 0.00 AED
  Item 83: Qty 2000.00 @ 0.00 = 0.00 AED

Project 664:
  Item 256: Qty 10.00 @ 345.00 = 3450.00 AED

Project 665:
  Item 188: Qty 10.00 @ 0.00 = 0.00 AED
  Item 189: Qty 20.00 @ 0.00 = 0.00 AED
  Item 192: Qty 10.00 @ 0.00 = 0.00 AED

Project 682:
  Item 184: Qty 2.00 @ 0.00 = 0.00 AED
  Item 209: Qty 12.00 @ 212.09 = 2545.08 AED
  Item 219: Qty 12.00 @ 137.93 = 1655.16 AED

Project 692:
  Item 27: Qty 50.00 @ 0.00 = 0.00 AED

Project 706:
  Item 27: Qty 10.00 @ 0.00 = 0.00 AED
  Item 29: Qty 2.00 @ 0.00 = 0.00 AED

Project 709:
  Item 45: Qty 120.00 @ 0.00 = 0.00 AED
  Item 56: Qty 4.00 @ 0.00 = 0.00 AED

Project 713:
  Item 85: Qty 2.00 @ 0.00 = 0.00 AED
  Item 87: Qty 30.00 @ 0.00 = 0.00 AED
  Item 98: Qty 500.00 @ 0.00 = 0.00 AED
  Item 126: Qty 2.00 @ 0.00 = 0.00 AED
  Item 129: Qty 40.00 @ 0.00 = 0.00 AED
  Item 130: Qty 66.00 @ 0.00 = 0.00 AED

Project 720:
  Item 209: Qty 10.00 @ 215.00 = 2150.00 AED

Project 724:
  Item 160: Qty 1000.00 @ 0.00 = 0.00 AED

Project 727:
  Item 209: Qty 16.00 @ 204.66 = 3274.56 AED
  Item 219: Qty 40.00 @ 172.07 = 6882.80 AED

Project 733:
  Item 209: Qty 6.00 @ 214.39 = 1286.34 AED

Project 742:
  Item 184: Qty 2.00 @ 0.00 = 0.00 AED
  Item 209: Qty 4.00 @ 214.54 = 858.16 AED
  Item 219: Qty 20.00 @ 137.93 = 2758.60 AED

Project 745:
  Item 209: Qty 8.00 @ 214.77 = 1718.16 AED
  Item 219: Qty 30.00 @ 137.93 = 4137.90 AED

Project 753:
  Item 184: Qty 3.00 @ 0.00 = 0.00 AED
  Item 209: Qty 2.00 @ 214.08 = 428.16 AED

Project 767:
  Item 184: Qty 10.00 @ 0.00 = 0.00 AED
  Item 209: Qty 36.00 @ 178.86 = 6438.96 AED
  Item 210: Qty 20.00 @ 59.00 = 1180.00 AED
  Item 219: Qty 60.00 @ 0.00 = 0.00 AED

Project 775:
  Item 68: Qty 68.00 @ 0.00 = 0.00 AED
  Item 81: Qty 6.00 @ 0.00 = 0.00 AED
  Item 82: Qty 200.00 @ 0.00 = 0.00 AED
  Item 83: Qty 200.00 @ 0.00 = 0.00 AED

Project 781:
  Item 209: Qty 10.00 @ 215.00 = 2150.00 AED
  Item 242: Qty 76.00 @ 80.00 = 6080.00 AED
  Item 257: Qty 20.00 @ 310.00 = 6200.00 AED

Project 800:
  Item 160: Qty 1000.00 @ 0.00 = 0.00 AED

Project 810:
  Item 160: Qty 2000.00 @ 7.60 = 15200.00 AED

Project 818:
  Item 125: Qty 5.00 @ 0.00 = 0.00 AED

Project 820:
  Item 209: Qty 12.00 @ 214.54 = 2574.48 AED

Project 889:
  Item 12: Qty 1800.00 @ 0.00 = 0.00 AED
  Item 19: Qty 600.00 @ 0.00 = 0.00 AED
  Item 124: Qty 92.00 @ 0.00 = 0.00 AED

Project 900:
  Item 27: Qty 100.00 @ 0.00 = 0.00 AED

Project 903:
  Item 188: Qty 10.00 @ 0.00 = 0.00 AED

Project 914:
  Item 209: Qty 10.00 @ 211.69 = 2116.90 AED
  Item 210: Qty 4.00 @ 0.00 = 0.00 AED
  Item 219: Qty 100.00 @ 137.93 = 13793.00 AED
  Item 225: Qty 40.00 @ 0.00 = 0.00 AED
  Item 240: Qty 18.00 @ 0.00 = 0.00 AED

Project 919:
  Item 184: Qty 10.00 @ 0.00 = 0.00 AED
  Item 190: Qty 10.00 @ 0.00 = 0.00 AED
  Item 209: Qty 10.00 @ 198.46 = 1984.60 AED
  Item 219: Qty 30.00 @ 137.93 = 4137.90 AED

Project 928:
  Item 89: Qty 184.00 @ 0.00 = 0.00 AED

Project 939:
  Item 209: Qty 12.00 @ 214.85 = 2578.20 AED
  Item 210: Qty 2.00 @ 0.00 = 0.00 AED
  Item 219: Qty 80.00 @ 168.97 = 13517.60 AED

Project 942:
  Item 89: Qty 138.00 @ 0.00 = 0.00 AED

Project 961:
  Item 209: Qty 1.00 @ 214.08 = 214.08 AED

Project 962:
  Item 209: Qty 10.00 @ 215.00 = 2150.00 AED
  Item 210: Qty 4.00 @ 59.00 = 236.00 AED
  Item 219: Qty 40.00 @ 137.93 = 5517.20 AED

Project 972:
  Item 209: Qty 6.00 @ 215.00 = 1290.00 AED

Project 973:
  Item 63: Qty 4.00 @ 0.00 = 0.00 AED
  Item 64: Qty 4.00 @ 0.00 = 0.00 AED
  Item 65: Qty 4.00 @ 0.00 = 0.00 AED
  Item 125: Qty 4.00 @ 0.00 = 0.00 AED

Project 975:
  Item 188: Qty 30.00 @ 0.00 = 0.00 AED
  Item 189: Qty 20.00 @ 0.00 = 0.00 AED
  Item 192: Qty 20.00 @ 0.00 = 0.00 AED

Project 976:
  Item 82: Qty 1000.00 @ 0.00 = 0.00 AED
  Item 83: Qty 1000.00 @ 0.00 = 0.00 AED