Skip to Content
0
Former Member
Jul 21, 2010 at 08:55 PM

Variable on FiscalYear Period for actuals and Forecast

10 Views

Hi gurus,

I need to create a customer exit variable on 0FISCPER. Need help on the code.

The requirement is as follows:-

User wants to see sales in 12 columns. He will key in the current fiscalyear period. So if the current fiscal year period is five then the actual sales should come for 5 periods in different columns and forecasted in 7 columns. 1.

Using Fiscal Year Variant u2018Z4u2019, determine the beginning and ending periods of the current fiscal year based on system date.

For the current period and all the prior period of the same fiscal year, pass the value u2018ACTUALSu2019 u2013 concatenating it to the name of that month.

For the remaining periods of the current fiscal year after current period, pass the value u2018FORECASTu2019 u2013 concatenating it to the name of that month.

Further restrict u2018ACTUALSu2019 to only values with VERSION (0VERSION) value u2018000u2019 and VALUE TYPE (0VTYPE) value u201810u2019.

Further restrict u2018FORECASTu2019 to only values with VERSION (0VERSION) value u2018000u2019 and VALUE TYPE (0VTYPE) value u201860u2019.

If current fiscal period is determined as September, return u2018NO ACTUALSu2019.

If current fiscal period is determined as August, return u2018NO FORECASTu2019.

Can anyone help me with the code?

Regards