MassAllocations

• Use a MassAllocation formula to create journals that allocate revenues and expenses across a group of cost centers, departments, divisions, and so on. By including parent values in allocation formulas, you can allocate to the child values referenced by the parent without having to enumerate each child separately. Hence, a single formula can perform
  multiple allocations.
• To define MassAllocation formulas, you create a MassAllocation batch that contains one or more MassAllocation formula entries. You can also copy an existing MassAllocation batch then modify it as needed for your new batch.
• Use MassAllocation batches to group your MassAllocation formulas. For example, you might combine all formulas for a single department or division into one batch, or group
  all formulas for certain types of calculations into separate entries.
• You can create MassAllocations in your functional currency, a foreign currency or statistical currency.

Creating MassAllocation Batches
Prerequisites
❑ Post journals to ensure that the existing balance for your allocation cost pool is current.

To create a MassAllocation batch:
1. Navigate to the Define MassAllocations window.
2. Enter a Name for the MassAllocation batch.
3. Choose Actual or Encumbrance from the Balance Type poplist, for the types of balances to use in your mass allocation batch.
4. Enter a Description for the MassAllocation batch.
5. Choose Formulas to enter MassAllocation formulas.
6. After entering the formulas, save your work.
7. Choose Validate All to validate the batch, as well as all previously unvalidated batches. If you do not validate all batches, General Ledger will ask if you want to validate all unvalidated batches when you close the Define Mass Allocations window.
8. Check the MassAllocation batch validation status.
9. Generate unposted journal batches from your MassAllocation formulas.

* You can generate your massallocations according to a shedule.

To copy an existing MassAllocation batch:
1. Navigate to the Define MassAllocations window.
2. Enter a Name for the new MassAllocation batch.
3. Choose the AutoCopy button, then choose the MassAllocation
batch that you want to copy.
4. Change the Balance Type as needed.
5. Enter a Description for the new MassAllocation batch.
6. Choose Formulas to modify the MassAllocation formulas that you
copied.
7. After modifying the formulas, save your work.
8. Choose Validate All to validate the batch.
9. Check the MassAllocation batch validation status.
10. Generate unposted journal batches from your MassAllocation formulas.

Creating MassAllocation Formulas

1. Navigate to the Define MassAllocations window.
2. Enter or query the name of the MassAllocation batch to which you want to add the formula.
3. Choose Formulas.
4. Enter the Name, Category, and Description of the MassAllocation
formula. Categories help you group journal entries in a convenient manner for reporting and analysis.
5. Choose whether to Allocate Balances From the full balance or from a single entered currency.
• If you choose Full Balance, General Ledger allocates your entire account balance, which is comprised of amounts entered in your functional currency, as well as amounts converted to your
functional currency from a foreign currency. The generated MassAllocation will be a functional currency journal entry.
• If you choose Single Entered Currency, General Ledger allocates the portion of your account balance entered in the Currency you specify. The generated MassAllocation will be a journal entry in the specified currency.
* If you choose a foreign currency with a fixed relationship to your functional currency, the conversion rate used to calculate the accounted amount will be the fixed conversion factor between the transaction and functional currencies. If you are allocating encumbrance balances, you must allocate the full balance. You cannot allocate foreign currency encumbrances.
6. Choose Full Cost Pool Allocation to have any rounding difference resulting from the MassAllocation computation added to the allocations with the largest relative balance. If you do not choose this option, any rounding differences will remain in the original
account.

7. Enter the formula lines.
8. Save your work.
9. Choose Validate All to validate the batch, as well as all previously unvalidated batches. If you do not validate all batches, General Ledger will ask if you want to validate all unvalidated batches when you close the window.
10. Check the MassAllocation batch validation status to confirm the batch passed validation.