<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>
    


    
    
    
      以文本方式查看主題
    
        
    
      -  安易免費財務軟件交流論壇  (http://m.gangyx.cn/bbs/index.asp)
    
        --  用友財務軟件交流  (http://m.gangyx.cn/bbs/list.asp?boardid=7)
    
        ----  財務通標準版821存貨核算財務通現存量不對怎么辦？  (http://m.gangyx.cn/bbs/dispbbs.asp?boardid=7&id=23780)
    
        
    
          		
    
    
    
    
    
      --  作者：iabc3000
    
        --  發布時間：2009/8/16 18:02:28
    
        
        --  財務通標準版821存貨核算財務通現存量不對怎么辦？
    
        財務通標準版821存貨核算財務通現存量不對怎么辦？
        
    
          		
    
    
    
    
      --  作者：iabc3000
    
        --  發布時間：2009/8/16 18:02:59
    
        
        --  
    
        執行以下腳本能解決問題
        
        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
    
        
    
          		
    
    
    
    
      --  作者：清風生
    
        --  發布時間：2010/4/26 22:08:36
    
        
        --  
    
        
    哦
    這樣啊
    圖片點擊可在新窗口打開查看
        
    
          		
    
    
    
    
      --  作者：caritas
    
        --  發布時間：2011/3/2 17:59:32
    
        
        --  
    
        看不懂哦
        
    
          		
    
    
    
    
      --  作者：sunjiacun
    
        --  發布時間：2011/10/7 15:28:36
    
        
        --  
    
        看不明白
        
    
          		
    
    
    
    
      --  作者：hlp34567
    
        --  發布時間：2011/10/8 8:25:41
    
        
        --  
    
        好麻煩看不懂
        
    
          		
    
    
    
    
      --  作者：dmacc906
    
        --  發布時間：2011/11/5 21:35:23
    
        
        --  
    
        應該不會啊~~
        
    
          		
    
    

    
Channel