Exporting to a Text File in Jobs History

When exporting adjustments, you can select one or more of the available transaction types within a match type. You can also filter adjustments based on the transaction date.

The last step in the process is to export adjustments or transactions from Jobs History for Transaction Matching. The export process exports all the adjustments and transactions that are in open status and match any applied filter criteria. Filtering is available to limit the number of transactions.

Once you export the journal entries, you can reopen them and re-export. See Re-Exporting or Reopening Journal Entries

Export Adjustments as Journal Entries

The number of adjustments per reconciliation that you can export in one action is 1,000,000. To export more than 1,000,000, you must perform a separate export for the remaining adjustments.

To export adjustments as journal entries:

  1. From Home, select Applications, then Jobs and then Transaction Matching.
  2. On Job History, from Actions, select Export Journals.
    Export Journals dialog
  3. In Type, select Adjustments.
  4. Select the Match Type.
  5. (Optional) The Adjustment Type displays the adjustment types available for the match type selected in the previous step. Select one or more of the displayed values. If you don't select a value, the default used is All.
  6. (Optional) Specify the Accounting Date. The operators available for filtering are Equals, Before, Between, and After. Select the operator required for the date comparison and then use the Date Picker to select the dates. If you don't specify anything, the default used is All (all dates).
  7. Click OK.
  8. The job is now visible on Job History and once successful, you can open or save the csv file created.

    Note:

    Once you export, adjustments that are successfully exported are changed from open to closed state. The export process will not include Adjustments that are in a closed state. This ensures that the same Adjustment is never accidentally exported more than one time. See Re-Exporting or Reopening Journal Entries for information on how to re-open previously closed Adjustments, or re-export previously exported Adjustments.

Export Transactions as Journal Entries

To export transactions as journal entries:

  1. From Home, select Applications, then Jobs and then Transaction Matching.
  2. On Job History, from Actions, select Export Journals.
  3. In Type, select Transactions.
    Export transactions as journal entries
  4. In Match Type, select a match type.
  5. In Data Source, select the data source.
  6. If you applied filters to the transactions, select the filter.
  7. Click OK and the job is now visible on Job History. Once successful, you can open or save the csv file created.

Apply Filters to Transactions

You can now create filters for transactions within a given datasource so that you can export only those transactions you wish. You first create the filter on the Edit Match Type, Data Sources tab and then during the export as journal entries, you will be able to select that filter from the list.

To create a filter to limit the transactions for export:

  1. From Home, select Applications, then Match Types and then select the match type you want, and under Actions, select Edit.
  2. Select Data Sources and then select the data source you want to filter.
  3. Select the Filters tab and click New. Here is an example of creating a new filter on the Accounts Payable data source.
    Example showing new filter on filters tab
  4. Enter a name for the filter in the Name field.
  5. In Filter Definition, you can create the conditions that need to be met to be included and then click Apply.

    For example, let's create a filter for AP amount greater than 100.


    Filter example
  6. Click Create Condition.
  7. In Attribute, select AP Amount.
  8. In Operator, select Greater Than.
  9. In Value, select 100 and then click Apply.
    Data Sources showing AP Filter 1

    This filter will now be available when you export transactions as journal entries.

Note:

Once you export, transactions that are successfully exported are changed from open to closed state The export process will not include transactions that are in a closed state. This ensures that the same transaction is never accidentally exported more than one time. See Re-Exporting or Reopening Journal Entries for information on how to re-open previously closed journal entries, or re-export previously exported journal entries

Re-Exporting or Reopening Journal Entries

Once an export has been performed, you can see two options on the Actions menu: Re-Export and Reopen .

Re-export is done from the Jobs History and you use the same Job ID which gets stored when an export takes place. This Re-export means that you get the same result as the original export.

The Reopen option can be used if you need to look at the adjustments or transaction journal entries again and is useful if you have a partial failure of some kind before it gets imported into your ERP system, or if you want to make a change to a filtered list of transactions. This option changes the exported entries from Closed to Open.