How to get Account Balance on specific date?

V5 Question
1

I’m trying to get the balance of an account for specific date. When I go to the reports section I get the current balance for that account, even if I select a date or a date range in the filters section, I’m using this tag:

Caja Fuerte|{ACCOUNT TYPE BALANCE:Caja Fuerte}

Is there a way to get the balance of an account for a specific date or date range? I know I can do it with SQL, but I want to know if there’s an easier way, Thanks in advance.

2

Not that I’m aware of. Wasn’t one when I was trying to do a debtors/creditors report.

3

Got it, so I’ll do it with SQL, thanks @JTRTech