用友财务软件交流-通2005总账现存量整理后还是不对怎么办?[安易免费财务软件交流论坛]

以文本方式查看主题

-  安易免费财务软件交流论坛  (http://www.anyicw.com/bbs/index.asp)
--  用友财务软件交流  (http://www.anyicw.com/bbs/list.asp?boardid=7)
----  通2005总账现存量整理后还是不对怎么办?  (http://www.anyicw.com/bbs/dispbbs.asp?boardid=7&id=23763)

--  作者：iabc3000
--  发布时间：2009/8/16 15:40:17
--  通2005总账现存量整理后还是不对怎么办?
现存量整理后还是不对怎么办?

--  作者：iabc3000
--  发布时间：2009/8/16 15:40:42
--
执行如下脚本:
    SELECT *
    FROM sysobjects
    WHERE name = \'tempcurrentstock\' DROP TABLE TempCurrentStock
    SELECT cWhCode, cInvCode, (CASE WHEN cFree1 = \'\' THEN NULL
    ELSE cFree1 END) AS cFree1, (CASE WHEN cFree2 = \'\' THEN NULL
    ELSE cFree2 END) AS cFree2, iainquantity AS iQuantity, CAST(0 AS FLOAT)
    AS fOutQuantity, CAST(0 AS FLOAT) AS fInQuantity
    INTO TempCurrentStock
    FROM ia_subsidiary
    WHERE cvoutype = \'34\'
    GROUP BY ia_subsidiary.cWhCode, ia_subsidiary.cInvCode, ia_subsidiary.cFree1,
    ia_subsidiary.cFree2, ia_subsidiary.iainquantity