top of page

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

Delete --->

loading gif.gif

Add New File

Select 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]

loading gif.gif

X

Select File
loading gif.gif
Add Image
bottom of page