Does anyone know if Salesforce has a better tool to use with regards revenue recognition other than the Product Schedule option?
The Product Schedule option is clever but not nearly as flexible as it needs to be. (atleast from what I know)
Pre Salesforce we used a simple excel spreadsheet to forecast monthly revenues from our pipeline.
So essentially what we need is to set automatic schedules based on formula rates and start dates rather than having to manually edit each record’s start date and rate.
Any Ideas? Here is an example of what we need and how robust it needs to be
Total Project Daily Revenue Formula Start Date Month 1 Month 2 Momth 3 Momth 4
Revenue Recognition Rate
$100,000 $2,000 August 31 2000 60,000 38,000
$300,000 $4,000 August 30 8000 120,000 120,000 52,000
We have all the formula fields needed but we don’t know how to tell Salesforce to use them for forecasting or revenue scheduling.
Thank you for your help!!!!!