Happy Business Starts Here

Re: Revenue Schedule Date - Which date to select in Billing-based Revenue Rule Models ?

Honor Student

Revenue Schedule Date - Which date to select in Billing-based Revenue Rule Models ?

Hi Gurus,

 

We are starting implementation of RevPro on Oracle EBS R12. We intend to select billing based revenue rule model for most of the transaction types. 

Please help us to guide which date is most appropriate for Revenue Schedule Date. We can choose from Invoice Date, GL Date , GL Posting Date. 

 

We intend to choose Invoice Date keeping performance in mind, Can you please help us to understand the pros and cons of using all 3 dates ?

 

Many thanks in Advance

Gaurav 

5 REPLIES 5
Highlighted
Zuora Product Team
Zuora Product Team

Re: Revenue Schedule Date - Which date to select in Billing-based Revenue Rule Models ?

Hi Gautam,

 

Based on the question posted, making an assumption is that your revenue to be recognized upon billing

 

Invoice date would be appropriate when it is Billing Based model

 

Can you elaborate on the point performance you mentioned, am trying to understand more on the performance aspect against GL Date/GL Posting Date/Invoice Date?

 

Is the performance concern is in EBS R12 or RevPro?

 

This would help us provide you back with an apt answer on your second point.

 

Thanks

 

 

Tags (1)
Honor Student

Re: Revenue Schedule Date - Which date to select in Billing-based Revenue Rule Models ?

Many thanks Sai for the quick reply. 

 

The performance concern is on EBS side. 

 

GL Date resides in ra_cust_trx_line_gl_dist_all table and invoice date we get it from ra_customer_trx_all table. For every transaction that we want to push to RevPro we don't want to touch upon ra_cust_trx_line_gl_dist_all for any information and it seems GL_Date is the only column that we might need rest all the information (Viz. revenue account, unearned revenue account etc,) we can pick up from setups.

 

Also can you please share your insights why Invoice date is more appropriate?

 

Thanks in Advance

Gaurav Gautam

Tags (1)
RevPro Support

Re: Revenue Schedule Date - Which date to select in Billing-based Revenue Rule Models ?

Hello Gautam,

    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?

 

Thanks,

Bhadresh Moola





If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

Tags (1)
Honor Student

Re: Revenue Schedule Date - Which date to select in Billing-based Revenue Rule Models ?


Hi Bhadresh, Sai,

 

We have the number of scenarios where GL date is not in same as invoice date viz billing in arrears and catch up bills etc.
But if we stamp the appropriate rule_start_date and rule_end_date (or duration) and send a billing event on invoice_date, how does it matter what is the GL_date at the source for the corresponding invoice?

 

Please advise?

 

Thanks

Gaurav Gautam

Tags (1)
Zuora Product Team
Zuora Product Team

Re: Revenue Schedule Date - Which date to select in Billing-based Revenue Rule Models ?

Hi Gautam,

 

It doesn't matter as long as you ensure the invoice date is correctly populated along with Rule Start Date and Rule End Date, based on which the billed revenue will get amortized accordingly.

 

If the invoice date is in a future period, then the system will not process until the period is open which am sure you are aware of

 

Thanks,
Sai Prasad

Tags (1)