问题现象: | 原版本为U871标准版,在做零售单时不能保存,提示信息为“调用目标发生异常”,然后将管理端和门店客户端都升级至8.71SP2后,对数据库进行升级操作,在登陆时就出现报错。报错截图请见附件。 [2011-8-1 8:00:27 补充] 前面的版本说明有误,不是U871SP2,而是已经升级至U872标准版。 |
问题原因: | |
解决方案: | 您好,该问题一线已经重新安装门店解决,但是希望增加一个永久调价单,现出脚本如下 修改前请务必备份数据库: insert into PriceAdjustDetail select newid() as fchrdetailid, '做的调价单的主表id'as fchrPriceAdjustID, 你导入的表.零售价 as flotAdjustPrice 0 as flotAdjustParameter fchritemid as fchrID 0 as fchrType '做的调价单的fchrAccountID'as fchrAccountID 0 as ftinOrder 0 as fbitSpecial null as flotAdjustVipPrice1 null as flotAdjustVipPrice2 null as flotAdjustVipPrice3 null as flotAdjustVipPrice4 null as flotAdjustVipPrice5 null as flotAdjustVipPrice6 0 as flotPriceBeforeAdjust 0 as flotVipPrice1BeforeAdjust 0 as flotVipPrice2BeforeAdjust 0 as flotVipPrice3BeforeAdjust 0 as flotVipPrice4BeforeAdjust 0 as flotVipPrice5BeforeAdjust 0 as flotVipPrice6BeforeAdjust '0'as fbitNoUsed '做的调价单的fdtmLastModifyTime' as fdtmLastModifyTime from 你导入的表,item where 你导入的表.存货编码=item.fchritemcode 如有问题请及时与我联系 u8支持李春秋 lichq@ufida.com.cn |
相关补丁: | |
版本: | 分销与零售 |
模块: | 零售8.71 |
产品: | 零售 |
问题名称: | U871SP2零售版登陆时报错 |
最后更新: | 2011-08-10 23:20:33 |