We have a customer in our AR who has a zero balance outstandting but the statements and AR Aging show a balance due.
Somehow when we imported our customer data to Adagio in 2014 a 2001 customer was imported with a 2001 invoice still outstanding. An adjustment for the same customer was also imported which cleared this invoice but somehow that adjustment is dated 2020.

Therefore now we have a zero balance for this customer but it still shows the items as not cleared as they won't clear until the system thinks it is 2020 and applied the adjustment. Therefore when we print statements or look at aged customers this shows as outstanding unless we print the report as at 2020.

This causes our AR listings to be off from GL totals and other issues which we would rather fix now than wait until 2020 for the issue to clear itself.
Is there a way to change the date on the other adjustment so that it clears correctly?