Upload American Express Non-Financial Transactions

To upload American Express non-financial transactions, you must create the lookup type EXM_CC_AMEX_NF_FEES. Non-financial transactions are transactions where the MIS transaction code is NF in the corporate card transactions file. Examples of non-financial transactions include a membership rewards annual fee and a membership reinstatement fee.

Create the lookup type EXM_CC_AMEX_NF_FEES with its associated lookup codes.

1. In the Setup and Maintenance work area, use:

   • Offering: Financials

   • Functional Area: Expenses

   • Task: Manage Standard Lookups

2. On the Manage Standard Lookups page in the Search Results section, click the New icon.

3. In the Lookup Type field, enter EXM_CC_AMEX_NF_FEES.

4. In the Meaning field, enter an applicable meaning.

5. In the Description field, enter an applicable description.

6. From the Module choice list, search and select Expenses.

7. Click Save.

8. In the EXM_CC_AMEX_NF_FEES: Lookup Codes section, add lookup codes for each of the non-financial transactions that you would like to load.

9. In the Lookup Code field, enter a code that represents the name of the lookup code, such as NF_MEMRWDS.

10. In the Meaning field, you must enter the same description you receive in the feed, such as MEM RWDS ANNUAL PROG.

11. In the Description field, enter a description for the lookup code meaning, such as Membership Rewards Annual Fee.

12. Click Save and Close.

13. Schedule the Upload Corporate Card Transactions process to load the American Express non-financial transactions.