cancel
Showing results for 
Search instead for 
Did you mean: 

Fiscal period / fiscal year shift in Reporting

Private_Member_24235
Participant
0 Kudos

Hello all,

our company has defined 0FISCVARNT = V6 because our fiscal year end in June. I want to provide the time char 0FISCPER in our reports as key and text.

The text table table T009C is maintained as Jan fo period 007, Feb for period 008.

When I run a report and drill down by FISCPER and display text and key and the characteristic 0FISCYEAR is combined with 0FISCPER. Therefore text information is correct for july until December (July 2006 - December 2006) but from January on the result is not correct (January 2006 instead of January 2007).

Is there a way to adjust or to shift the Fiscal year in the query output. Any help would be great.

Best Regards,

Stefan from Munich/Germany

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Stefanos,

The result with the Fiscal Year is fine.

Fiscal Year, even though you're reporting January 2007, is still 2006. If you "shift" the Fiscal Year, then the result would be wrong.

Make a simple test, make a drill-down by 0FISCPER and 0CALMONTH. I'm sure 0CALMONTH will show "January 2007".

Regards,

Luis

Answers (0)