<br />
<b>Notice</b>:  Undefined index: start in <b>C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getCollect.php</b> on line <b>8</b><br />
<br />
<b>Notice</b>:  Undefined index: scenario in <b>C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getCollect.php</b> on line <b>9</b><br />
<br />
<b>Notice</b>:  Undefined index: RID in <b>C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getCollect.php</b> on line <b>10</b><br />
Error in executing query. SELECT
  trans.ACCOUNTNUM AS 'IDCode',
  trans.ACCOUNTNUM + ' ' + cust.NAME AS 'Codigo',
   CONVERT(varchar(20),
   TRANSDATE
  ,20) AS 'CreatedOn',
  CAST (AMOUNTCUR AS VARCHAR) AS 'Amount',
  trans.CREATEDBY as 'CreatedBy'
FROM
  dbo.CUSTTRANS trans
INNER JOIN dbo.custtable cust ON cust.dataareaid = trans.dataareaid
AND trans.ACCOUNTNUM = cust.ACCOUNTNUM 
WHERE
  TRANSDATE = 
AND VOUCHER LIKE 'RB%'
AND trans.DIMENSION2_ = 
AND trans.DATAAREAID = Array
(
    [0] => Array
        (
            [0] => 42000
            [SQLSTATE] => 42000
            [1] => 156
            [code] => 156
            [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'AND'.
            [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'AND'.
        )

)