General Payment Fix


  • Delete any with a PaidUntil year of 2037

  • Move the ReceiptType column to between PaidUntil and CharityId

  • Change date format of PaidUntil, NotifiedToEnforcementTime, PaymentTime and EntryTime to yyyy-mm-dd hh:mm:ss

  • Change AmountDue and UnpaidChange to Number format

  • Save file

  • Right click and open in Notepad++

  • Find and replace , with “,”

  • Find and replace ^ with “

  • Find and replace $ with “

  • Save and name file as per upload requirements



Slug and Lettuce / Wythall Community Centre


  • Delete any with a PaidUntil year of 2037

  • Delete any with a PaymentMethod of NotSet and FullyCovered

  • Delete any transactions where the PaymentResult is not Success

  • Move the ReceiptType column to between PaidUntil and CharityId

  • Change date format of PaidUntil, NotifiedToEnforcementTime, PaymentTime and EntryTime to yyyy-mm-dd hh:mm:ss

  • Change AmountDue and UnpaidChange to Number format

  • Save file

  • Right click and open in Notepad++

  • Find and replace , with “,”

  • Find and replace ^ with “

  • Find and replace $ with “

  • Save and name file as per upload requirements