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

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

    詳細信息

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

    用友軟件各種單據(jù)最大單據(jù)號的解決方法!

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

    人工客服

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

    用友軟件各種單據(jù)最大單據(jù)號的解決方法

    1、發(fā)貨單

    * dbo.UA_Identity
    set ifatherid=(* Max(Cast(right(isnull(DLid,0),7) AS INT))AS ID FROM
    UFDATA_006_2012..
    dispatchlist),
    ICHILDID=(* Max(Cast(right(isnull(aoutoid,0),7) AS INT))AS ID FROM
    UFDATA_006_2012..dispatchlists) WHERE

    (CVOUCHTYPE=*dispatch* AND CACC_ID=*006*)


    2、委托代銷結(jié)算單

    * dbo.UA_Identity
    set ifatherid=(* Max(Cast(right(isnull(id,0),7) AS INT))AS ID FROM
    UFDATA_006_2012..
    SA_SETTLEVOUCH),
    ICHILDID=(* Max(Cast(right(isnull(AUTOid,0),7) AS INT))AS ID FROM
    UFDATA_006_2012..SA_SETTLEVOUCHS) WHERE

    (CVOUCHTYPE=*SETTLEVOUCH* AND CACC_ID=*006*)


    3、調(diào)撥單

    * dbo.UA_Identity
    set ifatherid=(* Max(Cast(right(isnull(id,0),7) AS INT))AS ID FROM
    UFDATA_006_2012..
    transvouch),
    ICHILDID=(* Max(Cast(right(isnull(AUTOid,0),7) AS INT))AS ID FROM
    UFDATA_006_2012..transvouchs) WHERE (CVOUCHTYPE=*tr*

    AND CACC_ID=*006*)


    4,出入庫單

    * dbo.UA_Identity
    set ifatherid=(* Max(Cast(right(isnull(id,0),7) AS INT))AS ID FROM
    UFDATA_006_2012..
    rdrecord32),
    ICHILDID=(* Max(Cast(right(isnull(AUTOid,0),7) AS INT))AS ID FROM
    UFDATA_006_2012..rdrecords32) WHERE (CVOUCHTYPE=*rd*

    AND CACC_ID=*006*)


    5、銷售發(fā)票

    * dbo.UA_Identity
    set ifatherid=(* Max(Cast(right(isnull(sbvid,0),7) AS INT))AS ID FROM
    UFDATA_006_2012..
    salebillvouch),
    ICHILDID=(* Max(Cast(right(isnull(AUTOid,0),7) AS INT))AS ID FROM
    UFDATA_006_2012..salebillvouchs) WHERE

    (CVOUCHTYPE=*billvouch* AND CACC_ID=*006*)


    6、銷售訂單

    * UA_Identity
    set ifatherid=(* Max(Cast(right(isnull(id,0),7) AS INT))AS ID FROM
    UFDATA_006_2012..SO_SOMAIN),
    ICHILDID=(* Max(Cast(right(isnull(AUTOid,0),7) AS INT))AS ID FROM
    UFDATA_006_2012..SO_SODetails) WHERE

    (CVOUCHTYPE=*SOMAIN* AND CACC_ID=*006*)


    7、采購訂單

    * UA_Identity
    set ifatherid=(* Max(Cast(right(isnull(cPOid,0),7) AS INT))AS ID FROM
    UFDATA_006_2012..PO_POMAIN),
    ICHILDID=(* Max(Cast(right(isnull(id,0),7) AS INT))AS ID FROM
    UFDATA_006_2012..PO_PODetails) WHERE (CVOUCHTYPE=*POMAIN*

    AND CACC_ID=*006*)

     

     

    上一篇:用友U8C服務(wù)器環(huán)境配置要求

    客服電話:400-665-0028

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

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

    魯ICP備2020041017號-6