用友软件各种单据最大单据号的解决方法！

2019-4-23 8:0:0　wondial

用友软件各种单据最大单据号的解决方法！

用友软件各种单据最大单据号的解决方法

1、发货单

* 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、委托代销结算单

* 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、调拨单

* 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、销售发票

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

如果您的问题还没有解决，可以到 T+搜索>>上找一下答案

分享到：

微博关注

bj用友软件

最新信息

t+11.60 升级t+12.0标准版登陆进去有显示演示版怎么回事

t+11.60 升级t+12.0标准版登陆进去有显示演示版怎么回事 t+11.60 升级t+12.0标准版登陆进去有显示演示版怎么回事[]

重新注册加密狗后，需要更新12.0的补丁。
@畅捷支持侯椿寳:已经重新注册，但是还不行
@邱丽丽miq:急谢谢回答一下
补丁是否更新。
@畅捷支持侯椿寳:最新补丁了
检查加密狗注册时的到期日期。
@畅捷支持侯椿寳:你好怎么查看，新的T+12.0注册网址是多少？
T+登录首页有注册网址的链接。