How to Configure Sage Import Maps for RedAnt

How to Configure Sage Import Maps for RedAnt

Follow the steps below to identify your Sage version and correctly configure the RedAnt import mapping.

  1. From the RedAnt main menu, go to:
    Maintenance → Setup → Defaults
  2. Select the General tab.
  3. In the bottom-right corner, locate the Financial Link dropdown.
  4. Note the selected value (e.g. Sage 50 or Sage 50 V11+).
  5. Close the Defaults window.

Start the Import in Sage

  1. Open Sage.
  2. Select File → Import.
  3. Create a backup if required, then click Next.
  4. Select Audit Trail Transactions, then click Next.
  5. Choose Comma Separated File (CSV).
  6. Browse to your exported RedAnt file and click Next.

Configure Field Mapping

You will now see the mapping screen where RedAnt fields are matched to Sage fields.

  • Use the Financial Link version you identified earlier to determine how many fields to map:

    • Sage 50 → Map fields A to J
    • Sage 50 V11+ → Map fields A to M

Mapping Instructions:

  • In the Imported Field column:
    • Assign A to the first field
    • Assign B to the second field
    • Continue sequentially through the alphabet
    • Stop at the appropriate letter based on your Sage version

Example:

  • If using Sage 50, stop at J
  • If using Sage 50 V11+, continue to M (User Name)

Save the Mapping (Optional)

  • Click Save Map to store your configuration for future use.
  • Once a successful import is completed, Sage will remember your mapping settings automatically.

    • Related Articles

    • Setting Up Redant for Foreign Currency Transactions

      This guide explains how to configure RedAnt to process foreign currency transactions and export the correct VAT codes to Sage or Xero. Sage / Xero Export VAT Code Setup From the Redant Main Menu, navigate to: Maintenance > Setup > Defaults Select VAT ...

    • How to Enable TCP/IP Connections for SQL Server and Configure RedAnt to Use TCP

      By default, some SQL Server installations use Named Pipes for database connectivity. In many environments this works without issue, but in some cases Named Pipes can lead to connection timeouts or intermittent connectivity problems after periods of ...

    • Adding Terms and Supporting Documents in RedAnt

      RedAnt allows you to attach terms and conditions and additional supporting documents to outgoing emails, such as quotations, invoices, and purchase orders. Follow the guidelines below to configure these documents. Adding Sales and Purchase Terms To ...

    • How to Install RedAnt on a Workstation

      Follow the steps below to install RedAnt on a workstation: 1. Access the Server Open My Computer / Computer from the Desktop or Start menu. In the address bar, type: \\servername (Replace “servername” with the name of the server where RedAnt is ...

    • Adding and Running Crystal Reports in RedAnt

      Any report created using Crystal Reports can be incorporated into the Reports module in RedAnt. Follow the steps below to add and manage reports. Adding a New Report From the Main Menu, select Reports from the top navigation bar. In the Report Name ...