I have a very simple GL function:
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?