Calendar view for checks

Business Central/NAV User Forum
1

Hi,

I need a report that shows summarized totals per day for every issued check, in a calendar way (horizontal).

The idea is to let the user know how much will be discounted from a bank account in any day due to issued checks.

It would be something like this:

MON TUE WED THU FRI

WEEK 1 $100 $300 $80 $250 $400

WEEK 2 $120 $800 $400 $20 $490

…

Is there any standard report in NAV 2009 SP1 that fulfills my needs? or something similar…?

Thanks and regards.

2

Hi,

There is no standard report in this format, you can code this yourself. I suggest using the virtual table Date with “Period Type” filtered to week. Have a look at the standard report 8 - Budget for ideas.