<br />
<b>Notice</b>:  Undefined index: journal in <b>C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getInvoiceHour.php</b> on line <b>8</b><br />
<br />
<b>Notice</b>:  Undefined index: scenario in <b>C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getInvoiceHour.php</b> on line <b>9</b><br />
Error in executing query. SELECT
      CONVERT(varchar(20),
  DATEADD(
    HOUR,
    CAST (
      sales.HORAENTREGAREPARTIDOR AS DECIMAL (12, 4)
    ) / 3600,
    sales.fechaentregarepartidor
  ), 20) as AS 'DATE'
FROM
  salesshippingstat sales
INNER JOIN salesshippingjour ON sales.snentfact = salesshippingjour.snentfact
AND sales.dataareaid = salesshippingjour.dataareaid
INNER JOIN salestable ON sales.salesid = salestable.salesid
AND sales.dataareaid = salestable.dataareaid
INNER JOIN custtable ON salestable.invoiceaccount = custtable.accountnum
AND salestable.dataareaid = custtable.dataareaid
WHERE
  (sales.snentfact != '')
AND sales.DATAAREAID =  AND SALES.INVOICEID=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 'AS'.
            [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'AS'.
        )

)