Wrong designation showing in query results

I'm noticing a curious discrepancy between my query results and canned report results and I wanted to know if there's a reason for it that I should be aware of. On my order, there is one designation showing. But when I build a query for the order, a different fund shows. 
Query will show the designation/fund that is applied to the revenue. This may show differently than what is originally on the Sales Order record, if the revenue was edited after the fact. To review the revenue record: 
  1. Click Sales > Click Order Search
  2. Enter the order number
  3. On the Order Details tab, see the fund showing for the donation
  4. Click Go to Revenue for the donation
  5. See that the designation has been edited on the Details tab, and is showing a different designation. 
  6. If this is the incorrect designation, click Edit and enter the correct designation

Steps to Duplicate

Create a Sales order donation
  1. Click sales > Advance sales
  2. Type in the name of the patron and click on the create order tab
  3. Click the Donation button. Enter the amount and designation of the donation
  4. Click add to order
  5. Click on the Add payment tab
  6. Click on the cash payment method > enter the amount and click save
  7. Click the complete button

Change the designation of the sales order
  1. Click Sales > Order search
  2. Search for and select the order
  3. Under the Order Details tab click the Go to revenue button
  4. Click edit under the details tab > change the designation > click save

Create a Revenue query that pulls in the transaction
  1. Click Analysis > information library > add an ad hoc query
  2. Choose Revenue in the record type drop down > double click on Revenue
  3. Under browse for fields in click on Revenue > drag revenue ID from the middle column to the include records where section and enter the revenue ID
  4. Under browse for fields in click on Application details > drag designation name from the middle column to the results fields to display section
  5. Click Preview results



 Altru Arts & Cultural

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.