SELECT 
        cf4you.paymentamount AS payamount_main,
        cf4youcf.cf_1173,
        cf4youcf.cashflow4youid,
        cf4you.paymentdate,
        so.cf_914,
        so.cf_996,
        so.cf_1265
    FROM 
        its4you_cashflow4you AS cf4you
    INNER JOIN 
        its4you_cashflow4youcf AS cf4youcf
        ON cf4you.cashflow4youid = cf4youcf.cashflow4youid
    INNER JOIN 
        vtiger_salesordercf AS so
        ON cf4you.relationid = so.salesorderid
    INNER JOIN 
        vtiger_salesorder AS s
        ON so.salesorderid = s.salesorderid
    WHERE 
        cf4you.cashflow4you_cash = 'WEBPAY' 
        AND so.cf_928 = 'Pagado' 
        AND (cf4youcf.cf_3271 IS NOT NULL) 
        AND cf4youcf.cf_3271 = '' 
        AND s.sostatus != 'Anulado' 
        AND cf4you.paymentdate BETWEEN '2025-01-19' AND '2025-02-20';
string(121) "<?xml version='1.0'?>
<methodResponse>
<params>
<param>
<value><int>7</int></value>
</param>
</params>
</methodResponse>
"
Autenticado con éxito. UID: 7
<br>TOTAL: 0
<br>FIN