This column in the B13 report depends on the calendar year configuration you have at your site. For example, we'll assume our current year is the 2024-25 financial year, and you're expecting to see the Expenditure Next Year column from the report for the 2025-26 financial year. Once you understand the principle, you'll be able to apply it to any year we're in.
📌Note: Test the following in the non-prod environment first before making changes to a prod environment.
Check in the Calendar Maintenance area of the Admin Tool to make sure you've set up and activated a calendar year for 2025/26. If not, the table called all_payments, which the B13 report draws from, will be empty for the year_ID '2025/26', causing the 'Expenditure Next Year' field to be empty.
To resolve this, you'll need to set the Bank Holidays for next year and activate the next year in 'Calendar Maintenance' via the Admin Tool.
Once you've activated that calendar year, let the populate reports job run once before you verify the 'Expenditure Next Year' report field.
Try it first in the non-prod environment before making changes to Prod to test if it works. If you're a self-hosted customer, your DBA can control the running of the Populate Reports job to update the datamart reports tables. For hosted customers, if you want to test a non-live instance first, please raise a request to have the Populate Reports job run on a test instance you specify, and we can arrange that with the relevant team.
It's very important to follow the usual guidelines to set the bank holidays and other special dates that are locally significant in your council. If you notice a calendar has incorrect or missing dates once it's activated, you'll need to send a request to the support team to rectify it, and this would be chargeable. So, please take care before clicking to activate.
A list of formal bank holiday dates for next year can be found on the Government's website:
https://www.gov.uk/bank-holidays
If there's still an issue with this field after you've done the above, please raise a new case with the following:
The latest Pop Script Logs.
A full screenshot from your Calendar Maintenance window in the Admin Tool.
A full screenshot of the parameters you're using to run the B13 report.