Allocation Processor
Allocation Processor computes allocations based on the amounts or units of Project actual transactions. If the processing is set to Final, the transactions will post to the General Ledger and/or Project Ledger.
The Allocation Processor uses methods and rate tables for either estimated cost analysis (for example, an applied overhead percentage) or to mark up costs and create billing records to load into Invoice Suggestions. For more information see:
- Allocation Methods
- Allocation Rate Type
- Allocation Rate Table List
- Allocation Hierarchy List
- Allocation Key Definition List
Options
| Field Name | Description |
|---|---|
| Preliminary/Final |
Specifies whether the allocation Processor runs in Preliminary Mode or Final Mode. The program can be run in Preliminary Mode any number of times to review and verify that the correct transactions and rates are being applied. |
| Recalculation | Specifies whether the Allocation Processor runs in Normal Mode or in Recalculation Mode. If selected (true), the program reverses out the original allocation transactions for the specified date range and recalculates new postings. Typically, Recalculation Mode is used to correct transactions that were created by a previous final allocation process and that were incorrect due to the wrong Allocation Method or rates. New transactions that are created and reversals are both posted using the Allocation Posting Date. |
| Allocation Posting Date | Specifies the Posting Date to use on new and reversal allocation transactions created. |
Filter: Project
Filter: Project section allows you to run the Allocation Processor on a specific Project, or by Dimensions.
| Field Name | Description |
|---|---|
| No. |
Select a Project from the lookup list to filter by Project. |
| Dimension 1 | Select a Dimension Code value from the lookup list to filter by Dimension 1 Code value. |
| Dimension 2 | Select a Dimension Code value from the lookup list to filter by Dimension 2 Code value. |
| Filter Totals By | Select the + to view a list of other values that you can use as filters. |
Filter: Project (Job) Ledger Entry
| Field Name | Description |
|---|---|
| Posting Date |
Specifies the required Posting Date for the transactions generated by running the Allocation Processor. |
| Document Date | Optionally enter a document date to use as a filter when running the Allocation Processor. |
| Type | Optionally enter a Type (i.e., Resource, Item, G/L Account) to use as a filter when running the Allocation Processor. |
Allocation Results
Allocation Results Working
Run the Allocation Results Working page to view a listing of working or temporary allocation processor results. Select Open in Excel to review the results in an Excel spreadsheet format. Note that each time the allocation process is run, a new allocation batch is created for review.
Allocation Results Final
Run the Allocation Results Final page to view a listing of final Allocation Processor results. Select Open in Excel to review the results in an Excel spreadsheet format. ** The fields displayed in Allocation Results Working and Allocation Results Final are the same:
| Field Name | Description |
|---|---|
| Entry No. |
Specifies the system generated entry number of this transaction. |
| Project No. | Specifies the Project of the allocation transaction. |
| Project Task No. | Specifies the Project Task of the allocation transaction. |
| Post Cost Type | Specifies the Cost Type to be updated when the allocation transaction is created. Entering an % in any character position indicates a wildcard and the character from the source will be used. |
| Expense Payment Type | Specifies the Expense Payment Type used in the allocation transaction. For more information on Expense Payment Types, see: Expense Payment Types. |
| Allocation Batch No. | Specifies the unique number of the allocation process as generated from allocation batch auto number field in Project Setup. |
| Allocation Method | Specifies the allocation method that this step used. For more information on allocation methods, see: Project Cost Allocation - Allocation Methods. |
| Step | Specifies the step from the Allocation Method Detail for which this record is the result. |
| Calculation Type | Specifies the type of calculation to be performed on the data for the Cost Type specified for the step. For more information on Calculation Types, see: Allocation Method Detail FastTab |
| Direct Rate | Specifies the Direct rate used in calculating the allocation amount for this transaction. |
| Billing Rate | Specifies the Billing rate used in calculating the allocation amount for this transaction. |
| Basis Amount (LCY) | Specifies the basis amount for this transaction in local currency. |
| Allocation Amount | Specifies the calculated value of the allocation for this step. |
| Allocation Amount (LCY) | Specifies the calculated value of the allocation for this step in local currency. |
| Subtotal Allocation Amount | Specifies the subtotal of the allocation amount for this transaction. |
| Subtotal Allocation Amount (LCY) | Specifies the subtotal of the allocation amount for this transaction in local currency. |
| Billing Allocation Amount | Specifies the billing amount of the allocation for this transaction. |
| Billing Allocation Amount (LCY) | Specifies the billing amount of the allocation for this transaction in local currency. |
| Subtotal Billing Allocation Amount | Specifies the subtotal of the billing allocation amount for this transaction. |
| Subtotal Billing Allocation Amount (LCY) | Specifies the subtotal of the billing allocation amount for this transaction in local currency. |
| Allocation Chargeable | Specifies if the allocation transaction created should be chargeable or not. If selected, the allocation transaction is chargeable. |
| Apply to Rate | Specifies which rate(s) to which this Allocation Method step will apply. Options: |
| Both | |
| Direct Usage | |
| Billing. | |
| Currency Code | Specifies the Currency Code used. |
| Currency Factor | Specifies the Currency Factor. |
| Document Date | Specifies the Document Date for this transaction. |
| Posting Date | Specifies the Posting Date for this transaction. |
| GL Account | Specifies the General Ledger Account Number used in the allocation transaction. |
| GL Offset Account | Specifies the General Ledger Account Number used in the allocation offset transaction. |
| GL Dimensions Set | Specifies the General Ledger Dimensions Set used in this allocation transaction. |
| GL Offset Dimensions | Specifies the General Ledger Dimensions Set used in the allocation offset transaction. |
| Post Entry No. | Specifies the Entry Number of the posted allocation transaction. |
| Source Register No. | Specifies the Register Number of the Source Transaction. |
| Source Entry No. | Specifies the Entry Number from the Project Ledger of the Source Transaction. |
| Source Amount | Specifies the amount of the Source Transaction. |
| Source Amount (LCY) | Specifies the amount in local currency of the Source Transaction. |
| Source Comment | Specifies the Source Transaction description. |
| Source Posting Date | Specifies the Source Transaction Posting Date. |
| Source Resource Group | Specifies the Source Transaction Resource Group. |
| Source Resource | Specifies the Resource used in the Source Transaction. |
| Source Task | Specifies the Source Transaction task. |
| Allocation Rate | Specifies the rate used in calculating this allocation transaction. |
| Source Cost Type | Specifies the Cost Type of the Source Transaction. |
| Source Document Date | Specifies the document date of the Source Transaction. |
| Source Project | Specifies the Project of the Source Transaction. |
| Source Quantity | Specifies the quantity of the Source Transaction. |
| Source UOM | Specifies the Unit of Measure (UOM) of the Source Transaction. |
| Reversed | Specifies if this allocation has been reversed. |
| Post Units | Specifies the Post Units of the Source Transaction. |
Allocation Logs
When you run the Allocation Processor in Preliminary or Final mode, you can review a log page which lists each allocation batch where details are provided on failed or skipped steps in the Allocation Method used with Allocation Processor. To access the logs:
Use the Search feature and enter: Allocation Log List.
Select the Allocation Batch No. that pertains to the processing run you want to view.
Select View > Manage from the ribbon to open the Allocation Log Card.
Select Export to Excel to view the results in Excel format or select Open Results to view the results in the Allocation Working List page.