SELECT UCSMCD+''+E.JUTX40 as SALEMAN,
SUM(UCSAAM)+SUM(UCDIA1+UCDIA2+UCDIA3+UCDIA4+UCDIA5) as AMOUNT,
SUM(UCDIA1+UCDIA2+UCDIA3+UCDIA4) as DISCOUNT_LINE,
SUM(UCDIA5) as DISCOUNT_HEAD,
SUM(UCSAAM)+ABS(Sum(case when UCITNO like 'DIS%' then UCSAAM+UCDIA5 else 0 end)+Sum(case when UCITNO like 'PRO%' then UCSAAM+UCDIA5 else 0 end)) as NET_AMOUNT
FROM MVXJDTA.OSBSTD A
LEFT JOIN MVXJDTA.OCUSMA D ON A.UCCUNO = D.OKCUNO
LEFT JOIN MVXJDTA.CMNUSR E ON A.UCSMCD = E.JUUSID
WHERE UCIVDT like '%'
AND A.UCCUNO <> '73110139'
AND A.UCORTP IN
GROUP BY UCSMCD,E.JUTX40
ORDER BY UCSMCD
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'GROUP'., SQL state 37000 in SQLExecDirect in E:\www\mango\ps\ps_ac_commission_baht_bk13092017.php on line 111
Report Commission by Amount (Exclude VAT)SaleMan | Discount | NetAmount |
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in E:\www\mango\ps\ps_ac_commission_baht_bk13092017.php on line 123
|---|
| TOTAL | 0.00 | 0.00 |