I have the following code that provides teh Heading for a list of GL accountc and their values
=NL("Rows=5","G/L Entry","Global Dimension 2 Code","Posting Date",Options!$C$22,"Global Dimension 2 Code",$F$23,"G/L Account No.",$F$25,"Global Dimension 1 Code","DIVPREP")
The report prints th elist of accounts for each Global Dimension 2 Code - in alphabetical order i.e. the GD2 values are sorted in alpha order - what say I want them(the GD2 values) in a different (custom) order ?
Alos how can I insert a total line which is the sum of the total of just two of 10 GD2 values ?
Thanks
Allister
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Allister,
What you're asking for is somewhat complicated since the G/L Account Name is not on the G/L Entry table, but it can be done. The formula would look something like this:=NL("Rows=5","G/L Entry","Global Dimension 2 Code","Posting Date",Options!$C$22,"Global Dimension 2 Code",$F$23,"G/L Account No.",$F$25,"Global Dimension 1 Code","DIVPREP","+=NL(,""G/L Account"",""Name"",""No."",NF(,""G/L Account No.""))","*")
Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts Thanks for your email
However i may have misled you
I want the Report first of all sorted by Global Dimension 2 but according to a customised list - that is in a particular order (eg Orange Green Yellow Blue ) and then within this sort the GL accounts bin Account number order.
Thanks
Allister :) -
Jet Reports Historic Posts Hi Allister,
There is no way to specify a custom sort order. On the other hand, if you know what values you want and what order you want them in, you can just create a replicator which replicates those values in that order. Per your example:=NL("Rows=5",{"Orange","Green","Yellow","Blue"})
Then within that you could replicate other things and reference those values. I have been corrected that in more recent version of NAV the G/L Account Name is a field on the G/L Entry table, so it should be much easier to sort by the G/L Account Name than the formula I previously put in if you are on a more recent version of NAV. Does this help?
Regards,
Hughes
Please sign in to leave a comment.