Advanced Allocations

The ability to have any transaction allocated immediately upon posting to your detailed cost centers increases the value of your data for real-time financial analysis, as well as facilitating expenditure approvals and budget controls based on your responsibility center rules.



Navigator allows you to:

• Attach line allocation codes to any transaction in any functional area
• Review, approve and post allocated amounts in real-time
• Allow you to preview allocated amounts before posting
• Define batch allocations to perform complex period-end distributions
• Use budget, statistical, commitment, encumbrance and actual data
• Apply any timeframe for data extraction including average daily balance
• Derive percentages based on posted amounts and account dimensions
• Post results of batch allocations to journals or directly to GL

System-wide Line Allocations

Line allocation codes can be attached to any transaction in the system such as general journal entries, requisition lines, purchase order lines, invoice lines, payroll calculations. An entered amount is distributed based on the allocation specification and each resulting amount is evaluated for budget control and approval rules before posting. Line allocations allow you to pre-actively define how amounts should be approved and distributed, greatly improving the validity for your data for reporting and analysis.

Batch Allocations

Batch allocations are defined using a high-level instruction set to perform data extraction, manipulation and posting functions. Any data stored in the general ledger can be used as a source or basis for allocations and computed results can be reviewed by users before final posting back to the general ledger. The easy instruction set allows power accounting users to manage the allocation algorithms and implement powerful processes without depending on technical or external consulting resources.

Line Allocation MethodsLine allocations allow for the following calculation types:

1. Fixed Percentage - when percentages are known up-front
2. Derived Percentage - percentages are computed based on posted balances
3. Fixed Amount - where all amounts are known up-front
4. Combination - combines fixed amount and percentage allocations
5. Markup Percentage - generates a markup debit and credit automatically

Period Types Supported

• Year To Date
• Current Period
• Rest of Fiscal Year
• Entire Fiscal Year
• Beginning Balance
• Life To Date
• Average Daily Balance
• Life To Prior Period End

Batch Allocation Operations

• Source - extracts data from any GL transaction type
• Basis - extracts data and generates derived percentages for calculations
• Compute - performs various mathematical operations
• If - starts a conditional nest based on Source or Basis operations
• EndIf - end a conditional nest started by an If operation
• Target - generates information qualified for posting to the general ledger

Click here for Advanced Allocations pdf 

Executive's Corner: Follow CEO Steve Ballmer around the world as he continues to inspire companies to reach their full potential.