存货核算期末反结账的时候报错
金蝶云社区-云社区用户81Uv5361
云社区用户81Uv5361
0人赞赏了该文章 490次浏览 未经作者许可,禁止转载编辑于2016年08月03日 12:07:38

update T_IM_PurInWarehsBill as bill set (FFIVouchered,FVoucherId)=(select 1 as FFiVouchered,pinvoucher.FVoucherId from T_IM_PurInWarehsVoucher as pinvoucher inner join t_gl_voucher as voucher on voucher.fid=pinvoucher.FVoucherID where bill.fid=pinvoucher.FBillID and voucher.fPeriodID='Ut4AAAAJoQ6COIxM' AND PINVOUCHER.FCommpanyOrgUnitId='Ut4AAAAAB+fM567U' and pinvoucher.FVoucherType=1)
ORA-01427:single-row subquery returns more than one row

目前没有找到相关的原因,还请谁大侠能指导下
PurInWarehsVoucher 这张表是什么表啊