AP Expense Report Upload Copy link

➜ Back to Library
XMLXML import file

Description

Categories
Enginatics, R12 only, Upload
Repository
GitHub
Creates and updates expense reports - the Excel equivalent of the Payables Expense Reports form (Invoices > Entry > Expense Reports) - and transfers them to Payables invoices with Expense Report Export.

Each row is one expense report line, with the expense report header columns repeated on every line. The header values are taken from the first row of each expense report. An expense report is identified by Employee and Invoice Num.

Each expense report is processed as a whole: when any of its rows fails validation, none of its rows are saved. The Amount must equal the total of the lines; leave it unchanged to set it to the total of the lines.

The account of a line defaults from the GL Account of the expense report, overlaid with the account segments of the expense item, as in the form. Set Delete Line to Yes to delete a line.

With Submit Expense Report Export set to Yes, Expense Report Export runs for the operating units of the uploaded expense reports and creates the Payables invoices. As in Payables, it transfers every expense report pending export in the operating unit, also those not in the upload file. Rows of an expense report that it did not transfer (rejected, or on hold) show the reason as an error, and the expense report can be corrected and uploaded again. An exported expense report cannot be changed.

SQL 118 lines

Parameters 8

ParameterTypeList of values SQL
Upload ModeLOV
:p_upload_mode like '%' || xxen_upload.action_update
Submit Expense Report ExportLOV Oracle
Operating UnitLOV
haouv.name=:operating_unit
Employee NameLOV
ppx.full_name=:employee_name
Invoice NumChar
aerha.invoice_num=:invoice_num
Report Date FromDate
aerha.week_end_date>=:report_date_from
Report Date ToDate
aerha.week_end_date<:report_date_to+1
Not Exported OnlyLOV
aerha.vouchno=0