As in the title: one database with ledgers of many companies (outsourced accounting), to get any data from navision the option "default company" must be set in the jetreports, thus only data form the set company can be extracted - other company's data wanted, the default company must be changed. I was told there's an option to get data from many ledgers kept in one database simply with use the table "company" with the filter "name". We use jetreports version 7.0.6 - and kill me, but I can't find any links (not even direct ones but also via other tables) between tables "company" and "vendor" or "customer". Maybe the solution is very simple, as many things in the jet, but any help appreciated.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello,
You can make an NL function get data from a different company by using a "Company=" filter. So basically you might change your NL function to look like this:
=NL("Rows","Table","Field","FilterField","Filter","Company=","Company")
For a GL function, there is a company argument where you can specify the company name (just look in the Jfx). Is this what you were looking for?
Regards,
Hughes
Please sign in to leave a comment.