Entered By
Amanda D
Title
Payment cleanup
652022d4-66ba-48bb-9ad7-55f63b0e20e0
Assigned To
Date Entered
Attached Files
Bill H
Center
...
...
Contact
Jane Fecto
Apr 18, 2022
Last Updated
Oct 15, 2022
...
X
Add New File
Status
Completed
Date Due
Mar 9, 2021
Date Completed
Mar 9, 2021
Notes
Going to paste her email here and please reach out to me with questions: In reviewing our database, it appears we have 2019 (and prior) past due membership fees. We believe this resulted from a combination of things: 1) we invoiced the specific members but they did not pay; or 2) we did not invoice the specific members; or 3) we invoiced the specific members and they paid, but we did not record their payment. Would you be able to go into our database to ?wipe the slate clean? for any membership dues from 2019 or prior? We should only be showing invoices due in 2021 or beyond (as you recently moved all 2020 invoices to 2021 at our request). NOTES FROM BILL: I deleted all payments for their membership group where the payment date was less than 1/31/2019. Pasting Script below for future reference. SELECT [Payments_ID] ,[Payments_SeniorID] ,[Payments_Type] ,[Payments_TypeID] ,[Payments_TypeMasterID] ,[Payments_TypeMaster] ,[Payments_Date] ,[Payments_Time] ,[Payments_Amount] ,[Payments_PayHow] ,[Payments_Notes] ,[Payments_Paid] FROM [dbo].[Payments] -- delete FROM [dbo].[Payments] where [Payments_ID] not in (SELECT [Payments_PaymentID] FROM [dbo].[Payments_Link]) and [Payments_Date] < '1/31/2019' and [Payments_Type] = 'Group' and [Payments_TypeID] = 1 order by [Payments_Date]
X