【出纳管理】付款单选择供应商带出的收款人名称和收款人实名不一致

【问题描述】付款单选择供应商带出的收款人名称和收款人实名不一致

供应商财务资料页签检查是一致

解决方案：

1、查询供应商

select * from T_BD_Supplier where fid ='供应商fid'

2、查询供应商财务信息

select * from T_BD_SUPPLIERCOMPANYINFO where FSUPPLIERID  ='供应商fid'

3、查询供应商财务银行

select * from T_BD_SupplierCompanyBank where FSUPPLIERCOMPANYINFOID in (select fid from T_BD_SUPPLIERCOMPANYINFO where FSUPPLIERID  ='供应商fid')

4、批量更新收款人名称

update T_BD_SupplierCompanyBank set FBENEFICIARY='正确的收款人实名' where  FSUPPLIERCOMPANYINFOID in (select fid from T_BD_SUPPLIERCOMPANYINFO where FSUPPLIERID  ='供应商fid')