Notice: Undefined index: start in C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getSales.php on line 8
Notice: Undefined index: scenario in C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getSales.php on line 9
Notice: Undefined index: RID in C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getSales.php on line 10
Error in executing query. SELECT
dbo.custtable.accountnum AS 'IDCode',
dbo.custtable.accountnum + ' ' + dbo.custtable.NAME AS Codigo,
CONVERT(varchar(20),
dbo.salestable.createddate
,20) AS CreatedOn,
Isnull(
SUM (
dbo.custinvoicejour.invoiceamountmst
),
0
) AS Amount
,'' AS CreatedBy
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 = ) AND ( dbo.custinvoicejour.salesgroup = )
GROUP BY
dbo.custtable.accountnum,
dbo.custtable.NAME,
dbo.custinvoicejour.salesgroup,
dbo.custinvoicejour.invoicedate,
dbo.custinvoicejour.dataareaid,
dbo.salestable.createddate,
dbo.custtable.accountnum + ' ' + dbo.custtable.NAMEArray
(
[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 ')'.
)
)