0

i need to produce fiscal year in Jet

Jet Reports Historic Posts

June 03, 2010 21:29

None

Follow

Hello, I have written a report where the client enters in an ending date for the report, i.e. 05/31/10

Now their fiscal year is 04/01/10..03/31/11

I need Jet to automatically create the fiscal year, and I can't quite get it, here is what I have.

Cell E7 - 05/31/10

Fiscal Year Start - =NL("Last","Accounting Period","Starting Date","New Fiscal Year","Yes","Starting Date",NL("DateFilter",,$E$7))

Fiscal Year End - =NL(,"Accounting Period","Starting Date","New Fiscal Year","Yes","Starting Date",NL("DateFilter",$E$7,))-1

FYS gives me 04/01/09 - BUT it is supposed to be 04/01/10
FYE is correct.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts June 16, 2010 21:42

  The NL("Last") might not return what you are looking for unless you also apply a sort. Try sorting the Starting Date in ascending order, like this:
  
  NL("Last","Accounting Period","Starting Date","New Fiscal Year","Yes","+Starting Date",NL("DateFilter",,$E$7))
  
  I just added a + in front of the Starting Date filter.
  
  Does this fix it?