I am trying to create an account schedule which shows each day of the month (1-31) in the columns, and a GL account, in this case sales, as the rows.
I am using the comparison date formula as D1, D2, D3, etc. with Net Change for GL Entries.
This returns the result as cumulative for each day. So, if I have $100 of sales for each day, I get $100 on D1, $200 on D2, $300 on D3 and so on.
Does anyone know how to get NAV to put the amount of activity for each day into these columns? I would like the report to show, using the example above, D1=$100, D2=$100, D3=$100.
I have tried inserting a column between the two to calculate D2-D1, but this results in a huge messy looking report.
Has anyone tackled this?
Additional challenges: Getting D1 to reflect correct total, dealing with varying numbers of days in a month.
Thanks for the help!