Views:

Scenario Overview

In this business scenario you have a requirement to copy the field  'Standard Cost' from the product entity record on to the 'Quote Product' record whenever the 'Quote Product'  is created. This is primarily used for historical reporting purposes where a business user needs to compare the standard cost at that point in time with the Price Per Unit on the actual Quote Product.


This allows you to run Advanced Finds or create reports that can query this data from the 'Quote Product' entity.

N52 Formula Manager Solution

The Formula Manager solution works like this,

  • We create a formula of type 'Save - To Current Record' for the 'Quote Product' entity
  • The formula will only execute when the record gets created
  • It will lookup the 'Standard Cost' field on the product entity using the FindValue() function
  • It will place the result into a custom field on the 'Quote Product' called 'Standard Cost'

N52 Formula Manager Steps

  • Create a custom field called 'Standard Cost' on the Quote Product entity
  • Create a new formula of type 'Save - To Current Record'
  • Set the Mode to 'Server Side'
  • Set the Event to 'Create'
  • Set the Source Entity to 'Quote Product'
  • Set the Target Property to 'Standard Cost'
  • Copy & paste the formula below into the formula description field & click save
  • You are ready to test

Formula

if(ContainsData([quotedetail.productid]),
    FindValue('product', 'productid',[quotedetail.productid],'standardcost'), 
   'NoOp')

Wizard - FindValue

Please see below the wizard you can use to create the FindValue() function call used in this formula. 

Note 1:  Equals Value, you will need to go the Explore Tab > Entites > Quote Product > existing product. (value).
 

Wizard - ContainsData

Please see below the wizard you can use to create the ContainsData() function call used in this formula. 

Note 1:The Fields you will need to go the Explore Tab > Entities > Quote Product > existing product (value).