SELECT ol.OBSMCD+''+cm.JUTX40 AS SALENAME,
ol.OBITNO AS ITEMNO,
ol.OBITDS AS ITEMNAME,
CASE WHEN (ol.OBITNO not in('10052001009')) THEN
CONVERT(DECIMAL(10,2),(sum(ol.OBORQT)/(select max(un.MUCOFA) from MVXJDTA.MITAUN as un where ol.OBITNO=un.MUITNO)))
ELSE sum(ol.OBORQT)
END AS QTY,
,
CASE
WHEN ((ol.OBSMCD like '1%') AND (ol.OBSMCD not in('10001','10034'))) THEN 'CREDIT'
WHEN ((ol.OBSMCD like '1%') AND (ol.OBSMCD in('10001','10034'))) THEN 'MT'
WHEN (ol.OBSMCD like '2%') THEN 'CASH'
WHEN (ol.OBSMCD like '3%') THEN 'PC'
WHEN (ol.OBSMCD like '4%') THEN 'IDS'
END AS CHANNEL
FROM MVXJDTA.OOHEAD AS oh
INNER JOIN MVXJDTA.OOLINE AS ol ON oh.OAORNO = ol.OBORNO
INNER JOIN MVXJDTA.OCUSMA AS cu ON oh.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO
INNER JOIN MVXJDTA.CMNUSR as cm ON ol.OBSMCD = cm.JUUSID
WHERE (oh.OAORDT LIKE '%') AND
(oh.OAORTP IN ()) AND
(((oh.OAORST between '22' and '77') OR (oh.OAORST in ('99'))) and (oh.OAORSL not in('99'))) AND
(ol.OBORST not in ('90','99')) AND
(ol.OBSAPR>=1)
AND (ol.OBSMCD not in('11000','30001','30002','30003','30004'))
GROUP BY ol.OBSMCD,cm.JUTX40,ol.OBITNO,ol.OBITDS
ORDER BY ol.OBSMCD,ol.OBITNO ASC
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ','., SQL state 37000 in SQLExecDirect in E:\www\mango\ps\ps_rpt_sales_person_detail.php on line 109
SUMMARY
SALEMAN |
ITEMNO |
ITEMNAME |
QTY |
NETAMOUNT |
CHANNEL |
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ','., SQL state 37000 in SQLExecDirect in E:\www\mango\ps\ps_rpt_sales_person_detail.php on line 126
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in E:\www\mango\ps\ps_rpt_sales_person_detail.php on line 128
|
| TOTAL |
|
|
|
0.00 |
|