Hello I am trying to get a detail trail balanced over a range of accounts inside certain departments and I am in need of help of how to get a NL (rows) function to read a General Ledger accounts filter (4000..5000) as for each account if amount exceeds zero. Hopefully to have the ability to just change account numbers to any range and everything adjust to it. I would greatly appreciate the help.
Department 4
NL Row ( acct # 4005)
Nl Row (acct # 40007)
No Row (acct # 40008)
Department 5
NL Row ( acct # 4000)
Nl Row (acct # 40001)
No Row (acct # 40002)