/** * Get balance by creditor & invoice * * @param integer $creditorNo * @param integer $invoiceNo * * @return bool|float */ public function getBalanceByInvoice($creditorNo, $invoiceNo) { $criteria = new Criteria(); $criteria->setTable('CREOPP')->setSelect('SALDO')->setWheres("FACT\tCRE")->setOperators("=\t=")->setValues(sprintf("%s\t%s", $invoiceNo, $creditorNo))->setOrderBy('SALDO')->setMaxResults(0)->setPageSize(1)->setPage(1); $response = $this->getResults($criteria); $data = json_decode(json_encode($response->getData())); return isset($data->DATA->SALDO) ? (double) $data->DATA->SALDO : false; }