一、车辆费用单怎么修改和删除
处理方法:
1、车辆费用单开单界面点击调入单据,可以调需要修改的单据进来修改。
2、备份数据后执行下面脚本进行删除:
DELETE FROM dbo.CM_FeeIndex WHERE BillCode='替换成要删除的单据编号'
DELETE FROM dbo.CM_FeeBill WHERE BillNumberId IN(SELECT BillNumberId FROM dbo.CM_FeeIndex WHERE BillCode='替换成要删除的单据编号')
DELETE FROM dbo.CM_FeeBill WHERE BillNumberId NOT IN(SELECT BillNumberId FROM dbo.CM_FeeIndex )