网站首页 > 服务与支持 > 常见问题

怎样删除红字单据?

2016-10-23 10:09:09 岳阳诺尔软件科技有限公司 阅读

删除红字反冲单据,在查询分析器中执行以下代码:

delete from Salemanagebill where bill_id in (select billid from billidx where billstates =1 or billstates =4)
delete from buymanagebill where bill_id in (select billid from billidx where billstates =1 or billstates =4)
delete from accountDetail where billid in (select billid from billidx where billstates =1 or billstates =4)
delete from productDetail where billid in (select billid from billidx where billstates =1 or billstates =4)
delete from billidx where billstates =1 or billstates =4


适用于药易通、卓越精算T3、卓越精财、卓越精算T9、精算服装T6。

岳阳诺尔软件科技有限公司 版权所有 2008-2014 湘ICP备12010268号