string(385) "select DISTINCT(ai.accountid), count(*) as total 
from vtiger_invoice as ai
 LEFT JOIN vtiger_invoicecf as aif on aif.invoiceid = ai.invoiceid 
 LEFT JOIN vtiger_accountscf as accf on ai.accountid = accf.accountid
 WHERE YEAR(aif.j_fechaemision) >=2023 and (accf.sales_sync!=1 OR accf.sales_sync is NULL) 
group by ai.accountid HAVING count(*) >=1 order by ai.accountid DESC limit 500;"
<br><br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1132791"
  ["accountid"]=>
  string(7) "1132234"
  ["subtotal"]=>
  string(13) "7441.35000000"
  ["total"]=>
  string(13) "8631.97000000"
  ["subtotal_usd"]=>
  string(16) "403.872455902307"
  ["total_usd"]=>
  string(16) "468.492265943012"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(7) "1132234"
  ["2last"]=>
  float(0)
  ["1last"]=>
  float(0)
  ["actual"]=>
  float(404)
}
update vtiger_accountscf set sales_current='404.00', sales_1last='0.00', sales_2last='0.00', sales_dt_sync='2026-10-25 10:27:21', sales_sync=1 where accountid=1132234;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1132334"
  ["accountid"]=>
  string(7) "1132045"
  ["subtotal"]=>
  string(14) "11945.32000000"
  ["total"]=>
  string(14) "13856.57000000"
  ["subtotal_usd"]=>
  string(16) "648.321302578019"
  ["total_usd"]=>
  string(16) "752.052645861601"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(7) "1132045"
  ["2last"]=>
  float(0)
  ["1last"]=>
  float(0)
  ["actual"]=>
  float(648)
}
update vtiger_accountscf set sales_current='648.00', sales_1last='0.00', sales_2last='0.00', sales_dt_sync='2026-10-25 10:27:21', sales_sync=1 where accountid=1132045;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1132405"
  ["accountid"]=>
  string(7) "1131988"
  ["subtotal"]=>
  string(14) "17702.11000000"
  ["total"]=>
  string(14) "20534.45000000"
  ["subtotal_usd"]=>
  string(16) "960.765807327001"
  ["total_usd"]=>
  string(17) "1114.488466757123"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(7) "1131988"
  ["2last"]=>
  float(0)
  ["1last"]=>
  float(0)
  ["actual"]=>
  float(961)
}
update vtiger_accountscf set sales_current='961.00', sales_1last='0.00', sales_2last='0.00', sales_dt_sync='2026-10-25 10:27:21', sales_sync=1 where accountid=1131988;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1133194"
  ["accountid"]=>
  string(7) "1131301"
  ["subtotal"]=>
  string(13) "9869.59000000"
  ["total"]=>
  string(14) "11448.72000000"
  ["subtotal_usd"]=>
  string(16) "535.808360477742"
  ["total_usd"]=>
  string(16) "621.537459283388"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(7) "1131301"
  ["2last"]=>
  float(0)
  ["1last"]=>
  float(0)
  ["actual"]=>
  float(536)
}
update vtiger_accountscf set sales_current='536.00', sales_1last='0.00', sales_2last='0.00', sales_dt_sync='2026-10-25 10:27:21', sales_sync=1 where accountid=1131301;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1132815"
  ["accountid"]=>
  string(7) "1128403"
  ["subtotal"]=>
  string(12) "387.03000000"
  ["total"]=>
  string(12) "448.95000000"
  ["subtotal_usd"]=>
  string(16) "387.030000000000"
  ["total_usd"]=>
  string(16) "448.950000000000"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(7) "1128403"
  ["2last"]=>
  float(0)
  ["1last"]=>
  float(0)
  ["actual"]=>
  float(387)
}
update vtiger_accountscf set sales_current='387.00', sales_1last='0.00', sales_2last='0.00', sales_dt_sync='2026-10-25 10:27:21', sales_sync=1 where accountid=1128403;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1132833"
  ["accountid"]=>
  string(7) "1107504"
  ["subtotal"]=>
  string(14) "28350.40000000"
  ["total"]=>
  string(14) "32886.46000000"
  ["subtotal_usd"]=>
  string(17) "1539.109663409338"
  ["total_usd"]=>
  string(17) "1785.366992399566"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(7) "1107504"
  ["2last"]=>
  float(0)
  ["1last"]=>
  float(0)
  ["actual"]=>
  float(1539)
}
update vtiger_accountscf set sales_current='1,539.00', sales_1last='0.00', sales_2last='0.00', sales_dt_sync='2026-10-25 10:27:21', sales_sync=1 where accountid=1107504;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1106765"
  ["accountid"]=>
  string(7) "1105593"
  ["subtotal"]=>
  string(15) "282830.78000000"
  ["total"]=>
  string(15) "328083.70000000"
  ["subtotal_usd"]=>
  string(18) "31834.892224900564"
  ["total_usd"]=>
  string(18) "36928.472059374915"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(7) "1105593"
  ["2last"]=>
  float(0)
  ["1last"]=>
  float(0)
  ["actual"]=>
  float(31835)
}
update vtiger_accountscf set sales_current='31,835.00', sales_1last='0.00', sales_2last='0.00', sales_dt_sync='2026-10-25 10:27:22', sales_sync=1 where accountid=1105593;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1054165"
  ["accountid"]=>
  string(7) "1053450"
  ["subtotal"]=>
  string(15) "119972.29000000"
  ["total"]=>
  string(15) "139167.86000000"
  ["subtotal_usd"]=>
  string(17) "6613.408319614591"
  ["total_usd"]=>
  string(17) "7671.553845445319"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(7) "1053450"
  ["2last"]=>
  float(0)
  ["1last"]=>
  float(0)
  ["actual"]=>
  float(6613)
}
update vtiger_accountscf set sales_current='6,613.00', sales_1last='0.00', sales_2last='0.00', sales_dt_sync='2026-10-25 10:27:22', sales_sync=1 where accountid=1053450;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1027013"
  ["accountid"]=>
  string(7) "1018531"
  ["subtotal"]=>
  string(13) "7211.22000000"
  ["total"]=>
  string(13) "8365.01000000"
  ["subtotal_usd"]=>
  string(17) "7211.220000000000"
  ["total_usd"]=>
  string(17) "8365.010000000000"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1052469"
  ["accountid"]=>
  string(7) "1018531"
  ["subtotal"]=>
  string(15) "151448.41000000"
  ["total"]=>
  string(15) "175680.15000000"
  ["subtotal_usd"]=>
  string(18) "16496.314681649949"
  ["total_usd"]=>
  string(18) "19135.721701979295"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(7) "1018531"
  ["2last"]=>
  float(0)
  ["1last"]=>
  float(7211)
  ["actual"]=>
  float(16496)
}
update vtiger_accountscf set sales_current='16,496.00', sales_1last='7,211.00', sales_2last='0.00', sales_dt_sync='2026-10-25 10:27:22', sales_sync=1 where accountid=1018531;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1022499"
  ["accountid"]=>
  string(7) "1018465"
  ["subtotal"]=>
  string(13) "2481.89000000"
  ["total"]=>
  string(13) "2878.99000000"
  ["subtotal_usd"]=>
  string(17) "2481.890000000000"
  ["total_usd"]=>
  string(17) "2878.990000000000"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1079831"
  ["accountid"]=>
  string(7) "1018465"
  ["subtotal"]=>
  string(13) "4368.00000000"
  ["total"]=>
  string(13) "5066.88000000"
  ["subtotal_usd"]=>
  string(17) "4368.000000000000"
  ["total_usd"]=>
  string(17) "5066.880000000000"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(7) "1018465"
  ["2last"]=>
  float(0)
  ["1last"]=>
  float(2482)
  ["actual"]=>
  float(4368)
}
update vtiger_accountscf set sales_current='4,368.00', sales_1last='2,482.00', sales_2last='0.00', sales_dt_sync='2026-10-25 10:27:22', sales_sync=1 where accountid=1018465;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "966021"
  ["accountid"]=>
  string(6) "965515"
  ["subtotal"]=>
  string(15) "542913.36000000"
  ["total"]=>
  string(15) "629779.50000000"
  ["subtotal_usd"]=>
  string(18) "28655.024098653687"
  ["total_usd"]=>
  string(18) "33239.828069298345"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1058596"
  ["accountid"]=>
  string(6) "965515"
  ["subtotal"]=>
  string(15) "369956.95000000"
  ["total"]=>
  string(15) "429150.07000000"
  ["subtotal_usd"]=>
  string(18) "21091.735875663138"
  ["total_usd"]=>
  string(18) "24466.414062756807"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "965515"
  ["2last"]=>
  float(0)
  ["1last"]=>
  float(28655)
  ["actual"]=>
  float(21092)
}
update vtiger_accountscf set sales_current='21,092.00', sales_1last='28,655.00', sales_2last='0.00', sales_dt_sync='2026-10-25 10:27:22', sales_sync=1 where accountid=965515;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "966183"
  ["accountid"]=>
  string(6) "954185"
  ["subtotal"]=>
  string(15) "335560.67000000"
  ["total"]=>
  string(15) "389250.38000000"
  ["subtotal_usd"]=>
  string(18) "16613.680027542849"
  ["total_usd"]=>
  string(18) "19271.868978623356"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1133301"
  ["accountid"]=>
  string(6) "954185"
  ["subtotal"]=>
  string(15) "437692.20000000"
  ["total"]=>
  string(15) "507722.95000000"
  ["subtotal_usd"]=>
  string(18) "23477.562624041195"
  ["total_usd"]=>
  string(18) "27233.972536608915"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "954185"
  ["2last"]=>
  float(0)
  ["1last"]=>
  float(16614)
  ["actual"]=>
  float(23478)
}
update vtiger_accountscf set sales_current='23,478.00', sales_1last='16,614.00', sales_2last='0.00', sales_dt_sync='2026-10-25 10:27:22', sales_sync=1 where accountid=954185;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "943469"
  ["accountid"]=>
  string(6) "942863"
  ["subtotal"]=>
  string(14) "39546.40000000"
  ["total"]=>
  string(14) "45873.82000000"
  ["subtotal_usd"]=>
  string(17) "1934.755381604697"
  ["total_usd"]=>
  string(17) "2244.316046966732"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1031284"
  ["accountid"]=>
  string(6) "942863"
  ["subtotal"]=>
  string(14) "42294.08000000"
  ["total"]=>
  string(14) "49061.13000000"
  ["subtotal_usd"]=>
  string(17) "2293.605206073753"
  ["total_usd"]=>
  string(17) "2660.581887201735"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1132283"
  ["accountid"]=>
  string(6) "942863"
  ["subtotal"]=>
  string(14) "45111.12000000"
  ["total"]=>
  string(14) "52328.90000000"
  ["subtotal_usd"]=>
  string(17) "2448.364721845319"
  ["total_usd"]=>
  string(17) "2840.103120759837"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "942863"
  ["2last"]=>
  float(1935)
  ["1last"]=>
  float(2294)
  ["actual"]=>
  float(2448)
}
update vtiger_accountscf set sales_current='2,448.00', sales_1last='2,294.00', sales_2last='1,935.00', sales_dt_sync='2026-10-25 10:27:22', sales_sync=1 where accountid=942863;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "946897"
  ["accountid"]=>
  string(6) "941290"
  ["subtotal"]=>
  string(14) "10759.32000000"
  ["total"]=>
  string(14) "12480.81000000"
  ["subtotal_usd"]=>
  string(16) "518.771456123433"
  ["total_usd"]=>
  string(16) "601.774831243973"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1037133"
  ["accountid"]=>
  string(6) "941290"
  ["subtotal"]=>
  string(13) "9670.05000000"
  ["total"]=>
  string(14) "11217.26000000"
  ["subtotal_usd"]=>
  string(16) "519.532047493687"
  ["total_usd"]=>
  string(16) "602.657282544458"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1133043"
  ["accountid"]=>
  string(6) "941290"
  ["subtotal"]=>
  string(13) "9695.70000000"
  ["total"]=>
  string(14) "11247.01000000"
  ["subtotal_usd"]=>
  string(16) "520.071876843856"
  ["total_usd"]=>
  string(16) "603.283269860001"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "941290"
  ["2last"]=>
  float(519)
  ["1last"]=>
  float(520)
  ["actual"]=>
  float(520)
}
update vtiger_accountscf set sales_current='520.00', sales_1last='520.00', sales_2last='519.00', sales_dt_sync='2026-10-25 10:27:22', sales_sync=1 where accountid=941290;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "940539"
  ["accountid"]=>
  string(6) "940113"
  ["subtotal"]=>
  string(14) "33189.49000000"
  ["total"]=>
  string(14) "38499.81000000"
  ["subtotal_usd"]=>
  string(17) "1634.145248645987"
  ["total_usd"]=>
  string(17) "1895.608567208272"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1028491"
  ["accountid"]=>
  string(6) "940113"
  ["subtotal"]=>
  string(14) "45551.30000000"
  ["total"]=>
  string(14) "52839.51000000"
  ["subtotal_usd"]=>
  string(17) "2475.000565955432"
  ["total_usd"]=>
  string(17) "2871.000764914532"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1076293"
  ["accountid"]=>
  string(6) "940113"
  ["subtotal"]=>
  string(14) "44289.68000000"
  ["total"]=>
  string(14) "51376.03000000"
  ["subtotal_usd"]=>
  string(17) "2454.244433335920"
  ["total_usd"]=>
  string(17) "2846.923615358803"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "940113"
  ["2last"]=>
  float(1634)
  ["1last"]=>
  float(2475)
  ["actual"]=>
  float(2454)
}
update vtiger_accountscf set sales_current='2,454.00', sales_1last='2,475.00', sales_2last='1,634.00', sales_dt_sync='2026-10-25 10:27:22', sales_sync=1 where accountid=940113;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "937612"
  ["accountid"]=>
  string(6) "937239"
  ["subtotal"]=>
  string(15) "100223.06000000"
  ["total"]=>
  string(15) "116258.75000000"
  ["subtotal_usd"]=>
  string(17) "4977.799801291605"
  ["total_usd"]=>
  string(17) "5774.247789664798"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1024685"
  ["accountid"]=>
  string(6) "937239"
  ["subtotal"]=>
  string(14) "14405.26000000"
  ["total"]=>
  string(14) "16710.10000000"
  ["subtotal_usd"]=>
  string(16) "783.362879982598"
  ["total_usd"]=>
  string(16) "908.700853771276"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1132052"
  ["accountid"]=>
  string(6) "937239"
  ["subtotal"]=>
  string(14) "14938.56000000"
  ["total"]=>
  string(14) "17328.73000000"
  ["subtotal_usd"]=>
  string(16) "807.795382036446"
  ["total_usd"]=>
  string(16) "937.042664792083"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "937239"
  ["2last"]=>
  float(4978)
  ["1last"]=>
  float(783)
  ["actual"]=>
  float(808)
}
update vtiger_accountscf set sales_current='808.00', sales_1last='783.00', sales_2last='4,978.00', sales_dt_sync='2026-10-25 10:27:22', sales_sync=1 where accountid=937239;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "939413"
  ["accountid"]=>
  string(6) "932570"
  ["subtotal"]=>
  string(14) "36789.92000000"
  ["total"]=>
  string(14) "42676.31000000"
  ["subtotal_usd"]=>
  string(17) "1827.616492796821"
  ["total_usd"]=>
  string(17) "2120.035270740189"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "970684"
  ["accountid"]=>
  string(6) "932570"
  ["subtotal"]=>
  string(15) "221726.43000000"
  ["total"]=>
  string(15) "257202.66000000"
  ["subtotal_usd"]=>
  string(18) "10768.646430305974"
  ["total_usd"]=>
  string(18) "12491.629917435648"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1132392"
  ["accountid"]=>
  string(6) "932570"
  ["subtotal"]=>
  string(13) "6315.99000000"
  ["total"]=>
  string(13) "7326.55000000"
  ["subtotal_usd"]=>
  string(16) "342.794572591588"
  ["total_usd"]=>
  string(16) "397.641791044776"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "932570"
  ["2last"]=>
  float(1828)
  ["1last"]=>
  float(10769)
  ["actual"]=>
  float(343)
}
update vtiger_accountscf set sales_current='343.00', sales_1last='10,769.00', sales_2last='1,828.00', sales_dt_sync='2026-10-25 10:27:22', sales_sync=1 where accountid=932570;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "927906"
  ["accountid"]=>
  string(6) "842699"
  ["subtotal"]=>
  string(13) "4756.95000000"
  ["total"]=>
  string(13) "5518.06000000"
  ["subtotal_usd"]=>
  string(16) "236.899900398406"
  ["total_usd"]=>
  string(16) "274.803784860558"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1033631"
  ["accountid"]=>
  string(6) "842699"
  ["subtotal"]=>
  string(13) "5564.78000000"
  ["total"]=>
  string(13) "6455.14000000"
  ["subtotal_usd"]=>
  string(16) "302.384393848829"
  ["total_usd"]=>
  string(16) "350.765636037603"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1132422"
  ["accountid"]=>
  string(6) "842699"
  ["subtotal"]=>
  string(13) "5972.66000000"
  ["total"]=>
  string(13) "6928.29000000"
  ["subtotal_usd"]=>
  string(16) "324.160651289009"
  ["total_usd"]=>
  string(16) "376.026594301221"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "842699"
  ["2last"]=>
  float(237)
  ["1last"]=>
  float(302)
  ["actual"]=>
  float(324)
}
update vtiger_accountscf set sales_current='324.00', sales_1last='302.00', sales_2last='237.00', sales_dt_sync='2026-10-25 10:27:22', sales_sync=1 where accountid=842699;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "910657"
  ["accountid"]=>
  string(6) "812053"
  ["subtotal"]=>
  string(14) "10149.64000000"
  ["total"]=>
  string(14) "11773.58000000"
  ["subtotal_usd"]=>
  string(16) "558.900881057269"
  ["total_usd"]=>
  string(16) "648.324889867841"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1008170"
  ["accountid"]=>
  string(6) "812053"
  ["subtotal"]=>
  string(14) "30255.07000000"
  ["total"]=>
  string(14) "35095.88000000"
  ["subtotal_usd"]=>
  string(17) "1617.888253561959"
  ["total_usd"]=>
  string(17) "1876.750307201183"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1101863"
  ["accountid"]=>
  string(6) "812053"
  ["subtotal"]=>
  string(14) "42453.93000000"
  ["total"]=>
  string(14) "49246.55000000"
  ["subtotal_usd"]=>
  string(17) "2404.719590830563"
  ["total_usd"]=>
  string(17) "2789.474234177076"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "812053"
  ["2last"]=>
  float(559)
  ["1last"]=>
  float(1618)
  ["actual"]=>
  float(2405)
}
update vtiger_accountscf set sales_current='2,405.00', sales_1last='1,618.00', sales_2last='559.00', sales_dt_sync='2026-10-25 10:27:22', sales_sync=1 where accountid=812053;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "876725"
  ["accountid"]=>
  string(6) "811248"
  ["subtotal"]=>
  string(13) "5300.00000000"
  ["total"]=>
  string(13) "6148.00000000"
  ["subtotal_usd"]=>
  string(16) "306.535569693464"
  ["total_usd"]=>
  string(16) "355.581260844419"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "993857"
  ["accountid"]=>
  string(6) "811248"
  ["subtotal"]=>
  string(14) "14610.00000000"
  ["total"]=>
  string(14) "16947.60000000"
  ["subtotal_usd"]=>
  string(16) "700.719424460432"
  ["total_usd"]=>
  string(16) "812.834532374101"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1097271"
  ["accountid"]=>
  string(6) "811248"
  ["subtotal"]=>
  string(14) "14400.00000000"
  ["total"]=>
  string(14) "16704.00000000"
  ["subtotal_usd"]=>
  string(16) "801.253517009254"
  ["total_usd"]=>
  string(16) "929.454079730735"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "811248"
  ["2last"]=>
  float(307)
  ["1last"]=>
  float(701)
  ["actual"]=>
  float(801)
}
update vtiger_accountscf set sales_current='801.00', sales_1last='701.00', sales_2last='307.00', sales_dt_sync='2026-10-25 10:27:22', sales_sync=1 where accountid=811248;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "874420"
  ["accountid"]=>
  string(6) "801540"
  ["subtotal"]=>
  string(13) "3978.03000000"
  ["total"]=>
  string(13) "4614.51000000"
  ["subtotal_usd"]=>
  string(17) "3978.030000000000"
  ["total_usd"]=>
  string(17) "4614.510000000000"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "970948"
  ["accountid"]=>
  string(6) "801540"
  ["subtotal"]=>
  string(13) "9403.60000000"
  ["total"]=>
  string(14) "10908.18000000"
  ["subtotal_usd"]=>
  string(17) "3962.843340325118"
  ["total_usd"]=>
  string(17) "4596.898484530676"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1066122"
  ["accountid"]=>
  string(6) "801540"
  ["subtotal"]=>
  string(14) "25899.01000000"
  ["total"]=>
  string(14) "30042.88000000"
  ["subtotal_usd"]=>
  string(17) "4359.408117074778"
  ["total_usd"]=>
  string(17) "5056.933146290828"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "801540"
  ["2last"]=>
  float(3978)
  ["1last"]=>
  float(3963)
  ["actual"]=>
  float(4359)
}
update vtiger_accountscf set sales_current='4,359.00', sales_1last='3,963.00', sales_2last='3,978.00', sales_dt_sync='2026-10-25 10:27:23', sales_sync=1 where accountid=801540;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "859102"
  ["accountid"]=>
  string(6) "779316"
  ["subtotal"]=>
  string(15) "957878.76000000"
  ["total"]=>
  string(16) "1111084.83000000"
  ["subtotal_usd"]=>
  string(18) "55506.924373168286"
  ["total_usd"]=>
  string(18) "64333.466974200380"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "955612"
  ["accountid"]=>
  string(6) "779316"
  ["subtotal"]=>
  string(15) "929206.80000000"
  ["total"]=>
  string(16) "1077879.90000000"
  ["subtotal_usd"]=>
  string(18) "49379.672097089338"
  ["total_usd"]=>
  string(18) "57280.415789450714"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1050026"
  ["accountid"]=>
  string(6) "779316"
  ["subtotal"]=>
  string(15) "772125.63000000"
  ["total"]=>
  string(15) "890768.58000000"
  ["subtotal_usd"]=>
  string(18) "71379.375124965593"
  ["total_usd"]=>
  string(18) "77902.883949112888"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "779316"
  ["2last"]=>
  float(55507)
  ["1last"]=>
  float(49380)
  ["actual"]=>
  float(71379)
}
update vtiger_accountscf set sales_current='71,379.00', sales_1last='49,380.00', sales_2last='55,507.00', sales_dt_sync='2026-10-25 10:27:23', sales_sync=1 where accountid=779316;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "878821"
  ["accountid"]=>
  string(6) "762216"
  ["subtotal"]=>
  string(15) "272157.06000000"
  ["total"]=>
  string(15) "315702.19000000"
  ["subtotal_usd"]=>
  string(18) "14213.454053321346"
  ["total_usd"]=>
  string(18) "16487.606742316329"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "967768"
  ["accountid"]=>
  string(6) "762216"
  ["subtotal"]=>
  string(15) "267849.23000000"
  ["total"]=>
  string(15) "310705.11000000"
  ["subtotal_usd"]=>
  string(18) "13556.349031026693"
  ["total_usd"]=>
  string(18) "15725.365045042379"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1058504"
  ["accountid"]=>
  string(6) "762216"
  ["subtotal"]=>
  string(15) "134551.55000000"
  ["total"]=>
  string(15) "156079.80000000"
  ["subtotal_usd"]=>
  string(18) "13231.285136571924"
  ["total_usd"]=>
  string(18) "15348.290868080213"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "762216"
  ["2last"]=>
  float(14213)
  ["1last"]=>
  float(13556)
  ["actual"]=>
  float(13231)
}
update vtiger_accountscf set sales_current='13,231.00', sales_1last='13,556.00', sales_2last='14,213.00', sales_dt_sync='2026-10-25 10:27:23', sales_sync=1 where accountid=762216;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "864402"
  ["accountid"]=>
  string(6) "759095"
  ["subtotal"]=>
  string(15) "350951.79000000"
  ["total"]=>
  string(15) "407104.07000000"
  ["subtotal_usd"]=>
  string(18) "38343.754259491905"
  ["total_usd"]=>
  string(18) "44478.757998726517"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "959304"
  ["accountid"]=>
  string(6) "759095"
  ["subtotal"]=>
  string(14) "40588.67000000"
  ["total"]=>
  string(14) "47082.86000000"
  ["subtotal_usd"]=>
  string(18) "40588.670000000000"
  ["total_usd"]=>
  string(18) "47082.860000000000"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1052274"
  ["accountid"]=>
  string(6) "759095"
  ["subtotal"]=>
  string(15) "101509.38000000"
  ["total"]=>
  string(15) "117750.87000000"
  ["subtotal_usd"]=>
  string(18) "40335.012315293061"
  ["total_usd"]=>
  string(18) "46788.599710307658"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "759095"
  ["2last"]=>
  float(38344)
  ["1last"]=>
  float(40589)
  ["actual"]=>
  float(40335)
}
update vtiger_accountscf set sales_current='40,335.00', sales_1last='40,589.00', sales_2last='38,344.00', sales_dt_sync='2026-10-25 10:27:23', sales_sync=1 where accountid=759095;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1133660"
  ["accountid"]=>
  string(6) "740623"
  ["subtotal"]=>
  string(13) "6065.54000000"
  ["total"]=>
  string(13) "7036.03000000"
  ["subtotal_usd"]=>
  string(16) "324.343083257580"
  ["total_usd"]=>
  string(16) "376.238169081867"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "740623"
  ["2last"]=>
  float(0)
  ["1last"]=>
  float(0)
  ["actual"]=>
  float(324)
}
update vtiger_accountscf set sales_current='324.00', sales_1last='0.00', sales_2last='0.00', sales_dt_sync='2026-10-25 10:27:23', sales_sync=1 where accountid=740623;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "894597"
  ["accountid"]=>
  string(6) "720708"
  ["subtotal"]=>
  string(14) "57318.46000000"
  ["total"]=>
  string(14) "66489.42000000"
  ["subtotal_usd"]=>
  string(17) "2991.326098936435"
  ["total_usd"]=>
  string(17) "3469.938620859081"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1006935"
  ["accountid"]=>
  string(6) "720708"
  ["subtotal"]=>
  string(14) "63639.67000000"
  ["total"]=>
  string(14) "73822.02000000"
  ["subtotal_usd"]=>
  string(17) "3370.745233050847"
  ["total_usd"]=>
  string(17) "3910.064618644068"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1110402"
  ["accountid"]=>
  string(6) "720708"
  ["subtotal"]=>
  string(14) "90903.85000000"
  ["total"]=>
  string(15) "105448.46000000"
  ["subtotal_usd"]=>
  string(17) "5212.433309855856"
  ["total_usd"]=>
  string(17) "6046.422284912091"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "720708"
  ["2last"]=>
  float(2991)
  ["1last"]=>
  float(3371)
  ["actual"]=>
  float(5212)
}
update vtiger_accountscf set sales_current='5,212.00', sales_1last='3,371.00', sales_2last='2,991.00', sales_dt_sync='2026-10-25 10:27:23', sales_sync=1 where accountid=720708;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "906102"
  ["accountid"]=>
  string(6) "720686"
  ["subtotal"]=>
  string(15) "154046.11000000"
  ["total"]=>
  string(15) "178693.49000000"
  ["subtotal_usd"]=>
  string(17) "8394.883378746594"
  ["total_usd"]=>
  string(17) "9738.064850136240"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1004804"
  ["accountid"]=>
  string(6) "720686"
  ["subtotal"]=>
  string(15) "230388.59000000"
  ["total"]=>
  string(15) "267250.76000000"
  ["subtotal_usd"]=>
  string(18) "12136.380491986971"
  ["total_usd"]=>
  string(18) "14078.201138148280"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1050946"
  ["accountid"]=>
  string(6) "720686"
  ["subtotal"]=>
  string(15) "312885.40000000"
  ["total"]=>
  string(15) "362947.07000000"
  ["subtotal_usd"]=>
  string(18) "17718.020608797188"
  ["total_usd"]=>
  string(18) "20552.904234144332"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "720686"
  ["2last"]=>
  float(8395)
  ["1last"]=>
  float(12136)
  ["actual"]=>
  float(17718)
}
update vtiger_accountscf set sales_current='17,718.00', sales_1last='12,136.00', sales_2last='8,395.00', sales_dt_sync='2026-10-25 10:27:23', sales_sync=1 where accountid=720686;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1030913"
  ["accountid"]=>
  string(6) "716556"
  ["subtotal"]=>
  string(12) "298.70000000"
  ["total"]=>
  string(12) "346.49000000"
  ["subtotal_usd"]=>
  string(16) "298.700000000000"
  ["total_usd"]=>
  string(16) "346.490000000000"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1132913"
  ["accountid"]=>
  string(6) "716556"
  ["subtotal"]=>
  string(12) "320.25000000"
  ["total"]=>
  string(12) "371.49000000"
  ["subtotal_usd"]=>
  string(16) "320.250000000000"
  ["total_usd"]=>
  string(16) "371.490000000000"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "716556"
  ["2last"]=>
  float(0)
  ["1last"]=>
  float(299)
  ["actual"]=>
  float(320)
}
update vtiger_accountscf set sales_current='320.00', sales_1last='299.00', sales_2last='0.00', sales_dt_sync='2026-10-25 10:27:23', sales_sync=1 where accountid=716556;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "930617"
  ["accountid"]=>
  string(6) "703492"
  ["subtotal"]=>
  string(14) "69151.81000000"
  ["total"]=>
  string(14) "80216.10000000"
  ["subtotal_usd"]=>
  string(17) "3538.362206713490"
  ["total_usd"]=>
  string(17) "4104.500180363187"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "959244"
  ["accountid"]=>
  string(6) "703492"
  ["subtotal"]=>
  string(15) "382109.48000000"
  ["total"]=>
  string(15) "443246.98000000"
  ["subtotal_usd"]=>
  string(18) "19458.566319610089"
  ["total_usd"]=>
  string(18) "22571.936070545651"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1050941"
  ["accountid"]=>
  string(6) "703492"
  ["subtotal"]=>
  string(15) "552938.34000000"
  ["total"]=>
  string(15) "641408.48000000"
  ["subtotal_usd"]=>
  string(18) "31565.532036807946"
  ["total_usd"]=>
  string(18) "36616.017457588404"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "703492"
  ["2last"]=>
  float(3538)
  ["1last"]=>
  float(19459)
  ["actual"]=>
  float(31566)
}
update vtiger_accountscf set sales_current='31,566.00', sales_1last='19,459.00', sales_2last='3,538.00', sales_dt_sync='2026-10-25 10:27:23', sales_sync=1 where accountid=703492;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "876856"
  ["accountid"]=>
  string(6) "640729"
  ["subtotal"]=>
  string(14) "42291.50000000"
  ["total"]=>
  string(14) "49058.14000000"
  ["subtotal_usd"]=>
  string(18) "42291.500000000000"
  ["total_usd"]=>
  string(18) "49058.140000000000"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "962266"
  ["accountid"]=>
  string(6) "640729"
  ["subtotal"]=>
  string(14) "47293.97000000"
  ["total"]=>
  string(14) "54861.00000000"
  ["subtotal_usd"]=>
  string(18) "47293.970000000000"
  ["total_usd"]=>
  string(18) "54861.000000000000"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1067494"
  ["accountid"]=>
  string(6) "640729"
  ["subtotal"]=>
  string(14) "20239.27000000"
  ["total"]=>
  string(14) "23477.55000000"
  ["subtotal_usd"]=>
  string(18) "20239.270000000000"
  ["total_usd"]=>
  string(18) "23477.550000000000"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "640729"
  ["2last"]=>
  float(42292)
  ["1last"]=>
  float(47294)
  ["actual"]=>
  float(20239)
}
update vtiger_accountscf set sales_current='20,239.00', sales_1last='47,294.00', sales_2last='42,292.00', sales_dt_sync='2026-10-25 10:27:23', sales_sync=1 where accountid=640729;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "901291"
  ["accountid"]=>
  string(6) "616933"
  ["subtotal"]=>
  string(13) "3490.00000000"
  ["total"]=>
  string(13) "4048.40000000"
  ["subtotal_usd"]=>
  string(17) "3490.000000000000"
  ["total_usd"]=>
  string(17) "4048.400000000000"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "964295"
  ["accountid"]=>
  string(6) "616933"
  ["subtotal"]=>
  string(14) "10126.80000000"
  ["total"]=>
  string(14) "11747.09000000"
  ["subtotal_usd"]=>
  string(17) "3190.999075232552"
  ["total_usd"]=>
  string(17) "3701.559036065930"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1056478"
  ["accountid"]=>
  string(6) "616933"
  ["subtotal"]=>
  string(14) "49812.13000000"
  ["total"]=>
  string(14) "57782.08000000"
  ["subtotal_usd"]=>
  string(17) "2821.173616176825"
  ["total_usd"]=>
  string(17) "3272.561907357489"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "616933"
  ["2last"]=>
  float(3490)
  ["1last"]=>
  float(3191)
  ["actual"]=>
  float(2821)
}
update vtiger_accountscf set sales_current='2,821.00', sales_1last='3,191.00', sales_2last='3,490.00', sales_dt_sync='2026-10-25 10:27:23', sales_sync=1 where accountid=616933;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "875848"
  ["accountid"]=>
  string(6) "568735"
  ["subtotal"]=>
  string(13) "7099.79000000"
  ["total"]=>
  string(13) "8235.76000000"
  ["subtotal_usd"]=>
  string(17) "7099.790000000000"
  ["total_usd"]=>
  string(17) "8235.760000000000"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "977141"
  ["accountid"]=>
  string(6) "568735"
  ["subtotal"]=>
  string(13) "6723.84000000"
  ["total"]=>
  string(13) "7799.65000000"
  ["subtotal_usd"]=>
  string(17) "6723.840000000000"
  ["total_usd"]=>
  string(17) "7799.650000000000"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1132530"
  ["accountid"]=>
  string(6) "568735"
  ["subtotal"]=>
  string(13) "2172.24000000"
  ["total"]=>
  string(13) "2519.80000000"
  ["subtotal_usd"]=>
  string(17) "2172.240000000000"
  ["total_usd"]=>
  string(17) "2519.800000000000"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "568735"
  ["2last"]=>
  float(7100)
  ["1last"]=>
  float(6724)
  ["actual"]=>
  float(2172)
}
update vtiger_accountscf set sales_current='2,172.00', sales_1last='6,724.00', sales_2last='7,100.00', sales_dt_sync='2026-10-25 10:27:23', sales_sync=1 where accountid=568735;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "873056"
  ["accountid"]=>
  string(6) "566318"
  ["subtotal"]=>
  string(14) "17465.51000000"
  ["total"]=>
  string(14) "20259.99000000"
  ["subtotal_usd"]=>
  string(17) "1010.150954308849"
  ["total_usd"]=>
  string(17) "1171.775014459225"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "967025"
  ["accountid"]=>
  string(6) "566318"
  ["subtotal"]=>
  string(14) "30921.70000000"
  ["total"]=>
  string(14) "35869.17000000"
  ["subtotal_usd"]=>
  string(17) "1487.349231138876"
  ["total_usd"]=>
  string(17) "1725.325012430911"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1064104"
  ["accountid"]=>
  string(6) "566318"
  ["subtotal"]=>
  string(14) "11051.20000000"
  ["total"]=>
  string(14) "12819.40000000"
  ["subtotal_usd"]=>
  string(17) "1564.122782738891"
  ["total_usd"]=>
  string(17) "1814.387020480188"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "566318"
  ["2last"]=>
  float(1010)
  ["1last"]=>
  float(1487)
  ["actual"]=>
  float(1564)
}
update vtiger_accountscf set sales_current='1,564.00', sales_1last='1,487.00', sales_2last='1,010.00', sales_dt_sync='2026-10-25 10:27:23', sales_sync=1 where accountid=566318;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "909702"
  ["accountid"]=>
  string(6) "464485"
  ["subtotal"]=>
  string(14) "30656.97000000"
  ["total"]=>
  string(14) "35562.09000000"
  ["subtotal_usd"]=>
  string(18) "30656.970000000000"
  ["total_usd"]=>
  string(18) "35562.090000000000"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1000278"
  ["accountid"]=>
  string(6) "464485"
  ["subtotal"]=>
  string(14) "46377.33000000"
  ["total"]=>
  string(14) "53797.67000000"
  ["subtotal_usd"]=>
  string(18) "46377.330000000000"
  ["total_usd"]=>
  string(18) "53797.670000000000"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1067241"
  ["accountid"]=>
  string(6) "464485"
  ["subtotal"]=>
  string(14) "46619.48000000"
  ["total"]=>
  string(14) "54078.60000000"
  ["subtotal_usd"]=>
  string(18) "46619.480000000000"
  ["total_usd"]=>
  string(18) "54078.600000000000"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "464485"
  ["2last"]=>
  float(30657)
  ["1last"]=>
  float(46377)
  ["actual"]=>
  float(46619)
}
update vtiger_accountscf set sales_current='46,619.00', sales_1last='46,377.00', sales_2last='30,657.00', sales_dt_sync='2026-10-25 10:27:23', sales_sync=1 where accountid=464485;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "898390"
  ["accountid"]=>
  string(6) "430030"
  ["subtotal"]=>
  string(14) "54153.76000000"
  ["total"]=>
  string(14) "62818.37000000"
  ["subtotal_usd"]=>
  string(17) "2955.069916943336"
  ["total_usd"]=>
  string(17) "3427.881565967977"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1032616"
  ["accountid"]=>
  string(6) "430030"
  ["subtotal"]=>
  string(14) "27440.12000000"
  ["total"]=>
  string(14) "31830.54000000"
  ["subtotal_usd"]=>
  string(17) "1491.067760691192"
  ["total_usd"]=>
  string(17) "1729.638645872955"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1118322"
  ["accountid"]=>
  string(6) "430030"
  ["subtotal"]=>
  string(14) "54311.04000000"
  ["total"]=>
  string(14) "63000.80000000"
  ["subtotal_usd"]=>
  string(17) "3061.698911733280"
  ["total_usd"]=>
  string(17) "3551.570372329856"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "430030"
  ["2last"]=>
  float(2955)
  ["1last"]=>
  float(1491)
  ["actual"]=>
  float(3062)
}
update vtiger_accountscf set sales_current='3,062.00', sales_1last='1,491.00', sales_2last='2,955.00', sales_dt_sync='2026-10-25 10:27:24', sales_sync=1 where accountid=430030;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1133277"
  ["accountid"]=>
  string(6) "403766"
  ["subtotal"]=>
  string(13) "7497.21000000"
  ["total"]=>
  string(13) "8696.76000000"
  ["subtotal_usd"]=>
  string(16) "402.146113822883"
  ["total_usd"]=>
  string(16) "466.489298932575"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "403766"
  ["2last"]=>
  float(0)
  ["1last"]=>
  float(0)
  ["actual"]=>
  float(402)
}
update vtiger_accountscf set sales_current='402.00', sales_1last='0.00', sales_2last='0.00', sales_dt_sync='2026-10-25 10:27:24', sales_sync=1 where accountid=403766;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  NULL
  ["accountid"]=>
  NULL
  ["subtotal"]=>
  NULL
  ["total"]=>
  NULL
  ["subtotal_usd"]=>
  NULL
  ["total_usd"]=>
  NULL
  ["anio"]=>
  NULL
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1039572"
  ["accountid"]=>
  string(6) "378799"
  ["subtotal"]=>
  string(14) "48167.68000000"
  ["total"]=>
  string(14) "55874.51000000"
  ["subtotal_usd"]=>
  string(17) "2605.912140229388"
  ["total_usd"]=>
  string(17) "3022.858147587102"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1123321"
  ["accountid"]=>
  string(6) "378799"
  ["subtotal"]=>
  string(15) "222405.63000000"
  ["total"]=>
  string(15) "257990.53000000"
  ["subtotal_usd"]=>
  string(18) "12528.849566764070"
  ["total_usd"]=>
  string(18) "14533.465435605144"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "378799"
  ["2last"]=>
  float(0)
  ["1last"]=>
  float(2606)
  ["actual"]=>
  float(12529)
}
update vtiger_accountscf set sales_current='12,529.00', sales_1last='2,606.00', sales_2last='0.00', sales_dt_sync='2026-10-25 10:27:24', sales_sync=1 where accountid=378799;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "904884"
  ["accountid"]=>
  string(6) "342974"
  ["subtotal"]=>
  string(13) "1709.80000000"
  ["total"]=>
  string(13) "1983.37000000"
  ["subtotal_usd"]=>
  string(17) "1709.800000000000"
  ["total_usd"]=>
  string(17) "1983.370000000000"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "959373"
  ["accountid"]=>
  string(6) "342974"
  ["subtotal"]=>
  string(13) "2338.10000000"
  ["total"]=>
  string(13) "2712.19000000"
  ["subtotal_usd"]=>
  string(17) "2338.100000000000"
  ["total_usd"]=>
  string(17) "2712.190000000000"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1053075"
  ["accountid"]=>
  string(6) "342974"
  ["subtotal"]=>
  string(13) "2547.73000000"
  ["total"]=>
  string(13) "2955.36000000"
  ["subtotal_usd"]=>
  string(17) "2547.730000000000"
  ["total_usd"]=>
  string(17) "2955.360000000000"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "342974"
  ["2last"]=>
  float(1710)
  ["1last"]=>
  float(2338)
  ["actual"]=>
  float(2548)
}
update vtiger_accountscf set sales_current='2,548.00', sales_1last='2,338.00', sales_2last='1,710.00', sales_dt_sync='2026-10-25 10:27:24', sales_sync=1 where accountid=342974;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "868723"
  ["accountid"]=>
  string(6) "180028"
  ["subtotal"]=>
  string(15) "134708.64000000"
  ["total"]=>
  string(15) "156262.03000000"
  ["subtotal_usd"]=>
  string(18) "54383.898570598489"
  ["total_usd"]=>
  string(18) "63085.329941894248"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "974292"
  ["accountid"]=>
  string(6) "180028"
  ["subtotal"]=>
  string(14) "19699.71000000"
  ["total"]=>
  string(14) "22851.65000000"
  ["subtotal_usd"]=>
  string(18) "19699.710000000000"
  ["total_usd"]=>
  string(18) "22851.650000000000"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1058786"
  ["accountid"]=>
  string(6) "180028"
  ["subtotal"]=>
  string(15) "208526.26000000"
  ["total"]=>
  string(15) "241890.46000000"
  ["subtotal_usd"]=>
  string(18) "55718.498007882112"
  ["total_usd"]=>
  string(18) "64633.456089143250"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "180028"
  ["2last"]=>
  float(54384)
  ["1last"]=>
  float(19700)
  ["actual"]=>
  float(55718)
}
update vtiger_accountscf set sales_current='55,718.00', sales_1last='19,700.00', sales_2last='54,384.00', sales_dt_sync='2026-10-25 10:27:24', sales_sync=1 where accountid=180028;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "882783"
  ["accountid"]=>
  string(6) "172648"
  ["subtotal"]=>
  string(13) "8031.44000000"
  ["total"]=>
  string(13) "9316.47000000"
  ["subtotal_usd"]=>
  string(17) "4147.020781990521"
  ["total_usd"]=>
  string(17) "4810.548222748815"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "980913"
  ["accountid"]=>
  string(6) "172648"
  ["subtotal"]=>
  string(13) "5297.08000000"
  ["total"]=>
  string(13) "6144.61000000"
  ["subtotal_usd"]=>
  string(17) "5297.080000000000"
  ["total_usd"]=>
  string(17) "6144.610000000000"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1071079"
  ["accountid"]=>
  string(6) "172648"
  ["subtotal"]=>
  string(13) "6315.75000000"
  ["total"]=>
  string(13) "7326.27000000"
  ["subtotal_usd"]=>
  string(17) "6315.750000000000"
  ["total_usd"]=>
  string(17) "7326.270000000000"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "172648"
  ["2last"]=>
  float(4147)
  ["1last"]=>
  float(5297)
  ["actual"]=>
  float(6316)
}
update vtiger_accountscf set sales_current='6,316.00', sales_1last='5,297.00', sales_2last='4,147.00', sales_dt_sync='2026-10-25 10:27:24', sales_sync=1 where accountid=172648;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "921702"
  ["accountid"]=>
  string(6) "169938"
  ["subtotal"]=>
  string(14) "51110.95000000"
  ["total"]=>
  string(14) "59288.70000000"
  ["subtotal_usd"]=>
  string(17) "2561.860968946572"
  ["total_usd"]=>
  string(17) "2971.758627572033"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1012275"
  ["accountid"]=>
  string(6) "169938"
  ["subtotal"]=>
  string(15) "104720.73000000"
  ["total"]=>
  string(15) "121476.05000000"
  ["subtotal_usd"]=>
  string(17) "5606.138787011601"
  ["total_usd"]=>
  string(17) "6503.121161238619"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1108385"
  ["accountid"]=>
  string(6) "169938"
  ["subtotal"]=>
  string(14) "80646.60000000"
  ["total"]=>
  string(14) "93550.05000000"
  ["subtotal_usd"]=>
  string(17) "4538.676836446102"
  ["total_usd"]=>
  string(17) "5264.864797504404"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "169938"
  ["2last"]=>
  float(2562)
  ["1last"]=>
  float(5606)
  ["actual"]=>
  float(4539)
}
update vtiger_accountscf set sales_current='4,539.00', sales_1last='5,606.00', sales_2last='2,562.00', sales_dt_sync='2026-10-25 10:27:24', sales_sync=1 where accountid=169938;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "878300"
  ["accountid"]=>
  string(6) "159779"
  ["subtotal"]=>
  string(14) "31956.10000000"
  ["total"]=>
  string(14) "37069.08000000"
  ["subtotal_usd"]=>
  string(17) "1658.196172351103"
  ["total_usd"]=>
  string(17) "1923.507787602523"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "968039"
  ["accountid"]=>
  string(6) "159779"
  ["subtotal"]=>
  string(14) "45864.89000000"
  ["total"]=>
  string(14) "53203.28000000"
  ["subtotal_usd"]=>
  string(17) "2332.593685708717"
  ["total_usd"]=>
  string(17) "2705.809060775091"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1060441"
  ["accountid"]=>
  string(6) "159779"
  ["subtotal"]=>
  string(14) "38007.47000000"
  ["total"]=>
  string(14) "44088.66000000"
  ["subtotal_usd"]=>
  string(17) "2140.942575128437"
  ["total_usd"]=>
  string(17) "2483.493097818185"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(6) "159779"
  ["2last"]=>
  float(1658)
  ["1last"]=>
  float(2333)
  ["actual"]=>
  float(2141)
}
update vtiger_accountscf set sales_current='2,141.00', sales_1last='2,333.00', sales_2last='1,658.00', sales_dt_sync='2026-10-25 10:27:24', sales_sync=1 where accountid=159779;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "858711"
  ["accountid"]=>
  string(5) "61591"
  ["subtotal"]=>
  string(15) "254662.22000000"
  ["total"]=>
  string(15) "295408.17000000"
  ["subtotal_usd"]=>
  string(18) "13543.346281197984"
  ["total_usd"]=>
  string(18) "15710.281443721811"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "987891"
  ["accountid"]=>
  string(5) "61591"
  ["subtotal"]=>
  string(15) "299686.26000000"
  ["total"]=>
  string(15) "347636.07000000"
  ["subtotal_usd"]=>
  string(18) "15567.459726345285"
  ["total_usd"]=>
  string(18) "18058.253726779440"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1061173"
  ["accountid"]=>
  string(5) "61591"
  ["subtotal"]=>
  string(15) "319781.22000000"
  ["total"]=>
  string(15) "370946.22000000"
  ["subtotal_usd"]=>
  string(18) "17939.558097650217"
  ["total_usd"]=>
  string(18) "20809.887669758548"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(5) "61591"
  ["2last"]=>
  float(13543)
  ["1last"]=>
  float(15567)
  ["actual"]=>
  float(17940)
}
update vtiger_accountscf set sales_current='17,940.00', sales_1last='15,567.00', sales_2last='13,543.00', sales_dt_sync='2026-10-25 10:27:24', sales_sync=1 where accountid=61591;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "905649"
  ["accountid"]=>
  string(5) "20424"
  ["subtotal"]=>
  string(14) "43281.78000000"
  ["total"]=>
  string(14) "50206.86000000"
  ["subtotal_usd"]=>
  string(17) "2353.549755301794"
  ["total_usd"]=>
  string(17) "2730.117455138662"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1004809"
  ["accountid"]=>
  string(5) "20424"
  ["subtotal"]=>
  string(14) "48843.56000000"
  ["total"]=>
  string(14) "56658.53000000"
  ["subtotal_usd"]=>
  string(17) "2554.579497907950"
  ["total_usd"]=>
  string(17) "2963.312238493724"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1092015"
  ["accountid"]=>
  string(5) "20424"
  ["subtotal"]=>
  string(14) "74016.42000000"
  ["total"]=>
  string(14) "85859.05000000"
  ["subtotal_usd"]=>
  string(17) "4168.105067356175"
  ["total_usd"]=>
  string(17) "4835.002037948447"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(5) "20424"
  ["2last"]=>
  float(2354)
  ["1last"]=>
  float(2555)
  ["actual"]=>
  float(4168)
}
update vtiger_accountscf set sales_current='4,168.00', sales_1last='2,555.00', sales_2last='2,354.00', sales_dt_sync='2026-10-25 10:27:24', sales_sync=1 where accountid=20424;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "864979"
  ["accountid"]=>
  string(4) "6315"
  ["subtotal"]=>
  string(16) "1424356.91000000"
  ["total"]=>
  string(16) "1652254.01000000"
  ["subtotal_usd"]=>
  string(18) "76164.536059776960"
  ["total_usd"]=>
  string(18) "88350.861524936088"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "962891"
  ["accountid"]=>
  string(4) "6315"
  ["subtotal"]=>
  string(16) "1341732.02000000"
  ["total"]=>
  string(16) "1556409.14000000"
  ["subtotal_usd"]=>
  string(18) "70461.319810419263"
  ["total_usd"]=>
  string(18) "81735.130809116416"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1053157"
  ["accountid"]=>
  string(4) "6315"
  ["subtotal"]=>
  string(16) "1587636.56000000"
  ["total"]=>
  string(16) "1841658.41000000"
  ["subtotal_usd"]=>
  string(18) "89407.998336824404"
  ["total_usd"]=>
  string(19) "103713.278109266559"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(4) "6315"
  ["2last"]=>
  float(76165)
  ["1last"]=>
  float(70461)
  ["actual"]=>
  float(89408)
}
update vtiger_accountscf set sales_current='89,408.00', sales_1last='70,461.00', sales_2last='76,165.00', sales_dt_sync='2026-10-25 10:27:24', sales_sync=1 where accountid=6315;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "858490"
  ["accountid"]=>
  string(4) "5889"
  ["subtotal"]=>
  string(15) "192069.19000000"
  ["total"]=>
  string(15) "222800.25000000"
  ["subtotal_usd"]=>
  string(19) "112226.684005209374"
  ["total_usd"]=>
  string(19) "130182.967262767885"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "955210"
  ["accountid"]=>
  string(4) "5889"
  ["subtotal"]=>
  string(15) "162399.21000000"
  ["total"]=>
  string(15) "188383.04000000"
  ["subtotal_usd"]=>
  string(19) "162399.210000000000"
  ["total_usd"]=>
  string(19) "188383.040000000000"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1049989"
  ["accountid"]=>
  string(4) "5889"
  ["subtotal"]=>
  string(15) "182254.31000000"
  ["total"]=>
  string(15) "211414.99000000"
  ["subtotal_usd"]=>
  string(19) "182254.310000000000"
  ["total_usd"]=>
  string(19) "211414.990000000000"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(4) "5889"
  ["2last"]=>
  float(112227)
  ["1last"]=>
  float(162399)
  ["actual"]=>
  float(182254)
}
update vtiger_accountscf set sales_current='182,254.00', sales_1last='162,399.00', sales_2last='112,227.00', sales_dt_sync='2026-10-25 10:27:24', sales_sync=1 where accountid=5889;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "862900"
  ["accountid"]=>
  string(4) "3958"
  ["subtotal"]=>
  string(15) "483399.22000000"
  ["total"]=>
  string(15) "560743.11000000"
  ["subtotal_usd"]=>
  string(18) "32571.714269664062"
  ["total_usd"]=>
  string(18) "37783.191221416630"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "958998"
  ["accountid"]=>
  string(4) "3958"
  ["subtotal"]=>
  string(15) "419943.74000000"
  ["total"]=>
  string(15) "487134.74000000"
  ["subtotal_usd"]=>
  string(18) "21967.744788918218"
  ["total_usd"]=>
  string(18) "25482.584062076684"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1054194"
  ["accountid"]=>
  string(4) "3958"
  ["subtotal"]=>
  string(15) "534672.17000000"
  ["total"]=>
  string(15) "620219.71000000"
  ["subtotal_usd"]=>
  string(18) "30106.152816349012"
  ["total_usd"]=>
  string(18) "34923.136867600877"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(4) "3958"
  ["2last"]=>
  float(32572)
  ["1last"]=>
  float(21968)
  ["actual"]=>
  float(30106)
}
update vtiger_accountscf set sales_current='30,106.00', sales_1last='21,968.00', sales_2last='32,572.00', sales_dt_sync='2026-10-25 10:27:24', sales_sync=1 where accountid=3958;<br>object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "898970"
  ["accountid"]=>
  string(3) "822"
  ["subtotal"]=>
  string(13) "1200.00000000"
  ["total"]=>
  string(13) "1392.00000000"
  ["subtotal_usd"]=>
  string(17) "1200.000000000000"
  ["total_usd"]=>
  string(17) "1392.000000000000"
  ["anio"]=>
  string(4) "2024"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(6) "990800"
  ["accountid"]=>
  string(3) "822"
  ["subtotal"]=>
  string(12) "700.00000000"
  ["total"]=>
  string(12) "812.00000000"
  ["subtotal_usd"]=>
  string(16) "700.000000000000"
  ["total_usd"]=>
  string(16) "812.000000000000"
  ["anio"]=>
  string(4) "2025"
}
object(stdClass)#6 (7) {
  ["invoiceid"]=>
  string(7) "1091068"
  ["accountid"]=>
  string(3) "822"
  ["subtotal"]=>
  string(13) "1096.50000000"
  ["total"]=>
  string(13) "1271.94000000"
  ["subtotal_usd"]=>
  string(17) "1096.500000000000"
  ["total_usd"]=>
  string(17) "1271.940000000000"
  ["anio"]=>
  string(4) "2026"
}
array(4) {
  ["id"]=>
  string(3) "822"
  ["2last"]=>
  float(1200)
  ["1last"]=>
  float(700)
  ["actual"]=>
  float(1097)
}
update vtiger_accountscf set sales_current='1,097.00', sales_1last='700.00', sales_2last='1,200.00', sales_dt_sync='2026-10-25 10:27:24', sales_sync=1 where accountid=822;<br>