0

Help with GL Activity Report

dusty guadian

January 25, 2020 03:54

None

Follow

How can edit this report Just pull one GL . 

Just need to get GL# 11200

Also how could I use NL sheets to have it grab from every company?

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  dusty guadian January 25, 2020 03:56

  I am referring to NB027- GL activity report

• 0
  
  Bryan Robinson May 20, 2020 17:48

  Adding a filter to only show Account 11200 is easy enough.  While in Design mode, add G/L Account No. in cell C6 and 11200 in cell D6.  You can add OPTION to cell A6 if you wish to be able to change this easily at run-time but is optional.

  Then modify the Table function in D10 to ensure the Filters range is $C$5:$D$6.  See screenshot.

  

  You can use a similar technique for adding Company= in C7 as a filter and put the NL("Sheets") replicator in cell D7.  However, the PivorTable will only show one company.  Additionally, any PivotTables you make referring to sheets will break upon refresh as Jet will physically delete sheets at run time.  Excel then has a broken reference.

  To be honest, it would probably be easiest to build this report using the Browser and not rely on PivotTables.  https://support.jetglobal.com/hc/en-us/articles/219403377-Using-the-Jet-Browser-in-Jet-Reports

  Edited by Bryan Robinson May 20, 2020 17:48