用友T+12.1客户往来数据异常

已打最新补丁，有期初金额的往来单位在基础设置-往来单位看不到，勾选包含停用也没显示。做凭证参照不到此客户，查辅助账有此单位

--执行语句前备份账套 update AA_PartnerAddress set isDefaultAddress= 1 where idpartner in ( select idpartner from AA_PartnerAddress group by idpartner having count(*)=1 ) 

--另外，检查以下客户是否设置的有默认联系方式，而且有且仅能有一个 select id,code as '往来单位编码',name as '往来单位名称' from aa_partner where id in ( select idpartner from AA_PartnerAddress group by idpartner having count(*)>1 ) 

--将联系方式上面的默认联系方式更新到往来单位上 update AA_Partner set AA_Partner.Contact=AA_PartnerAddress.contact, AA_Partner.TelephoneNo=AA_PartnerAddress.TelephoneNo, AA_Partner.Fax=AA_PartnerAddress.Fax, AA_Partner.EmailAddr=AA_PartnerAddress.EmailAddr, AA_Partner.MobilePhone=AA_PartnerAddress.MobilePhone, AA_Partner.QqNo=AA_PartnerAddress.QqNo, AA_Partner.MsnAddress=AA_PartnerAddress.MsnAddress, AA_Partner.UuNo=AA_PartnerAddress.UuNo, AA_Partner.ShipmentAddress=AA_PartnerAddress.ShipmentAddress, AA_Partner.AddressJC=AA_PartnerAddress.name, AA_Partner.Position=AA_PartnerAddress.Position, AA_Partner.Birthday=AA_PartnerAddress.Birthday from AA_PartnerAddress where AA_PartnerAddress.idpartner=AA_Partner.id and AA_PartnerAddress.isDefaultAddress=1