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.