Warning: include(../connect_mysql.php) [function.include]: failed to open stream: No such file or directory in E:\www\_kpi\ps\nouse\ps_show_cust11sku.php on line 32
Warning: include() [function.include]: Failed opening '../connect_mysql.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\_kpi\ps\nouse\ps_show_cust11sku.php on line 32
Warning: include(../connect.php) [function.include]: failed to open stream: No such file or directory in E:\www\_kpi\ps\nouse\ps_show_cust11sku.php on line 33
Warning: include() [function.include]: Failed opening '../connect.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\_kpi\ps\nouse\ps_show_cust11sku.php on line 33
Warning: include(../function.php) [function.include]: failed to open stream: No such file or directory in E:\www\_kpi\ps\nouse\ps_show_cust11sku.php on line 34
Warning: include() [function.include]: Failed opening '../function.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\_kpi\ps\nouse\ps_show_cust11sku.php on line 34
Warning: include(../trip_config.php) [function.include]: failed to open stream: No such file or directory in E:\www\_kpi\ps\nouse\ps_show_cust11sku.php on line 35
Warning: include() [function.include]: Failed opening '../trip_config.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\_kpi\ps\nouse\ps_show_cust11sku.php on line 35
CA
select cu.OKCUNO,cu.OKCUNM,
Sum(case when ol.OBRGDT LIKE '%' AND OBNEPR > 0 AND OAORDT like '%' AND then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY_SALE],
Sum(case when ol.OBRGDT LIKE '%' AND OBNEPR < 0 AND OAORDT like '%' AND then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY_CN],
Sum(case when ol.OBRGDT LIKE '%' AND OAORDT like '%' AND then CONVERT(DECIMAL(10,2),ol.OBORQA) else 0 end) [TOTAL_QTY]
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO
where OAORDT like '%' AND (st.OAORTP IN ('A31')) and and OKSDST='' and OBNEPR >='1'
AND OBORST NOT IN ('90','99')
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OAORSL NOT IN ('90','99')
GROUP BY cu.OKCUNO,cu.OKCUNM
ORDER BY cu.OKCUNO
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in E:\www\_kpi\ps\nouse\ps_show_cust11sku.php on line 202
Distribution ร้านค้า สินค้ากลุ่ม :
storeCode |
storeName |
จำนวนหีบ
ขาย |
จำนวนหีบ
รับคืน |
จำนวนหีบ หลังหักรับคืน |
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in E:\www\_kpi\ps\nouse\ps_show_cust11sku.php on line 215
| รวม Carton | | | 0.00 | 0.00 |
รวมร้านค้าที่ขาย : ร้านค้า (ร้านค้าที่ยอด จำนวนหีบ หลังหักรับคืน ติดลบจะไม่นำมาคิดรวม)
รวมจำนวนสินค้าที่ขายหลังหักสินค้ารับคืน : 0.00 หีบ