Mass Allocation
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.
Use Mass Allocation batches to group your Mass Allocation 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 Mass Allocations in your functional currency, a foreign currency or statistical currency.
MassAllocations versus Recurring Journals
Creating MassAllocation Batches & Formulas
Navigate to the Define MassAllocations window, Enter a Name and description for the MassAllocation batch. Choose Actual or Encumbrance from the Balance Type poplist, for the types of balances to use in your mass allocation batch.
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.
To enter a MassAllocation formula:
1. Navigate to the Define MassAllocations window. Enter or query the name of the MassAllocation batch to which you want to add the formula. Choose Formulas. Enter the Name, Category, and Description of the MassAllocation formula. Categories help you group journal entries in a convenient
manner for reporting and analysis.
2. 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.
Note: 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.
3. 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.
4. Enter the formula lines and Save your work.
reverse allocation
can you take an allocation from a parent (multiple locations) and allocate it back to a single location. i.e the target and offset lines will not match. Target will be constant and offset will be looping.