(FAQ)销售退货申请单业务完结但单据未关闭
金蝶云社区
622次浏览
编辑于2015年03月02日 00:00:00
【问题】: (FAQ)销售退货申请单业务完结但单据未关闭
版本: 7.5
模块: 销售管理
【答复】:
-- 1、已完结分录更新为关闭 update T_SD_SaleReturnsEntry set fbasestatus = 7 where fbasestatus=4 and fbaseqty <=freturnsbaseqty and fremainingbaseqty<=0 and fassociateqty <=0 -- 2、分录全部关闭则单头关闭 update t_sd_salereturns set fbasestatus = 7 where fbasestatus =4 and fid not in (select distinct fparentid from T_SD_SaleReturnsEntry where fbasestatus != 7 )
版本: 7.5
模块: 销售管理
【答复】:
-- 1、已完结分录更新为关闭 update T_SD_SaleReturnsEntry set fbasestatus = 7 where fbasestatus=4 and fbaseqty <=freturnsbaseqty and fremainingbaseqty<=0 and fassociateqty <=0 -- 2、分录全部关闭则单头关闭 update t_sd_salereturns set fbasestatus = 7 where fbasestatus =4 and fid not in (select distinct fparentid from T_SD_SaleReturnsEntry where fbasestatus != 7 )
推荐阅读