Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt

This article describes how to produce a file for Western Union payment system in Adonis.

...


Page Properties

Description

Create Westerm Union Payment file

Latest Version

2020.9.25.2

Release Date

Download Path

Download

Type

APM Plugin

The interface to Western Union is implemented as an APM plug-in. How to install the plug-in see here Install APM Plugin.

Table of Contents
minLevel1
maxLevel7
excludeContents

Configuration

As with any payment files created from Adonis, Western Union requires the setup of banking info for payroll transactions.

The Balance Action used for this interface is ISO 20022/Swift. Please use article How to generate ISO 20022 format bank file to configure the system (General Codes and Organization setup, Person/Employee setup). Most settings are the same, though there are specifics for Western Union:

  1. Though the file sent to Western Union does not contain information about the company bank, Adonis still needs it be created in General Codes > Payroll > Banks and then setup in Organization structure under company Payroll > Payment settings in Bank Account for NetPay. If wanted, a dummy bank can be used.

    Image Modified


    Image Modified
  2. Western Union does not use the setup in Global Options > Payroll > Countries type definition described in the article that we refer to above.

  3. Western Union only works with Payroll Entry Codes that are setup with "Advance Entry Code" option. Meaning, it does not include payments from EC 994 Net Wages and Payment tab does not need to be setup with ISO 20022/Swift balance action and banking details on a person as described in the article. All transactions must be added to payroll entries with "advance" entry codes and banking details in Payroll Additional Info window (described later in the mentioned article).

    Image Modified
  4. When configuring a person transactions for back processing, use Text field in Payroll Additional Info to define EFT or ACH transfer. EFT - Electronic file transfer, ACH - Automatic Clearing House system transfer used by many USA banks.
    This field is further used in the Western Union files in "PayBy" column.

    Image Modified

Produce file to Western Union

Go to Tools > Export > Western Union

...

Image Added

In the next window select Entry Codes that should be selected by the system for payment distribution. This window only shows Entry Codes with option "Advance Entry Code".

...

Image Added

Western Union window will give a preview of all the data that will be included in the export file. You can make checks, select the records that you want to be exported, the export directory and export the file.

...

Image Added

After the export file is created you will receive confirmation message as below. The file is exported in .csv format.

...

Image Added

When you click "OK" you will be asked if you want to lock the exported entries. You can learn more about this functionality in the following article Lock/Unlock Payment Entries and Payroll Period

...

Image Added

Reports for bank transactions sent to Western Union

If you want to produce a report on all transactions with banking details that will be included in Western Union export file, then before the export you can run Payroll > Reports > Current > Advance List report > Preview and save it to pdf or excel, or print it.

The report is also available in historical mode to check on historical bank transfers in closed payroll periods.

...

Image Added

Specification of WU files

Western Union excepts the .csv format files. Adonis creates the files of the same format.

Fields specification:

Adonis spec

Crew Personal Details Last, First name separated by comma

Receiver name from Payroll Additional Info

Transaction country

Transaction currency code

Transaction amount

Fetch Text from Payroll Additional lnfo

Receiver Bank name

Receiver bank account

Receiver bank SWIFT

Receiver bank Routing code

Receiver bank country

Receiver bank address

Receiver bank address

Receiver bank address

Receiver bank address

Receiver address

Receiver address

Receiver address

Receiver address

Blank

Blank

Receiver Bank Identification

Intermediate bank Bank Identification code

Intermediate bank name

Intermediate bank SWIFT

Intermediate bank

Intermediate bank

Intermediate bank

Intermediate bank

Intermediate bank

Intermediate bank

Intermediate bank

File column headers

Name

AcctName

Country

Currency

Amount

PayBy

BankName

BankAccount

BankSWIFT_Address

BankRoutingCode

BeneBankCountry

BankAddressLine1

BankAddressLine2

BankAddressLine3

BankPostalCode

BeneAddressLine1

BeneAddressLine2

BeneAddressLine3

PostalCode

RefLine1

RefLine2

BankCode

IBankCode

IBankDescription

IBankSWIFT_Address

IBankRoutingCode

IBankAccount

BeneIBankCountry

IBankAddressLine1

IBankAddressLine2

IBankAddressLine3

IBankPostalCode

Example of file.

View file
nameWU202011541046.csv