存货系统在做发出商品记账时出错 问题描述：存货系统在做发出商品记账时,调不出任何数据(发货单或销售发票),连列字段名没有显示. 问题原因：通过事件跟踪器发现,在进入发出商品记账时有运行一条"SELECT DISTINCT DISPATCHLIST.DLID AS ID, DISPATCHLISTS.IDLSID AS AUTOID, CONVERT(CHAR(10),DISPATCHLIST.DDATE,121) AS DDATE, DISPATCHLIST.CDLCODE, DISPATCHLISTS.CWHCODE, WAREHOUSE.CWHNAME,DISPATCHLIST.CRDCODE, RD_STYLE.CRDNAME, DISPATCHLISTS.CINVCODE, INVENTORY.CINVNAME, LTRIM(STR(CAST(DISPATCHLISTS.IQUANTITY AS DECIMAL(38,2)),38,2)) AS IQUANTITY, NULL AS IUNITCOST,NULL AS IPRICE, LTRIM(STR(INVENTORY.IINVRCOST,40,4)) AS IPUNITCOST, LTRIM(STR(DISPATCHLISTS.IQUANTITY*INVENTORY.IINVRCOST,40,2)) AS IPPRICE, 0 AS BRDFLAG,DISPATCHLIST.CVOUCHTYPE AS CVOUCHTYPE,INVENTORY.CVALUETYPE, DISPATCHLISTS.ICORID,DISPATCHLIST.CBUSTYPE AS CBUSTYPE, DISPATCHLIST.DDATE AS DSDATE,NULL AS CACCOUNTER,'销售' AS CSOURCE, NULL AS CBUSCODE,CONVERT(CHAR,CONVERT(MONEY,DISPATCHLIST.UFTS),2) AS UFTS INTO TEMPFCSPTABLE FROM ((((((((( DISPATCHLIST LEFT JOIN DISPATCHLISTS ON DISPATCHLIST.DLID = DISPATCHLISTS.DLID) LEFT JOIN WAREHOUSE ON WAREHOUSE.CWHCODE = DISPATCHLISTS.CWHCODE) LEFT JOIN SALETYPE ON SALETYPE.CSTCODE = DISPATCHLIST.CSTCODE)LEFT JOIN RD_STYLE ON RD_STYLE.CRDCODE = SALETYPE.CRDCODE)LEFT JOIN INVENTORY ON DISPATCHLISTS.CINVCODE = INVENTORY.CINVCODE) LEFT JOIN RDRECORDS ON RDRECORDS.IDLSID = DISPATCHLISTS.IDLSID) LEFT JOIN RDRECORD ON RDRECORD.ID = RDRECORDS.ID) LEFT JOIN SALEBILLVOUCHS ON SALEBILLVOUCHS.IDLSID = DISPATCHLISTS.IDLSID) LEFT JOIN SALEBILLVOUCH ON SALEBILLVOUCH.SBVID = SALEBILLVOUCHS.SBVID) WHERE DISPATCHLIST.CACCOUNTER IS NULL AND DISPATCHLISTS.CWHCODE IN ('01','11','12','13','21','22','23','24','25','26','31','32','33') AND (ISNULL(DISPATCHLISTS.IQUANTITY,0)<>0) AND (RDRECORD.CACCOUNTER IS NULL) AND (DISPATCHLIST.CACCOUNTER IS NULL) AND (NOT DISPATCHLIST.CVERIFIER IS NULL) AND DISPATCHLIST.DDATE <= '2003-11-30' AND BSERVICE=0 AND INVENTORY.BINVTYPE=0 AND SALEBILLVOUCH.CACCOUNTER IS NULL AND ((INVENTORY.CMONTH IS NULL) OR RIGHT(INVENTORY.CMONTH,2)<11) AND (ISNULL(DISPATCHLIST.CBUSTYPE,'')='分期收款' AND DISPATCHLIST.CVOUCHTYPE='05')"的语句,将此语句放入查询分析器中运行后提示"服务器: 消息 2714，级别 16，状态 6，行 2 数据库中已存在名为 'TEMPFCSPTABLE' 的对象。" 这可能是在软件进入时没有去判断该表是否存在,在退出软件时有,那么如果是在非正常退出请况下就会出错啦! 解决方案：游客无权查看 相关补丁：模块：存货核算产品：8.5X存货系统问题名称：存货系统在做发出商品记账时出错更新时间：2005-06-28 00:00:00 有用 没用84 浏览 分类 U8知识库用友U8知识库(旧)畅捷通知识库用友NC知识库用友U9知识库用友政务知识库致远OA知识库U8Cloud知识库