今天在进行销售云巡检时,又出现了"检查销售单据存在业务关联关系但实际业务被非法删除"巡检不通过的警示,烦,但该如何处理?
根据系统的操作建议一条条处理很烦琐,现提供之前总部老师的指导方法,以备忘也供需要的人员参考:
```language
--查询销售订单中“检查销售单据存在业务关联关系但实际业务被非法删除”的记录
SELECT '销售订单' fbilltype, FSTABLENAME, FSID, FTID fdeletedeid, FTID, FTTABLENAME, 'T_BF_INSTANCEENTRY' fqyerytable
--删除查询结果
--delete bfe
FROM T_BF_INSTANCEENTRY bfe WHERE
NOT EXISTS (SELECT *, 1 FROM T_SAL_ORDERENTRY WHERE FENTRYID = bfe.FTID)
and FCREATETIME>'2023-3-24' AND FTTABLENAME = 'T_SAL_ORDERENTRY'
--查询销售出库单中“检查销售单据存在业务关联关系但实际业务被非法删除”的记录
SELECT bfe.*
--删除查询结果
--delete bfe
FROM T_BF_INSTANCEENTRY bfe WHERE (((FCREATETIME > '2023-3-24' ) AND FTTABLENAME = 'T_SAL_OUTSTOCKENTRY')
AND NOT EXISTS (SELECT 1 FROM T_SAL_OUTSTOCKENTRY WHERE FENTRYID = bfe.FTID))
```
