期初在产品成本调整单,过滤条件勾选后,查询报错!!
金蝶云社区-LT_zhengjiayunxia
LT_zhengjiayunxia
0人赞赏了该文章 762次浏览 未经作者许可,禁止转载编辑于2016年12月06日 12:03:00
6.1版本,9月份补丁,期初在产品成本调整单,过滤条件勾选后,查询报错,请解决!



SELECT * FROM (SELECT t0.FBILLNO FBILLNO, t0.FDOCUMENTSTATUS FDOCUMENTSTATUS, t0.FYEAR FYEAR, t0.FPERIOD FPERIOD, t1.FPROORDERTYPE FPROORDERTYPE, t1.FPROORDERNO FPROORDERNO, t1.FPROORDERSEQ FPROORDERSEQ, t1.FCOSTCENTERID FCOSTCENTERID_ID, t1.FPRODUCTID FPRODUCTID_ID, t1.FUNITID FUNITID_ID, t1.FINITADJQTY FINITINPROQTY, t1.FCOSTITEMID FCOSTITEMID_ID, t1.FINITADJAMOUNT FINITINPROAMOUNT, t2.FMATERIALID FMATERIALID_ID, t2.FSTOCKID FSTOCKID_ID, t2.FSTOCKLOCID FSTOCKLOCID, st28.FF102029 FF102029_FSTOCKLOCID_ID, st28.FF102033 FF102033_FSTOCKLOCID_ID, st28.FF102501 FF102501_FSTOCKLOCID_ID, st28.FF103502 FF103502_FSTOCKLOCID_ID, st28.FF103001 FF103001_FSTOCKLOCID_ID, st28.FF103501 FF103501_FSTOCKLOCID_ID, st28.FF106001 FF106001_FSTOCKLOCID_ID, st28.FF106502 FF106502_FSTOCKLOCID_ID, t2.FDETAILUNITID FDETAILUNITID_ID, t2.FINITADJMATQTY FINITINPROMATQTY, t2.FINITADJMATAMOUNT FINITINPROMATAMOUNT, t3.FDETAILEXPITEMID FDETAILEXPITEMID_ID, t3.FINITADJEXPQTY FINITINPROEXPQTY, t3.FINITADJEXPAMOUNT FINITINPROEXPAMOUNT, t1.FMTONO FMTONO, t2.FEXPENSESITEMID FEXPENSESITEMID_ID, t0.FCURRENCYID FCURRENCYID_ID, st28.FOPCODE FSTOCKLOCID_19, t0.FID FID, t1.FENTRYID T1_FENTRYID, t2.FDETAILID T2_FDETAILID, t3.FSUBDETAILID T3_FSUBDETAILID, t1.FSEQ T1_FSEQ, ROW_NUMBER() OVER( ORDER BY t0.FID ASC, fentryid ASC) FIDENTITYID FROM T_CB_INITPRODUCECOSTADJ T0 LEFT OUTER JOIN T_CB_INITPRODUCECOSTADJENTRY T1 ON t0.FID = t1.FID LEFT OUTER JOIN T_CB_INITPROCOSTMATADJENTRY T2 ON t1.FENTRYID = t2.FENTRYID LEFT OUTER JOIN T_CB_INITPROCOSTEXPADJENTRY T3 ON t2.FDETAILID = t3.FDETAILID LEFT OUTER JOIN T_BAS_FLEXVALUESDETAIL ST28 ON t2.FSTOCKLOCID = st28.FID WHERE (((t0.FACCTGORGID IN (1, 100001, 100002, 100003, 100004, 2231159, 4467699, 7123077)) AND (t0.FACCTGORGID IN (1, 100001, 100002, 100003, 100004, 2231159, 4467699, 7123077))) AND t0.FFORBIDSTATUS = 'A')) TLIST WHERE ((fidentityid >= 1) AND (fidentityid <= 10000))

您的鼓励与嘉奖将成为创作者们前进的动力,如果觉得本文还不错,可以给予作者创作打赏哦!

请选择打赏金币数 *

10金币20金币30金币40金币50金币60金币
可用金币: 0