The table below shows the standard worksheet columns selected when records are posted to the cost ledger.
Record Type
|
Worksheet Column
|
Notes
|
A/P Payments (Asset Management)
|
Payments A/P (Tenant)
|
|
A/P Payment Batches (Asset Management)
|
Payments A/P (Tenant)
|
|
A/R Payments (Asset Management)
|
Payments A/R (Tenant)
|
|
A/R Payment Batches (Asset Management)
|
Payments A/R (Tenant)
|
|
A/P Payments (Cost Management)
|
Payments A/R
|
|
A/P Payment Batches (Cost Management)
|
Payments A/R
|
|
A/R Payments (Cost Management)
|
Payments A/P
|
|
A/R Payment Batches (Cost Management)
|
Payments A/P
|
|
Budgets - Transaction "A"
|
Original Owner Budget
|
Each Budget Record line is two lines in the Cost Ledger (Transaction "A" & "B")
|
Budgets - Transaction "B"
|
Original Project Budget
|
Each Budget Record line is two lines in the Cost Ledger (Transaction "A" & "B")
|
Budget Requests - Transaction "A"
|
Depends on selection
|
If Post as in Budget Request header is “Original Budget” the Worksheet column is "Original Owner Budget". If not it is "Owner Budget Changes"
|
Budget Requests - Transaction "B"
|
Depends on selection
|
If Post as in Budget Request header is “Original Budget” the Worksheet column is "Original Project Budget". If not it is "Project Budget Changes"
|
Change Events - Transaction "A"
|
Owner Budget Changes
|
From the budget lines of Change Events.
|
Change Events - Transaction "B"
|
Project Budget Changes
|
From the budget lines of Change Events.
|
Change Events - Commitment Lines
|
Commitment Changes
|
From the Commitment lines of Change Events.
|
Commitments
|
Original Commitments
|
|
Commitment COs
|
Commitment Changes
|
|
Contracts
|
Original Income
|
|
Contract COs
|
Income Changes
|
|
Requirements
|
Estimated Cost - Approved
|
|
Forecasts
|
Forecasts
|
Unlike other records, Forecasts only post when the Post button is clicked.
|
Journal Entries
|
Variable
|
The worksheet column can be selected on each line of a journal entry
|
Miscellaneous Invoices - Transaction "A"
|
Actual Costs - Non-commitment
|
|
Miscellaneous Invoices - Transaction "B"
|
Non-commitment Costs
|
Transaction "B" is only posted if Post to Non-commitment Costs is checked at the top of the Miscellaneous Invoice.
|
Production
|
Variable
|
If the record is linked to a commitment the worksheet column is Actual Costs - Commitment. If not it is Actual Costs - Non-commitment.
|
Progress Invoices
|
Actual Costs - Commitment
|
|
Requisitions
|
Actual Income
|
|
Tenant Invoices
|
Tenant Revenue
|
|
Timesheets - Transaction "A"
|
Actual Costs - Non-commitment
|
|
Timesheets - Transaction "B"
|
Non-commitment Costs
|
Transaction "B" is only posted if Post to Non-commitment Costs is checked at the top of the Timesheet
|
Work Orders
|
Tenant Cost
|
|