I have built many reports in my day using other platforms, I am very new to JP though.
Nut Shell
I built a Balance to date and a Net Change using the GL Tables… (Entry and Accounts) … I have a single datasource with 3 companies in it. I would like to have each comapny build its own "Set" of sheets… I get everything working but ran into a wall with getting the ,,, "Navision server Data Source 1","ABC Company","G/LAccount"."10000" to change to the next company like "Navision server Data Source 1","XYZ Company","G/LAccount"."10000" etc.
I can ust the Function Wizard to edit everything but "Navision server Data Source 1","ABC Company"… I also can change the compay but clicking on the "Set the Default company" button, but I would like this to run the report for all 3 companies without manual help…
I am sure I am just missing something basic somewhere… Thanks again
Jeff
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi jmatulevich,
There's a difference between the function and the result of the function. The Jet functions are NL, NF, GL and NP. And what you refer to is the result of the function. It's the same in Excel: you define a function (e.g. =SUM(A4:A10) and the result shows 1000.
But enough lecturing done… let me try to help you with the company. NAV has a company table that contains alle company names. These company names may be used in the NL and GL functions to retrieve records / data from another company than the default company.
To get a sheet per company: =NL("Sheets","Company","Name") (assume this is in Cell D4)
To get the G/L accounts per company: =NL("Rows","G/L Account",,"Company=",$D$4) (assume this is in Cell D6)
To get the account nos: =NF($D6,"No.") (assume this is in Cell E6)
To get the balance for this: =GL("Balace",$E6,,,,,,,,,,$D$4)
If you open the Jet Reports Help pdf file, you may find more info about the Company options on page 190..195. -
Jet Reports Historic Posts I understand the basics, my wording maybe the problem… you stated..
To get a sheet per company: =NL("Sheets","Company","Name") (assume this is in Cell D4)
To get the G/L accounts per company: =NL("Rows","G/L Account",,"Company=",$D$4) (assume this is in Cell D6)
To get the account nos: =NF($D6,"No.") (assume this is in Cell E6)
To get the balance for this: =GL("Balace",$E6,,,,,,,,,,$D$4)
in
To get the G/L accounts per company: =NL("Rows","G/L Account",,"Company=",$D$4) (assume this is in Cell D6)
"Company" is not a field in the "G/L Account" Table
However i did notice the "=" sign after the word company. I am gussing that this would tell excel to pull the data in the G/L Account table using the Company name listed in $D$4.
So really all i was missing was the Equal sign?
Thanks alot for any help… I am taking the training courses from JP, and my next session is Thursday, so I will be sure to bring this up. -
Jet Reports Historic Posts Yes, "Company=" is not a field in the G/L Account table, but great functionality Jet Reports added so that you may retrieve data from any company in your database. Please read the Jet Reports manual - it's all in there. Enjoy your training course :)
Please sign in to leave a comment.