By definition (in Help files and the real world) a Pledge Payment Transaction is a payment against a pledge. Note Standard Pledge reports expect a payment to be linked to a pledge.
Millennium should only allow a pledge to be journaled once only voided transactions are linked to it.
Note : If you try to journal a Sustainer pledge (payments attached or not) when you insert you get an error “The INSERT statement conflicted with the FOREIGN KEY constraint "fk_gifttype". The conflict occurred in database "milldata", table "dbo.gift_types", column 'table_code'. Error Code 547” THIS IS FINE do not change it; sustainers can be inactivated rather than journaled.
File attached with screen shots and query to find these voided pledges.
Hello! I've seen a solution here https://writemyessay4me.org/lab-report. It is not such a difficult question.
Attachments Open full size
Here's the file!
Attachments Open full size