Re: voiding payment

Josh Hillman ( (no email) )
Thu, 4 Jun 1998 16:51:26 -0400

/* Delete a payment from the database */
/* This does NOT subtract the payment from MasterAccounts.Balance */
/* Or modify the expiration, paidthru, last-received dates */

DECLARE @PaymentID int
SELECT @PaymentID = /* Enter PaymentID to be deleted */

UPDATE InvoiceItems
SET PaymentID = NULL
WHERE PaymentID = @PaymentID

DELETE FROM Payments
WHERE PaymentID = @PaymentID

Josh Hillman
hillman@talstar.com

> Bill Bongiorno wrote:
> > Is there any way to void/cancel a payment?
>
> From: Dale E. Reed Jr. <daler@iea-software.com>
> You have to void the invoice the payment was applied to and then
> re-create the invoice.