Statetement designer - not updating current year figures


I am trying to run a an IS through the statement designer function in Sage 300 ACCPAC. August would be period 1 of FY2022, however when I select this period, all the figures that come back are 0. If I select period 12 FY2021, everything runs as normal up to July 2021. 

The formula in the statement is below, and it ties to the way the templates from previous years is set up, so it must work.

Does anyone have any ideas on what I may be missing?