Apex Code Development You need to sign in to do that
Don't have an account?
iSqFt_AD Forecasting GAAP Revenue within Salesforce
Has anyone figured out a way on the Opportunity or Opportunity Product to build a formula field to be able to track GAAP revenue against that product?
I have been tasked with finding a way to take an opportunity that has a one-time setup fee as a product (revenue forcasted immediately) and a monthly subscription product (revenue forecasted based on Total Price divided by number of months in contract length) and then reporting on forecasted revenue based on GAAP analysis. So for example if an Opportunity has a setup fee product for $3,000 and a 12 month subscription product that starts on April 1st for $1,000 a month for a total Amount of $15,000, the GAAP revenue of this sale is forecasted as $4,000 in April and $8,000 across May-December for a total GAAP revenue of $12,000, since the last three months of the subscription will be recognized in 2013.
Anyone know of a way to do this effectively in Salesforce without a financial app or heavy reliance on exporting to Excel?