存货核算期末反结账的时候报错

栏目:eas cloud知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:2

存货核算期末反结账的时候报错

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 这张表是什么表啊


版本是EAS 7.5的

存货核算期末反结账的时候报错

update T_IM_PurInWarehsBill as bill set (FFIVouchered,FVoucherId)=(select 1 as FFiVouchered,pinvoucher.FVoucherId from T...
点击下载文档
分享:
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息