用友软件各种单据最大单据号的解决方法!
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+搜索>>上找一下答案
相关阅读
- 用友U8不同的核算方式如何影响存货成本2021-10-9 10:15:1
- 用友U8材料采购科目借贷发生不平有余额是什么原因详解2021-10-9 9:57:49
- 用友U8电子文档管理详解2021-9-26 11:31:31
- 用友U8哪些办法可以让库存更准确详解2021-9-26 11:24:19
- 用友u8无法自动备份问题解决方法2020-4-10 10:50:44
- 用友U8固定资产科目设置详解2020-4-8 8:14:24
- U8标准成本详解2019-9-29 13:36:49
- 用友U8 系统运行越来越慢2019-4-23 8:0:0
- 用友U8 系统运行越来越慢2019-4-23 8:0:0
- 用友U8 系统运行越来越慢2019-4-23 8:0:0
最新信息
购置47000元的电脑作为固定资产。用平均年限法折旧怎么做算,怎么做凭证 购置47000元的电脑作为固定资产。用平均年限法折旧怎么做算,怎么做凭证
???年折旧额=[固定资产原值*(1-残值率)]/预计使用年限,假定残值率为5%,预计使用年限为3年,则年折旧额=[47000*(1-5%)]/3=14883.33元。???分录为:????????借:管理费用14883.33????????????贷:累计折旧14883.33电脑是按单台计提折旧,如果单台不超过5000,可一次性计入成本费用