You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

New Tutorial Video just added

12
Views
0
Comments
edited May 2, 2022 8:48PM in Product Innovation

Summary: Learn how to add new fields to the Revenue tab of a Proposal and use Groovy scripting to calculate input from the new fields to generate the Amount of a Revenue record.

Content (required): https://videohub.oracle.com/media/t/1_hiak309k/144764042

Code Snippet (add any code snippets that support your topic, if applicable):

def revenue = Revenue

revenue.reset()

while(revenue.hasNext()){

 def eachRev = revenue.next()

 def baseAmount = eachRev.BaseAmount_c

 def multiplier = eachRev.Multiplier_c

 def revAmount = eachRev.RevenueAmount

 def multiple = (nvl(baseAmount,1.00) * nvl(multiplier,1.00))

 eachRev.setAttribute("RevenueAmount",multiple)

}

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!