1/5用友股份-LE支持服务业务本部产品方案--《NC61客户关联供应商相关问题》建立日期：2013-07-01修改日期：xxxx-xx-xx文档属性：客户文控编号：LE-DY-CP-2013-02842/5文档控制创建记录适用范围审阅人日期审阅签字所属部门发布范围内部员工伙伴客户发布人姓名所属部门发布时间日期作者所属部门邮件地址版本2012-07-01高磊产品支持部V1.0版本领域模块备注NC61GL总账3/5目录NC61客户关联供应商相关问题..........................................................................4一、引言..............................................................................................................4二、应用场景及问题描述....................................................................................4三、解决方案.......................................................................................................44/5NC61客户关联供应商相关问题一、引言NC61版本客户关联供应商并且修改之后在总账查询账表会出现数据问题二、应用场景及问题描述客户关联供应商后取消关联，查询报表出现了数据的混淆三、解决方案1、执行脚本解决数据混淆问题（专项脚本，需要根据情况出具，此处仅作参考）updateap_payitemsetsupplier='1001T11000000004JUER'wheresupplier='1001T11000000000S72C';updatearap_verifydetailsetsupplier='1001T11000000004JUER'wheresupplier='1001T11000000000S72C';updatearap_busidatasetsupplier='1001T11000000004JUER'wheresupplier='1001T11000000000S72C';updatearap_tallysetsupplier='1001T11000000004JUER'wheresupplier='1001T11000000000S72C';updatearap_balancesetsupplier='1001T11000000004JUER'wheresupplier='1001T11000000000S72C';updateap_payableitemsetsupplier='1001T11000000004JUER'wheresupplier='1001T11000000000S72C';UPDATEgl_detailSETassid='1001T110000000067RA4'WHEREassid='1001T11000000000Y73R'ANDpk_accountingbook='1001T1100000000022KS'ANDperiodv<'02'ANDyearv='2013';5/5UPDATEgl_balanceSETassid='1001T110000000067RA4'WHEREassid='1001T11000000000Y73R'ANDpk_accountingbook='1001T1100000000022KS'ANDperiod<'02'ANDyear='2013';2、打平台补丁，杜绝此类问题。补丁名称：uapbd客商调整61.zip
