问题现象: | 凭证打印时不显示制单人等相关信息 |
问题原因: | U821中允许人员编码重复使用,而升级后872是不允许重复编码的,存在重复记录后,计算公式计算不出来 |
解决方案: | SELECT * into psn FROM (SELECT cGZGradeNum, cPsn_Num, MAX(dInTime) AS Expr1 FROM WA_psn GROUP BY cGZGradeNum, cPsn_Num) DERIVEDTBL--取出最新增加人员 select wa_psn.* into bak from wa_psn,psn where wa_psn.cGZGradeNum = psn.cGZGradeNum and wa_psn.cPsn_Num =psn.cPsn_Num and dintime = psn.expr1 |
相关补丁: | |
版本: | 8.52 |
模块: | 其他 |
产品: | U852 |
问题名称: | 工资部份人员计算不出工资项 |
最后更新: | 2008-05-20 00:00:00 |