Profit & Loss by Department - Actuals show the wrong figure

SOLVED

Hi, this is my first post in the community. I'm using Sage 50 Accounts Professional.

I'm trying to get a report running to show me the actuals, budgets and variance on my profit & loss sheet all together. I'd like to do this on a monthly basis.

I have a problem in that the figures showing under my actuals on the report titled Profit & Loss by Department (Advanced Budget and Variance) are incorrect - they are way lower than the correct figures (which are based on the posted transactions) that the Departmental Profit & Loss report gives me.

Is there any reason for which the figure for actuals is wrong or a procedure that is required to get them right that I'm missing? 

Many thanks for any answers!