详细信息

您现在的位置：网站首页 >> 百科问答 >> 详细信息

新建T+报表提示已添加了具有相同键的项

【业务场景】：

客户新建报表提示已添加了具有相同键的项

【问题解决】：

备份数据，执行脚本，按会计制度不同区分脚本，再去执行脚本

2007会计制度执行脚本：-恢复2007的增值税申报表等所有税表出厂设置，执行后重新打开就行了

DELETE SR_ReportDataFormula where idReportDataDTO in (Select id FROM SR_ReportData where templateID in(-1041,-1050,-1051,-1061,-1071,-1081))

DELETE SR_ReportDataCell where idReportDataDTO in(Select id FROM SR_ReportData where templateID in(-1041,-1050,-1051,-1061,-1071,-1081))

DELETE SR_ReportData where templateID in(-1041,-1050,-1051,-1061,-1071,-1081)

DELETE SR_PeriodTemplate where TemplateID in(-1041,-1050,-1051,-1061,-1071,-1081)

DELETE SR_KeyWord where TemplateID in(-1041,-1050,-1051,-1061,-1071,-1081)

DELETE SR_TemplateCell where idTemplateDTO in(Select id FROM SR_Template where templateSourceID in(-1041,-1050,-1051,-1061,-1071,-1081))

DELETE SR_Template where templateSourceID in(-1041,-1050,-1051,-1061,-1071,-1081)

2013会计制度执行脚本：--恢复2013的增值税申报表等所有税表出厂设置，执行后重新打开就行了

DELETE SR_ReportDataFormula where idReportDataDTO in (Select id FROM SR_ReportData where templateID in(-15041,-15050,-15051,-15061,-15071,-15081))

DELETE SR_ReportDataCell where idReportDataDTO in(Select id FROM SR_ReportData where templateID in(-15041,-15050,-15051,-15061,-15071,-15081))

DELETE SR_ReportData where templateID in(-15041,-15050,-15051,-15061,-15071,-15081)

DELETE SR_PeriodTemplate where TemplateID in(-15041,-15050,-15051,-15061,-15071,-15081)

DELETE SR_KeyWord where TemplateID in(-15041,-15050,-15051,-15061,-15071,-15081)

DELETE SR_TemplateCell where idTemplateDTO in(Select id FROM SR_Template where templateSourceID in(-15041,-15050,-15051,-15061,-15071,-15081))

DELETE SR_Template where templateSourceID in(-15041,-15050,-15051,-15061,-15071,-15081)