GL Date
Oracle Projects determines the GL Date when you interface costs, revenue, and invoices to other Oracle Application products. The GL date is determined for each cost distribution line, each draft revenue, and each draft invoice.
GL Dates are determined according to the following criteria:
Timecard, Usage, and Miscellaneous Transaction Costs
Oracle Projects derives the GL date when you interface costs to Oracle General Ledger. A GL date is determined for each cost distribution line of an expenditure item.
The GL Date is set to the end date of the earliest GL period that is on or after the PA date of the cost distribution line and has a status of Open or Future according to the period status in Oracle General Ledger.
Expense Report Costs
Oracle Projects derives the GL date when you interface expense report costs to Oracle Payables. A GL date is determined for each cost distribution line of an expenditure item.
The GL Date is set to the end date of the earliest GL period that is on or after the latest PA date of the cost distribution lines included on the expense report and has a status of Open or Future according to the period status in Oracle Payables. The Oracle Payables Invoice Import program uses one GL date for each expense report loaded into Oracle Payables. Because of this, all cost distribution lines for an expense report must use the same GL date.
Supplier Invoice Costs
Oracle Projects copies the GL date for each supplier invoice cost distribution line from the GL date that you entered for the invoice distribution line in Oracle Payables, when you interface supplier invoices from Oracle Payables. This date may not be the end date of a GL period.
Supplier Invoice Adjustment Costs
Oracle Projects derives the GL date for supplier invoice adjustment distribution lines as it does for timecard, usage, and miscellaneous transaction items, which is explained above.
Revenue
Oracle Projects derives the GL date when you interface revenue to Oracle General Ledger. A GL date is determined for each draft revenue. All items associated with the draft revenue use the GL date of the draft revenue.
The GL Date is set to the end date of the earliest GL period that is on or after the PA date of the draft revenue and has a status of Open or Future according to the period status in Oracle General Ledger.
Invoice
Oracle Projects derives the GL date when you interface invoices to Oracle Receivables. A GL date is determined for each draft invoice.
The GL Date is set to the end date of the GL period that the invoice date of the draft invoice falls within and has a status of Open or Future according to the period status in Oracle Receivables.
