找回密码
 注册账号

QQ登录

只需一步,快速开始

手机号码,快捷登录

手机号码,快捷登录

初学者课程:T3自学|T6自学|U8自学软件下载课件下载工具下载资料:通资料|U8资料|NC|培训|年结积分规则 | 使用常见问题Q&A
知识库:U8 | | NC | U9 | OA | 政务U8|U9|NCC|NC65|NC65客开|NCC客开新手必读 | 任务 | 快速增金币用友QQ群[微信群]
查看: 5217|回复: 1

[求助] 年收入统计

[复制链接]
发表于 2012-11-27 13:17:18 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。

您需要 登录 才可以下载或查看,没有账号?注册账号

×
我在做报表 年收入统计 为什么报错~无效数字。具体代码如下
select bd_psndoc.psncode"bd_psndoc.psncode",bd_psndoc.psnname"bd_psndoc.psnname",sum(wa_data.f_16)"岗位工资",sum(wa_data.f_74)"驻外津贴",sum(wa_data.f_163)"补发",sum(wa_data.f_31)"综合津贴(合计)",sum(wa_data.f_30)"综合津贴(劳务)",sum(wa_data.f_17)"综合津贴(正式)",sum(wa_data.f_64)"综合津贴(劳务)1",sum(wa_data.f_61)"综合津贴1",sum(wa_data.f_59)"工龄计算",sum(wa_data.f_37)"经营体",sum(wa_data.f_101)"考核结果",sum(wa_data.f_15)"绩效工资",sum(wa_data.f_75)"保育费",sum(wa_data.f_80)"高温费",sum(wa_data.f_81)"中班费",sum(wa_data.f_82)"夜班费",sum(wa_data.f_83)"劳防费",sum(wa_data.f_33)"卫生福利费",sum(wa_data.f_88)"就餐扣",sum(wa_data.f_76)"加班费",sum(wa_data.f_78)"保健费",sum(wa_data.f_79)"值班费",sum(wa_data.f_84)"营养费",sum(wa_data.f_77)"养老补贴",sum(wa_data.f_164)"附加工资",sum(wa_data.f_21)"奖励费",sum(wa_data.f_43)"部门奖励费",sum(wa_data.f_36)"职级制奖励费",sum(wa_data.f_183)"技术中心奖励费",sum(wa_data.f_73)"经验输入奖励费",sum(wa_data.f_182)"支部书记奖励费",sum(wa_data.f_55)"高温奖励费",sum(wa_data.f_42)"专利奖励费",sum(wa_data.f_40)"团委奖励费",sum(wa_data.f_41)"质量保证部奖励费",sum(wa_data.f_38)"持续改善办奖励费",sum(wa_data.f_44)"安全保障部奖励费",sum(wa_data.f_46)"上汽奖励费",sum(wa_data.f_47)"总经办奖励费",sum(wa_data.f_49)"手工焊奖励费(劳务)",sum(wa_data.f_50)"留沪奖励费(劳务)",sum(wa_data.f_39)"返乡费(劳务)",sum(wa_data.f_32)"星级津贴(劳务)",sum(wa_data.f_62)"星级津贴1",sum(wa_data.f_22)"一次性奖",sum(wa_data.f_179)"部门质量安全奖",sum(wa_data.f_180)"劳动竞赛",sum(wa_data.f_23)"嘉奖(劳务)",sum(wa_data.f_65)"各厂明星员工",sum(wa_data.f_66)"各厂管理奖",sum(wa_data.f_67)"各厂特殊补贴",sum(wa_data.f_69)"各厂超产奖",sum(wa_data.f_70)"各厂质量奖惩",sum(wa_data.f_72)"各厂其他费用",sum(wa_data.f_147)"应发工资",sum(wa_data.f_85)"歇工扣",sum(wa_data.f_86)"缺勤扣",sum(wa_data.f_173)"缺勤扣(病假)",sum(wa_data.f_174)"缺勤扣(事假)",sum(wa_data.f_175)"缺勤扣(百分率)",sum(wa_data.f_177)"缺勤扣(中心)",sum(wa_data.f_45)"个人养老",sum(wa_data.f_48)"个人医疗",sum(wa_data.f_51)"个人失业",sum(wa_data.f_68)"个人公积金",sum(wa_data.f_89)"会费",sum(wa_data.f_18)"党费",sum(wa_data.f_90)"住宿费"
from wa_data  inner join  bd_psndoc on wa_data.psnid = bd_psndoc.pk_psndoc  left outer join  bd_psncl on wa_data.nestpsnclid = bd_psncl.pk_psncl  left outer join  bd_deptdoc on wa_data.nestdeptid = bd_deptdoc.pk_deptdoc  left outer join  om_job on wa_data.pk_om_job = om_job.pk_om_job  left outer join  bd_defdoc on om_job.jobseries = bd_defdoc.pk_defdoc  left outer join  bd_defdoc as bd_defdoc_2 on om_job.jobrank = bd_defdoc_2.pk_defdoc  left outer join  bd_defdoc as bd_defdoc_3 on om_job.groupdef1 = bd_defdoc_3.pk_defdoc  left outer join  bd_defdoc as bd_defdoc_4 on om_job.groupdef2 = bd_defdoc_4.pk_defdoc  left outer join  wa_waclass on wa_data.classid = wa_waclass.addflag  left outer join  wa_bank on wa_data.bankid = wa_bank.accbankid  left outer join  bd_psnbasdoc on bd_psndoc.pk_psnbasdoc = bd_psnbasdoc.pk_psnbasdoc  left outer join  bd_defdoc as bd_defdoc_5 on bd_psndoc.jobseries = bd_defdoc_5.pk_defdoc
where (wa_data.cnestyear =#year# )and (wa_data.cnestperiod between #start# and #last#)
group by
bd_psndoc.psncode,bd_psndoc.psnname
发表于 2012-11-29 21:10:05 | 显示全部楼层
看这个东东,不好看问题。看下NCHOME/NCLOGS下的日志,查看下日志抛什么错误?在哪里抛错?
回复 点赞 拍砖

使用道具 举报

您需要登录后才可以回帖 登录 | 注册账号

本版积分规则

QQ|站长微信|Archiver|手机版|小黑屋|用友之家 ( 蜀ICP备07505338号|51072502110008 )

GMT+8, 2024-11-17 22:46 , Processed in 0.036939 second(s), 7 queries , Gzip On, Redis On.

Powered by Discuz! X3.5

© 2001-2024 Discuz! Team.

快速回复 返回顶部 返回列表