0

Simplifying from NL to GL, pls advice

Jet Reports Historic Posts

August 03, 2015 16:02

None

Follow

Hi,

Would you be able to advice on the following;
We have a Balance sheet (same for P&L) with the following formulas which we would like to change to GL instead, mainly for load up speed issues;

=NL("Sum","vwTCL_GL_Summary_Balances","Period Balance","Account Number",$E86,"Period ID",G$1,"Year",Options!$F$5,"company=",G$2)

What would you suggest to do to change to GL instead. We do not require the transaction load up, just balances as of the period in question.

Thanks.

zuzana

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts August 03, 2015 16:25

  The knowledge base has a lot of info on the GL function: http://kb.jetreports.com/article/AA-00531/0/

• 0
  
  Jet Reports Historic Posts August 04, 2015 08:50

  Thank you