Update the Liability account for the existing supplier liability account

Hello All ,

We have loaded new Suppliers & supplier sites during our recent go live with the wrong liability account  ( say instead of 2085031 its loaded as 208501 )

Since they are more than 1000 Suppliers we have loaded into the system , we cant update the liability account  manually from application .

Q1 ) Can we update the ACCTS_PAY_CODE_COMBINATION_ID column in PO_VENDOR_SITES_ALL  from back end  ? is this a recommended solution ?

Q2 ) Is there any alternative approaches  or solution to update the liability account  for existing  suppliers ?

Appreciate any kind of  inputs !

Thankyou,

Deepthi.