Skip to main content

Exporting Invoices

The Invoice Export Utility enables you to bulk export multiple invoices using a list of invoice numbers from an Excel file. You can export invoices to a specified folder as PDF or RTF files using a selected print form.

How the Invoice Export Utility Works

The utility imports invoice numbers from an Excel file and automatically generates exports for each invoice using a selected print form.

For each invoice, the tool:

  • Exports the document in either PDF or RTF format.
  • Saves the file to a user-specified folder.
  • Names the file according to the corresponding invoice number.

Before Starting

EPASS Users need the Invoice Export security option to use the utility.

Steps

  1. Go to Tools > System Maintenance.

  2. On the Tables tab, select User Security and then click Open.

  3. Select a User or Group, and then click Security.

  4. In the Keyword field, enter invoice export.

  5. Select the Utilities: Invoice Export security option.

  6. Click OK, and then Exit the User Security window.

Preparing the Excel File

Create an Excel file and list each invoice number that you want to export in a single column. When finished, save and close the Excel file.

Running the Utility

  1. Go to Invoicing > Utilities > Invoice Export Utility.

  2. Do the following:

    AEnter the location of the Excel file.
    BEnter the column letter that contains the invoice numbers.
    CSelect the export file type: PDF or RTF.
    DEnter the destination folder for the exported files.
    ESelect a print form. (Available print forms on the terminal are listed.)
  3. Click OK. The utility runs and exports the invoices to the destination folder.

Notes
  • Invalid or missing invoice numbers are skipped.
  • Make sure that the destination folder has write permissions.
  • EPASS Users without the required security are not able to run the utility.

See Also