已打最新補(bǔ)丁，有期初金額的往來(lái)單位在基礎(chǔ)設(shè)置-往來(lái)單位看不到，勾選包含停用也沒(méi)顯示。做憑證參照不到此客戶(hù)，查輔助賬有此單位

--執(zhí)行語(yǔ)句前備份賬套 update AA_PartnerAddress set isDefaultAddress= 1 where idpartner in ( select idpartner from AA_PartnerAddress group by idpartner having count(*)=1 ) 

--另外，檢查以下客戶(hù)是否設(shè)置的有默認(rèn)聯(lián)系方式，而且有且僅能有一個(gè) select id,code as '往來(lái)單位編碼',name as '往來(lái)單位名稱(chēng)' from aa_partner where id in ( select idpartner from AA_PartnerAddress group by idpartner having count(*)>1 ) 

--將聯(lián)系方式上面的默認(rèn)聯(lián)系方式更新到往來(lái)單位上 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