If Invoices are imported to GL at regular intervals on the same day of invoice creation, there is no difference in using Invoice Date vs GL Date. This is the scenario most of the times.
If Invoices are posted to GL at different day/time, Preferable data point would be "GL Date" to schedule revenue. Yes, agreed that there would be performance issue while pulling Invoice details from Oracle Apps since data point has to come to Distributions table.
Why GL Date and Not Invoice Date?
GL Date actually represents the period in which its being accounted in upstream ( Oracle Apps in this case). For RevPro to stay intact with upsteam and reconcile with GL, GL_Date would be right data point to use.
Curious why the Invoices are not posted to GL on same day, do you mind to add details. Is it common not to post invoices on same day?
... View more