Skip to Content

Fiscal period / fiscal year shift in Reporting

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2007 at 01:52 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.