Skip to main content
I am working on setting up some objects to capture sales and conversions which will be brought into salesforce using web services.  I created a custom object named "small employer transactions" which will be a child of the account object.

 

My issue is regarding de-duping information for reporting purposes.  We could have multiple records come in for the same account and I am trying to figure out how I can de-dup these to roll up to one.  For example, I might get 3 transactions that equal one sale for an account.  Each transaction is a separate product but I need to count that as 1 sale (not 3) The same thing applies to conversions.  The group may decide to change products next year and we could get multiple transactions that need to roll up as 1.

 

I can't just add roll up summary fields on the account because each year there could be transactions.  I am thinking the only way for me to do this is to add a buffer object between the account and small employer transactions object but that means that you have to create it each year.... The problem with using the buffer object is that it is high volume and would be a real chore to create a buffer object under the account for every year there are transactions.

 

Any advice would be greatly appreciated!!!

 

Fred