Trying to write a report and having an issue.
I am grouping the report by a non global dimension (Glob.Dim. 5)
From the GL entry table…i am pulling the records, filtering on the Glob.Dim. 5 filter.
This all works…now the issue.
I need to link back to the GL Account table because there are 2 flowfields i would like to have on the report, Net Change, Balance.
I can't seem to bring in the proper amounts…i know each entery in the GL entry table is unigue by it's Entry No., so i tried filtering on this, but doesn't work, i also tried a Link= and NL(Filter), but still can't get it to work.
Anyone have any ideas? I have attached the report.
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi cveale,
What do you mean by "I can't seem to bring in the proper amounts". Are you getting zero's or a number that is incorrect? What do you expect to get, and what are you getting with this report.
Can you provide a Navision .fob file of your "G/L Account" and "G/L Entry" tables. If the amounts are incorrect, I wonder if there may be some problem in the definitions of your flow fields or flow filters in the tables. -
Jet Reports Historic Posts It is summarizing each GL account by the appropriate dimensions (Glob. Dim's), but i need it specifically for each entry in the table…
See the attached word doc. hopefully it explains it better. -
Jet Reports Historic Posts I'm not sure why you are going back to the G/L Account table to find an amount this is already on the G/L Entry table. Why don't you just use =NF(C12,"Amount"). Sorry, maybe I don't understand the database. I do know however, that unless the flowfield on the G/L Account table has a filter for the "G/L Entry No.", you are not going to get what you want using a flowfield. Which is why I'm confused as to why you are using a flowfield.
Can anyone else help here? Like I said, maybe it's be cause I don't understand the database you are using. -
Jet Reports Historic Posts Actually, i was going back to the G/L Account table because we have some custom flow fields that are almost the same as the amount field.
But this right here answered my question
–"that unless the flowfield on the G/L Account table has a filter for the "G/L Entry No.", you are not going to get what you want using a flowfield"
The custom flow field does not have a filter for the G/L Entry No.
Thanx for your help !!!!
Please sign in to leave a comment.