Warning: include(../connect.php) [function.include]: failed to open stream: No such file or directory in E:\www\_kpi\ps\nouse\ps_ac_commission_qty.php.bak on line 13
Warning: include() [function.include]: Failed opening '../connect.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\_kpi\ps\nouse\ps_ac_commission_qty.php.bak on line 13
Warning: include(../function.php) [function.include]: failed to open stream: No such file or directory in E:\www\_kpi\ps\nouse\ps_ac_commission_qty.php.bak on line 14
Warning: include() [function.include]: Failed opening '../function.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\_kpi\ps\nouse\ps_ac_commission_qty.php.bak on line 14
SELECT UCSMCD+''+E.JUTX40 as SALEMAN,UCITNO as ITNO,MMITDS as ITNAME,
SUM(UCOFQS) as ALLQTY
FROM MVXJDTA.OSBSTD A
LEFT JOIN MVXJDTA.OCUSMA D ON A.UCCUNO = D.OKCUNO
LEFT JOIN MVXJDTA.CMNUSR E ON A.UCSMCD = E.JUUSID
LEFT JOIN MVXJDTA.MITMAS F ON A.UCITNO = F.MMITNO
WHERE UCIVDT like '%'
AND A.UCCUNO <> '73110139'
AND A.UCSAAM<>0
AND A.UCORTP IN
AND A.UCITNO NOT IN('VARY','DC01')
GROUP BY UCSMCD,E.JUTX40,UCITNO,MMITDS
ORDER BY UCSMCD
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in E:\www\_kpi\ps\nouse\ps_ac_commission_qty.php.bak on line 97
Report Commission by QuantitySaleMan | ItemNo | ItemName | Qty |
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in E:\www\_kpi\ps\nouse\ps_ac_commission_qty.php.bak on line 109
|---|
| TOTAL | | | 0.00 |