0

GL transactions and all Dimensions

Jet Reports Historic Posts

February 21, 2013 18:04

None

Follow

We are trying to create a report that will provide the GL detail and all dimensions that pertain to the line transaction. We do not know how to have the dimension codes span the columns with 1 line entry.

I am looking for something like this.: (GBL Dim1) (GBL Dim2) (Dim3) (Dim4)
Posting Date Document Type Document No. G/L Account No. Description Amount Entry No. CLASS DEPT EXPTYPE T & E


Can someone please provide some insight?

Thanks.
MC

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts April 04, 2013 18:24

  Hi Mike,
  
  See my posts with Hughes. I am still working on this but maybe it will help
  
  http://community.jetreports.com/viewtopic.php?f=7&t=2630
  
  Regards
  
  Thomas

• 0
  
  Jet Reports Historic Posts July 17, 2013 23:33

  Hello,
  I have a similar question using dimensions, however, I would like to exclude "multiple" dimensions. I know that if I use "|" I can add dimensions, and if i use "<>" I can exclude dimensions. However, the "|" does not seem to work for multiple exclusions. Is there a trick for this?
  
  Thanks,
  Sandi

• 0
  
  Jet Reports Historic Posts July 18, 2013 12:32

  Sandi,
  
  You need to combine <> with &. So "<>VALUE1&<>VALUE2&<>VALUE3". Does that help?
  
  Regards,
  Hughes