Hello Gurus! :)
I have a question related to Advanced Revenue Management's reports please.
Sceanario: For "delivery items" (items to be delivered) the setup is such that revenue plans are created upon delivery (and not revenue arrangement creation). These items will have (let's call it delivery) "delivery" rules, where rev rec start and end dates are event dates (delivery date).
Usually, if we want to see a forecast for such items, since there will not be any plan created until delivery, we must use a different rule so that forecast revenue plan is created immediately upon revenue arrangement. So, we can use an "over time" type of rule, where we set rev rec start and end dates to revenue element start and end dates in SO, and we can make sure to use the estimated delivery month dates.
However, the problem with this approach is that on the rev rec forecast report,
Forecast line = Forecast per period - Actual Plan per period - rev rec per period.
However, this approach has problem.
Assume:
Forecast month is December.
Revenue element is $100.
Delivery takes places earlier than expected, in November.
Forecast line (November) = $0 (forecast) - actual plan ($100) = -$100.
Forecast line (December) = $100 (original forecast) - $0 (item is delievered already) = $100.
Though mathematically it makes sense, it makes no sense to a decision maker to see a negative forecast in November. All he wants to see is just the original forecast of $100 in December (even though the forecast is no longer useful since the item is delivered).
Question: This obviously would not happen if the rev rec rule and forecast rule were the same, as is the case with "non-delivery" (think subscription type) items where revenue is recognized proportionally over time and the forecast rule is identical, since there is no reason to have any different forecast.
Is there any other way to create a forecast report that would simply show the original December forecast of $100 and nothing else? In other words, this report will not be tied to the regular rev rec forecast report and will not interact with the actual forecast and hence will not show any negative amounts for the months where delivery happened but where there was no forecast?
I apologize for the long discussion, but I thought I would be detailed from the beginning. Please feel free to ask any followup questions.
Thanks! :)