This object is in archive! 

Overstated revenue due to multiple payments revenue duplicated

Stacey W. shared this problem 5 years ago
Solved

It appears that revenue is overstated by the amount of multiple payments that are posted within a contract. This is concerning given that it overstated revenue when looking at the sales on the sales page and also when pulling the sales tax report.

Comments (1)

photo
1

Do you have a lead ID for an example?

photo
1

Down Syndrome Guild - when I have 2 payments, the Lead $ Sales is duplicate of the total payments. The payments amount is correct, 3994325

photo
1

Are you referring to the Lead $ Sub Total and Lead $ Total in your report, Payment Report, doubling the total of the event, Down Syndrome Guild?

photo
1

Yes, that is correct. I had noticed that the overview sales tab YTD and Sales by month had different totals. They are correct now but the report that I ran on Monday was incorrect and I has to manually adjust.

photo
1

This is being caused because this report is set to be grouped by the Lead Organization and with the payment columns in this report also, it's taking the duplicate information from the multiple payments and adding it together. You could split these columns into different reports to keep this from happening.

Replies have been locked on this page!