Need Beginning Year Balances for Assets and Liabilities with dynamic Period Of Interest

Hi All,

We are building an FSG report whereby we want YTD balances (current year only) for all accounts including Balance Sheet and P&L. As Balance Sheets account balances are carried forward, YTD balances include previous year end balance as well. We want only this year's activity and therefore want to exclude it.

In our workaround, we tried to subtract previous year end balance from YTD and it worked good for balance sheet accounts but surely won't work for P&L. Is there a way to get beginning year balance instead, that would be zero for P&L and use that for subtracting from YTD balance.