I need to create a query for all payments with a certain Other payment method

In Altru, you can set up Other payment methods for other types of payments rather than cash, check, and credit card.  These Other methods could be things such as gift certificate, Groupon, Pre-Altru, Scholarship, and more.  This Knowledgebase explains how to query on when a certain Other payment method was used. 
To see all front and back office revenue:
  1. Navigate to Analysis, then click on Information Library
  2. Click Add an ad-hoc query
  3. Select the source view of Revenue and click OK
  4. In the middle column, scroll down to the section titled Other and drag Other method into Include records where. Set Equal to the Other payment method you want to review.
  5. To filter on a date range: In the middle column, drag Date into Include records where.  Set equal to your date range.
  6. In the left column, select Revenue. From the middle, drag Revenue ID into Results fields to display.
  7. Click the Set Save Options tab and Name the query
  8. Save and Close

To see only sales orders:
  1. Go to Analysis, then click on Information Library
  2. Click Add an ad-hoc query
  3. Select the source view of Sales Order and click OK
  4. On the left column, expand Sales Order Payment, then select Revenue. From the middle column, scroll down to the section titled Other and drag Other method into Include records where. Set Equal to the Other payment method you want to review.
  5. To filter on a date range: In the left column, select Sales Orders. From the middle, drag Transaction date into Include records where. Set equal to your date range.
  6. From the middle column, drag Transaction date into Results fields to display.
  7. Click the Set Save Options tab and Name the query
  8. Save and Close

Environment

 3.15

Was this article helpful?