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.

Environment

 Blackbaud CRM
 4.0
 4.0.170

Was this article helpful?