Hi
We have to prepare a mid month close. So I have done the below:
1. Renamed base period June 2021 to Jun 2021-1
2. Changed end date of Jun 2021-1 to 17/6/2021
3. Created a new base period called Jun 2021-2, with start date 18/6/2021 to 30/6/2021.
We use advanced revenue management, the fixed asset module and deferred expenses and I am looking for some tricks to update these for the new periods.
Advanced revenue management
For revenue recognition, a portion needs to be allocated to Jun 2021-2. Existing revenue recognition plans are allocating the entire June revenue to Jun 2021-1.
I did the following;
- Transactions - financial - recalculate revenue forecast plans
- No filters clicked submit. Let it process to 100%
- Next went to transactions - financial - edit revenue plans
- Edited the first revenue recognition plan by changing the revenue recognition end date to the next date; and clicked submit
- Changed the above plan date to the existing date, clicked submit
I noticed this updated the Jun 2021-1 and Jun 2021-2 portions on that revenue plan. The problem is we have in excess of 3000 revenue plans so doing this manually is impossible.
I tried using the bulk plan update option,
first make by turning the hold revenue recognition on all plans on and off. However this did not update the period Jun 2021-1 and Jun 2021-2.
Next I tried updating the revenue recognition rules to a new rule (which had the same attributes as the old rule) this successfully updated periods, but it a plan already had a journal attached from an earlier period it resulted in a failure.
Not sure what else to try, would be great if there was an option to csv update the revenue recognition end dates on the revenue plans. But there doesn't appear to be.
Fixed assets
To update the depreciation histories to reflect two periods, I am assuming the only option is to exporting the current histories, split the period in the csv and reimport?
Deferred expenses
Is the only way to update manually each one as per below?
Thanks for your help.