金蝶云星空二开销售订单执行明细表报表界面行数与引出数据不相等

1. 背景客户要求根据多个报表生成一张报表各个单据需要关联性而且各个单据可能隔2-3种单据进行关联想到二开销售订单执行明细表来进行开发出现前端界面行数与引出数据不相等。1.2 罪魁祸首sql语句SELECT CASE WHEN FSETACCOUNTTYPE N财务应收 THEN FRECENTRYID ELSE NULL END AS FRECENTRYID_FIN, CASE WHEN FSETACCOUNTTYPE N财务应收 THEN FRECEIVEBILLNO ELSE NULL END AS FRECEIVEBILLNO_FIN, CASE WHEN FSETACCOUNTTYPE N财务应收 THEN FARDATE ELSE NULL END AS FARDATE_FIN, CASE WHEN FSETACCOUNTTYPE N财务应收 THEN FRECQTY ELSE NULL END AS FRECQTY_FIN, CASE WHEN FSETACCOUNTTYPE N财务应收 THEN FRECEIVECHARGEQTY ELSE NULL END AS FRECEIVECHARGEQTY_FIN, CASE WHEN FSETACCOUNTTYPE N财务应收 THEN FRECAMOUNT ELSE NULL END AS FRECAMOUNT_FIN, CASE WHEN FSETACCOUNTTYPE N财务应收 THEN FWRITEOFFAMOUNT ELSE NULL END AS FWRITEOFFAMOUNT_FIN, CASE WHEN FSETACCOUNTTYPE N财务应收 THEN FJSWRITEOFFAMOUNT ELSE NULL END AS FJSWRITEOFFAMOUNT_FIN, CASE WHEN FSETACCOUNTTYPE N财务应收 THEN FSETACCOUNTTYPE ELSE NULL END AS FSETACCOUNTTYPE_FIN, CASE WHEN FSETACCOUNTTYPE N财务应收 THEN FRECEIPTAMOUNT ELSE NULL END AS FRECEIPTAMOUNT_FIN, CASE WHEN FSETACCOUNTTYPE N财务应收 THEN t_AR_receivableEntry.FSOURCEBILLNO ELSE NULL END AS FSOURCEBILLNO_FIN INTO #PreprocessedTemp FROM QUOTENAME(GlobalTempRaw) N LEFT JOIN t_AR_receivableEntry ON t_AR_receivableEntry.FENTRYID QUOTENAME(GlobalTempRaw) N.FRECENTRYID1.3 原因销售订单执行明细表fidentityid字段重复以上sql语句导致新增行后fidentityid字段重复,结果导致引出数据与前端界面不一致注意fidentityid跳跃也会导致引出数据与前端界面不一致。1.4 解决方案使用该语句重新生成id存储过程最后更新至fidentityid字段。IDENTITY(int, 1, 1) as NewID