Import Actual Costs from GLD (tfcat2210m000)

Use this session to import actual costs from the General Ledger module by period.

Importing process

The History - Dimension/Ledger Account Combination Totals (tfgld105) table is imported and split into a fixed part and a variable part according to the planned variability.

Postings to the Contra Account for Cost Postings in GLD field are skipped.

Variable/fixed cost distribution

LN splits variable and fixed costs in the following way:

  • If the actual costs are equal to or greater than the budgeted fixed costs, the budgeted fixed costs are copied to the actual fixed costs, and the remaining costs are variable costs.
  • If the actual costs are less than the budgeted fixed costs, the budget variator is used to split the amount. If there is no budget for this dimension, LN checks if there is a budget at a higher sublevel in the dimension structure.

Cost distribution by reference unit

Costs can be distributed over the reference units in four different ways, according to the Distribution Base. For details, refer to Actual costs distribution

Field Information

Distribution Method

Defines how the actual costs are distributed over the reference units that are linked to the dimension.

Include Non-Finalized Transactions

If this check box is selected, not finalized transactions are also imported from the General Ledger module.

Amounts from statutory accounts

If this check box is selected, amounts from statutory accounts are imported from the General Ledger module as well.

Amounts from complementary accounts

If this check box is selected, amounts from complementary accounts are imported from the General Ledger module as well.

Overwrite

If this check box is selected, existing values in the Actual Costs by Reference Unit (tfcat210) and the Actual Costs by Dimension (tfcat211) table are overwritten.

If this check box is selected, a report with the imported amounts by ledger account is printed.