+ Start a Discussion
SATHISH REDDY.SATHISH REDDY. 

Design question - whats the recommended way to track an opportunity amount being used and reallocate the unused balance

To all sf experts out here, trying to get your inputs for a use case that i’m trying to incorporate. Use case: We have a currency field called “Amount Owed” on opportunity which holds an $ value. It is calculated by user based on any unused amount for that opportunity. Example if an opp Amount = $1000 and only $800 was spend in reality, then the Amount Owed = $200 which will then be applied to future opportunities under that account. (Note: This Amount Owed can be applied to a single oppty or to multiple opportunities.)
Question: That said, business needs a way to track where, when and to which Opportunities was this $200 got applied to as a credit. Also they want the ability to run reports showing this.
My Idea: Thinking on to create a custom object named “AmountHeld” which would hold the actual amount owed on the oppty record and then have a child record associated to “Amount Held” called “AmountDistributed” which would then hold the credited amount value along with oppty name to which credit was applied to.
Please let me know if i’m thinking in the right direction in regards to business logic implementation & also reporting perspective? if not pls share your inputs. Thanks in advance!
ShirishaShirisha (Salesforce Developers) 
Hi Sathish,

Greetings!

Can you please confirm,how exactly the amount is being spent here.If it is for product(which is child of opportunity) then you can easily relate the product record for which you spent the amount as a child record in the related list and you need to have an another amount on the Opportunity Object which holds the credit amount(to store the remaining amount) for which you would like to spend in future.

Instead of creating the custom Objects,you can proceed it with the Products and Opportunity as these are standard Objects and related to each other.You can easily create the report as well.

Kindly mark it as best answer if it helps so that it can help others in the future.

Warm Regards,
Shirisha Pathuri