=== Site Returns Project Inventory Sync Script === Starting sync of existing site returns to project inventory... Found 4 site return items to sync... --- Processing Project ID: 332 --- Processing Item ID: 56 - Updated: Qty 3.00 - 1.00 = 2.00 Processing Item ID: 57 - Updated: Qty 4.00 - 1.00 = 3.00 - Updated: Qty 3.00 - 1.00 = 2.00 --- Processing Project ID: 961 --- Processing Item ID: 209 - Deleted: Qty 1.00 - 1.00 = 0.00 (removed record) === Site Returns Sync Complete === Total site return items processed: 4 Project inventory records updated: 3 Project inventory records deleted (zero quantity): 1 Missing project inventory records (warnings): 0 === Updated Project Inventory Summary === Project 332: 3 items, Total Qty: 404.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: 2538.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 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