|
Oguzhan Altun
|
March 23, 2017 at 5:25 am
Hello,
I used to depend on the registrations CSV report – Amount Paid column – to track my total sales. As we are closing 2016, there was a quite big gap vs what my accounting told me. When I checked, I found out that all the registrations that have been moved to another event using the EE4 attendee mover had amount paid repeated.
So when I look at user A originally registered to Event 1 and paid $100, then moved to Event 2: I see $100 in the Amount Paid column in both lines in the CSV report. Transaction status is also “complete” in all lines. So the report makes it look like the user paid multiple times for the same registration.
I also looked at REG_final_price column, which handles this case correctly, but then the pending payment registrations are reported there.
So my question is how do I report the actual total sales?
Also is this a bug with how the Attendee mover works? I don’t understand why it duplicates transactions while only the registration is moving.
|
|
Josh
|
March 24, 2017 at 12:15 pm
Hi Oguzhan,
I checked and the Attendee mover does not actually duplicate transactions. Are you looking at the registrations instead? There should be an original, cancelled registration and also a new registration for the moved attendee. You can use the “Registration’s share of the transaction total[REG_final_price]” to get an accurate total. The other columns shouldn’t really be used for getting total amounts of money via the registrations CSV.
|
|
Oguzhan Altun
|
March 25, 2017 at 11:55 am
Hello Josh,
The [REG_final_price] column gives the correct result in this case, however that one has a major flaw: It also includes those who selected “payment by bank transfer” but did not pay at the end…. This is why I have been using the “Amount Paid” column.
|
|
Josh
|
March 27, 2017 at 2:27 pm
I get that you don’t like that it reports an amount there if they didn’t pay, but it’s not a flaw that it reports an amount there. When you track total sales with the registrations report, regardless of the column you’re looking at, you’ll need to factor in the Registration Status column. So for example if the column values have “Cancelled” or “Pending Payment”, then those rows shouldn’t be counted as sales.
|
