- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
issue: Using Mass Updater tool, how do we redistribute revenue that is already allocated in other accounting periods? Using, "Manual: fixed amount" distribution type, we keep on getting an error with "The total amounts distributed to accounting periods [x amount] do not match the revenue schedule amount [x amount]. There are [x amount] remaining to be distributed".
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Solution: For "Manual: fixed amount" distribution. If the RS amount that you're redistributing has been allocated to all other accounting periods, populate the template with 0 for the accounting periods that will be zeroed out or input the delta value.
Example: Revenue schedule RS-1234 amount is 100 and it's been distributed from 2017-03 to 2018-03 accounting periods. Now if the goal is to just put the whole 100 revenue only in 2017-03, place 0 on the template for the rest of the accounting periods from 2017-04. (This is the similar behavior in UI if you're going to perform manual re-distribution across accounting periods).
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Solution: For "Manual: fixed amount" distribution. If the RS amount that you're redistributing has been allocated to all other accounting periods, populate the template with 0 for the accounting periods that will be zeroed out or input the delta value.
Example: Revenue schedule RS-1234 amount is 100 and it's been distributed from 2017-03 to 2018-03 accounting periods. Now if the goal is to just put the whole 100 revenue only in 2017-03, place 0 on the template for the rest of the accounting periods from 2017-04. (This is the similar behavior in UI if you're going to perform manual re-distribution across accounting periods).
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: How to redistribute revenue using Mass updater
Hello,
I am trying to utilize the mass updater to perform an update to revenue schedules. I keep recieving an error relating to the date header name. I have tried various different names/dates. Is anyone aware with the correct format for the column headers relating to the dates?
Thanks