Prev Year

[Former Member]

Hi Guru's

How can we run the report for previuos year. I've varaibles year, period selection.

report is like account nomber posting period . period value YTD

522241 02 10 20.

This is for current year data. Now I want to display YTD for previous year using the current year selection. I've specified the offset value -1 but not getting the data.

And also same for forecasting.we use E1 for jan ,E2 for feb like that.If I select forecast value E3 then my report should show per forecast value E3 and E2 as well.

Nagesh.

[Former Member]

Hi Guru's

It's working with previuos year but not working with prev version.

We use versions E1 for jan, E2 for Feb etc.So If I select version E2 then on the report it should show E1 and E2 data.

Nagesh.

[Former Member]

Hi Nagesh,

For showing more than 1 version u can either use the 'less than or equal to' operator or u may write a CMOD exit which will return a range of values u intend to restict with.

if u restrict with E2 with 'less than or equal to' operator , u will get E1 and E2 data.

hope it helps

Regards,

Rathy

[Former Member]

Hi

Thanks for the response.

If I select E3 then I'll get E1,E2 and E3 but I want only E2 and E3 on the report.

Nagesh.

[Former Member]

then make two restrictions

1) with E3

2) and again with E3 with offset -1.

instead of E3 u can use a variable also.

hope it helps.

Regards,

Rathy

[Former Member]

Hi

It's throwing an error if I use offset -1.Error message says that version is a characteristic.

Nagesh.

[Former Member]

in that case u can try writing CMOD routine.

Regards,

Rathy

[Former Member]

Hi

Please can you write the code for that.

Nagesh.

[Former Member]

Don't restrict the year char by variable in the filter section, instead restrict in the RKF. As the variable is ready for input, it pops up in the variable screen. As year is not restricted in the filter, you can display any year data by giving proper offsets for year in the RKFs. Same is the case with months also.

[Former Member]

Hi,

If it is fiscal year/period use offset -12. if it is fiscal year use offset -1.

Regards

Pcrao.