ABC分类分组规则按存货金额报错

ABC分类分组规则按存货金额报错
1.

2.

INSERT INTO #TM_STK_ABCGRPRATIOTIME (FMATERIALID, FNUMBER, FIOAMOUNT, FDATE) SELECT TPME.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TPMEF.FCOSTAMOUNT_LC, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TPMF.FSETTLECURRID) AND FCYTOID = 1)), 1)) fioamount, TPM.FDATE fdate FROM T_PUR_MRBENTRY TPME INNER JOIN T_PUR_MRB TPM ON ((TPM.FID = TPME.FID AND TPM.FCANCELSTATUS = 'A') AND (TPM.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_PUR_MRBFIN TPMF ON TPM.FID = TPMF.FID INNER JOIN T_PUR_MRBENTRY_F TPMEF ON ((TPMEF.FID = TPME.FID AND TPMEF.FENTRYID = TPME.FENTRYID) AND (TPMEF.FAMOUNT > 0)) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TPME.FMATERIALID AND TM.FUSEORGID = 1) WHERE TPME.FSTOCKFLAG = '1' UNION ALL SELECT TSIE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TSIEF.FCOSTAMOUNT_LC, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSIF.FSETTLECURRID) AND FCYTOID = 1)), 1)) fioamount, TSI.FDATE fdate FROM T_STK_INSTOCKENTRY TSIE INNER JOIN T_STK_INSTOCK TSI ON ((TSI.FID = TSIE.FID AND TSI.FCANCELSTATUS = 'A') AND (TSI.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_STK_INSTOCKFIN TSIF ON TSI.FID = TSIF.FID INNER JOIN T_STK_INSTOCKENTRY_F TSIEF ON ((TSIEF.FID = TSIE.FID AND TSIEF.FENTRYID = TSIE.FENTRYID) AND (TSIEF.FAMOUNT > 0)) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSIE.FMATERIALID AND TM.FUSEORGID = 1) UNION ALL SELECT TPIE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TPIE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TPI.FCURRID) AND FCYTOID = 1)), 1)) fioamount, TPI.FDATE fdate FROM T_PRD_INSTOCKENTRY TPIE INNER JOIN T_PRD_INSTOCK TPI ON ((TPI.FID = TPIE.FID AND TPI.FCANCELSTATUS = 'A') AND (TPI.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TPIE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TPIE.FAMOUNT > 0) UNION ALL SELECT TSME.FMATERIALID fmaterialid, TM.FNUMBER fnumber, CASE WHEN TSM.FSTOCKDIRECT = 'GENERAL' THEN (ISNULL(TSME.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSM.FCURRENCYID) AND FCYTOID = 1)), 1)) ELSE (ISNULL(TSME.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSM.FCURRENCYID) AND FCYTOID = 1)), 1)) END fioamount, TSM.FDATE fdate FROM T_STK_MISCELLANEOUSENTRY TSME INNER JOIN T_STK_MISCELLANEOUS TSM ON ((TSM.FID = TSME.FID AND TSM.FCANCELSTATUS = 'A') AND (TSM.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSME.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSME.FAMOUNT > 0) UNION ALL SELECT TSSE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TSSE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSS.FBASECURRID) AND FCYTOID = 1)), 1)) fioamount, TSS.FDATE fdate FROM T_STK_STKCOUNTGAINENTRY TSSE INNER JOIN T_STK_STKCOUNTGAIN TSS ON (TSS.FID = TSSE.FID AND (TSS.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSSE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSSE.FAMOUNT > 0) UNION ALL SELECT TSOE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TSOEF.FCOSTAMOUNT_LC, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSOF.FSETTLECURRID) AND FCYTOID = 1)), 1)) fioamount, TSO.FDATE fdate FROM T_SAL_OUTSTOCKENTRY TSOE INNER JOIN T_SAL_OUTSTOCK TSO ON ((TSO.FID = TSOE.FID AND TSO.FCANCELSTATUS = 'A') AND (TSO.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_SAL_OUTSTOCKFIN TSOF ON TSOF.FID = TSO.FID INNER JOIN T_SAL_OUTSTOCKENTRY_F TSOEF ON ((TSOEF.FID = TSOE.FID AND TSOEF.FENTRYID = TSOE.FENTRYID) AND (TSOEF.FAMOUNT > 0)) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSOE.FMATERIALID AND TM.FUSEORGID = 1) UNION ALL SELECT TSRE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TSREF.FCOSTAMOUNT_LC, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSRF.FSETTLECURRID) AND FCYTOID = 1)), 1)) fioamount, TSR.FDATE fdate FROM T_SAL_RETURNSTOCKENTRY TSRE INNER JOIN T_SAL_RETURNSTOCK TSR ON ((TSR.FID = TSRE.FID AND TSR.FCANCELSTATUS = 'A') AND (TSR.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_SAL_RETURNSTOCKFIN TSRF ON TSRF.FID = TSR.FID INNER JOIN T_SAL_RETURNSTOCKENTRY_F TSREF ON ((TSREF.FID = TSRE.FID AND TSREF.FENTRYID = TSRE.FENTRYID) AND (TSREF.FAMOUNT > 0)) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSRE.FMATERIALID AND TM.FUSEORGID = 1) UNION ALL SELECT TSME.FMATERIALID fmaterialid, TM.FNUMBER fnumber, CASE WHEN TSM.FSTOCKDIRECT = 'GENERAL' THEN (ISNULL(TSME.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSM.FBASECURRID) AND FCYTOID = 1)), 1)) ELSE (ISNULL(TSME.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSM.FBASECURRID) AND FCYTOID = 1)), 1)) END fioamount, TSM.FDATE fdate FROM T_STK_MISDELIVERYENTRY TSME INNER JOIN T_STK_MISDELIVERY TSM ON ((TSM.FID = TSME.FID AND TSM.FCANCELSTATUS = 'A') AND (TSM.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSME.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSME.FAMOUNT > 0) UNION ALL SELECT TPPE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TPPE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TPP.FCURRID) AND FCYTOID = 1)), 1)) fioamount, TPP.FDATE fdate FROM T_PRD_PICKMTRLDATA TPPE INNER JOIN T_PRD_PICKMTRL TPP ON ((TPP.FID = TPPE.FID AND TPP.FCANCELSTATUS = 'A') AND (TPP.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TPPE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TPPE.FAMOUNT > 0) UNION ALL SELECT TPRE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TPRE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TPR.FCURRID) AND FCYTOID = 1)), 1)) fioamount, TPR.FDATE fdate FROM T_PRD_RETURNMTRLENTRY TPRE INNER JOIN T_PRD_RETURNMTRL TPR ON ((TPR.FID = TPRE.FID AND TPR.FCANCELSTATUS = 'A') AND (TPR.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TPRE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TPRE.FAMOUNT > 0) UNION ALL SELECT TPFE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TPFE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TPF.FCURRID) AND FCYTOID = 1)), 1)) fioamount, TPF.FDATE fdate FROM T_PRD_FEEDMTRLDATA TPFE INNER JOIN T_PRD_FEEDMTRL TPF ON ((TPF.FID = TPFE.FID AND TPF.FCANCELSTATUS = 'A') AND (TPF.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TPFE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TPFE.FAMOUNT > 0) UNION ALL SELECT TSPE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TSPEA.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSP.FCURRID) AND FCYTOID = 1)), 1)) fioamount, TSP.FDATE fdate FROM T_SUB_PICKMTRLDATA TSPE INNER JOIN T_SUB_PICKMTRL TSP ON ((TSP.FID = TSPE.FID AND TSP.FCANCELSTATUS = 'A') AND (TSP.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_SUB_PICKMTRLDATA_A TSPEA ON ((TSPEA.FID = TSPE.FID AND TSPEA.FENTRYID = TSPE.FENTRYID) AND (TSPEA.FAMOUNT > 0)) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSPE.FMATERIALID AND TM.FUSEORGID = 1) UNION ALL SELECT TSRE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TSRE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSR.FCURRID) AND FCYTOID = 1)), 1)) fioamount, TSR.FDATE fdate FROM T_SUB_RETURNMTRLENTRY TSRE INNER JOIN T_SUB_RETURNMTRL TSR ON ((TSR.FID = TSRE.FID AND TSR.FCANCELSTATUS = 'A') AND (TSR.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSRE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSRE.FAMOUNT > 0) UNION ALL SELECT TSFE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TSFE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSF.FCURRID) AND FCYTOID = 1)), 1)) fioamount, TSF.FDATE fdate FROM T_SUB_FEEDMTRLENTRY TSFE INNER JOIN T_SUB_FEEDMTRL TSF ON ((TSF.FID = TSFE.FID AND TSF.FCANCELSTATUS = 'A') AND (TSF.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSFE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSFE.FAMOUNT > 0) UNION ALL SELECT TSSE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TSSE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSS.FBASECURRID) AND FCYTOID = 1)), 1)) fioamount, TSS.FDATE fdate FROM T_STK_STKCOUNTLOSSENTRY TSSE INNER JOIN T_STK_STKCOUNTLOSS TSS ON (TSS.FID = TSSE.FID AND (TSS.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSSE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSSE.FAMOUNT > 0) UNION ALL SELECT TSAE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, CASE WHEN TSA.FAFFAIRTYPE = 'Assembly' THEN (ISNULL(TSAE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSA.FBASECURRID) AND FCYTOID = 1)), 1)) ELSE (ISNULL(TSAE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSA.FBASECURRID) AND FCYTOID = 1)), 1)) END fioamount, TSA.FDATE fdate FROM T_STK_ASSEMBLYPRODUCT TSAE INNER JOIN T_STK_ASSEMBLY TSA ON ((TSA.FID = TSAE.FID AND TSA.FCANCELSTATUS = 'A') AND (TSA.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSAE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSAE.FAMOUNT > 0) UNION ALL SELECT TSAESUB.FMATERIALID fmaterialid, TM.FNUMBER fnumber, CASE WHEN TSA.FAFFAIRTYPE = 'Assembly' THEN (ISNULL(TSAESUB.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSA.FBASECURRID) AND FCYTOID = 1)), 1)) ELSE (ISNULL(TSAESUB.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSA.FBASECURRID) AND FCYTOID = 1)), 1)) END fioamount, TSA.FDATE fdate FROM T_STK_ASSEMBLYSUBITEM TSAESUB INNER JOIN T_STK_ASSEMBLYPRODUCT TSAE ON TSAE.FENTRYID = TSAESUB.FENTRYID INNER JOIN T_STK_ASSEMBLY TSA ON ((TSA.FID = TSAE.FID AND TSA.FCANCELSTATUS = 'A') AND (TSA.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSAESUB.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSAESUB.FAMOUNT > 0) UNION ALL SELECT TSSE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, CASE WHEN TSSE.FCONVERTTYPE = 'A' THEN (ISNULL(TSSE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSS.FBASECURRID) AND FCYTOID = 1)), 1)) ELSE (ISNULL(TSSE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSS.FBASECURRID) AND FCYTOID = 1)), 1)) END fioamount, TSS.FDATE fdate FROM T_STK_STATUSCONVERTENTRY TSSE INNER JOIN T_STK_STATUSCONVERT TSS ON ((TSS.FID = TSSE.FID AND TSS.FCANCELSTATUS = 'A') AND (TSS.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSSE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSSE.FAMOUNT > 0) UNION ALL SELECT TSSE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, CASE WHEN TSSE.FCONVERTTYPE = 'A' THEN (ISNULL(TSSE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSS.FBASECURRID) AND FCYTOID = 1)), 1)) ELSE (ISNULL(TSSE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSS.FBASECURRID) AND FCYTOID = 1)), 1)) END fioamount, TSS.FDATE fdate FROM T_STK_STOCKCONVERTENTRY TSSE INNER JOIN T_STK_STOCKCONVERT TSS ON ((TSS.FID = TSSE.FID AND TSS.FCANCELSTATUS = 'A') AND (TSS.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSSE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSSE.FAMOUNT > 0) UNION ALL SELECT TSSE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, CASE WHEN TSSE.FCONVERTTYPE = 'A' THEN (ISNULL(TSSE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSS.FBASECURRID) AND FCYTOID = 1)), 1)) ELSE (ISNULL(TSSE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSS.FBASECURRID) AND FCYTOID = 1)), 1)) END fioamount, TSS.FDATE fdate FROM T_STK_LOTADJUSTENTRY TSSE INNER JOIN T_STK_LOTADJUST TSS ON ((TSS.FID = TSSE.FID AND TSS.FCANCELSTATUS = 'A') AND (TSS.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSSE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSSE.FAMOUNT > 0) UNION ALL SELECT TSSE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, CASE WHEN (TSS.FTRANSFERDIRECT = 'GENERAL' AND FVESTONWAY = 'A') THEN 0 WHEN (TSS.FTRANSFERDIRECT = 'RETURN' AND FVESTONWAY = 'A') THEN 0 WHEN (TSS.FTRANSFERDIRECT = 'GENERAL' AND FVESTONWAY = 'B') THEN (ISNULL(TSSE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSS.FBASECURRID) AND FCYTOID = 1)), 1)) WHEN (TSS.FTRANSFERDIRECT = 'RETURN' AND FVESTONWAY = 'B') THEN (ISNULL(TSSE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSS.FBASECURRID) AND FCYTOID = 1)), 1)) END fioamount, TSS.FDATE fdate FROM T_STK_STKTRANSFEROUTENTRY TSSE INNER JOIN T_STK_STKTRANSFEROUT TSS ON ((TSS.FID = TSSE.FID AND TSS.FCANCELSTATUS = 'A') AND (TSS.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSSE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSSE.FAMOUNT > 0) UNION ALL SELECT TSSE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, CASE WHEN (TSS.FTRANSFERDIRECT = 'GENERAL' AND FVESTONWAY = 'B') THEN 0 WHEN (TSS.FTRANSFERDIRECT = 'RETURN' AND FVESTONWAY = 'B') THEN 0 WHEN (TSS.FTRANSFERDIRECT = 'GENERAL' AND FVESTONWAY = 'A') THEN (ISNULL(TSSE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSS.FBASECURRID) AND FCYTOID = 1)), 1)) WHEN (TSS.FTRANSFERDIRECT = 'RETURN' AND FVESTONWAY = 'A') THEN (ISNULL(TSSE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSS.FBASECURRID) AND FCYTOID = 1)), 1)) END fioamount, TSS.FDATE fdate FROM T_STK_STKTRANSFERINENTRY TSSE INNER JOIN T_STK_STKTRANSFERIN TSS ON ((TSS.FID = TSSE.FID AND TSS.FCANCELSTATUS = 'A') AND (TSS.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSSE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSSE.FAMOUNT > 0) UNION ALL SELECT TSIE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TSIE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSI.FCURRID) AND FCYTOID = 1)), 1)) fioamount, TSI.FDATE fdate FROM T_SP_INSTOCKENTRY TSIE INNER JOIN T_SP_INSTOCK TSI ON ((TSI.FID = TSIE.FID AND TSI.FCANCELSTATUS = 'A') AND (TSI.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSIE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSIE.FAMOUNT > 0) UNION ALL SELECT TSIE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TSIE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSI.FCURRID) AND FCYTOID = 1)), 1)) fioamount, TSI.FDATE fdate FROM T_SP_PICKMTRLDATA TSIE INNER JOIN T_SP_PICKMTRL TSI ON ((TSI.FID = TSIE.FID AND TSI.FCANCELSTATUS = 'A') AND (TSI.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSIE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSIE.FAMOUNT > 0) UNION ALL SELECT TSIE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TSIE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSI.FCURRID) AND FCYTOID = 1)), 1)) fioamount, TSI.FDATE fdate FROM T_SP_RETURNMTRLENTRY TSIE INNER JOIN T_SP_RETURNMTRL TSI ON ((TSI.FID = TSIE.FID AND TSI.FCANCELSTATUS = 'A') AND (TSI.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSIE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSIE.FAMOUNT > 0) UNION ALL SELECT TPIE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TPIE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TPI.FCURRID) AND FCYTOID = 1)), 1)) fioamount, TPI.FDATE fdate FROM T_REM_INSTOCKENTRY TPIE INNER JOIN T_REM_INSTOCK TPI ON ((TPI.FID = TPIE.FID AND TPI.FCANCELSTATUS = 'A') AND (TPI.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TPIE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TPIE.FAMOUNT > 0) UNION ALL SELECT TPPE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TPPE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TPP.FCURRID) AND FCYTOID = 1)), 1)) fioamount, TPP.FDATE fdate FROM T_REM_PICKMTRLDATA TPPE INNER JOIN T_REM_PICKMTRL TPP ON ((TPP.FID = TPPE.FID AND TPP.FCANCELSTATUS = 'A') AND (TPP.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TPPE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TPPE.FAMOUNT > 0) UNION ALL SELECT TPRE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TPRE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TPR.FCURRID) AND FCYTOID = 1)), 1)) fioamount, TPR.FDATE fdate FROM T_REM_RETURNMTRLENTRY TPRE INNER JOIN T_REM_RETURNMTRL TPR ON ((TPR.FID = TPRE.FID AND TPR.FCANCELSTATUS = 'A') AND (TPR.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TPRE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TPRE.FAMOUNT > 0) UNION ALL SELECT TPIE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, (ISNULL(TPIE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TPI.FCURRID) AND FCYTOID = 1)), 1)) fioamount, TPI.FDATE fdate FROM T_REM_OUTSTOCKENTRY TPIE INNER JOIN T_REM_OUTSTOCK TPI ON ((TPI.FID = TPIE.FID AND TPI.FCANCELSTATUS = 'A') AND (TPI.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TPIE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TPIE.FAMOUNT > 0) UNION ALL SELECT TSSE.FMATERIALID fmaterialid, TM.FNUMBER fnumber, CASE WHEN TSS.FTRANSFERDIRECT = 'GENERAL' THEN (ISNULL(TSSE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSS.FBASECURRID) AND FCYTOID = 1)), 1)) WHEN TSS.FTRANSFERDIRECT = 'RETURN' THEN (ISNULL(TSSE.FAMOUNT, 0) * ISNULL((SELECT FEXCHANGERATE FROM V_CRE_NEWRATE t0 INNER JOIN V_ORG_ORGRATETYPE t1 ON t0.FRATETYPEID = t1.FRATETYPEID WHERE ((FORGID = 1 AND FCYFORID = TSS.FBASECURRID) AND FCYTOID = 1)), 1)) END fioamount, TSS.FDATE fdate FROM T_REM_STKTRANSFERINENTRY TSSE INNER JOIN T_REM_STKTRANSFERIN TSS ON ((TSS.FID = TSSE.FID AND TSS.FCANCELSTATUS = 'A') AND (TSS.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALID = TSSE.FMATERIALID AND TM.FUSEORGID = 1) WHERE (TSSE.FAMOUNT > 0)

Server stack trace:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.DBUtils.ExecuteBatch(Context ctx, List`1 lstSqlObj)
at Kingdee.K3.SCM.App.Core.StockCycleCount.InvAmountGroupDataSource.GetABCGroupDataForReport(Context ctx, IRptParams filterObject, String tableName)
at Kingdee.K3.SCM.App.Core.StockCycleCountService.GetMaterialABCGroup(Context ctx, IRptParams filterPara, String sTmpTable)
at Kingdee.K3.SCM.App.Stock.Report.ABCAnalyseRpt.BuilderReportSqlAndTempTable(IRptParams filter, String tableName)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.CreateTempTable(IRptParams filter, String tablename)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetDataForVirtual(IRptParams filter)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetData(IRptParams filter)
at Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.App.Core.SysReportService.GetReportData(ReportServiceParameter parameter)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Kingdee.BOS.Contracts.ISysReportService.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.Model.Report.SysReportModel.GetData(Int32 start, Int32 rows)
at Kingdee.BOS.Web.Report.SysReportView.GetListData()
at Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass4d.b__49()