Notice: Undefined index: start in C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getSalesByCode.php on line 8
Notice: Undefined index: stop in C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getSalesByCode.php on line 9
Notice: Undefined index: scenario in C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getSalesByCode.php on line 10
Notice: Undefined index: IDCode in C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getSalesByCode.php on line 11
Error in executing query. SELECT Isnull(Sum(dbo.custinvoicejour.invoiceamountmst), 0) AS AMOUNT
FROM dbo.custinvoicejour INNER JOIN dbo.custtable ON dbo.custinvoicejour.dataareaid = dbo.custtable.dataareaid AND dbo.custinvoicejour.invoiceaccount = dbo.custtable.accountnum
INNER JOIN dbo.salestable ON dbo.custinvoicejour.salesid = dbo.salestable.salesid AND dbo.custinvoicejour.dataareaid = dbo.salestable.dataareaid
WHERE ( dbo.custinvoicejour.dataareaid = )
AND ( dbo.salestable.createddate between AND )
AND ( dbo.custtable.accountnum = )
GROUP BY dbo.custtable.accountnum, dbo.custinvoicejour.salesgroup, dbo.custinvoicejour.dataareaidArray
(
[0] => Array
(
[0] => 42000
[SQLSTATE] => 42000
[1] => 102
[code] => 102
[2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ')'.
[message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ')'.
)
)