We have around 280 Vendor Bills and associated Bill Payment transactions that have been posted to the wrong AP account. This happened due to a CSV import over a number of weeks where the AP account was not being defaulted in the import so the value last used in the UI was set as the default.
Updating the AP account on the Vendor Bill orphans the Bill Payment. I then tried updating the Bill Payment via a CSV import to set the AP account hoping that I can then reapply the Bill Payment to the Vendor Bill. Whilst the import ran without errors, it did not update the account.
Any pointers on how I can update the AP account for both Vendor Bill and Bill Payment transactions keeping the link intact would be appreciated.