***UPDATE***

Restarted Sage and tried again, error now reads "The report could not be generated. Arithmetic operation resulted in and overflow"

Hi Mark,

Thanks for using Community Hub, welcome to the forum.

In principle I'd expect that filter and report to give you the result you need, but the error message suggests a conflict between the software and something else on your computer. I'd suggest restarting and then try the report again. 

If the problem persists we'd need to try and narrow down the cause, check to see if the error gives any more details about the conflict, maybe it names the component? I'd also try running a few different reports to see if it's just this report that is affected or all reports in Sage 50 Accounts.

Feel free to come back to this thread if you can find any more details or if the issue persists.

Regards,

Andy
Sage UKI

Thanks for coming back Mark, there are some steps in this article that can help you to resolve this error: Error running reports: Arithmetic operation resulted in overflow >