I found this formula suggestion on StackExchange to create a custom Date Paid field on Invoice objects:
The downside of this approach is, if the Payment object was entered later than the actual Payment date, it will take the date the Payment was entered.
Example: the Payment was entered on July 2, but the date on the payment was actually June 30. The Invoice Date Paid will show July 2 - which in this case means the sales rep will not get commission till next month!
Anyone have a suggestion for a formula to use that will give the date of the Payment object instead?
(Usually they are the same, but sometimes the person who enters the payments is out of the office for a day or two and puts them in late!)
thanks,
Ari