热门关键词用友BIP 用友U9 用友NC 用友U8 T+ 好业财 T3 好会计

    详细信息

    您现在的位置:网站首页 >> 百科问答 >> 详细信息

    用友畅捷通T+收发存汇总表和存货总账结存不一致

    发布时间:2024-6-11  

    特价活动:>>>> 用友U8、T6、T+、T3软件产品4折优惠,畅捷通T+cloud、好会计、易代账、好业财、好生意云产品6-8折优惠 

    用友畅捷通T+收发存汇总表和存货总账结存不一致


    账套备份

     执行以下语句



    UPDATE r2 SET r2.amount = xx.outAmount , r2.price = round (xx.outAmount/r2.quantity,2),


    r2.basePrice = ROUND(xx.outAmount/r2.baseQuantity,2)




    FROM dbo.ST_RDRecord r1


    JOIN dbo.ST_RDRecord_b r2 ON r1.id = r2.idRDRecordDTO


    JOIN dbo.AA_Inventory i ON r2.idinventory = i.id


    JOIN (




    SELECT s.idvouchertype, s.voucherDetailID, s.voucherID, SUM(s.outAmount) AS outAmount


    FROM dbo.ST_SubsidiaryBook s


    GROUP BY s.idvouchertype, s.voucherDetailID, s.voucherID


    ) xx ON r1.id = xx.voucherID AND r1.idvouchertype = xx.idvouchertype AND r2.id = xx.voucherDetailID 


    WHERE r2.amount <> xx.outAmount AND r1.rdDirectionFlag = 0

     

     

    上一篇:用友畅捷通T3如何使用自定义转账结转制造费用?

    客服电话:400-665-0028

    关键字:用友财务软件,畅捷通软件,财务软件,进销存软件,U9官网,用友U8,用友T1,用友T+,用友T3,用友T6,畅捷通好会计,好生意,智+好业财,用友培训服务售后公司,畅捷通运营培训服务公司

    版权所有:用友畅捷通软件 Copyright © 2024 All rights reserved.

    鲁ICP备2020041017号-6