| 解决方案： |
1.select distinct cdept_id from gl_accvouch where cdept_id not in (select cdepcode from department)
select distinct cCus_id from gl_accvouch where cCus_id not in (select cCusCode from customer)
select distinct cPeron_id from gl_accvouch where cCus_id not in (select cPersoncode from Person)
检查是否存在明细账中对应档案不存在，返回为NULL
2.测试zt888演示账套及ufdata_001_2003 无问题,确定数据问题
3.跟踪发现 select * from printex where csystemname = 'AR' and nTableNum= 16返回结果不一致(对比ufdata_888_2004,ufdata_001_2004)
SQL EM复制 粘贴此记录 测试正常,客户端测试不正常
4.备份数据 SQLEM 导表printex from ufdata_888_2004 => ufdata_001_2004,ufdata_001_2005,注意选择复制表和视图,且转换中选择 替换(默认 附加)
5.用户确认OK
|