SELECT oh.OASMCD+''+cm.JUTX40 as SALEMAN,
CONVERT(DECIMAL(10,2),sum(oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100))) AS TOT_AMT,
CONVERT(DECIMAL(10,2),sum(oh.OANTLA*oh.OAOTDP/100)) AS DIS_AMOUNT,
CONVERT(DECIMAL(10,2),(select sum(ol.OBNEPR) from MVXJDTA.OOLINE as ol where (((ol.OBITDS like 'DIS%') or (ol.OBITDS like 'PRO%')) and (oh.OASMCD=ol.OBSMCD)) and (ol.OBRGDT like '%'))) as DISCOUNT_LINE,
CASE
WHEN ((oh.OASMCD like '1%') AND (oh.OASMCD not in('10001','10034'))) THEN 'CREDIT'
WHEN ((oh.OASMCD like '1%') AND (oh.OASMCD in('10001','10034'))) THEN 'MT'
WHEN (oh.OASMCD like '2%') THEN 'CASH'
WHEN (oh.OASMCD like '3%') THEN 'PC'
WHEN (oh.OASMCD like '4%') THEN 'IDS'
END AS CHANNEL
FROM MVXJDTA.OOHEAD AS oh
INNER JOIN MVXJDTA.CMNUSR AS cm ON oh.OASMCD = cm.JUUSID
WHERE (oh.OAORDT LIKE '%') AND
(((oh.OAORST BETWEEN '22' AND '77') OR (oh.OAORST IN ('99'))) AND (oh.OAORSL NOT IN ('99'))) AND
(oh.OAORTP IN ('021', '921', '011', '911', '041', '941', '051', '031', '035','034','281','A31'))
AND (oh.OASMCD not in('11000','30001','30002','30003','30004'))
GROUP BY oh.OASMCD,cm.JUTX40
ORDER BY oh.OASMCD ASC
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting numeric to data type numeric., SQL state 22003 in SQLExecDirect in E:\www\Nouse_delete\mango\ps\bk_ps_rpt_sales_person_all.php on line 50
SUMMARY
SALEMAN |
AMOUNT |
DISCOUNT_LINE |
TOT_AMOUNT |
CHANNEL |
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting numeric to data type numeric., SQL state 22003 in SQLExecDirect in E:\www\Nouse_delete\mango\ps\bk_ps_rpt_sales_person_all.php on line 65
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in E:\www\Nouse_delete\mango\ps\bk_ps_rpt_sales_person_all.php on line 67
|
| TOTAL |
0.00 |
0.00 |
0.00 |
|