<address id="thnfp"></address>

    <address id="thnfp"><th id="thnfp"><progress id="thnfp"></progress></th></address>
    <listing id="thnfp"><nobr id="thnfp"><meter id="thnfp"></meter></nobr></listing>
    dvbbs
    收藏本頁
    聯系我們
    論壇幫助
    dvbbs

    >> 用友U8、TONG系統軟件交流
    搜一搜更多此類問題 
    安易免費財務軟件交流論壇其它財務軟件交流用友財務軟件交流 → 財務通標準版821存貨核算財務通現存量不對怎么辦?

    您是本帖的第 1276 個閱讀者
    樹形 打印
    標題:
    財務通標準版821存貨核算財務通現存量不對怎么辦?
    iabc3000
    帥哥喲,離線,有人找我嗎?
    等級:俠圣
    文章:4389
    積分:24360
    注冊:2009年7月18日
    樓主
      點擊這里發送電子郵件給iabc3000

    發貼心情
    財務通標準版821存貨核算財務通現存量不對怎么辦?
    財務通標準版821存貨核算財務通現存量不對怎么辦?
    ip地址已設置保密
    2009/8/16 18:02:28
    iabc3000
    帥哥喲,離線,有人找我嗎?
    等級:俠圣
    文章:4389
    積分:24360
    注冊:2009年7月18日
    2
      點擊這里發送電子郵件給iabc3000

    發貼心情
    執行以下腳本能解決問題
       
        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
        INSERT INTO TempCurrentStock(cWhCode,cInvCode,cFree1,cFree2,iQuantity) SELECT
        cWhCode, cInvCode,(CASE WHEN cFree1=''THEN NULL ELSE cFree1 END) AS cFree1 ,(
        CASE WHEN cFree2=''THEN NULL ELSE cFree2 END) AS cFree2 , (CASE WHEN bRdFlag<>0
        THEN iQuantity ELSE -iQuantity END) AS iQuantity
        FROM RdRecord INNER JOIN RdRecords ON RdRecord.ID = RdRecords.ID
        WHERE cVouchType<>'33'AND cVouchType<>'34' AND RdRecord.dDate>='2007-1-01'
        INSERT INTO TempCurrentStock(cWhCode,cInvCode,cFree1,cFree2,fOutQuantity)
        SELECT EnDispatchs.cWhCode, EnDispatchs.cInvCode,(CASE WHEN EnDispatchs.cFree1=
        '' THEN NULL ELSE EnDispatchs.cFree1 END) AS cFree1 ,(CASE WHEN EnDispatchs.
        cFree2='' THEN NULL ELSE EnDispatchs.cFree2 END) AS cFree2 , (ISNULL(iQuantity,
        0)-ISNULL(fOutQuantity,0)) AS fOutQuantity
        FROM EnDispatch INNER JOIN EnDispatchs ON EnDispatch.EDID = EnDispatchs.EDID
        WHERE ISNULL(EnDispatchs.cWhCode,'')<>'' AND ISNULL(EnDispatch.cSTCode,'')<>''
        AND EnDispatchs.iQuantity>0 AND bReturnFlag=0
        INSERT INTO TempCurrentStock(cWhCode,cInvCode,cFree1,cFree2,fOutQuantity)
        SELECT DispatchLists.cWhCode as cWhCode, DispatchLists.cInvCode as cInvCode,(
        CASE WHEN DispatchLists.cFree1='' THEN NULL ELSE DispatchLists.cFree1 END) AS
        cFree1 , (CASE WHEN DispatchLists.cFree2='' THEN NULL ELSE DispatchLists.cFree2
        END) AS cFree2 , (ISNULL(iQuantity,0)-ISNULL(fOutQuantity,0)) AS fOutQuantity
        FROM DispatchLists INNER JOIN DispatchList ON DispatchLists.DLID =
        DispatchList.DLID
        WHERE DispatchList.cVouchType='05' AND ISNULL(DispatchLists.cWhCode,'')<>''
        AND ISNULL(DispatchList.cSTCode,'')<>'' AND (DispatchList.iSale=0 or
        DispatchList.iSale IS NULL) AND DispatchLists.iQuantity>0
        INSERT INTO TempCurrentStock(cWhCode,cInvCode,cFree1,cFree2,fOutQuantity)
        SELECT cWhCode, cInvCode,(CASE WHEN cFree1=''THEN NULL ELSE cFree1 END) AS
        cFree1 , (CASE WHEN cFree2=''THEN NULL ELSE cFree2 END) AS cFree2 , (ISNULL(
        iQuantity,0)-ISNULL(fOutQuantity,0)) AS fOutQuantity
        FROM SaleBillVouchs INNER JOIN SaleBillVouch ON SaleBillVouch.SBVID=
        SaleBillVouchs.SBVID
        WHERE ISNULL(SaleBillVouchs.cWhCode,'')<>'' AND (SaleBillVouch.iDisp=0 OR
        SaleBillVouch.iDisp IS NULL) AND ISNULL(cBusType,'')<>'委托' AND ISNULL(
        cSTCode,'')<>'' AND ISNULL(cInvalider,'')='' AND SaleBillVouchs.iQuantity>
        0INSERT INTO CurrentStock(cWhCode,cInvCode,cFree1,cFree2,iQuantity,fOutQuantity,
        fInQuantity)
        SELECT cWhCode, cInvCode,cFree1,cFree2 , sum(iQuantity) AS iQuantity,sum(
        ISNULL(fOutQuantity,0)) AS fOutQuantity, sum(ISNULL(fInQuantity,0)) AS
        fInQuantity
        FROM TempCurrentStock
        GROUP BY cWhCode,cInvCode,cFree1,cFree2
        Delete From CurrentStock
        where iquantity is null and foutquantity=0 and finquantity=0
    ip地址已設置保密
    2009/8/16 18:02:59
    清風生
    帥哥喲,離線,有人找我嗎?
    等級:論壇游民
    文章:194
    積分:940
    注冊:2010年1月19日
    3
      點擊這里發送電子郵件給清風生

    發貼心情

    這樣啊

    圖片點擊可在新窗口打開查看
    ip地址已設置保密
    2010/4/26 22:08:36
    caritas
    帥哥喲,離線,有人找我嗎?
    等級:論壇游俠
    文章:198
    積分:725
    注冊:2011年1月5日
    4
      點擊這里發送電子郵件給caritas

    發貼心情
    看不懂哦
    ip地址已設置保密
    2011/3/2 17:59:32
    sunjiacun
    帥哥喲,離線,有人找我嗎?
    等級:論壇游俠
    文章:203
    積分:835
    注冊:2011年9月13日
    5
      點擊這里發送電子郵件給sunjiacun

    發貼心情
    看不明白
    ip地址已設置保密
    2011/10/7 15:28:36
    hlp34567
    美女呀,離線,留言給我吧!
    等級:論壇游民
    文章:119
    積分:585
    注冊:2011年8月18日
    6
      點擊這里發送電子郵件給hlp34567

    發貼心情
    好麻煩看不懂
    ip地址已設置保密
    2011/10/8 8:25:41
    dmacc906
    帥哥喲,離線,有人找我嗎?
    等級:論壇游俠
    文章:202
    積分:775
    注冊:2011年8月7日
    7
      點擊這里發送電子郵件給dmacc906

    發貼心情
    應該不會啊~~
    ip地址已設置保密
    2011/11/5 21:35:23

     7   7   1/1頁      1    
    網上貿易 創造奇跡! 阿里巴巴 Alibaba
    北京安易天地軟件有限公司北方論壇
    聯系電話:010-51268244 13611231185 QQ:511102924
    Powered By Dvbbs Version 7.1.0 Sp1
    頁面執行時間 0.09375 秒, 5 次數據查詢
    Channel