用友U8 1.销售发货单0000000465不能生成销售出库单,出错提示:“存货,对应的发货单存货不存在或者已被改变。新增单据保存失败” 2.材料出库单0000000214、0000000215记账,生成凭证后不能打印,出现被零除错误。用友U8 1.销售发货单0000000465不能生成销售出库单,出错提示:“存货,对应的发货单存货不存在或者已被改变。新增单据保存失败” 2.材料出库单0000000214、0000000215记账,生成凭证后不能打印,出现被零除错误。
问题原因:1、对于第一个问题,主要是由于在UserDefine、DispatchLists、CurrentStock的表中,存货自定义项字段(主要在‘备注1’中)存在全角字符,造成不能生成出库单(请建议用户以后不要录入全角字符,否则还会发生类似现象)。 2、对于合并生成凭证,预览出错,主要是因数合并后数量为0,但在数据库 GL_ACCVOUCH 的 nc_s 字段有值造成。 解决方法:请执行如下两个脚本,执行前请好备份: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,'*','*') --更改不能生成出库单。
解决方案:
问题原因:1、对于第一个问题,主要是由于在UserDefine、DispatchLists、CurrentStock的表中,存货自定义项字段(主要在‘备注1’中)存在全角字符,造成不能生成出库单(请建议用户以后不要录入全角字符,否则还会发生类似现象)。 2、对于合并生成凭证,预览出错,主要是因数合并后数量为0,但在数据库 GL_ACCVOUCH 的 nc_s 字段有值造成。 解决方法:请执行如下两个脚本,执行前请好备份: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,'*','*') --更改不能生成出库单。
www.kuaiji66.com 天龙瑞德