Hi there,
Is there a way to use a GL() and select multiple companies so that the balance is the sum of all the companies selected.
You can not use a pipe filter in the company field and using GL() + GL() + GL() with a separate company filter to add each company does seem like a long winded process.
any clever ideas?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Meemz,
It would be a nice option but this is not possible. My guess would be that it is because Navision only allows access to one company at a time per function.
An idea could be to create an NL for the Company table, retrieve the company names, sum the amounts in a GL and sum it with Excel:
- in D4: NL("Rows";"Company";"Name")
- in E4: your GL function referring to the company name in D4
- in E6: =SUM(E4:E5)
Please sign in to leave a comment.