久久亚洲精品无码人区_中文字字幕在线_波多野结衣av免费观看_天堂va在线视频

    熱門關(guān)鍵詞用友BIP 用友U9 用友NC 用友U8 OA T+ 好業(yè)財(cái)

    詳細(xì)信息

    您現(xiàn)在的位置:網(wǎng)站首頁 >> 百科問答 >> 詳細(xì)信息

    T+12.1存貨31001 出庫審核提示“在當(dāng)前期間不夠出庫,小于當(dāng)前存貨總賬數(shù)量”

    發(fā)布時間:2024-11-18  

    人工客服

    特價活動:>>>> 用友U8、T6、T+、T3軟件產(chǎn)品4折優(yōu)惠,暢捷通T+cloud、好會計(jì)、易代賬、好業(yè)財(cái)、好生意云產(chǎn)品6-8折優(yōu)惠。 

    問題描述:

    存貨31001 出庫審核提示“在當(dāng)前期間不夠出庫,小于當(dāng)前存貨總賬數(shù)量” 銷貨單自動出庫,所以是在審核銷貨單時提示的。


    問題原因:存貨明細(xì)賬中多了一行銷售出庫單號為“IO-2017-03-0044”記錄。

     

    解決方法: 

    1、執(zhí)行修復(fù)數(shù)據(jù)腳本。 

    --處理31001存貨錯誤數(shù)據(jù) DELETE FROM ST_SubsidiaryBookWHERE id = 2353995UPDATE ST_AssistantDataBookSET outQuantity = outQuantity - sumquantity , outAmount = outAmount- sumAmount , outVoucherAmount = outVoucherAmount-sumOutVoucherAmount , asOutQuantityAmount = asOutQuantityAmount- sumOutAmount , outExpenseAmount = outExpenseAmount-sumoutexpenseamountFROM ST_AssistantDataBook JOIN ( SELECT r.assistantDataBookID , SUM(r.quantity) AS sumQuantity , SUM(r.amount) AS sumAmount , SUM(r.outAmount) AS sumOutAmount , SUM(outVoucherAmount) AS sumOutVoucherAmount , SUM(ISNULL(r.outAmount, 0) - ISNULL(r.outVoucherAmount, 0)) AS sumoutexpenseamount FROM ST_AssistantDataRelation rWHERE r.[subsidiaryBookID] = 2353995 GROUP BY r.assistantDataBookID ) a ON ST_AssistantDataBook.id = a.assistantDataBookID DELETE FROM ST_AssistantDataRelation WHERE [subsidiaryBookID] = 2353995 

     

     

    上一篇:T+12.3進(jìn)貨單和入庫單數(shù)據(jù)不一致,不能棄審和刪除

    客服電話:400-665-0028

    關(guān)鍵字:用友財(cái)務(wù)軟件,暢捷通軟件,財(cái)務(wù)軟件,進(jìn)銷存軟件,U9官網(wǎng),用友U8,用友T1,用友T+,用友T3,用友T6,暢捷通好會計(jì),好生意,智+好業(yè)財(cái),用友培訓(xùn)服務(wù)售后公司,暢捷通運(yùn)營培訓(xùn)服務(wù)公司

    版權(quán)所有:用友暢捷通軟件 Copyright © 2024 All rights reserved.

    魯ICP備2020041017號-6