How to set the date for fiscal year 2015

[Former Member]

Hello,

I am using the following query to give me the sale for fiscal year 2015-01. If I set the date to OFPR.Name = '2014-12' or prior to that date it return data.

For some reasons when I set the date to OFPR.Name = '2015-01' it returns zero row. I have already created numbers of invoices for year 2015. My question is what I need to do (may be set the date in journal entry to 2015?) in SAP Business one 8.82 so that it causes query to return the data for 2015-01.

Please help me.

Regards,

Bill

[julie_jamieson2]

Is 2015-01 your period name or period code? Do check using show system information...

[Former Member]

Hi Julie, Please see the screenshot of posting period. Thanks.

[julie_jamieson2]

Try adding:

Group By OFPR.Name, JDT1.FinncPriod at the end? That works for me...