该问题已解决，明天上传语句给大家。

--将手工抹零金额分摊回单据及单据明细;
declare @sheet_no varchar(20),@ml_amt numeric(18,2),@pos_total_amt numeric(18,2),@rate numeric(18,6)
declare cur_sheet cursor for
select sheet_no,pos_total_amt from t_pos_sale_master where pos_status ='9'
open cur_sheet
fetch cur_sheet into @sheet_no,@pos_total_amt
while @@fetch_status =0
begin
select @ml_amt = IsNull(sum(payment_amt * coin_rate),0.00) from t_pos_sale_payment where sheet_no=@sheet_no and payment_no ='34'
if @ml_amt <= 0.00 goto next_
if @pos_total_amt<= 0.00 goto next_

select @rate = (@pos_total_amt - @ml_amt) / @pos_total_amt

update t_pos_sale_detail set sale_amt = round(sale_amt * @rate,2),real_price =round((sale_amt * @rate)/sale_qty,6) where sheet_no =@sheet_no

delete t_pos_sale_payment where sheet_no=@sheet_no and payment_no ='34'
update t_pos_sale_master set pos_total_amt = pos_total_amt - @ml_amt where sheet_no=@sheet_no

next_:
fetch cur_sheet into @sheet_no,@pos_total_amt
end
close cur_sheet
deallocate cur_sheet

go

declare @sheet_no varchar(20),@ml_amt numeric(18,2),@pos_total_amt numeric(18,2),@rate numeric(18,6)
declare cur_sheet1 cursor for
select sheet_no,pos_total_amt from t_pos_sale_master_fore where pos_status ='9'
open cur_sheet1
fetch cur_sheet1 into @sheet_no,@pos_total_amt
while @@fetch_status =0
begin
select @ml_amt = IsNull(sum(payment_amt * coin_rate),0.00) from t_pos_sale_payment_fore where sheet_no=@sheet_no and payment_no ='34'
if @ml_amt <= 0.00 goto next_
if @pos_total_amt<= 0.00 goto next_

select @rate = (@pos_total_amt - @ml_amt) / @pos_total_amt

update t_pos_sale_detail_fore set sale_amt = round(sale_amt * @rate,2),real_price =round((sale_amt * @rate)/sale_qty,6) where sheet_no =@sheet_no

delete t_pos_sale_payment_fore where sheet_no=@sheet_no and payment_no ='34'
update t_pos_sale_master_fore set pos_total_amt = pos_total_amt - @ml_amt where sheet_no=@sheet_no

next_:
fetch cur_sheet1 into @sheet_no,@pos_total_amt
end
close cur_sheet1
deallocate cur_sheet1

go

仅用于一单一商品情况下，一单多商品情况下不支持。