The issue with closing entries (C document type) is known when working with Beginning Balance in Account Schedules. By design the system include closing entries in Beginning Balance, that is why the balance reset to zero after year-end closing.
One approach is to use Net Change instead of Beginning Balance, with a date filter that cover the period you want, and exclude closing date entries. In the Column Definition you can use a date formula like "P-1Y" combined with Closing Period filter set to exclude closing entries.
Another option is to play with the Posting Date filter to exclude the closing date specifically. If your fiscal year closing date is 31/12/2024 with closing entries, you can filter Posting Date to be before that exact date.
For Italian localization there might be additional setup in the Cash Flow report that handle closing entries differently, worth check the IT documentation.
If standard does not give you the result, last resort is custom AL extension to filter out C document type during summation.
✅ Tick the checkbox below to mark the answer as verified, if it helped resolve your question.
Regards
Gregory Mavrogeorgis
