Home360New York Compliance ReportingContribution Payment Types

69.2. Contribution Payment Types

Why is Column AG of my NY report populating a NULL value?

 

The contents of column AG depend on what is selected as a receipt's payment method, which is usually determined by the receipt's subtype. Subtype/payment method maps to the report on column AF, and if that payment method is Check, then the contents of the receipt's Check # field will then populate column AG.

If a receipt's payment method is anything other than 1, then column AG should pull a NULL value, since Check # wouldn't apply for receipts paid via other means.

The table below lists the various payment methods that can pull to an NY report:

payment_type_id payment_type_abbrev payment_type_desc
1 CHK Check
2 CRC Credit Card
3 DC Debit Card
4 OP Online Processor
5 WT Wire Transfer
6 CASH Cash
7 OTHER Other

This page was: Helpful | Not Helpful