Bex Report to calulate the invoice amount for last 24 months dynamically

[Former Member]

Hello Experts,

We have an requirement to create a Bex Report to calculate the invoiced amount for last 24 months for active suppliers.Active Suppliers are the Suppliers with at least 1 Invoice during the last 24 months.

We are giving the selection screen for Calmonth.Based on the input by user, it should calculate the invoiced amount for last 24 months. we have been strucked in calulating the value for last 24 months.

Can we achieve this by offsetting the value in variable or do i need to write customer exit?

Thank u....

Pradeep

Edited by: Pradeep Kumar C K on Jan 12, 2011 6:26 AM

[Former Member]

I believe you can use a range for offset as well.

You must select value range in the prior step which will give you two windows beneath it.

For the first window, select varaible for calmonth and offset it by -24.

For the second window select the same variable for calmonth and offset it by -1.

This will select the past 24 months from the month that user enters in the selection window.

Let me know if this doesn't work. I have used the value range option for trailing twelve month calculation before and it worked fine.

Good Luck.

MP.

[Former Member]

You can try this with offsetting account if you have period and year values entered by the user seperately. Else the best option would be to write a simple exit.

[Former Member]

Hi Pradeep,

It looks like you need to have a calmonth range ( 24 months which you cannot get by setting offset).

offset setting will pick only 24th month.

So my suggestion would be take input from user and write the customer exit code.