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?
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?
I am referring to NB027- GL activity report
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