With Navision, the GL function does not return "rows" or "columns" etc. The NL function will do this, but I cannot use the NL function to filter out data based on specific companies in a database. (Which can be done using the GL function)
I can set up multiple with Datasouces pointing to the same database, each with a different default company. But this seems like a lot.
Is there an easier way to do this. Ie: Pull GL account no's from Co.A and Co.B.??
Thanks.
Date
Votes
3 comments
-
Jet Reports Historic Posts Noël_L
First, thanks for your question on our new community website. Let's see if I can answers your questions.With Navision, the GL function does not return "rows" or "columns" etc. The NL function will do this, but I cannot use the NL function to filter out data based on specific companies in a database. (Which can be done using the GL function)
You can use the NL to retrieve database from a specific company from within the same datasource. For example
=NL("Rows","G/L Account",'No.","Company=","Cronus USA, Inc.")
will retrieve the G/L Account No.'s from the "Cronus USA, Inc." company even if the datasource is set to another company. You only have to use the "Company=" in the NL function. If you use NF's also, the NF get's the company information from the NL.
Does this answer your question? -
Jet Reports Historic Posts Yes, Thanks! This does answer my question.
I have just started to work with Jet Reports and your replies really helps speed up the learning curve. Just to further clarify, If we then use the NFfunction referenced to the NL function that we specified a specific company, do we need to put the company= in the NF function or does it automatically reference this based on the NL function that called the specific company.
Thanks. -
Jet Reports Historic Posts You do not need to add "Company=" to the NF, only the NL.
Please sign in to leave a comment.