Understanding the Credit Card Interface for Entering Expense Reports

The process of reimbursing employees for business expenses is time-consuming. Employees must sort and copy receipts, as well as accurately transcribe information to a report. To ensure accuracy, expense reports often require management approval and auditing before employees can be reimbursed. Delays in the review process can directly impact the company's ability to reimburse employees in a timely manner.

If the company issues a corporate credit card to employees, you can expedite the expense reimbursement process by downloading employee credit card transactions from the credit card company to the Credit Card Transaction Interface Table (F09E150) in the JD Edwards EnterpriseOne Expense Management system so that transactions can be directly applied to expense reports. Using the credit card interface not only saves employees time entering expenses; it also provides the company with a better method of tracking and reporting on expenses.

This is the process for using the credit card interface:

  1. Transactions are updated to the Credit Card Transaction Interface Table using a custom program.

    See Mapping to the Credit Card Transaction Interface Table.

  2. The employee reviews each transaction and updates the Transaction Status field, as indicated:

    • If the transaction is personal, the employee updates the transaction status to Nonreimbursable.

    • If the transaction is in dispute, the employee updates the transaction status to In Dispute.

    • If the transaction was applied manually (before becoming available in table F09E150), the employee updates the status to Applied and uses an additional form to match the credit card transaction to the applied expense.

    • If the transaction is a duplicate and should be purged, the employee or a system administrator updates the status to Obsolete.

      Note: You can also add custom transaction status codes to UDC 09E/CS (Credit Card Transaction Status) and assign them to credit card transactions.
  3. The employee applies the appropriate credit card transactions to the expense report.

  4. The system administrator purges the Credit Card Transaction Interface Table, as necessary.

    See Purging Credit Card Transactions.