Filter positive/negative Net Change in Account Schedule Line

Business Central/NAV User Forum
1

In my Account Schedule, I have a totalling of a number of G/L Accounts on a line A. This amount should however only sum the positive Nett Changes of the accounts.
On a line B I have the same totalling of G/L Accounts, but on this line I only want to sum the negative Nett Changes on the accounts.
I haven’t found any function with which I can achieve this. Anyone else?

2

Hi Michiel

Columns can be setup to use Net Amount, Debit Amount or Credit Amount but these options are not available for rows in Account Schedules.

Regards

Claus

3

Hi Claus,

Yes, I know that I can set up the columns in this way. But I cannot summarize two separate columns! [:’(]

I’m afraid I have to think of some other solution…