The only solution I can think of is is to remove payment, apply changes and then re apply payment.
Step 1: Using DataDear get all the Invoices in a separate sheet in the Invoices & Bills Template workbook - you can use filters to only get ‘
Paid’ Invoices and in the period you need. This is your backup so do not refresh or delete this page.
Step 2: Remove payments from Xero (DataDear cannot help with this one)
Step 3: In the workbook created earlier in Step 1, use the
Get Data to Edit button and get all required invoices to be fixed (filters can be used).
Step 4: Change whatever is required in the accounts plus enter the payment details in the columns X to AC - you may use Excel functionality to map these records to the other sheet created in step 1 and payments will load automatically (example using
vlookup). You may also do this manually but will take time for 2,000 Invoices.
Step 5: Use the
Post Online (I would suggest testing this in small batches to ensure all goes well)
Hope that helps - if you need any help with building a model in Step 4, feel free to contact me with a private message