Sort by field value

Select Enable sorting by this field in the field profile Options settings if the single item field can be used as a sorting field for Verify and Transfer jobs.

If the field is a date field, the invoices are sorted by date using the format YYYYMMDD, regardless of the format of the date on the invoices.

Do not select this setting for all field profiles. Decide which fields will be useful as sort fields and specify the setting only for those fields.

The invoices are sorted according to the sorting field’s value and status.

  • If the values are sorted in descending order, invoices with complete sorting fields are sorted first, followed by invoices whose sorting fields have interpretation errors.
  • If the values are sorted in ascending order, invoices whose sorting fields have interpretation errors are sorted first, followed by invoices with complete sorting fields.

Example

You can use this to sort invoices based on the value of the ‘due date’ field. The result is that you verify and transfer the invoices with the earliest due date first.

  1. Using Manager, open the invoice profile, make sure it is inactive, and then open the single item field profile.
  2. Select the Options settings.
  3. Select the settings in the Field sorting box.
  4. Select Enable sorting by this field.