The ALL_PAYMENTS table is populated as part of the Populate Reports tables (Datamart) job. The number of years worth of data is determined by the system property "Finance No. Previous Years Reported". The default value is 2.
The current value can be determined by running the following SQL
select * from system_properties where name = 'Finance No. Previous Years Reported'
To change the value, run the following SQL specifying the number of years required. This example is for 5 years.
update system_properties set value='5' where name = 'Finance No. Previous Years Reported'
📌Note: The change will take affect after Mosaic as restarted and when the populate reports job runs again.
For hosted customers please raise a case and reference the title of this article.