Skip to Content
author's profile photo Former Member
Former Member

Offset for 0fiscper using K4 fiscal year variant

I have created a query which asks for a fiscal period variable. It shows account information for the wanted fiscal period and automatically brings the information for the fiscal period before it by using the offset -1 option. Along the year, it works right but in January it doesn't´t because of the K4 (16 periods) fiscal year variant.

For December, the right fiscal period to get is not 12. We use the K4 fiscal year variant, so in December the right period to retrieve is 16 (not 12).

In January the query is retrieving information for 2005.001 (variable asked to the user) and 2004.012 (offset -1). However we need the query shows the information for 2004.016. Is it possible to get this information not creating another query? I mean, is it possible to use the offset option (or any other option) in the same query to get the 2004.016 period instead the 2004.012 in January?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 07, 2005 at 08:02 PM

    You will probably have to create a variable with a user exit to do this. In the user exit you can overwrite the variable with the right value.

    Look the documentation up for what is required to set the user exit up.

    hope that helps!

    Rishi

    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.