0

Filter function in GL

Tom

July 01, 2019 11:36

Answered

Follow

Hi there,

 

I have a very simple GL function:

=GL("Balance";8220;"01-01-2019";"31-05-2019")

 

I would like to filter the account number based on the consolidation debit code in Navision. So in above case, 8220 should be replaced by a function which filters out all accounts with a certain consolidation code, let's say 12345. I tried several (NL filter, NL lookup, nesting etc) but none was succesful, can anybody help me out? I want to avoid using the NL sum on G/L entries, is there a solution using the GL function?

Thx!

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Harry Lewis July 01, 2019 15:04

  Hi Tom -

  Here is a simplistic illustration:

  

   

  I'm using an NL(Filter) to create my list of G/L account numbers (in my example, I want all accounts which are non-taxable.

  For comparison purposes, I then list out each account and its balance and then sum up the results.

  At the end, I have one GL(Balance) function for all the accounts.  If I did this right, those last two lines should contain the exact same value.

  Here's what happens when I run the report:

  

• 0
  
  Tom July 01, 2019 20:51

  Great, that works! Thanks Harry!