Current situation: once a user submits data for a PPL or MCP donation, we store this data as an incomplete donations and set a time stamp. Regardless of the actual payment date according to the payment provider we set this incomplete data set incl. its early time stamp to a complete data set. This leads to a deviation of the time that we export to VEWA and the time the user actually completed the donation on the external payment site (in some cases). The latter is used by our accounting.
So the problem is that the donations might be booked on the wrong day if the donation happens near the change of a day or even year. The "right" date is the one of the confirmation of the payment.
Two examples
Beispiel PayPal/
Spenden-ID: 3254517
Backend:
Zeitstempel: 2019-08-31 23:59:01
PayPal
Spende erhalten: 1. September 2019 um 00:02:33 MESZ
(Transaktionscode: 0WP61548C2588384G)
VEWA
Sollgestellt und gebucht am 31.08.2019
Beispiel MCP/
Spenden-ID: 3262086
Backend
Zeistempel: 2019-09-15 23:59:41
MCP
Datum 16.09.2019 - 00:01:24
(Transaktionsnnummer: spenden.wikimedia.de-ID7m5g17sd92)
VEWA
Sollgestellt und gebucht am 15.09.2019
Expected behavior: the complete donation data set gets the time stamp that the payment provider tells us, so we export the correct time of the donation to VEWA and are able to send out correct donation receipt.
Note: Due to our current database structure and not wanting to do database changes and major refactorings during the campaign, we implement this on the export side of this and track the required changes to FundraisingFrontend in T238920