I am fairly new to both Jet Reports and Navision, but here goes.
We code amounts to a G/L Account and can also have up to 5 different dimensions also attached to it. i.e. G/L account 6305 will have many different amounts that are coded to different cost centers (Dimensions 3) or within a cost center & G/L it could also have many different business purposes (Dimension 2) and some can have employee codes as well (Dimension 5) & so on. I need to be able to have one line that can give me the Fund, G/L Account, Dimension 1, Dimension 2, Dimension 3, Dimension 4, Dimension 5, and an actual dollar amount and/or budget amount. What is the best way to achieve that? The reports usually work if I am just pulling Fund, G/L Account, and one Dimension, but as soon as I try to add another dimension I end up with extra lines that seem to total the other lines below it and doubling the grand total.
I have loaded one of the files here. If anyone can help, I would be very appreciative. Thanks.
Debby
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Debby,
I took a look at the report and I think that I know why you are getting some of the doubling up that you are seeing. Some of the NL("Rows") functions where you are listing out the dimensions don't seem to have enough filters to really make the results relevant to some of the other values on the line. For example, in cell J34 (in Design mode) you have a function that looks like this:=NL("Rows","G/L Entry",$J$30,"Company=",$D$19,"G/L Account No.","@@"&$E34,"Posting Date",$D$9,$I$30,$D$27,"Fund No.","@@"&$G34)
The problem, however, is that this function is not linked to the Business Purpose or Cost Center dimensions that come before it. This is probably causing employees to be listed out that have no relevence to some of the other dimensions on the row.
I would make sure that when you add in all of the additional dimensions that you make sure that they are filtering on all of the previous dimensions that come in the report. This will make sure that you are getting unique lists and not a bunch of doubles. I hope that this helps! -
Jet Reports Historic Posts Thanks for taking the time to look at this. I have tried filtering everything and then backed down on the filtering. I still can't get it to work properly. I have been trying to redo the report so here is the latest version.
Debby
Please sign in to leave a comment.