Share
Report
7Dear all,
I am preparing the Statement of Cash Flow (IT Localization), where the columns contain the years and the rows contain the balances at date (Beginning Balance and Net Change) for some accounts. For example, under Operating Activities, I have the net change of depreciation. Now I have an issue calculating the variance for some G/L accounts, For instance, for Receivables I created 2 lines:
- Receivables PY → where I set the accounts to be taken into consideration and selected the row type Beginning Balance
- Receivables CY → where I set the accounts to be taken into consideration and selected the row type Balance at Date
The difference between these 2 rows should display the yearly variance for receivables.
The issue is that by setting Beginning Balance for the “Receivables PY” row, the system is also taking into consideration the closing balance. This means that once the fiscal year is closed, the amount for this line becomes 0 because, by standard, during year-end closing the system creates the closing entries with document date “C” and then reopens the balances. How can I solve this problem?
Is there any way to exclude “C” from the Beginning Balance calculation?
Thank you
All responses (
Answers (
