Hi,
We have a scenario (very frequent) where the renewals are performed during the beginning of the month where Rev Rec Start date is in the current month (not calendar month) but the sales order date is from next month. During ME Close, we run the Update RA (without source dates' criteria to include prior month deals which got recognized current month) , it creates the RA (we don't have WF for RA and it gets created once the SO is approved and Invoiced) for next month also which causes the RA to be created and revenue to be booked for current month which is incorrect.
here is an example to make it less confusing:
Current Open period in system: August 2021
Sales Order SO#1 has SO Date of 9/2/2021 and Rev Rec Start date of 8/29/2021. The So has been approved and Invoiced on 9/2/2021. Update RA and Rev Plans is run on 9/3/2021 which creates RA and Rev Plans for SO Lines for SO#1 including Rev Plan for August 2021 (For three days of August 2021) and after Revenue JEs are booked, this 3 day revenue for august is posted for august 2021.
This revenue should not have been posted in August 2021 and should have been posted in September 2021 with a catchup of August 2021.
How can we limit this from happening/put a system check in place to tackle this? please suggest.