Logic for Oracle Expense Reports ‘Invoice’ Date

Once the Expense Repot is converted to Invoice using the standard ‘Expense Report Export Program’ The invoice date is nothing but ‘week_end_date’ column populated on the ap_expense_report_headers_all table.

Below is the logic used behind the screens to populate ‘week_end_date’

1) If Expense Report Header is just entered and saved, the Expesne report header entry day will be the week_end_date

2) While entering an expense report line, you can select date on the expense report line: which is stored as expese_start_date

3) Also in the details when you enter No of days: expense_end_date will be calculated as expese_start_date+no.of.days

4) Once the expense_end_Date is populated, the weekend_date on the expense report header or Invoice_date, is nothing but the maximum value of the expense_end_Date of all lines.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s