解决方案: |
请执行如下两个脚本,执行前请好备份:
update gl_accvouch set nc_s=0 where i_id=2768
--更改凭证预览错误。
update UserDefine set cValue=replace(cValue,'%','%')
update UserDefine set cValue=replace(cValue,';',';')
update UserDefine set cValue=replace(cValue,'0','0')
update UserDefine set cValue=replace(cValue,'.','.')
update UserDefine set cValue=replace(cValue,'9','9')
update UserDefine set cValue=replace(cValue,'P','P')
update UserDefine set cValue=replace(cValue,'w','W')
update UserDefine set cValue=replace(cValue,'6','6')
update UserDefine set cValue=replace(cValue,'8','8')
update UserDefine set cValue=replace(cValue,'1','1')
update UserDefine set cValue=replace(cValue,'*','*')
update UserDefine set cValue=replace(cValue,'<','<')
update UserDefine set cValue=replace(cValue,'*','*')
update UserDefine set cValue=replace(cValue,'*','*')
update UserDefine set cValue=replace(cValue,'*','*')
update UserDefine set cValue=replace(cValue,'*','*')
update DispatchLists set cFree10=replace(cFree10,'%','%')
update DispatchLists set cFree10=replace(cFree10,';',';')
update DispatchLists set cFree10=replace(cFree10,'0','0')
update DispatchLists set cFree10=replace(cFree10,'.','.')
update DispatchLists set cFree10=replace(cFree10,'9','9')
update DispatchLists set cFree10=replace(cFree10,'P','P')
update DispatchLists set cFree10=replace(cFree10,'w','W')
update DispatchLists set cFree10=replace(cFree10,'6','6')
update DispatchLists set cFree10=replace(cFree10,'8','8')
update DispatchLists set cFree10=replace(cFree10,'1','1')
update DispatchLists set cFree10=replace(cFree10,'*','*')
update DispatchLists set cFree10=replace(cFree10,'<','<')
update DispatchLists set cFree10=replace(cFree10,'*','*')
update DispatchLists set cFree10=replace(cFree10,'*','*')
update DispatchLists set cFree10=replace(cFree10,'*','*')
update DispatchLists set cFree10=replace(cFree10,'*','*')
update CurrentStock set cFree10=replace(cFree10,'%','%')
update CurrentStock set cFree10=replace(cFree10,';',';')
update CurrentStock set cFree10=replace(cFree10,'0','0')
update CurrentStock set cFree10=replace(cFree10,'.','.')
update CurrentStock set cFree10=replace(cFree10,'9','9')
update CurrentStock set cFree10=replace(cFree10,'P','P')
update CurrentStock set cFree10=replace(cFree10,'w','W')
update CurrentStock set cFree10=replace(cFree10,'6','6')
update CurrentStock set cFree10=replace(cFree10,'8','8')
update CurrentStock set cFree10=replace(cFree10,'1','1')
update CurrentStock set cFree10=replace(cFree10,'*','*')
update CurrentStock set cFree10=replace(cFree10,'<','<')
update CurrentStock set cFree10=replace(cFree10,'*','*')
update CurrentStock set cFree10=replace(cFree10,'*','*')
update CurrentStock set cFree10=replace(cFree10,'*','*')
update CurrentStock set cFree10=replace(cFree10,'*','*')
--更改不能生成出库单。 |