+ Start a Discussion
gkappgkapp 

Forecast Help !!! very Urgent

The issue we are facing is as follows. Since all forecast are tied down by closed date, its causing a problem in forecasting.For Ex say today 5/3/2010 , if i buy  10 products under "A" opportunity they will also have the same closed date, but i need to be able to forecast them based on demand varying over the period may be today may be next year. So in this case with a closed date of today its showing that the total amount = $100, and this would not show up in future forecasts(irrespective of when the product was purchased) . I tried using prod date too but it did not help either when you have multiple  sales order line items.

 

The client is using the below format ! Please suggest if there is a way to achieve this(the columns are categorized as below)

 

 

 

Customer  Part #   Jan-10   Feb-10   Mar-10   Sum of the values(Q1FY2010)