Understanding the Import Process

In addition to manually entering expenses using the Expense Entry program (P09E2011) or using the credit card interface to apply expenses charged to a corporate credit card, you can enter expenses into a spreadsheet and import them into the expense report. For example, you might want to import expenses under these circumstances:

• A network connection is not available (for example, when you are in an airplane).

• A high-speed connection is not available; performance is slow on the web environment.

To use the import feature in the JD Edwards EnterpriseOne Expense Management system, you must match the columns in the spreadsheet that you complete exactly to the columns that appear in the detail area of the Import Expense form (W09E2011D). You can ensure exact matching by using the export feature to create the spreadsheet.

You can import expenses from a spreadsheet and then enter additional expenses manually, but you cannot manually add a new expense report, and then append it with expenses that you import from a spreadsheet.

When you import an expense report, the system validates the imported information in the same manner that it does when you enter the expense report manually.

For tracking purposes, the system updates the Record Source field in the Expense Report Detail table (F20112) to 2 for the expenses that you import.