Warning: include(../connect.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\bk_ps_summary_sku.php on line 12
Warning: include() [function.include]: Failed opening '../connect.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\bk_ps_summary_sku.php on line 12
Warning: include(../function.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\bk_ps_summary_sku.php on line 13
Warning: include() [function.include]: Failed opening '../function.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\bk_ps_summary_sku.php on line 13
SELECT
as MN,
as YR,
ol.OBITNO AS ITEMNO,
ol.OBITDS AS ITEMNAME,
CONVERT(DECIMAL(10,2),(sum(ol.OBORQT)/(select max(un.MUCOFA) from MVXJDTA.MITAUN as un where ol.OBITNO=un.MUITNO))) as QTY,
CONVERT(DECIMAL(10,2),sum(ol.OBORQA*ol.OBNEPR)) AS NET_AMOUNT,
'' as CH
FROM MVXJDTA.OOHEAD AS oh
INNER JOIN MVXJDTA.OOLINE AS ol ON oh.OAORNO = ol.OBORNO
INNER JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO
WHERE (oh.OAORDT LIKE '%') AND
(oh.OAORTP IN ('021','921','031','035','051','011','911','041','941')) 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.OBITNO,ol.OBITDS
ORDER BY ol.OBITNO ASC
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in E:\www\mobile\no\_ps\bk_ps_summary_sku.php on line 56
SUMMARY
MN |
YR |
ITEMNO |
ITEMNAME |
QTY |
NET_AMOUNT |
CHANNEL |
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in E:\www\mobile\no\_ps\bk_ps_summary_sku.php on line 71
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in E:\www\mobile\no\_ps\bk_ps_summary_sku.php on line 73
|
| TOTAL |
|
|
|
0.00 |
0.00 |
|