I have imported hundreds of Recurring Donations via Data Loader during a migration. I have populated the NPE03__NEXT_PAYMENT_DATE__c with the date when the first collection should happen. However, checking the imported recurring donations, the dates are not the ones I specified in the import .csv file. It seems that NPSP runs a logic and overrides the values I uploaded. (sometimes by a day, other times a full month - e.g. specified date 2020-05-01 and in SF it turns into 2020-04-01.
Does anyone know, how I can force NPSP to accept my dates as first (next) collection date?
Thanks
Jens
Hi @Michael Beaty
The date is incorrect straight after import. Interestingly I found a solution. First issue was the date format in OpenOffice, but even that didn't fix the issue completely. Changing the date format always used the value in the field minus 1 day. e.g. field value in .csv file 2020-05-01. Value in Salesforce 2020-04-31. I actually ended up adding 1 day to the date in the .csv file. That did the trick.
btw: I do have Customizable Rollups turned on.
Thanks for your input.
