单据号重复，最大单据号问题
U8高版本可以用“U8智慧看板”工具处理，T3或者T6去畅捷通下载专门的软件，也可以通过以下语句
U890的版本可以在本站下载“最大单据号”检测修复工具，直接修复，有生产和其他单据两个版本
问题分析：ufsystem数据库中表ua_iadentity中ifather，ichildid小于出错数据库中所对应的主表和
用sql执行语句可解决：（ufdata_008_2010改为你所修改的帐套名）
发货单重复
use ufsystem
update ua_identity set ifatherid=(select max(dlid)from
ufdata_008_2010..dispatchlist),ichildid=(select max(idlsid)from
ufdata_008_2010..dispatchlists) where cacc_id='帐套号' and cvouchtype='DISPATCH'
销售发票重复
use ufsystem
update ua_identity set ifatherid=(select max(sbvid)from
ufdata_008_2010..salebillvouch),ichildid=(select max(autoid)from
ufdata_008_2010..salebillvouchs) where cacc_id='帐套号' and cvouchtype='billvouch'
（如果出错的是其他类型的单据，可以根据红色的字段，与下列ua_identity表中所对应的数据库表进行替换，下面的主子表代表出错的数据库中的表，不是ufsystem数据库中的。）
下表是UfSystem..Ua_identity 表中常用记录所对应的数据表及字段，
字段标识描述主表字段子表字段
Rd收发记录主子表Rdrecord.idRdrecords.autoid
BILLVOUCH销售发票主子表SaleBillVouch.SBVID SaleBillVouchs.autoid
DISPATCH发货退货单主子表DispatchList.dlidDispatchLists.idlsid
POMain采购订单主子表PO_Pomain.POIDPO_Podetails.id
SOMain销售订单主子表SO_SOMain.idSO_SODetails.autoid
PURBILL采购发票主子表PurBillVouch.PBVIDPurBillVouchs.ID
PURSTID采购结算单主子表PurSettleVouch.PSVIDPurSettleVouchs.ID
SETTLEVOUCH委托代销结算单主子表SA_SettleVouch.IDSA_SettleVouchs.Autoid
Ju出入库调整单主子表JustInVouch.IDJustInVouch.Autoid
PUAPP采购请购单主子表PU_AppVouch.IDPU_AppVouchs.Autoid
PUARRIVAL采购到货单主子表PU_ArrivalVouch.IDPU_ArrivalVouchs.Autoid
Tr库存调拨单主子表TransVouch.IdTransVouchs.Autoid
EXPENSE代垫费用单主子表ExpenseVouch.IDExpenseVouchs.Autoid
Ch盘点单主子表CheckVouch.ID CheckVouchs.Autoid
Ma限额领料单主子表MatchVouch.IDMatchVouchs.Autoid
SALEPAY销售支出单主子表SalePayVouch.IDSalePayVouchs.Autoid
QUOMAIN销售报价单主子表SA_QuoMain.IDSA_QuoDetails.Autoid
XJ收付款单主子表(销售现结使用)Ap_CloseBill.ccancelnoAp_CloseBills.ID
SK收付款单主子表(收款cCancelNo is null)Ap_CloseBill.iIDAp_CloseBills.ID
OM_MO委外订单主子表OM_MOMain.MoidOM_MODetails.MODetailsID
OM_MS
委外结算主子表OM_MatSettleVouch.MSIDOM_MatSettleVouchs.MSDetailsID
OM_Materials委外用料表OM_MOMaterials.MOIDOM_MOMaterials.MOMaterialsID
问题2：新增或者修改自定义档案，在保存的时候提示:键列信息不足或不正确，更新影响到多行
错误原因：查userdef表
userdef表中多了个触发器，T6的数据结构中没有这个触发器，请在查询分析器中找到这个表，
（userdef，右键-所有任务-管理触发器-名称-下拉选择，触发器-删除-确定）
问题：按保存时提示说:操作过程中发生资源共享冲突(可能单据号重复),请稍后重试!
解决：最大单据号检测修复,更改发货单的最大单据号的语句
use ufsystem update ua_identity set ifatherid=(select max(dlid)from ufdata_111_2012..dispatchlist),ichildid=(select max(idlsid)from ufdata_111_2012..dispatchlists) where cacc_id='111' and cvouchtype='DISPATCH'
问题：按保存时提示说：单据保存失败，不能在具有唯一索引...的对象..中出入重复键的行。
解决：最大单据号检测修复,更改入库单的最大单据号的语句
Update UFSystem..UA_Identity
Set iFatherId=(Select Max(ID) As ID From UFDATA_111_2012..RdRecord),
iChildId=(Select Max(AutoID) As AutoID From UFDATA_111_2012..RdRecords)
Where cAcc_Id='111' And cVouchType='rd'
应付应收单最大单据号
Update UFSystem..UA_Identity
Set iFatherId=(Select Max(ID) As IID From UFDATA_111_2012..ap_closebill),
iChildId=(Select Max(AutoID) As ID From UFDATA_111_2012..ap_closebills)
Where cAcc_Id='111' And cVouchType='sk'
PS: as 代表重命名列名或表名 111为要修改的帐套名 ufdata_111_2012为要修改的帐套数据库
以下是物料清单保存时处理的语句
update ua_identity set ifatherid=(select max(bomid)
from ufdata_999_2023..bom_bom),ichildid=(select max(bomid) from
ufdata_999_2023..bom_bom) where cacc_id=999 and cvouchtype='bom_bom'
update ua_identity set ifatherid=(select max(optionsid) from ufdata_999_2023..bom_opcomponentopt),
ichildid=(select max(optionsid) from ufdata_999_2023..bom_opcomponentopt)
where cacc_id=999 and cvouchtype='bom_opcomponentopt'
update ua_identity set ifatherid=(select max(OpComponentid) from ufdata_999_2023..bom_opcomponent),
ichildid=(select max(opComponentid) from ufdata_999_2023..bom_opcomponent)
where cacc_id=999 and cvouchtype='bom_opcomponent'
------------------------------------------------------------------------------------------
知识：用友做软件开发时，有一个表是专门存储最大单号的：
数据库名：Ufsystem.mdb，表名：UA_Identity，此表的字段如下：
字段名 意义
cAcc_Id 002
cVouchType 单据类型编码
iFatherId 主表标识，即主表ID
iChildId 子表标识，即子表ID
在表名：UA_Identity中，举例来说，对应cVouchType='Tr'的iFatherId和iChildId的数应对应主表TransVouch和子表TransVouchs最后一行的ID号，如果小于这两个数，保存单据时就会出现错误提示。
一般地，主表最大ID字段为ID，子表最大ID字段为 AutoID
两个错误提示的解决办法：
一、在使用用友软件中，在做某些业务单据时，无法保存，出现如下提示
这个问题主要是同一业务有多个人操作或在操作时非正常退出引起的，解决这个问题很简单，首先要保证这个业务就你一个人在操作，解决方法如下：
1.出现不能保存时，点确定，再点保存。
2.如果还是保存不上，返回第1步。
我发现，在Ufsystem.. UA_Identity表中，每保存一次，相应记录的两个字段iFatherId和iChildId会自动＋1，这样，反复执行这两步，就产生了最大的单号，可以保存了。
二、错误提示(不同的单据数据名不同，汉字基本相同)：
手工解决办法，打开对应数据库，主表TransVouch，子表TransVouchs，移到最下面一行，抄下其最大ID号，再打开Ufsystem.mdb….UA_Identity，找到相应的记录，填入这两个ID号即可。
也可以通过下面的SQL语句进行方便的修改，下面的SQL语句全部都是找出主表和子表的最大单据号，然后填入Ufsystem.mdb，表名为UA_Identity相应的记录字段中。
注意在执行某个SQL时，先把它复制到记事本中，然后修改002和2013，再打开SQL查询分析器执行。
范例：将"002"替换成"001"，"2013"替换成"2013"
原SQL语句
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..RDRECORD),
ichildid= (Select MAX(CAST(RIGHT(isnull(AUTOID,0),8) AS INT))as id from UFDATA_002_2013..RDRECORDS)
where (cvouchtype='rd'and cacc_id='002')
替换后
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_001_2013..RDRECORD),
ichildid= (Select MAX(CAST(RIGHT(isnull(AUTOID,0),8) AS INT))as id from UFDATA_001_2013..RDRECORDS)
where (cvouchtype='rd'and cacc_id='001')
各业务重复单号的解决方案
--1.出入库单（收发记录主子表）
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..RDRECORD),
ichildid= (Select MAX(CAST(RIGHT(isnull(AUTOID,0),8) AS INT))as id from UFDATA_002_2013..RDRECORDS)
where (cvouchtype='rd'and cacc_id='002')
--2.采购订单PO_Pomain和PO_Podetails
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(moID,0),8) AS INT))as id from UFDATA_002_2013..PO_Pomain),
ichildid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..PO_Podetails)
where (cvouchtype='Pomain'andi cacc_id='002')
21 委外订单
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(moID,0),8) AS INT))as id from UFDATA_002_2013..OM_MOMain),
ichildid= (Select MAX(CAST(RIGHT(isnull(MODetailsID,0),8) AS INT))as id from UFDATA_002_2013..OM_MODetails)
where (cvouchtype='om_mo'and cacc_id='002')
22 客户调价单
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013.. SA_CusPriceJustMain),
ichildid= (Select MAX(CAST(RIGHT(isnull(icusjustautoid,0),8) AS INT))as id from UFDATA_002_2013.. SA_CusUPrice)
where (cvouchtype=' SA_CusPriceJustMain'and cacc_id='002')
--3.采购发票PURBILL和PurBillVouchS
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(PBVID,0),8) AS INT))as id from UFDATA_002_2013..PurBillVouch),
ichildid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..PurBillVouchS)
where (cvouchtype='PURBILL'and cacc_id='002')
--4.采购结算单
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(PSVID,0),8) AS INT))as id from UFDATA_002_2013..PurSettleVouch),
ichildid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..PurSettleVouchs)
where (cvouchtype='PURSTID'and cacc_id='002')
--5.采购请购单
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..PU_AppVouch),
ichildid= (Select MAX(CAST(RIGHT(isnull(AUTOID,0),8) AS INT))as id from UFDATA_002_2013..PU_AppVouchs)
where (cvouchtype='PUAPP'and cacc_id='002')
--6.采购到货单
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..PU_ArrivalVouch),
ichildid= (Select MAX(CAST(RIGHT(isnull(AUTOID,0),8) AS INT))as id from UFDATA_002_2013..PU_ArrivalVouchS)
where (cvouchtype='PUARRIVAL'and cacc_id='002')
--7.销售发票
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(SBVID,0),8) AS INT))as id from UFDATA_002_2013..SaleBillVouch),
ichildid= (Select MAX(CAST(RIGHT(isnull(AUTOID,0),8) AS INT))as id from UFDATA_002_2013..SaleBillVouchS)
where (cvouchtype='BILLVOUCH'and cacc_id='002')
--8.销售发货单
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(DLID,0),8) AS INT))as id from UFDATA_002_2013..DispatchList),
ichildid= (Select MAX(CAST(RIGHT(isnull(AUTOID,0),8) AS INT))as id from UFDATA_002_2013..DispatchListS)
where (cvouchtype='DISPATCH'and cacc_id='002')
--9.销售订单
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..SO_SOMain),
ichildid= (Select MAX(CAST(RIGHT(isnull(AUTOID,0),8) AS INT))as id from UFDATA_002_2013..SO_SODetails)
where (cvouchtype='SOMain'and cacc_id='002')
--10.销售_委托代销结算单
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..SA_SettleVouch),
ichildid= (Select MAX(CAST(RIGHT(isnull(AUTOID,0),8) AS INT))as id from UFDATA_002_2013..SA_SettleVouchS)
where (cvouchtype='SETTLEVOUCH'and cacc_id='002')
--11.销售_销售报价单
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..SA_QuoMain),
ichildid= (Select MAX(CAST(RIGHT(isnull(AUTOID,0),8) AS INT))as id from UFDATA_002_2013..SA_QuoDetails)
where (cvouchtype='QUOMAIN'and cacc_id='002')
--12.销售_销售支出单
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..SalePayVouch),
ichildid= (Select MAX(CAST(RIGHT(isnull(AUTOID,0),8) AS INT))as id from UFDATA_002_2013..SalePayVouchS)
where (cvouchtype='SALEPAY'and cacc_id='002')
--13.销售_代垫费用单（应收）
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..ExpenseVouch),
ichildid= (Select MAX(CAST(RIGHT(isnull(AUTOID,0),8) AS INT))as id from UFDATA_002_2013..ExpenseVouchS)
where (cvouchtype='EXPENSE'and cacc_id='002')
--14.库存_盘点单
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..CheckVouch),
ichildid= (Select MAX(CAST(RIGHT(isnull(AUTOID,0),8) AS INT))as id from UFDATA_002_2013..CheckVouchS)
where (cvouchtype='CH'and cacc_id='002')
--14.存货_调整单
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..JustInVouch),
ichildid= (Select MAX(CAST(RIGHT(isnull(AUTOID,0),8) AS INT))as id from UFDATA_002_2013..JustInVouchS)
where (cvouchtype='JU'and cacc_id='002')
--15.库存_限额领料单
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..MatchVouch),
ichildid= (Select MAX(CAST(RIGHT(isnull(AUTOID,0),8) AS INT))as id from UFDATA_002_2013..MatchVouchS)
where (cvouchtype='MA'and cacc_id='002')
--16.库存_库存调拨单
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..TransVouch),
ichildid= (Select MAX(CAST(RIGHT(isnull(AUTOID,0),8) AS INT))as id from UFDATA_002_2013..TransVouchS)
where (cvouchtype='TR'and cacc_id='002')
--16.采购_销售现结线索号,本字段为"XJ"加流水号，所以要去除2位字符,但是反向操作"弃结"系统不回写减少ua_identity，下次增加直接加1。
update ufsystem..ua_identity
set ifatherid= (SELECT max(CAST(RIGHT(isnull(STUFF(cCancelNo,1,2, ''),0),8) as int))as id from UFDATA_002_2013..Ap_CloseBill),
ichildid= (SELECT max(CAST(RIGHT(isnull(STUFF(cCancelNo,1,2, ''),0),8) as int))as id from UFDATA_002_2013..Ap_CloseBill)
where (cvouchtype='XJ'and cacc_id='002')
--16.收款单
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(iID,0),8) AS INT))as id from UFDATA_002_2013..Ap_CloseBill),
ichildid= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..Ap_CloseBillS)
where (cvouchtype='SK'and cacc_id='002')
--16.生产订单
update ufsystem..ua_identity
set ifatherid= (Select MAX(CAST(RIGHT(isnull(moID,0),8) AS INT))as id from UFDATA_002_2013..mom_order),
ichildidi= (Select MAX(CAST(RIGHT(isnull(ID,0),8) AS INT))as id from UFDATA_002_2013..Ap_CloseBillS)
where (cvouchtype='SK'and cacc_id='002')
17 收发记录（10.1以后版本）
select MAX(id)
from (select MAX(id) as id from RdRecord01 union
select MAX(id) as id from RdRecord08 union
select MAX(id) as id from RdRecord09 union
select MAX(id) as id from rdrecord10 union
select MAX(id) as id from rdrecord11 union
select MAX(id) as id from rdrecord32 union
select MAX(id) as id from rdrecord34)t
select MAX(autoid)
from (select MAX(autoid) as autoid from RdRecords01 union
select MAX(autoid) as autoid from RdRecords08 union
select MAX(autoid) as autoid from RdRecords09 union
select MAX(autoid) as autoid from rdrecords10 union
select MAX(autoid) as autoid from rdrecords11 union
select MAX(autoid) as autoid from rdrecords32 union
select MAX(autoid) as autoid from rdrecords34)t附录：业务所对应的表格名：
对应单据名称
cvouchtype
data库中相关联主子表
相关联主子表ID字段标识
采购请购单
PuApp
PU_AppVouch/s
ID/Autoid
采购订单
Pomain
PO_Pomain/PO_Podetails
POID/ID
采购到货单
PuArrival
PU_ArrivalVouch/s
ID/autoid
采购入库单
rd
Rdrecord/s
ID/Autoid
采购发票
Purbill
PurBillVouch/s
PBVID/ID
销售报价单
QuoMain
SA_QuoMain/ SA_QuoDetails
ID/Autoid
销售订单
Somain
SO_SOMain/SO_SODetails
ID/Autoid
销售发（退）货单
Dispatch
DispatchList/s
DLID/Autoid
销售发票
Billvouch
SaleBillVouch/s
SBVID/Autoid
委托代销发货(退)单
Dispatch
DispatchList/s
DLID/Autoid
委托代销结算单
SettleVouch
SA_SettleVouch/s
ID/Autoid
委托代销调整单
Dispatch
DispatchList/s
DLID/Autoid
销售调拨单(红、蓝)
Billvouch
SaleBillVouch/s
SBVID/Autoid
销售零售日报(红、蓝)
Billvouch
SaleBillVouch/s
SBVID/Autoid
代垫费用单
Expense
ExpenseVouch/s
ID/Autoid
销售支出单
Salepay
SalePayVouch/s
ID/autoid
委外发票
Wwpurbill
OM_PurBillVouch/s
PBVID/ID
产成品入库单
rd
Rdrecord/s
ID/Autoid
其他入库单
rd
Rdrecord/s
ID/Autoid
材料出库单
rd
Rdrecord/s
ID/Autoid
其他出库单
rd
Rdrecord/s
ID/Autoid
调拨单
tr
TransVouch/s
ID/Autoid
盘点单
ch
CheckVouch/s
ID/autoid
限额领料单
ma
MatchVouch/s
ID/autoid
不合格品记录单
sc
ScrapVouch/ScrapVouchs
ID/Autoid
不合格品处理单
sc
ScrapVouch/ScrapVouchs
ID/Autoid
货位调整单
ad
AdjustPVouch/s
ID/Autoid
应收应付单
sk
ap_closebill/s
IID/ID
客户调价单
SA_CusPriceJustMain
Sa_cuspricejustmain/sa_cuspricejustdetail
Id/autoid
委外订单
om_mo
Om_momain/om_modetails
Moid/MODetailsID
委外用料单子表
OM_Materials
OM_MOMaterials
MOMaterialsID
组装拆卸形态转换单
as
Assemvouch/assemvouchs
备注
1
强制类型转换
cast(column_name as varchar2(20))之类的
2
Isnull 函数主要作用是将为空的值替换为指定值，如果不为空返回检查类型的返回值，isnull的语法：
Isnull （check_expression , replacement_value）
参数check_expression ,是待检查是否为空的表达式，参数replacement_value是带替换的指定值，如果参数check_expression为空则参数replacement_value进行填充，如果check_expression不为空，则返回表达式相应的返回值类型，需要注意到是参数check_expression和参数replacement_value的类型需要保持一致，否则要进行相应的转换
3
select right('1234',2)结果：34
反回字符右边的指定长度的字符
3
根据表名缩写推测：
Sc 报废单主表（ScrapVouch）
As 组装拆卸形态转换单主表（AssemVouch Table）
Ad 货位调整单主表（AdjustPVouch）
Cj 计划价或售价调整单主表（CostJustVouch
SK 代表收付款主子表
————————————————
