Marketing Effort Export Data Columns Out of Order after adding the Revenue Date Field.

When building an export definition after adding the date field under Revenue>Revenue Details>Date the column order is thrown into what appears to be a miscellaneous order opposed to numerically.
We’re currently evaluating this issue for a fix in a service pack. 

Steps to Duplicate

1. Go to Marketing Export Definitions.
2. Click the Add button.
3. Add a Direct Marketing Export Definition
4. Add the following fields to the export:
a. Constituent>Households Belong To>Household Constituent> Lookup ID
b. Revenue >Application details>Amount>
c. Revenue Details> Date.
5. Before adding the date field notice that the Column order is correct, after adding the date field it gets thrown out of numerical order.


 Blackbaud CRM

Was this article helpful?