物料收发事务汇总表，不包括门店收货单的数量？

另外餐饮物料收发事务汇总表，查询不到结果，刷新报错。
列名 'FENTRYTABLE' 无效。
列名 'FBILLENTRYID' 无效。

错误编号： BOS_ExecuteNonQuery
错误信息： 列名 'FENTRYTABLE' 无效。
列名 'FBILLENTRYID' 无效。
Sql语句： INSERT INTO TMP3A8323AA76B011E4998E42F2E9D (FSTOCKORGID, FOWNERTYPEID, FOWNERID, FENTRYTABLE, FBILLENTRYID, FORDERBY, FSTOCKIO, FIOPRICE, FIOAMOUNT, FMATERIALID, FCURRID, FAUXPROPID, FDATE, FCREATEDATE, FLOTNO, FSTOCKID, FDEPARTMENTID, FSTOCKLOCID, FSTOCKSTATUSID, FKEEPERTYPEID, FKEEPERID, FPRODUCEDATE, FEXPIRYDATE, FBOMID, FFORMID, FBILLNAME, FBILLID, FBILLSEQID, FBILLNO, FBILLTYPE, FMTONO, FBASEQCQTY, FBASEQCPRICE, FSECQCQTY, FBASEINQTY, FBASEINPRICE, FSECINQTY, FBASEOUTQTY, FBASEOUTPRICE, FSECOUTQTY) SELECT TS.FSTOCKORGID fstockorgid, TSE.FOWNERTYPEID fownertypeid, TSE.FOWNERID fownerid, 'T_PUR_MRBENTRY' fentrytable, TSE.FENTRYID fbillentryid, 0 forderby, 'I' fstockio, (ISNULL(TSEF.FCOSTPRICE, 0) * ISNULL(TSF.FEXCHANGERATE, 1)) fioprice, (0 - ISNULL(TSEF.FCOSTAMOUNT_LC, 0)) fioamount, TSE.FMATERIALID fmaterialid, TSF.FLOCALCURRID fcurrid, ISNULL(TSE.FAUXPROPID, 0) fauxpropid, TS.FDATE fdate, TS.FCREATEDATE fcreatedate, ISNULL(TSE.FLOT_TEXT, ' ') flotno, TSE.FSTOCKID fstockid, TS.FMRDEPTID fdepartmentid, ISNULL(TSE.FSTOCKLOCID, 0) fstocklocid, TSE.FSTOCKSTATUSID fstockstatusid, TSE.FKEEPERTYPEID, TSE.FKEEPERID, TSE.FPRODUCEDATE, TSE.FEXPIRYDATE, ISNULL(TSE.FBOMID, 0), 'PUR_MRB' fformid, '退料单' fbillname, TS.FID fbillid, TSE.FSEQ fbillseqid, TS.FBILLNO fbillno, TS.FBILLTYPEID fbilltypeid, ISNULL(TSE.FMTONO, ' ') fmtono, 0 fbaseqcqty, 0 fbaseqcprice, 0 fsecqcqty, (0 - TSE.FBASEUNITQTY) fbaseinqty, 0 fbaseinprice, (0 - TSE.FAUXUNITQTY) fsecinqty, 0 fbaseoutqty, 0 fbaseoutprice, 0 fsecoutqty FROM T_PUR_MRB TS INNER JOIN T_PUR_MRBENTRY TSE ON TSE.FID = TS.FID INNER JOIN T_PUR_MRBENTRY_F TSEF ON (TSE.FID = TSEF.FID AND TSE.FENTRYID = TSEF.FENTRYID) INNER JOIN T_PUR_MRBFIN TSF ON TSE.FID = TSF.FID INNER JOIN T_BD_MATERIAL TM ON TSE.FMATERIALID = TM.FMATERIALID WHERE (((((TS.FDATE >= '2014-11-01 00:00:00') AND (TS.FDATE <= '2014-11-28 23:59:59')) AND (((TS.FSTOCKORGID IN (100004) AND TS.FDOCUMENTSTATUS IN ('C')) AND TM.FFORBIDSTATUS = 'A') AND TS.FCANCELSTATUS = 'A')) AND (TSE.FSTOCKID > 0)) AND TSF.FISGENFORIOS = 0)
===================================================