Log into the System Administrator responsibility. The language component of the directory path is established for each language installed in your system.Ĭreate an HTML page with links to the spreadsheets and place the HTML page in the same OA_HTML/ virtual directory. Save the configured spreadsheets to the OA_HTML/ virtual directory on the Web Server. Save the spreadsheet using a different filename to the $OA_HTML/US directory. Save the spreadsheet using the method for either a single spreadsheet or multiple spreadsheets. To configure the Microsoft Excel template and make it available to your users:Īccess the apwexpmc.xls spreadsheet from the $AP_TOP/html/US directory.Ĭonfigure the spreadsheet according to your company's business needs. The seeded OIE Import Page function is assigned to the Expenses Shortcuts menu. Once you have configured the Microsoft Excel Template, remove the seeded function from the menu for exporting the spreadsheet. To configure the Microsoft Excel template, you must enter specific values from various Oracle Payables windows into the template. If the template does not match your implementation, employees cannot create and import expense reports using the disconnected process. For example, all fields in Internet Expenses must exist in your template, and fields that are set as Required in Internet Expenses must also be required in the template. You must configure the Microsoft Excel template so that it matches your current Internet Expenses implementation. The Microsoft Excel template is a spreadsheet that employees use to create disconnected expense reports. Note: All users assigned to the seeded Internet Expenses responsibility can access the Spreadsheet Export and Import Spreadsheet Expenses functions. An employee can enter additional expenses, save the report as a work in progress, or submit it for approval. When the spreadsheet passes validation, a new expense report is created in Internet Expenses. Modify the spreadsheet in Microsoft Excel.Ĭopy the contents of the spreadsheet, then paste the contents in the Spreadsheet Import Area. If a user pastes the spreadsheet more than once and then successfully uploads it, Internet Expenses creates an expense report with duplicate receipts.Ĭlick Skip to Review or Continue to ensure there is no missing or invalid data in the report. Note: Be sure to paste the spreadsheet only once into the Spreadsheet Import Area. When the spreadsheet is complete, log in to Internet Expenses and click the Expenses Entry link.Ĭlick the Import Spreadsheet Expenses button to display the Import Expense Report Spreadsheet page.Ĭopy the contents of the spreadsheet in Microsoft Excel, then paste the contents in the Spreadsheet Import Area. Open the spreadsheet template in Microsoft Excel and create a working copy using the Save As command.Įnter expenses in the spreadsheet using Microsoft Excel. To submit a disconnected expense report, an employee completes these steps:Ĭlick the Spreadsheet Export link and save the spreadsheet template to your local computer. Note: If you use the per diem or mileage rate schedules functionality, users need to enter these expenses online. See: Configuring the Microsoft Excel Template for more information. You can configure this spreadsheet template to meet the needs of your company. Internet Expenses provides a Microsoft Excel expense spreadsheet template to create a disconnected expense report. The disconnected expense reporting process involves entering expenses in a Microsoft Excel spreadsheet on a personal computer or laptop and then importing this spreadsheet into Internet Expenses.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |