Friday Feature - Applying Undistributed Amounts
I am constantly copying requisitions and making multiple changes, like adding line items and changing accounts. As you could imagine, this can make account amounts get out of sync. Now, I could go in and change the percentages or the amounts for each account and put everything back in order. Or, you could use the always-handy Apply Undistributed Amount task. Check it out.
When you use this task in a Vendor Requisition, Department Requisition or Stores Requisition (the task became available in 17.01), the software sums the account amounts for the accounts that can be changed* and then uses the following equation for each account:
new amount = (old amount / sum of account amounts * undistributed amount) + old amount
If there is any undistributed amount left over (usually due to penny rounding), then the software adjusts the account with the largest amount.
Now, let's see this in action. Here is a requisition for a pizza party that I copied from the previous year. But, one of the school sites is not participating (highlighted). Now, I could delete the account and then do the math.
OR, I could delete the account for that location (Escape Online crosses out lines I delete, nice!) and use the Apply Undistributed Amount task. Basically, with two clicks of my mouse (and NO MATH), I can get this party started!
I think this is an amazing time-saver! If I had this pizza party every year or, better yet, every month, I would gleefully create those requisitions with a few clicks and then eat pizza, knowing that I did my job in the most efficient and accurate manner possible.
* Liability accounts and accounts from previous fiscal years cannot be changed. In addition, accounts that have a $0.00 amount will not be adjusted, unless all of the accounts are $0.00, then the last account on the list that is not a liability or from a previous fiscal year is adjusted.