Skip to main content
Solved

How to generate GL detail report for a range of GL accounts?

  • April 27, 2022
  • 5 replies
  • 1338 views

Forum|alt.badge.img

How to generate a GL detail report for a range of GL accounts? Can the report sorted by GL accounts instead of batch numbers?

Best answer by Laura03

Hello, Transactions for Period offers the From/To account parameters, to print for a range of accounts.

 

On the Additional Sort & Filters tab, you may be able to change the sorting by removing the Batch Number sort and replacing it with Account number. YMMV - sometimes changing sort works and sometimes it doesn’t. I think it’s because the grouping in the report design comes into play as well. Pay attention to the totals after re-sorting to verify your new sort will work. Good luck.

 

5 replies

Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Answer
  • April 27, 2022

Hello, Transactions for Period offers the From/To account parameters, to print for a range of accounts.

 

On the Additional Sort & Filters tab, you may be able to change the sorting by removing the Batch Number sort and replacing it with Account number. YMMV - sometimes changing sort works and sometimes it doesn’t. I think it’s because the grouping in the report design comes into play as well. Pay attention to the totals after re-sorting to verify your new sort will work. Good luck.

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • April 28, 2022

Laura,

Thank you so much for your reply. It’s really helpful!

 

Regards,

Aaren


  • Freshman II
  • January 9, 2024

@Laura02, Is it possible to include the same parameters in the GI? I'm not getting accurate records since the database values differ from the AccountCD.
 


dominicpolicicchio03
Freshman I
Forum|alt.badge.img

Has anyone figured out how to do this in a GI? Im also running into the same issue as ​@KumarDighe 


Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • April 30, 2026

Hello ​@dominicpolicicchio03 , It’s helpful if you can show us Table relations & results with your GI and we can try to help. Thank you!