Print manual  

 NCCA Cost Accounting


Cost Accounting - up to 8 dimensions, allocations with many variants, comprehensive evaluations.
Current Version: 21.2.3.0 as of Business Central 21. For older BC versions, downgrades are available.

Manual


Creation date: 2024/04/20
The current version of this manual can be found at:

https://www.navax.app/help.php?AppID=NCCA&L=en


☰ Contents



General

  • NCCA Cost Accounting
    NCCA Cost Accounting adds a cost accounting module to Microsoft Dynamics 365 Business Central that has its own data model...
  • Role Center Integration
    NCCA Cost Accounting menu bar is integrated in the Finance, Accountant and Accounting Manager roles...

Setup

  • Cost Accounting Setup
    Before NCCA Cost Accounting can be used, its basic functionality must be set up...
  • Cost Dimension Setup
    The Cost Type and the Cost Dimensions are managed or created via the in the Cost Dimension Setup area...
  • Create/Update Cost Types
    The Cost Types can be created and/or updated based on the G/L Accounts with the Create/Update action in the Cost Dimension Setup area of the ...
  • Create/Update Cost Dimension Values
    The Cost Dimension Values can be created and/or updated based on the Related Dimension with the Create/Update action in the Cost Dimension Setup area of the ...
  • Create/Update Related Dimension Values
    The Dimension Values can be created and/or updated based on the Cost Dimension with the Create/Update Related Dimension action in the Cost Dimension Setup area of the ...
  • Cost Dimension Translations
    The NCCA Cost Dimension Translations page can be used to set up translations for the different display languages of the users...
  • Source Codes
    The source codes for the NCCA Cost Accounting are set up in the Source Code Setup page...

Chart of Cost Types & Chart of Cost Dimensions

  • Chart of Cost Types & Chart of Cost Dimensions
    The Chart of Cost Types and the different Chart of Cost Dimensions are the core of the NCCA Cost Accounting. Define indentation levels for a structured overview of your Cost Types and Cost Dimensions...
  • Unit of Measures
    In NCCA Cost Accounting, each Cost Type can be assigned a Unit of Measure Code...
  • Work Types
    Work Types can be used optionally or additionally in NCCA Cost Accounting...
  • Cost Dimension Groups
    The NCCA Cost Dimension Groups page can be used to set up groups for the cost type values or the cost dimension values...

Entry Transfer

  • G/L Entry Transfer
    In order for G/L Entries to be transferred to Cost Entries, the Starting Date G/L Entry Transfer field must first be set in the Cost Accounting Setup...
  • Calculatory FA Entry Transfer
    In order for FA Entries to be transferred to Cost Entries, the Depreciation Book Code field and the Starting Date Calc. FA Entry Transfer field must first be set in the Cost Accounting Setup...
  • Transfer Errors
    Via the NCCA G/L Entry Transfer Errors and NCCA Calc. FA Entry Transfer Errors page you can edit the transfer errors that occurred when transferring the G/L Entries and the FA Entries to NCCA Cost Accounting. Both pages are identical except for the fields for G/L Accounts and Fixed Assets. The screenshots below show the G/L Entry Transfer Errors...
  • Reverse Transfer
    When G/L Entries or FA Entries are transferred to Cost Accounting, an entry is automatically created in the NCCA Cost Register. Via the action Reverse Cost Register the transfer can be reversed...
  • Cost Type as Dimension (G/L)
    Basically, when transferring entries, the cost type is determined via the G/L Account No. of the G/L Entry or via the FA Posting Group from the FA Depreciation Book of the FA Entry...

Journals

  • General

    • Journal Templates & Journal Batches
  • Costs

    • Cost Journals
      In the Cost Journals you can post Amounts and/or Quantities to Cost Types and Cost Dimensions...
    • Import Cost Journal
      In the Cost Journal, journal lines can be imported from a file (action Import from File) or from an Excel file (action Import from Excel)...
  • Service Allocations

    • Service Allocation Prices
      The NCCA Service Allocation Prices page can be used to specify prices for the Service Allocation or for the pricing in the journals...
    • Service Allocation Journals
      Service Allocation Journals are optimized for recording and posting service allocations. You can credit any Cost Dimension using a Cost Type and thus debit any Cost Dimension using a Cost Type...
    • Import Service Allocation Journal
      In the Service Allocation Journal, journal lines can be imported from a file (action Import from File) or from an Excel file (action Import from Excel)...
  • Allocations

    • Allocation Journals
      The Allocation Journals are a powerful tool for setting up your allocations. For example, you can credit a base using a (specially created) allocation cost type and thus debit a large number of cost dimensions based on variable reference values. Topics such as iteration, consideration in subsequent allocations or a preview of calculation details are also supported...
    • Allocation Distribution
      In the Allocation Distribution area, the debit is specified...
    • Calculation Details
      More information will follow soon...
  • Extended

    • Posting Preview
      The Posting Preview shows a preview of all entries that will be created when posting the journal...
    • Cost Registers
      The NCCA Cost Registers page displays the history of all postings...
    • Cost Entries
      The NCCA Cost Entries page displays the history of all postings in the NCCA Cost Accounting...
    • Reversal
      More information will follow soon...

Budget

  • General

    • Cost Budgets
      More information will follow soon...
    • Cost Budget Entries
      More information will follow soon...
  • Journals

    • Cost Budget Journals
      More information will follow soon...
    • Import Cost Budget Journal
      In the Cost Budget Journal, journal lines can be imported from a file (action Import from File) or from an Excel file (action Import from Excel)...
  • Extended

    • Cost Budget Registers
      The NCCA Cost Budget Registers page displays the history of all budget postings...

Reports and Analysis

  • Edit Evaluations

    • Edit Evaluation
      In NCCA Cost Accounting, Evaluations and the Ad Hoc Evaluation are available...
    • Line Definition
      Here you can set up the lines of the evaluation...
    • Column Definition
      Here you can set up the columns of the evaluation...
    • Line Controlled Column Type
      By default, the individual columns of the of an evaluation determine which values are calculated. For example, for columns of type Amount, the amount is calculated for each line of the Line Definition, and for column type Quantity, the quantity is calculated...
    • Date Filter IDs
      For date filters, IDs (placeholders) can be specified in square brackets [ ] that will be calculated and replaced based on the Date Filter Calculation Date when the evaluation is executed...
    • Copy Evaluation
      Via this action, a copy of the evaluation can be created...
  • Execute Evaluations

    • Execute Evaluation
      Via the actions Execute, Show Matrix, Print and Export to Excel an evaluation can be executed...
    • Archive Evaluation
      Via this action, an evaluation can be archived. This will execute calculate the evaluation and save the result in the archive. The action is not available for ad hoc evaluations...
    • Evaluation Archive
      The NCCA Evaluation Archive page shows an overview of all archive entries of the evaluation and can be accessed directly from the evaluation...

Appendix

  • Date Compression
    You can compress data in Business Central to save space in the database, which in Business Central online can even save you money. The compression is based on dates and works by combining several old entries into one new entry...
  • Reset Cost Accounting Data
    The Reset Data action in the NCCA Cost Accounting Setup can be used to reset the NCCA Cost Accounting data...
  • NAVAX License Management
    The NAVAX License Management page (in older versions NAVAX License Overview or NCEX License Overview) displays the current license status of the NAVAX extensions...
  • Installation Notes
  • Release Notes

Docs  /  NCCA Cost Accounting  /  General
NCCA Cost Accounting

NCCA Cost Accounting adds a cost accounting module to Microsoft Dynamics 365 Business Central that has its own data model. The data model, which supports up to 8 dimensions, can be filled with data from the general ledger, but also from other sources. The allocation area supports almost all imaginable variants, such as imputed costs, iteration procedure, different distribution types based on fixed ratios, amounts or quantities. Comprehensive evaluations can be displayed as a matrix, printed out, archived or exported to Excel.

Navigation

NCCA Cost Accounting is integrated in the Finance, Accountant and Accounting Manager roles. For more information, see General, Role Center Integration. Fields, actions, pages and reports originating from the NCCA Cost Accounting extension are identified by the abbreviation NCCA. This additional labeling makes them clearly distinguishable from the Dynamics 365 Business Central Standard Cost Accounting module and other extensions (which may use similar names and designations). The search terms "ncca", "nvxca" and "navax" are also recognized by "Tell me what you want to do". This allows very fast access to the individual areas of the NCCA Cost Accounting. NCCA stands for NAVAX Consulting Cost Accounting.

Permission Sets

The following permission sets are available for the NCCA Cost Accounting:
NameDescription
NCCANCCA Cost Accounting You need these permissions to use the NCCA Cost Accounting.
NCCA, SETUPNCCA Cost Accounting Setup You need these permissions to set up the NCCA Cost Accounting. For more information, see Setup, Cost Accounting Setup.

Installation Notes

For more information, see Appendix, Installation Notes.

Docs  /  NCCA Cost Accounting  /  General
Role Center Integration

NCCA Cost Accounting menu bar is integrated in the Finance, Accountant and Accounting Manager roles. All functions of NCCA Cost Accounting can be accessed via this menu bar.

Cues

In addition, the following cues (status tiles) are available:

Transfer Errors

G/L Entry TransferSpecifies the number of errors that occurred when transferring the G/L Entries to NCCA Cost Accounting. For more information, see Entry Transfer, Transfer Errors.
Calc. FA Entry TransferSpecifies the number of errors that occurred when transferring the FA Entries to NCCA Cost Accounting. For more information, see Entry Transfer, Transfer Errors.

Docs  /  NCCA Cost Accounting  /  Setup
Cost Accounting Setup

Before NCCA Cost Accounting can be used, its basic functionality must be set up. In the NCCA Cost Accounting Setup page, the general settings and defaults are defined.

General, Fields

Allow Posting FromSpecifies the earliest date on which posting in NCCA Cost Accounting is allowed.
Allow Posting ToSpecifies the last date on which posting in NCCA Cost Accounting is allowed.
Allow Deletion BeforeSpecifies whether cost types can be deleted if there are already entries for the cost type. Cost types with entries on or after this date cannot be deleted. Deleting a Cost Type:
  • There must be no cost entry and no cost budget entry for the cost type that is on or after the Allow Deletion Before date.
  • Note

    Unlike deleting a G/L Account in general ledger, the balance of the cost type does not have to be 0 when deleting. When deleting a cost type, the cost type field is deleted for all related cost entries. So the cost entries are not deleted directly. To ensure that the cost entries are no longer included in any evaluations, all values of the cost dimension fields 1 to 8 in the cost entries are also deleted when a cost type is deleted. The cost budget entries of the cost type are completely deleted when a cost type is deleted.
Deleting a Cost Dimension:
  • There must be no cost entry or cost budget entry for the cost dimension. A cost dimension can therefore only be deleted if all cost types with which the cost dimension was posted together have been deleted first.
Posting Rule Cost Dimension 1 and 2Specifies which combination of cost dimension 1 and 2 is allowed when posting.
Default Net Change Date FilterSpecifies a filter that will be suggested in the Chart of Cost Dimensions. It is possible to specify IDs (placeholders) in the filter that will be calculated and replaced based on the Work Date. A list of Date Filter ID examples can be opened via the lookup of the field. For more information, see Reports and Analysis, Edit Evaluations, Date Filter IDs.

Cost Dimension Setup

In the Cost Dimension Setup area, the Cost Type and the Cost Dimensions are created or managed. For more information, see Setup, Cost Dimension Setup.

Entry Transfer, G/L Entries, Fields

In the Entry Transfer, G/L Entries section, the settings for the G/L Entry Transfer are specified.
Starting Date G/L Entry TransferSpecifies the earliest posting date on which G/L Entries can be transferred to the NCCA Cost Accounting.
Cumulate G/L EntriesSpecifies whether G/L Entries should be transferred to the NCCA Cost Accounting individually or cumulated (one entry per day, month, quarter or year) by the manual G/L Entry Transfer.
Automatic G/L Entry TransferSpecifies whether the NCCA Cost Accounting should be updated on each posting in the general ledger.

Entry Transfer, FA Ledger Entries, Fields

In the Entry Transfer, FA Ledger Entries section, the settings for the Calculatory FA Entry Transfer are specified.
Depreciation Book CodeSpecifies the Depreciation Book with which the FA Entries must be posted in order to be transferred.
FA Posting TypesSpecifies which FA Posting Types should be transferred by the calculatory FA Entry Transfer. Regardless of the selected setting in the field, FA Entries with the following FA Posting Types are always considered by the transfer:
  • Depreciation
  • Write-Down
  • Custom 1
  • Custom 2
If the Depreciation & Book Value on Disposal (Gross Calculation) option is set up, FA Entries with the following FA Posting Type are also considered:
  • Book Value on Disposal
If the Depreciation & Gain/Loss (Net Calculation) option is set up, FA Entries with the following FA Posting Type are also considered:
  • Gain/Loss
For an FA Entry to be transferred, the FA Posting Category field must be empty for FA Posting Type Depreciation, Write-Down, Custom 1 and Custom 2. For FA Posting Type Book Value on Disposal or Gain/Loss the value of the FA Posting Category does not matter.
Starting Date Calc. FA Entry TransferSpecifies the earliest posting date on which FA Entries can be transferred to the NCCA Cost Accounting.
Cumulate FA EntriesSpecifies whether FA Entries should be transferred to the NCCA Cost Accounting individually or cumulated (one entry per day, month, quarter or year) by the manual calculatory FA Entry Transfer.
Automatic Calc. FA Entry TransferSpecifies whether the NCCA Cost Accounting should be updated on each posting.

Evaluations, Fields

In the Evaluations section, general settings for the Evaluations are defined.
Column Warning LevelSpecifies the number of columns from which a warning should be displayed when creating an evaluation. If the field is empty, a warning is displayed if the evaluation generates more than 25 columns.
Column LimitSpecifies the maximum number of columns that evaluations are allowed to generate. If the field is empty, no limit exists.

Setup, Actions

  • Source Codes

    View or set up the Source Codes. If not all Source Codes of the NCCA Cost Accounting are set up yet, a message is displayed when the action is called and they can be initialized with default values. The Codes and their Descriptions are created either in German or in English, depending on your current display language. For more information, see Setup, Source Codes.
  • NCCA Journal Templates

    View or set up the NCCA Journal Templates. If no NCCA Journal Templates have been created yet, a message is displayed when the action is called and they can be initialized with default values. The Source Codes are also assigned in the templates if they are already set up for NCCA Cost Accounting. The Names and their Descriptions are created either in German or in English, depending on your current display language. For more information, see Journals, General, Journal Templates & Journal Batches.
  • Work Types

    View or set up the Work Types. For each Work Type a Credit/Debit Cost Type can be specified that will be proposed in the Service Allocation Journal when entering the Work Type. For more information, see Chart of Cost Types & Chart of Cost Dimensions, Work Types.
  • Service Allocation Prices

    View or set up the Service Allocation Prices. The Service Allocation Prices are based on Cost Dimension 1. For more information, see Journals, Service Allocations, Service Allocation Prices.
  • FA Posting Groups

    View or set up the FA Posting Groups. For each FA Posting Group, Cost Types can be specified that will be used by the calculatory FA Entry Transfer. For more information, see Entry Transfer, Calculatory FA Entry Transfer.

System, Actions

Docs  /  NCCA Cost Accounting  /  Setup
Cost Dimension Setup

The Cost Type and the Cost Dimensions are managed or created via the Cost Accounting Setup in the Cost Dimension Setup area. Up to 8 Cost Dimensions can be set up completely freely. It does not matter if cost dimensions are omitted in between. Cost Dimensions can be related or linked to the dimensions of general ledger. However, it is also possible to define cost dimensions that exist only in NCCA Cost Accounting. Through custom programming, it would also be possible for certain cost dimensions to be linked to or managed by other sources.

Fields

Cost DimensionSpecifies the Cost Dimension.

Note

The Service Allocation Prices (as is the Service Allocation) are based on Cost Dimension 1. Thus, the Cost Dimension 1 or the Credit Cost Dimension 1 is used for pricing in the journals. For more information, see Journals, Service Allocations, Service Allocation Prices.
Related Dimension (G/L)Specifies whether the cost dimension is related to a general ledger dimension and if so, which dimension. Setting up a related dimension for the cost type is possible at any time, regardless of whether NCCA Cost Entries already exist or not. All required cost types must also be created as Dimension Value Codes. The dimension value codes of the dimension can be created manually or via the action Create/Update Related Dimension from the already existing cost types. For more information, see Entry Transfer, Cost Type as Dimension (G/L).
No. of Dimension ValuesDisplays how many Values the Related Dimension has.
Cost Dimension CaptionSpecifies the caption of the Cost Dimension. The field must be specified so that the cost dimension is active and can be used in NCCA Cost Accounting.
No. of Cost Dimension ValuesDisplays how many Values the Cost Dimension has. The Create/Update action can be used to create and/or update the Cost Types based on the G/L Accounts. The other Cost Dimensions can also be created and/or updated via the action, based on the Dimension Values of the Related Dimension. For more information, see Setup, Create/Update Cost Types and Setup, Create/Update Cost Dimension Values.
Create/Update AutomaticallySpecifies whether the Cost Dimension Values and/or the Dimension Values of the Related Dimension should be created and/or updated automatically when changes are made.
  • " " specifies that neither the cost dimension values, nor the values of the related dimension should be updated automatically.
  • Cost Dimension specifies that changes in the values of the related dimension affect the cost dimension values but not vice versa.
  • Related Dimension specifies that changes in the cost dimension values affect the values of the related dimension but not vice versa.
  • Both Directions specifies that changes in the cost dimension values affect the values of the related dimension and vice versa.
Posting RuleSpecifies whether the cost dimension is mandatory and must be specified when posting. If no specification is selected, the specification of the cost dimension when posting is optional.
Code CaptionSpecifies the caption for the Code fields of the Cost Dimension.
Filter CaptionSpecifies the caption for the Filter fields of the Cost Dimension.
Name CaptionSpecifies the caption for the Name fields of the Cost Dimension.
DescriptionSpecifies a description of the Cost Dimension.

Actions

Docs  /  NCCA Cost Accounting  /  Setup
Create/Update Cost Types

The Cost Types can be created and/or updated based on the G/L Accounts with the Create/Update action in the Cost Dimension Setup area of the Cost Accounting Setup. This will open the Create/Update Cost Types page.

Fields

G/L Account No.Specifies the number of the G/L Account.
G/L Account NameSpecifies the name of the G/L Account.
Type of G/L AccountSpecifies the purpose of the G/L Account.
Income/BalanceSpecifies whether the G/L Account is an income statement account or a balance sheet account.
SynchronizationSpecifies whether the G/L Account should be considered by the creation/update or not (Synchronization Exception). Click the field to create or remove an exception for the G/L Account.
Cost Type CodeSpecifies the Cost Type that is assigned to the G/L Account.
Cost Type NameSpecifies the name of the Cost Type.
Type of Cost TypeSpecifies the purpose of the Cost Type.
Cumulate G/L EntriesSpecifies whether G/L Entries for the G/L Account should be transferred to the NCCA Cost Accounting individually or cumulated (one entry per day, month, quarter or year) by the manual G/L Entry Transfer. For more information, see Entry Transfer, G/L Entry Transfer.

How are Cost Type and G/L Account linked?

Each G/L Account can be assigned a Cost Type using the NCCA Cost Type Code field on the G/L Account Card. The assignment is basically done automatically via the Create action, but can also be done manually or changed manually. I.e. each G/L Account can only have one Cost Type assigned to it. The other way round, a Cost Type can be assigned to several G/L Accounts.

Which fields are transferred or updated?

  • No. resp. Code
  • Name
  • Search Name
  • Blocked
  • Account Type resp. Type
  • Totaling
  • Indentation

Actions

  • Create

    Creates a Cost Type for the selected Lines based on the G/L Account.

    Options

    No. of selected G/L AccountsSpecifies the number of the selected G/L Accounts that are considered by the action.
    Length of new Cost TypesSpecifies how many digits the codes of new Cost Types should have (without Prefix). The specification is optional. The code is either truncated, or extended by 0 if the length of the code differs from the length of the G/L Account number. In case of a reduction, only G/L Accounts with Account Type Posting will be considered.
    Cost Type PrefixSpecifies a value that precedes the codes of new Cost Types. The specification is optional.
  • Update

    Updates the Cost Type for the selected Lines based on the G/L Account.
  • Create Exception

    Creates a Synchronization Exception for the G/L Account of the selected Lines. G/L Accounts for which an exception exists are not created/updated.
  • Remove Exception

    Removes the Synchronization Exception for the G/L Account of the selected Lines.
  • G/L Account Card

    View or edit detailed information for the G/L Account.
  • Cost Type Card

    View or edit detailed information for the Cost Type.

G/L Account Card

On the G/L Account Card page, the cost type assignment can be found in the NCCA Cost Accounting group.

G/L Account Card, Fields

NCCA Cost Type CodeSpecifies the Cost Type that is assigned to the G/L Account.
NCCA Cost Type NameSpecifies the name of the Cost Type.
Type of NCCA Cost TypeSpecifies the purpose of the Cost Type.
NCCA Cumulate G/L EntriesSpecifies whether G/L Entries for the G/L Account should be transferred to the NCCA Cost Accounting individually or cumulated (one entry per day, month, quarter or year) by the manual G/L Entry Transfer.
NCCA SynchronizationSpecifies whether the G/L Account should be considered by the creation/update or not (Synchronization Exception).

Docs  /  NCCA Cost Accounting  /  Setup
Create/Update Cost Dimension Values

The Cost Dimension Values can be created and/or updated based on the Related Dimension with the Create/Update action in the Cost Dimension Setup area of the Cost Accounting Setup. This will open the Create/Update Cost Dimension Values page.

Fields

Dimension Value CodeSpecifies the code of the dimension value.
Dimension Value NameSpecifies the name of the dimension value.
Type of Dimension ValueSpecifies the purpose of the dimension value.
SynchronizationSpecifies whether the Code should be considered by the creation/update or not (Synchronization Exception). Click the field to create or remove an exception for the code.
Cost Dimension Value ExistsSpecifies if there is a cost dimension value for the dimension value.
Cost Dimension Value NameSpecifies the name of the cost dimension value.
Type of Cost Dimension ValueSpecifies the purpose of the cost dimension value.

How are Dimension and Cost Dimension linked?

Dimension Values and Cost Dimension Values with the same Code are automatically linked.

Which fields are transferred or updated?

  • Code
  • Name
  • Blocked
  • Type of Dimension Value resp. Type
  • Totaling
  • Indentation

Actions

  • Create

    Creates a Cost Dimension Value for the selected Lines based on the Dimension Value.
  • Update

    Updates the Cost Dimension Value for the selected Lines based on the Dimension Value.
  • Create Exception

    Creates a Synchronization Exception for the Code of the selected Lines. Codes for which an exception exists are not created/updated.
  • Remove Exception

    Removes the Synchronization Exception for the Code of the selected Lines.
  • Cost Dimension Value Card

    View or edit detailed information for the Cost Dimension Value.

Docs  /  NCCA Cost Accounting  /  Setup
Create/Update Related Dimension Values

The Dimension Values can be created and/or updated based on the Cost Dimension with the Create/Update Related Dimension action in the Cost Dimension Setup area of the Cost Accounting Setup. This will open the Create/Update Related Dimension Values page.

Fields

Cost Dimension Value CodeSpecifies the code of the cost dimension value.
Cost Dimension Value NameSpecifies the name of the cost dimension value.
Type of Cost Dimension ValueSpecifies the purpose of the cost dimension value.
SynchronizationSpecifies whether the Code should be considered by the creation/update or not (Synchronization Exception). Click the field to create or remove an exception for the code.
Dimension Value ExistsSpecifies if there is a dimension value for the cost dimension value.
Dimension Value NameSpecifies the name of the dimension value.
Type of Dimension ValueSpecifies the purpose of the dimension value.

How are Cost Dimension and Dimension linked?

Cost Dimension Values and Dimension Values with the same Code are automatically linked.

Which fields are transferred or updated?

  • Code
  • Name
  • Blocked
  • Type resp. Type of Dimension Value
  • Totaling
  • Indentation

Actions

  • Create

    Creates a Dimension Value for the selected Lines based on the Cost Dimension Value.
  • Update

    Updates the Dimension Value for the selected Lines based on the Cost Dimension Value.
  • Create Exception

    Creates a Synchronization Exception for the Code of the selected Lines. Codes for which an exception exists are not created/updated.
  • Remove Exception

    Removes the Synchronization Exception for the Code of the selected Lines.
  • Cost Dimension Value Card

    View or edit detailed information for the Cost Dimension Value.

Docs  /  NCCA Cost Accounting  /  Setup
Cost Dimension Translations

The NCCA Cost Dimension Translations page can be used to set up translations for the different display languages of the users. Basically, the code, filter and name fields of the cost dimensions are displayed to the user with the captions that are specified in the Cost Dimension Setup. If different captions are required for certain display languages, they can be set up here.

Fields

Language IDSpecifies a language code.
Language NameSpecifies the name of the language.
CaptionSpecifies the caption of the Cost Dimension.
Code CaptionSpecifies the caption for the Code fields of the Cost Dimension.
Filter CaptionSpecifies the caption for the Filter fields of the Cost Dimension.
Name CaptionSpecifies the caption for the Name fields of the Cost Dimension.

Docs  /  NCCA Cost Accounting  /  Setup
Source Codes

The source codes for the NCCA Cost Accounting are set up in the Source Code Setup page. All relevant codes can be found in the NCCA Cost Accounting group.

Note

The codes in the NCCA Cost Accounting group can also be initialized with default values. To do this, the page must be opened via the Source Codes action from the NCCA Cost Accounting Setup. For more information, see Setup, Cost Accounting Setup.

Fields

NCCA G/L Entry TransferSpecifies the code assigned to entries that are posted from the G/L Entry Transfer. Default value: CAGLTRAN
NCCA Calc. FA Entry TransferSpecifies the code assigned to entries that are posted from the calculatory FA Entry Transfer. Default value: CAFATRAN
NCCA Cost Jnl.Specifies the code assigned to entries that are posted from a cost journal. Default value: CACOSTJNL
NCCA Service Allocation Jnl.Specifies the code assigned to entries that are posted from a service allocation journal. Default value: CASERVJNL
NCCA Allocation Jnl.Specifies the code assigned to entries that are posted from a allocation journal. Default value: CAALLOCJNL
NCCA ReversalSpecifies the code assigned to entries that are posted when reversing cost entries. Default value: CAREVERSE
NCCA Compress EntriesSpecifies the code assigned to entries that are posted by the date compression. Default value: CACOMPR

Docs  /  NCCA Cost Accounting  /  Chart of Cost Types & Chart of Cost Dimensions
Chart of Cost Types & Chart of Cost Dimensions

The Chart of Cost Types and the different Chart of Cost Dimensions are the core of the NCCA Cost Accounting. Define indentation levels for a structured overview of your Cost Types and Cost Dimensions. Basically, both pages are structured identically, with a few exceptions. The screenshots shown here mostly show the Chart of Cost Types.

Fields

CodeSpecifies the code for the cost dimension value.
NameSpecifies a descriptive name for the code dimension value.
CommentsSpecifies if there are comments for the cost dimension value. Click on the field to view or edit the comments.
Direct PostingSpecifies whether you will be able to post directly or only indirectly to this cost dimension value.
Net ChangeSpecifies the total during the time period in the Net Change Date Filter field.

Note

The Net Change Date Filter can be suggested via the Default Net Change Date Filter field in the NCCA Cost Accounting Setup. For more information, see Setup, Cost Accounting Setup.
BalanceSpecifies the total during the time period in the Balance Date Filter field.

Note

Since there is no year-end closing in NCCA Cost Accounting, there is a separate date filter for calculating the balance. By default, the Balance Date Filter is set to the fiscal year from the work date.
Budgeted AmountSpecifies either the code dimension value's total budget or, if you have specified a name in the Budget Name field, a specific budget.
BlockedSpecifies that the cost dimension value is blocked from being posted in transactions.
TypeSpecifies the purpose of the cost dimension value.
  • Standard specifies that no sums are to be formed here.
  • Heading specifies that the value is only used to improve the readability of the Chart of Cost Dimensions.
  • Total specifies that different values are added here, which are specified in the Totaling field.
  • Begin-Total specifies that a series of values to be totaled starts from here, ending with End-Total.
  • End-Total specifies that the sum of the series of values to be totaled, starting with Begin-Total, is displayed here. Use the Indent Values action to update the Totaling field for End-Total.
TotalingSpecifies an cost dimension value interval or a list of cost dimension values. The entries of the cost dimension value will be totaled to give a total balance. How entries are totaled depends on the value in the Type field.
Unit of Measure CodeSpecifies the Unit of Measure Code of the Cost Type. The field is only displayed in the Chart of Cost Types and is only available for cost types. For more information, see Chart of Cost Types & Chart of Cost Dimensions, Unit of Measures.
G/L Entry Transfer incl. QuantitiesSpecifies whether the Entry Transfer should also transfer the quantities from the G/L Entries. The field can only be set if a Unit of Measure Code is specified for the cost type. The field is only displayed in the Chart of Cost Types and is only available for cost types. For more information, see Entry Transfer, G/L Entry Transfer.
FA Entry Transfer incl. QuantitiesSpecifies whether the Entry Transfer should also transfer the quantities from the FA Entries. The field can only be set if a Unit of Measure Code is specified for the cost type. The field is only displayed in the Chart of Cost Types and is only available for cost types. For more information, see Entry Transfer, Calculatory FA Entry Transfer.
Service Allocation Prices ExistsSpecifies if there are Service Allocation Prices for the cost dimension value. Click on the field to view or edit the prices. The field is only displayed in the Chart of Cost Dimensions of cost dimension 1 and is only available for cost dimension 1. For more information, see Journals, Service Allocations, Service Allocation Prices.
No. of Related G/L AccountsSpecifies if there are G/L Accounts that are related to the Cost Type. The field available only for cost types.
Dimension Value ExistsSpecifies if there is a dimension value for the cost dimension value. The field is available only for cost dimensions.
Search NameSpecifies an alternate name that you can use to search for the record in question when you cannot remember the value in the Name field.
Last Date ModifiedSpecifies when the cost dimension value was last modified.
Group 1 to 8Specifies groups for the cost dimension value. The group assignments can be used for evaluations. For more information, see Chart of Cost Types & Chart of Cost Dimensions, Cost Dimension Groups.

Actions

  • Entries

    View the history of transactions that have been posted for the selected record.
  • Budget Entries

    View the cost budget entries for the selected record.
  • Open

    Opens another Chart of Cost Dimensions for a selected Cost Dimension. The action is also available in the FactBox pane.
  • Open with Filters

    Opens another Chart of Cost Dimensions for a selected Cost Dimension and applies the filters set in the current page. The action is also available in the FactBox pane. Example A filter has been set to 40* for the cost types in the Chart of Cost Types: If the Chart of Cost Dimensions for the Departments is now called up via the action Open with Filters, the filters set in the Chart of Cost Types are also set in the Chart of Cost Dimensions of the Departments:
  • Create new Evaluation

    Creates an evaluation based on the currently displayed (filtered) values. For more information, see Reports and Analysis, Edit Evaluations, Edit Evaluation.
  • Open Ad Hoc Evaluation

    Opens the ad hoc evaluation with the currently displayed (filtered) values. For more information, see Reports and Analysis, Edit Evaluations, Edit Evaluation.
  • Indent Values

    Indent cost dimension values between a Begin-Total and the matching End-Total one level to make the chart of cost dimensions easier to read. The Totaling field for each End-Total will also be updated.
  • Reset Date Filter

    Resets the Net Change Date Filter and the Balance Date Filter to the default value.
  • Service Allocation Prices

    View or set up the Service Allocation Prices. The Service Allocation Prices are based on Cost Dimension 1. For more information, see Journals, Service Allocations, Service Allocation Prices.
  • Groups

    View or set up the Cost Dimension Groups for the Cost Dimension. Groups can be assigned to the individual cost dimension values and used for evaluations. For more information, see Chart of Cost Types & Chart of Cost Dimensions, Cost Dimension Groups.
  • Print

    Prepare to print the Chart of Cost Dimensions. A report request window opens where you can specify what to include on the print-out.

FactBoxes

  • Chart of Cost Dimensions

    Additional Chart of Cost Dimensions can be opened via the Chart of Cost Dimensions FactBox. The functionality is identical to the two actions Open and Open with Filters.
  • Evaluations

    Evaluations with the Add to FactBox pane field set can be executed directly from the Chart of Cost Dimensions via the Evaluations FactBox. For more information, see Reports and Analysis, Execute Evaluations, Execute Evaluation.

Docs  /  NCCA Cost Accounting  /  Chart of Cost Types & Chart of Cost Dimensions
Unit of Measures

In NCCA Cost Accounting, each Cost Type can be assigned a Unit of Measure Code.

Note

Quantities can only be posted in combination with a Unit of Measure Code.

Changing the Unit of Measure Code

The Unit of Measure Code of a Cost Type can be changed only under the following conditions:
  • If no Unit of Measure Code is specified for the Cost Type, the Unit of Measure Code of the Cost Type can be changed, regardless of whether entries already exist for the Cost Type or not. Any existing entries are not relevant in this case, as they were posted without a Unit of Measure Code, thus ensuring that no quantities were specified either.
  • If a Unit of Measure Code is specified for the Cost Type, it can only be changed if no entries with this Unit of Measure Code have yet been posted or exist for the Cost Type.

Rules when posting

  • In the Cost Journal, the Cost Type determines the Unit of Measure Code of the journal line.
  • In the Service Allocation Journal, the Credit Cost Type determines the Unit of Measure Code of the journal line. The Unit of Measure Code of the Debit Cost Type Code must match the Unit of Measure Code of the journal line.

Docs  /  NCCA Cost Accounting  /  Chart of Cost Types & Chart of Cost Dimensions
Work Types

Work Types can be used optionally or additionally in NCCA Cost Accounting.

Rules when posting

  • In the journals the Unit of Measure Code from the Work Type must match the Unit of Measure Code of the journal line. So, if a Unit of Measure Code is specified in the journal line, only work types to which the same Unit of Measure Code is assigned can be specified.
  • If no Unit of Measure Code is specified in the journal line, only work types to which no Unit of Measure Code is assigned can be specified. For more information, see Chart of Cost Types & Chart of Cost Dimensions, Unit of Measures.

Fields

For each work type, a Credit/Debit Cost Type can be specified that is suggested in the Service Allocation Journal when entering the Work Type.

Note

The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
NCCA Credit Cost Type CodeSpecifies a Credit Cost Type that is suggested in the Service Allocation Journal when entering the Work Type.
NCCA Credit Unit of Measure CodeSpecifies the Unit of Measure Code of the Credit Cost Type.
NCCA Debit Cost Type CodeSpecifies a Debit Cost Type that is suggested in the Service Allocation Journal when entering the Work Type.
NCCA Debit Unit of Measure CodeSpecifies the Unit of Measure Code of the Debit Cost Type.

Docs  /  NCCA Cost Accounting  /  Chart of Cost Types & Chart of Cost Dimensions
Cost Dimension Groups

The NCCA Cost Dimension Groups page can be used to set up groups for the cost type values or the cost dimension values. The groups can be assigned to the individual values and used as Filters in the line definition lines and column definition lines of the Evaluations. For more information, see Reports and Analysis, Edit Evaluations, Line Definition and Reports and Analysis, Edit Evaluations, Column Definition.

Fields

KostendimensionSpecifies the Cost Dimension.

Note

Depending on where the page is called from, an input is allowed or not. The field is automatically displayed if an input is allowed.
GroupSpecifies the group.

Note

Depending on where the page is called from, an input is allowed or not. The field is automatically displayed if an input is allowed.
CodeSpecifies the code of the group.
DescriptionSpecifies a description of the group.

Actions

  • Where-Used

    Displays all cost dimension values to which the cost dimension group is assigned.

Docs  /  NCCA Cost Accounting  /  Entry Transfer
G/L Entry Transfer

In order for G/L Entries to be transferred to Cost Entries, the Starting Date G/L Entry Transfer field must first be set in the Cost Accounting Setup. For more information, see Setup, Cost Accounting Setup.

Manual/Automatic Transfer

Basically, a distinction is made between manual and automatic transfer.
  • Manual Transfer

    A manual transfer can be performed at any time and regardless of whether the automatic transfer is activated. Already existing G/L Entries can only be transferred to the Cost Entries via a manual transfer. An initial initialization of the Cost Entries is thus performed by a manual transfer. The manual transfer can be accessed via the Administration area in the NCCA Cost Accounting Menu Bar. For more information, see General, Role Center Integration. Alternatively, the transfer can be accessed using the search term NCCA G/L Entry Transfer.

    Note

    It is recommended to perform the manual transfer first with the Test Transfer option and to perform the real transfer only when all entries could be transferred.

    Options

    Starting DateSpecifies the earliest posting date on which G/L Entries can be transferred to the NCCA Cost Accounting.
    From Posting DateSpecifies the posting date from which G/L Entries should be transferred to the NCCA Cost Accounting. If no date is specified, or if the date is before the starting date, then all entries with posting date from the starting date will be taken over.
    To Posting DateSpecifies the posting date to which G/L Entries should be transferred to the NCCA Cost Accounting.
    Reason CodeSpecifies the reason code, a supplementary source code that enables you to trace the entries.
    Include Transfer ErrorsSpecifies whether the currently existing transfer errors should also be included. This will again attempt to transfer the entries with the specified corrections. Note that this will also include corrections that may not have been fully specified.
    Test TransferSpecifies whether a test run should be performed so that you can find and correct any transfer errors before you perform the actual transfer. If the option Include Transfer Errors is also activated, all errors that could be transferred now due to the specified corrections will be set to the status Error (Corrections OK). For more information, see Entry Transfer, Transfer Errors.

    Tip

    The manual transfer can also be scheduled. This results in a kind of semi-automatic takeover where a recurring time for the transfer can be defined. When the transfer is scheduled with recurring time, it would be advisable not to set the Include Transfer Errors option. This allows any transfer errors that may have occurred to be corrected independently of the automatically recurring transfer.
  • Automatic Transfer

    If the automatic transfer is active, then the NCCA Cost Accounting is updated at each posting in the general ledger.

    Note

    • Only G/L Entries of the current posting are taken into account by the automatic transfer.
    • A cumulation of G/L Entries is not possible during the automatic transfer.

Which G/L Entries are taken into account?

All G/L Entries are included where the G/L Account is assigned to an NCCA Cost Type. It is also possible to specify the cost type for certain postings in the general journal or to define it manually for the entry transfer. These G/L Entries will then also be taken into account. For more information, see Entry Transfer, Cost Type as Dimension (G/L).

Which G/L Entries will not be transferred?

  • Entries for which the G/L Account No. field is empty
  • Entries without amount
  • Closing Entries
  • Entries for which a Transfer Exception has been created. For more information, see Entry Transfer, Transfer Errors.

What amount is taken over?

The amount of the G/L Entry is transferred.

Are quantities taken over?

If the G/L Entry Transfer incl. Quantities field is set for the determined cost type, the quantity of the G/L Entry is transferred.

How are Cost Type and Cost Dimensions determined?

  • Cost Type

    The cost type is basically determined from the G/L Entry via the G/L Account No.. It is also possible that the cost type for certain postings has already been specified in the journal or has been defined manually for the entry transfer. For more information, see Entry Transfer, Cost Type as Dimension (G/L).
  • Cost Dimensions

    The cost dimensions are determined by the settings of the Related Dimension (G/L) field of the Cost Dimension Setup. For more information, see Setup, Cost Dimension Setup.

Successful Transfer and Transfer Errors

After a manual transfer has been performed, a summary message is displayed. The message also shows, among other things, the number of the currently existing transfer errors. Example of a summary message with Test Transfer option enabled: The automatic transfer does not display a summary message. Transfer errors or a note that errors exist are also displayed at the following locations:
  • When opening the NCCA Cost Dimension Setup
  • When opening the NCCA Cost Registers
  • When opening the NCCA Cost Entries.
  • In the Accountant and Accounting Manager roles For more information, see General, Role Center Integration.
Transfer Errors must be corrected manually. For more information, see Entry Transfer, Transfer Errors.

General Ledger Entries, Fields

The following fields are available in the G/L Entries.
NCCA Transfer StatusDisplays the status of the transfer. For more information, see Entry Transfer, Transfer Errors.
NCCA Cost Entry No.Specifies the number of the assigned cost entry.

Reverse Transfer

For more information, see Entry Transfer, Reverse Transfer.

Docs  /  NCCA Cost Accounting  /  Entry Transfer
Calculatory FA Entry Transfer

In order for FA Entries to be transferred to Cost Entries, the Depreciation Book Code field and the Starting Date Calc. FA Entry Transfer field must first be set in the Cost Accounting Setup. For more information, see Setup, Cost Accounting Setup.

Manual/Automatic Transfer

Basically, a distinction is made between manual and automatic transfer.
  • Manual Transfer

    A manual transfer can be performed at any time and regardless of whether the automatic transfer is activated. Already existing FA Entries can only be transferred to the Cost Entries via a manual transfer. An initial initialization of the Cost Entries is thus performed by a manual transfer. The manual transfer can be accessed via the Administration area in the NCCA Cost Accounting Menu Bar. For more information, see General, Role Center Integration. Alternatively, the transfer can be accessed using the search term NCCA Calculatory FA Entry Transfer.

    Note

    It is recommended to perform the manual transfer first with the Test Transfer option and to perform the real transfer only when all entries could be transferred.

    Options

    Depreciation Book CodeSpecifies the Depreciation Book for the calculatory FA Entry Transfer.
    FA Posting TypesSpecifies which FA Posting Types should be transferred by the calculatory FA Entry Transfer.
    Starting DateSpecifies the earliest posting date on which FA Entries can be transferred to the NCCA Cost Accounting.
    From Posting DateSpecifies the posting date from which FA Entries should be transferred to the NCCA Cost Accounting. If no date is specified, or if the date is before the starting date, then all entries with posting date from the starting date will be taken over.
    To Posting DateSpecifies the posting date to which FA Entries should be transferred to the NCCA Cost Accounting.
    Reason CodeSpecifies the reason code, a supplementary source code that enables you to trace the entries.
    Include Transfer ErrorsSpecifies whether the currently existing transfer errors should also be included. This will again attempt to transfer the entries with the specified corrections. Note that this will also include corrections that may not have been fully specified.
    Test TransferSpecifies whether a test run should be performed so that you can find and correct any transfer errors before you perform the actual transfer. If the option Include Transfer Errors is also activated, all errors that could be transferred now due to the specified corrections will be set to the status Error (Corrections OK). For more information, see Entry Transfer, Transfer Errors.

    Tip

    The manual transfer can also be scheduled. This results in a kind of semi-automatic takeover where a recurring time for the transfer can be defined. When the transfer is scheduled with recurring time, it would be advisable not to set the Include Transfer Errors option. This allows any transfer errors that may have occurred to be corrected independently of the automatically recurring transfer.
  • Automatic Transfer

    If the automatic transfer is active, then the NCCA Cost Accounting is updated at each posting in the fixed asset accounting.

    Note

    • Only FA Entries of the current posting are taken into account by the automatic transfer.
    • A cumulation of FA Entries is not possible during the automatic transfer.

Which FA Entries are taken into account?

The field Depreciation Book Code in the NCCA Cost Accounting Setup specifies the Depreciation Book with which the FA Entries must be posted in order to be transferred. The field FA Posting Types in the NCCA Cost Accounting Setup specifies which FA Posting Types should be transferred. For more information, see Setup, Cost Accounting Setup.

Which FA Entries will not be transferred?

  • Entries where neither the FA No. field nor the Canceled from FA No. field contains a value
  • Entries without amount
  • Closing Entries
  • Entries for which a Transfer Exception has been created. For more information, see Entry Transfer, Transfer Errors.

What amount is taken over?

For FA Entries with FA Posting Type Depreciation, Write-Down, Custom 1 and Custom 2, the amount of the entry is transferred with inverted sign. For FA Posting Type Book Value on Disposal or Gain/Loss the amount of the entry is taken.

Are quantities taken over?

If the FA Entry Transfer incl. Quantities field is set for the determined cost type, the quantity of the FA Entry is transferred. Like the amount, quantities are also transferred with inverted sign for certain FA Posting Types.

How are Cost Type and Cost Dimensions determined?

  • Cost Type

    The cost type is basically determined via the FA Posting Group from the FA Depreciation Book of the FA Entry. For this purpose, the cost type must be specified for the individual FA Posting Groups. It is also possible that the cost type for certain postings has already been specified in the fixed assets journal or has been defined manually for the entry transfer. For more information, see Entry Transfer, Cost Type as Dimension (G/L).

    FA Posting Groups, Fields

    Note

    The caption of the fields depends on how the cost type is set up in the Cost Dimension Setup.
    NCCA Depreciation Cost Type CodeSpecifies a Cost Type that is used by the Transfer for FA Entries with the following FA Posting Type:
    • Depreciation
    • Write-Down
    • Custom 1
    • Custom 2
    NCCA Book Value on Disposal Cost Type CodeSpecifies a Cost Type that is used by the Transfer for FA Entries with the following FA Posting Type:
    • Book Value on Disposal
    NCCA Gain/Loss Cost Type CodeSpecifies a Cost Type that is used by the Transfer for FA Entries with the following FA Posting Type:
    • Gain/Loss
  • Cost Dimensions

    The cost dimensions are determined by the settings of the Related Dimension (G/L) field of the Cost Dimension Setup. For more information, see Setup, Cost Dimension Setup.

Successful Transfer and Transfer Errors

After a manual transfer has been performed, a summary message is displayed. The message also shows, among other things, the number of the currently existing transfer errors. Example of a summary message with Test Transfer option enabled: The automatic transfer does not display a summary message. Transfer errors or a note that errors exist are also displayed at the following locations:
  • When opening the NCCA Cost Dimension Setup
  • When opening the NCCA Cost Registers
  • When opening the NCCA Cost Entries.
  • In the Accountant and Accounting Manager roles For more information, see General, Role Center Integration.
Transfer Errors must be corrected manually. For more information, see Entry Transfer, Transfer Errors.

FA Ledger Entries, Fields

The following fields are available in the FA Entries.
NCCA Transfer StatusDisplays the status of the transfer. For more information, see Entry Transfer, Transfer Errors.
NCCA Cost Entry No.Specifies the number of the assigned cost entry.

Reverse Transfer

For more information, see Entry Transfer, Reverse Transfer.

Docs  /  NCCA Cost Accounting  /  Entry Transfer
Transfer Errors

Via the NCCA G/L Entry Transfer Errors and NCCA Calc. FA Entry Transfer Errors page you can edit the transfer errors that occurred when transferring the G/L Entries and the FA Entries to NCCA Cost Accounting. Both pages are identical except for the fields for G/L Accounts and Fixed Assets. The screenshots below show the G/L Entry Transfer Errors.

NCCA Transfer Status

If a manual or an automatic item transfer is performed, the NCCA Transfer Status field is set for all considered entries. Basically the following options are possible:
  • Not transferred The entry has not yet been transferred to NCCA Cost Accounting. This status is the default value, which is basically set for all G/L Entries and FA Entries.
  • Error The entry could not be transferred to NCCA Cost Accounting. Transfer errors occur if, for example, the cost type is locked or if required cost dimensions could not be determined.
  • Transferred The entry was transferred to NCCA Cost Accounting.

Note

There are other options that will be discussed in more detail later.
If there are errors in the transfer, this is displayed directly in a summary message after a manual transfer. The automatic transfer does not display a summary message. Transfer errors or a note that errors exist are also displayed at the following locations:
  • When opening the NCCA Cost Dimension Setup
  • When opening the NCCA Cost Registers
  • When opening the NCCA Cost Entries.
  • In the Accountant and Accounting Manager roles For more information, see General, Role Center Integration.
The errors can then be corrected or edited via the pages NCCA G/L Entry Transfer Errors and NCCA Calc. FA Entry Transfer Errors. By default, the page is opened in the Errors view.

Cause of Error & Correction

The cause of error is displayed in the NCCA Transfer Error Message field. The cost type and all cost dimensions, which could be determined automatically by the transfer, are also displayed in the NCCA Correction fields. The correction is done by specifying the appropriate codes in the NCCA Correction fields of each entry. The Assign Correction action can be used to assign a correction value to several selected entries. If certain entries are to be excluded from the transfer, the Create Transfer Exception action can be used for this purpose. This removes the entry from the current view or moves it to the Transfer Exceptions view.

Transfer again

With the Transfer action the manual transfer can be executed again. The Include Transfer Errors and Test Transfer fields are set by default.

Note

  • Only if Include Transfer Errors is set, the currently existing transfer errors are considered.
  • If the option Test Transfer is also activated, all errors that could be transferred now due to the specified corrections will be set to the status Error (Corrections OK) and are ranked after the open errors in the Errors view.
If the action is performed without the Test Transfer option, another attempt is made to transfer the entries. Thereby applies:
  • Entries for which the cause of the error was eliminated indirectly, e.g. by releasing a blocked cost type, are marked with the status Transferred by the transfer and are therefore no longer part of the transfer errors.
  • Entries which can be transferred by the specification of corrections are marked by the transfer with the status Transferred with Corrections. These entries will be removed from the current view or moved to the Transferred with Corrections view. This view can be seen as a kind of archive or history, where all corrections ever made can be found.

Reverse Transfer

For more information, see Entry Transfer, Reverse Transfer.

Fields

ViewSpecifies which data should be displayed on the page. The Errors option displays entries with status Error and Error (Corrections OK).
Posting DateSpecifies the Entry's posting date.
Document TypeSpecifies the Entry's document type.
Document No.Specifies the Entry's document no.
G/L Account No.Specifies the G/L Account that the G/L Entry has been posted to.
FA No.Specifies the Fixed Asset that the FA Entry has been posted to.
Depreciation Book CodeSpecifies the code of the depreciation book that the FA Entry has been posted to.
FA Posting CategorySpecifies the FA Entry's posting category.
FA Posting TypeSpecifies the FA Entry's posting type.
DescriptionSpecifies the description of the Entry.
AmountSpecifies the amount of the Entry.
User IDSpecifies the ID of the user who posted the Entry.
Source CodeSpecifies the source code that specifies where the Entry was created.
Entry No.Specifies the number assigned to the Entry.
Dimension Set IDSpecifies a reference to the posted general ledger dimensions.
NCCA Transfer StatusDisplays the status of the transfer.
  • Not transferred The entry has not yet been transferred to NCCA Cost Accounting. This status is the default value, which is basically set for all G/L Entries and FA Entries.
  • Error The entry could not be transferred to NCCA Cost Accounting. The reason for the error is displayed in the NCCA Transfer Error Message field.
  • Transferred The entry was transferred to NCCA Cost Accounting.
  • Transferred with Corrections The entry has been transferred to NCCA Cost Accounting through or with corrections.
  • Transfer Exception The entry should not be transferred to NCCA Cost Accounting.
  • Error (Corrections OK) The entry could be transferred to NCCA Cost Accounting with the corrections specified.
NCCA Transfer Error MessageDisplays information about the transfer error.
NCCA Correction Cost Type CodeDisplays the determined cost type of the entry in case of an error, or specifies a corrected (different) value which should be used for the transfer. If the field is empty, the cost type is determined during the transfer. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
NCCA Correction Cost Dimension CodesDisplays the determined cost dimension values of the entry in case of an error, or specifies corrected (different) values which should be used for the transfer. If the field is empty, the cost dimension is determined during the transfer using the posted general ledger dimensions. By specifying '', the cost dimension can be forced to be empty for the transfer. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
NCCA Cost Entry No.Specifies the number of the assigned cost entry.

Actions

  • Transfer

    Performs a manual Transfer. For more information, see Entry Transfer, G/L Entry Transfer and Entry Transfer, Calculatory FA Entry Transfer.
  • Assign Correction

    Specifies a Cost Dimension Correction for the selected Entries which should be used for the transfer.
  • Remove Correction

    Removes a Cost Dimension Correction from the selected Entries.
  • Reset Transfer

    Removes all corrections from the selected Entries and resets them to the Not transferred status. So the Entries are removed from the transfer errors. Entries in the status Transferred or Transferred with Corrections cannot be reset with this action. For more information, see Entry Transfer, Reverse Transfer.
  • Create Transfer Exception

    Creates a Transfer Exception for the selected Entries. Entries for which an exception exists are not transferred.
  • Remove Transfer Exception

    Removes the Transfer Exception from the selected Entries.
  • Find entries...

    Find entries and documents that exist for the document number and posting date on the selected document.
  • Dimensions (G/L)

    View the posted general ledger dimensions.

Docs  /  NCCA Cost Accounting  /  Entry Transfer
Reverse Transfer

When G/L Entries or FA Entries are transferred to Cost Accounting, an entry is automatically created in the NCCA Cost Register. Via the action Reverse Cost Register the transfer can be reversed. For more information, see Journals, Extended, Cost Registers. A reversal restores G/L Entries or FA Entries to their pre-transfer status. Thereby applies:
  • Entries that have Transferred set in the NCCA Transfer Status field will be set to Not transferred.
  • For entries that have Transferred with Corrections set in the NCCA Transfer Status field, it must be specified whether to keep any existing dimension corrections during the reversal. Therefore, after starting the reversal, a selection window with the following options appears:
    • Keep dimension corrections Dimension corrections are not deleted and the entries are set to Error (Corrections OK) status. So these entries will be shown again in the transfer errors and can be changed there further, or, if entries were part of the transfer by mistake, removed from the transfer errors with the action Reset Transfer. For more information, see Entry Transfer, Transfer Errors.
    • Remove dimension corrections All dimension corrections are deleted and the entries are set to status Not transferred.

    Note

    The selection window appears even if there are no dimension corrections. In this case, the selected option does not affect the result of the reversal.

Docs  /  NCCA Cost Accounting  /  Entry Transfer
Cost Type as Dimension (G/L)

Basically, when transferring entries, the cost type is determined via the G/L Account No. of the G/L Entry or via the FA Posting Group from the FA Depreciation Book of the FA Entry. Optionally, a Related Dimension (G/L) can also be set up for the cost type that allows you to specify a fixed cost type for the entry transfer already in the general journal or in the FA journal. For more information, see Setup, Cost Dimension Setup. If a related dimension (G/L) has been set up, the cost type can be specified via the dimensions of the journal line.

Important

Postings where the cost type is specified via a dimension are always taken into account by the entry transfer, even if the G/L Account of the posting is not assigned to an NCCA Cost Type.

Docs  /  NCCA Cost Accounting  /  Journals  /  General
Journal Templates & Journal Batches

Journal Templates

If a journal is opened in NCCA Cost Accounting and there is no Journal Template for it yet, all missing templates will be created automatically with default values.

Tip

NCCA Journal Templates can also be initialized via the NCCA Cost Accounting Setup. To do this, the page must be opened via the NCCA Journal Templates action from the NCCA Cost Accounting Setup. For more information, see Setup, Cost Accounting Setup.

Journal Templates, Fields

NameSpecifies the name of the journal template.
DescriptionSpecifies a brief description of the journal template.
TypeSpecifies for which journal type the template should be used.
RecurringSpecifies whether the journals of the template are recurring.
No. SeriesSpecifies the number series from which entry or record numbers are assigned to new entries or records.
Posting No. SeriesSpecifies the number series that will be used to assign document numbers to entries that are posted from this journals using this template.
Source CodeSpecifies the source code that specifies where the entry was created.
Reason CodeSpecifies the reason code, a supplementary source code that enables you to trace the entries.
Increment Batch NameSpecifies if batch names using this template are automatically incremented. Example: The posting following BATCH001 is automatically named BATCH002.
Page IDSpecifies the number of the journal page that should be used for the template.
Page CaptionSpecifies the name of the selected Page.
Test Report IDSpecifies the report that is printed when you click on the Test Report action in the journal.
Test Report CaptionSpecifies the name of the selected Test Report.
Posting Report IDSpecifies the report that is printed when you click on the Post and Print action in the journal.
Posting Report CaptionSpecifies the name of the selected Posting Report.
Force Posting ReportSpecifies whether the Posting Report is printed automatically when you post the journal.

Journal Templates, Actions

  • Batches

    View or set up the journals for the template.

Journal Batches

If a journal is opened in NCCA Cost Accounting and there is no Journal Batch for it yet, the STANDARD journal batch will be created automatically.

Journal Batches, Fields

NameSpecifies the name of the journal.
DescriptionSpecifies a brief description of the journal.
Use Service Allocation PricesSpecifies whether the service allocation prices should be used or proposed. The field is displayed only for Cost and Service Allocation Journal Batches. For more information, see Journals, Service Allocations, Service Allocation Prices.
Suggest Balancing AmountSpecifies if the Amount field on journal lines for the same document number is automatically prefilled with the value that is required to balance the document. The field is displayed only for Cost Journal Batches.
Fixed Allocation AmountSpecifies whether a fixed amount should be used for the Allocation or not. The field is displayed only for Allocation Journal Batches.
Allocation Without CreditSpecifies whether the Allocation should be posted without Credit or not. The field is displayed only for Allocation Journal Batches.
Archive Allocation Calculation DetailsSpecifies whether the Allocation Calculation Details should be archived when the journal is posted. The field is displayed only for Allocation Journal Batches. The archived calculation details are stored to the cost register entry of the posting and can be displayed there and if no longer needed, also deleted. For more information, see Journals, Extended, Cost Registers.

Important

Archiving the Calculation Details generates considerably more data. Permanent activation is therefore not advisable.
RecurringSpecifies whether the journal template and thus also the journal is recurring.
No. SeriesSpecifies the number series from which entry or record numbers are assigned to new entries or records.
Posting No. SeriesSpecifies the number series that will be used to assign document numbers to entries that are posted from this journal.
Reason CodeSpecifies the reason code, a supplementary source code that enables you to trace the entries.
Cost Type AppearanceSpecifies how the cost type should be displayed in the journal.
  • " " specifies that the cost type should be displayed as normal.
  • Promoted Specifies that the cost type should be highlighted and thus displayed in bold.
The field is displayed only in the Edit mode of the page. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
Cost Dimension AppearancesSpecifies how the cost dimensions should be displayed in the journal.
  • " " specifies that the cost dimension should be displayed as normal.
  • Promoted indicates that the cost dimension should be highlighted and thus displayed in bold.
  • Extended View Specifies that the cost dimension should only be displayed if the extended column view is activated in the journal.
  • Unavailable indicates that the cost dimension is not available and therefore should not be displayed.
The fields are displayed only in the Edit mode of the page. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.

Journal Batches, Actions

  • Edit Journal

    Open a journal based on the journal batch.
  • Test Report

    View a test report so that you can find and correct any errors before you perform the actual posting of the journal.
  • Post

    Finalize the journal by posting the amounts and quantities to the cost dimensions.
  • Post and Print

    Finalize and prepare to print the journal. The values and quantities are posted to the cost dimensions. A report request window opens where you can specify what to include on the print-out.
  • Marked On/Off

    View all journal batches or only marked journal batches. A journal batch is marked if an attempt to post the general journal fails.

Docs  /  NCCA Cost Accounting  /  Journals  /  Costs
Cost Journals

In the Cost Journals you can post Amounts and/or Quantities to Cost Types and Cost Dimensions. You can also prepare postings externally (e.g. in Excel) and import them directly into a Cost Journal. Via the Import actions, postings that have been prepared externally in Excel, for example, can be imported directly into the journal.

Fields

Batch NameSpecifies the name of the journal batch.
Posting DateSpecifies the posting date for the entry.
Document No.Specifies the number of the related document.
Posting TypeSpecifies the posting type.
  • " " This option requires an Amount to be specified.
  • Costs With this option, the Amount must be positive. If the field Correction is activated, the Amount must be negative.
  • Revenues With this option, the Amount must be negative. If the field Correction is activated, the Amount must be positive.
  • Transfer With this option, a balance check is performed. Service Allocations, for example, are posted with this posting type.
  • Quantities This option can be used to perform a quantity-only posting, where a quantity and no amount must be specified.
Cost Type CodeSpecifies the Cost Type for the entry. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
Cost Dimension CodesSpecifies the cost dimension values for the entry. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
DescriptionSpecifies a description for the entry.
Work Type CodeSpecifies the work type. For more information, see Chart of Cost Types & Chart of Cost Dimensions, Work Types.
QuantitySpecifies the quantity.

Note

  • Quantities can only be posted with a Unit of Measure Code.
  • The Posting Type Quantities can be used to perform a quantity-only posting, where a quantity and no amount must be specified.
Unit of Measure CodeSpecifies the Unit of Measure Code of the Cost Type. For more information, see Chart of Cost Types & Chart of Cost Dimensions, Unit of Measures.
PriceSpecifies the price of one unit.
AmountSpecifies the total amount that the journal line consists of.
Debit AmountSpecifies the total amount that the journal line consists of, if it is a debit amount.
Credit AmountSpecifies the total amount that the journal line consists of, if it is a credit amount.
BalanceSpecifies the balance of the journal line if Posting Type Transfer.
Reason CodeSpecifies the reason code, a supplementary source code that enables you to trace the entries.
CorrectionSpecifies the entry as a corrective entry. You can use the field if you need to post a corrective entry to a cost type.
Line No.Specifies the line number.

Recurring Journals, Placeholders

In the Document No. and Description fields, placeholders can be used for recurring journals, which are automatically determined each time the journal is posted. Example: If you want the entry description to be "Billing + number of current month", enter "Billing %3" in the field. The following placeholders are available:
PlaceholderResult
%1Current Day as Number (e.g. 1)
%2Current Week as Number (e.g. 52)
%3Current Month as Number (e.g. 1)
%4Current Month as Name (e.g. January)
%5Current Accounting Period as Name (e.g. March)

Recurring Journals, additional Fields

The following fields are additionally available for recurring journals. The fields correspond to the fields in the general recurring journals. For more information, see [Microsoft Docs] Work with recurring journals
Recurring MethodSpecifies a recurring method for the recurring journal.
Recurring FrequencySpecifies the recurring frequency for the posting date of the recurring journal.
Expiration DateSpecifies the last date the recurring journal will be posted.

Actions

  • Post

    Finalize the journal by posting the amounts and quantities to the cost dimensions.
  • Preview Posting

    Displays a preview of all entries that will be created when posting the journal. For more information, see Journals, Extended, Posting Preview.
  • Post and Print

    Finalize and prepare to print the journal. The values and quantities are posted to the cost dimensions. A report request window opens where you can specify what to include on the print-out.
  • Test Report

    View a test report so that you can find and correct any errors before you perform the actual posting of the journal.
  • Cost Entries

    View the history of transactions that have been posted for the Cost Type.
  • Extended Column View

    Click on the action to switch to the extended or reduced column view. In the journals of NCCA Cost Accounting some fields and actions (depending on e.g. the setting in the journal name or the Cost Accounting Setup) are automatically displayed or hidden. In addition, this action gives you the option to choose a simpler display or to show only the most important fields. Fields such as Work Type, Quantity and Unit of Measure Code are hidden in the simpler display. The settings are saved for each user and journal.
  • Renumber Document Numbers

    Resorts the numbers in the Document No. column. The action corresponds to the action from the General Journals. For more information, see [Microsoft Docs] To renumber document numbers in journals
  • Import from Excel

    Import journal lines from an Excel file. For more information, see Journals, Costs, Import Cost Journal.
  • Create Excel Workbook for Import

    Creates an Excel workbook that can be used as a template for importing journal lines.
  • Import from File

    Import journal lines from a file.

Docs  /  NCCA Cost Accounting  /  Journals  /  Costs
Import Cost Journal

In the Cost Journal, journal lines can be imported from a file (action Import from File) or from an Excel file (action Import from Excel). This can be used, for example, to transfer postings from other systems.

File structure

The field separator is assumed to be tab when importing from a file. A header line (e.g. line with field names) is not allowed when importing from a file. However, the Excel sheet can optionally contain a header row. In this case you will get a hint when importing the Excel file and you can import the data starting from the 2nd row.

Tip

The Create Excel Workbook for Import action in the Journals can be used to create an Excel workbook that can be used as a template for importing journal lines.

Field order

  1. Posting Date
  2. Document No.
  3. Cost Type Code
  4. Work Type Code
  5. Quantity
  6. Price
  7. Amount
  8. Description
  9. Reason Code
  10. Cost Dimension 1 Code
  11. Cost Dimension 2 Code
  12. Cost Dimension 3 Code
  13. Cost Dimension 4 Code
  14. Cost Dimension 5 Code
  15. Cost Dimension 6 Code
  16. Cost Dimension 7 Code
  17. Cost Dimension 8 Code

Note

If Price and Quantity are specified in the file, the amount is determined automatically. In this case, the amount is read from the file only if the quantity times the price is 0.

Docs  /  NCCA Cost Accounting  /  Journals  /  Service Allocations
Service Allocation Prices

The NCCA Service Allocation Prices page can be used to specify prices for the Service Allocation or for the pricing in the journals. The Service Allocation Prices (as is the Service Allocation) are based on Cost Dimension 1. Thus, the Cost Dimension 1 or the Credit Cost Dimension 1 is used for pricing in the journals. Prices can be specified either for a unit or for a work type.

Note

Pricing can be enabled for a journal in the Journal Batch Name via the Use Service Allocation Prices field. It is also possible to use pricing in the budget. To do this, activate the Use Service Allocation Prices field in the Budget Name.

Fields

Cost Dimension 1 CodeSpecifies the code of the Service Allocation Dimension for which the price is valid. If no code is specified, the price is valid for all codes that do not have their own price defined with the same combination of Unit of Measure Code and Work Type Code. The caption of the field depends on how the cost dimension 1 is set up in the Cost Dimension Setup.
Cost Dimension 1 NameSpecifies the name of the Service Allocation Dimension. The caption of the field depends on how the cost dimension 1 is set up in the Cost Dimension Setup.
Unit of Measure CodeSpecifies the Unit of Measure Code for which the price is valid. The price can be specified either for a unit or for a work type. Pricing first searches for prices for the work type.
Work Type CodeSpecifies the Work Type Code for which the price is valid. The price can be specified either for a unit or for a work type. Pricing first searches for prices for the work type.
Work Type Unit of Measure CodeSpecifies the Unit of Measure Code of the Work Type.
Starting DateSpecifies the date from which the price is valid.
PriceSpecifies the price

Process of pricing in the journal

  1. If a work type is specified, pricing first searches for a price for Cost Dimension 1 and the specified Work Type Code.
  2. If no price is found, a search is made for a price without Cost Dimension 1 but with the specified Work Type Code.
  3. If no price is found, a price is searched for Cost Dimension 1 and the specified Unit of Measure Code.
  4. If no price is found, a search is made for a price without Cost Dimension 1 but with the specified Unit of Measure Code.

Example

The following example shows how pricing works. In this example the department was set up as cost dimension 1.

Service Allocation Prices set up

Department CodeUnit of Measure CodeWork Type CodeWork Type Unit of Measure CodePrice
 HOUR  10
  INTERNALHOUR20
PRODHOUR  30
PROD EXTERNALHOUR40
The first two lines were created without department code and are therefore valid for all departments. For department code PROD, two additional prices have been defined for Unit of Measure Code HOUR and Work Type Code EXTERNAL.

Pricing results

The following table shows the prices determined by the pricing for different combinations of department code, Unit of Measure Code and Work Type Code based on a Cost Type with Unit of Measure Code HOUR.
Department CodeUnit of Measure CodeWork Type CodePrice foundNote
ADMINHOUR 10The general price for Unit of Measure Code HOUR was found.
ADMINHOURINTERNAL20The general price for Work Type Code INTERNAL was found.
ADMINHOUREXTERNAL10No price found for Work Type Code EXTERNAL. The general price for Unit of Measure Code HOUR was found.
PRODHOUR 30 
PRODHOURINTERNAL20No price found for Work Type Code INTERNAL. The general price for Work Type Code INTERNAL was found.
PRODHOUREXTERNAL40 
PRODHOUREXTERNAL30No price found for Work Type Code EXTERNAL. The price for Unit of Measure Code HOUR was found.

Docs  /  NCCA Cost Accounting  /  Journals  /  Service Allocations
Service Allocation Journals

Service Allocation Journals are optimized for recording and posting service allocations. You can credit any Cost Dimension using a Cost Type and thus debit any Cost Dimension using a Cost Type. Via the Import actions, postings that have been prepared externally in Excel, for example, can be imported directly into the journal.

Note

  • The Cost Type (and thus also the Unit of Measure Code) can be suggested via the Work Type.
  • The Service Allocation Prices (as is the Service Allocation) are based on Cost Dimension 1. Thus, the Cost Dimension 1 or the Credit Cost Dimension 1 is used for pricing in the journals. For more information, see Journals, Service Allocations, Service Allocation Prices.

Fields

Batch NameSpecifies the name of the journal batch.
Posting DateSpecifies the posting date for the entries.
Document No.Specifies the number of the related document.
Credit Cost Dimension CodesSpecifies the cost dimension values for the Credit entry. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
Debit Cost Dimension CodesSpecifies the cost dimension values for the Debit entry. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
Work Type CodeSpecifies the work type. You can set up a Credit and Debit Cost Type for each work type, which then will be suggested when entering the work type code in the journal. For more information, see Chart of Cost Types & Chart of Cost Dimensions, Work Types.
Credit Cost Type CodeSpecifies the Cost Type for the Credit entry. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
Debit Cost Type CodeSpecifies the Cost Type for the Debit entry. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
DescriptionSpecifies a description for the entries.
QuantitySpecifies the quantity.

Note

Quantities can only be posted with a Unit of Measure Code.
Unit of Measure CodeSpecifies the Unit of Measure Code of the Credit Cost Type. For more information, see Chart of Cost Types & Chart of Cost Dimensions, Unit of Measures.
PriceSpecifies the price of one unit.
AmountSpecifies the total amount that the journal line consists of.
Reason CodeSpecifies the reason code, a supplementary source code that enables you to trace the entries.
CorrectionSpecifies the entry as a corrective entry. You can use the field if you need to post a corrective entry to a cost type.
Line No.Specifies the line number.

Recurring Journals, Placeholders

In the Document No. and Description fields, placeholders can be used for recurring journals, which are automatically determined each time the journal is posted. Example: If you want the entry description to be "Billing + number of current month", enter "Billing %3" in the field. The following placeholders are available:
PlaceholderResult
%1Current Day as Number (e.g. 1)
%2Current Week as Number (e.g. 52)
%3Current Month as Number (e.g. 1)
%4Current Month as Name (e.g. January)
%5Current Accounting Period as Name (e.g. March)

Recurring Journals, additional Fields

The following fields are additionally available for recurring journals. The fields correspond to the fields in the general recurring journals. For more information, see [Microsoft Docs] Work with recurring journals
Recurring MethodSpecifies a recurring method for the recurring journal.
Recurring FrequencySpecifies the recurring frequency for the posting date of the recurring journal.
Expiration DateSpecifies the last date the recurring journal will be posted.

Actions

  • Post

    Finalize the journal by posting the amounts and quantities to the cost dimensions.
  • Preview Posting

    Displays a preview of all entries that will be created when posting the journal. For more information, see Journals, Extended, Posting Preview.
  • Post and Print

    Finalize and prepare to print the journal. The values and quantities are posted to the cost dimensions. A report request window opens where you can specify what to include on the print-out.
  • Test Report

    View a test report so that you can find and correct any errors before you perform the actual posting of the journal.
  • Credit Cost Entries

    View the history of transactions that have been posted for the Credit Cost Type.
  • Debit Cost Entries

    View the history of transactions that have been posted for the Debit Cost Type.
  • Extended Column View

    Click on the action to switch to the extended or reduced column view. In the journals of NCCA Cost Accounting some fields and actions (depending on e.g. the setting in the journal name or the Cost Accounting Setup) are automatically displayed or hidden. In addition, this action gives you the option to choose a simpler display or to show only the most important fields. Fields such as Work Type, Quantity and Unit of Measure Code are hidden in the simpler display. The settings are saved for each user and journal.
  • Renumber Document Numbers

    Resorts the numbers in the Document No. column. The action corresponds to the action from the General Journals. For more information, see [Microsoft Docs] To renumber document numbers in journals
  • Import from Excel

    Import journal lines from an Excel file. For more information, see Journals, Service Allocations, Import Service Allocation Journal.
  • Create Excel Workbook for Import

    Creates an Excel workbook that can be used as a template for importing journal lines.
  • Import from File

    Import journal lines from a file.

Docs  /  NCCA Cost Accounting  /  Journals  /  Service Allocations
Import Service Allocation Journal

In the Service Allocation Journal, journal lines can be imported from a file (action Import from File) or from an Excel file (action Import from Excel). This can be used, for example, to transfer postings from other systems.

File structure

The field separator is assumed to be tab when importing from a file. A header line (e.g. line with field names) is not allowed when importing from a file. However, the Excel sheet can optionally contain a header row. In this case you will get a hint when importing the Excel file and you can import the data starting from the 2nd row.

Tip

The Create Excel Workbook for Import action in the Journals can be used to create an Excel workbook that can be used as a template for importing journal lines.

Field order

  1. Posting Date
  2. Document No.
  3. Work Type Code
  4. Credit Cost Type Code
  5. Debit Cost Type Code
  6. Quantity
  7. Price
  8. Amount
  9. Description
  10. Reason Code
  11. Credit Cost Dimension 1 Code
  12. Debit Cost Dimension 1 Code
  13. Credit Cost Dimension 2 Code
  14. Debit Cost Dimension 2 Code
  15. Credit Cost Dimension 3 Code
  16. Debit Cost Dimension 3 Code
  17. Credit Cost Dimension 4 Code
  18. Debit Cost Dimension 4 Code
  19. Credit Cost Dimension 5 Code
  20. Debit Cost Dimension 5 Code
  21. Credit Cost Dimension 6 Code
  22. Debit Cost Dimension 6 Code
  23. Credit Cost Dimension 7 Code
  24. Debit Cost Dimension 7 Code
  25. Credit Cost Dimension 8 Code
  26. Debit Cost Dimension 8 Code

Note

If Price and Quantity are specified in the file, the amount is determined automatically. In this case, the amount is read from the file only if the quantity times the price is 0.

Docs  /  NCCA Cost Accounting  /  Journals  /  Allocations
Allocation Journals

The Allocation Journals are a powerful tool for setting up your allocations. For example, you can credit a base using a (specially created) allocation cost type and thus debit a large number of cost dimensions based on variable reference values. Topics such as iteration, consideration in subsequent allocations or a preview of calculation details are also supported. In the Journal Batches various settings like Fixed Allocation Amount or Allocation Without Credit are available to define the basic behavior for the journal.

Tip

In general, it is recommended to set up allocations right away in the recurring Allocation Journals. This means that your setups can also be used for subsequent periods or further tests and do not have to be re-entered after posting.

Fields

Batch NameSpecifies the name of the journal batch.
Posting DateSpecifies the posting date for the entries.
Document No.Specifies the number of the related document.
DescriptionSpecifies a description for the entries.
Allocation Base FromSpecifies a filter to determine which entries should be allocated.
Allocation Base ToSpecifies a filter to determine which entries should be allocated.
Allocation Base Cost Type FilterSpecifies a filter to determine which entries should be allocated. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
Allocation Base Cost Dimension FiltersSpecifies filters to determine which entries should be allocated. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
Allocation Base Work Type FilterSpecifies a filter to determine which entries should be allocated.
Fixed Allocation AmountSpecifies the fixed amount that should be allocated.
Allocation %Specifies the percentage by which the the allocation amount should be multiplied. If the field is empty or contains the value 100, the allocation amount is allocated 100 percent.
Open Base/CreditPrevents the base (or the base and the credit) entries from being marked with the Transaction No. of the posting. Marked entries are no longer considered in subsequent allocations. In the case of an open base/credit, the entries can still be used as the basis for subsequent allocations.
Distribution TypeSpecifies how the allocation should be distributed and how the distribution ratio should be calculated. The distribution ratio is used to calculate the debit amount.
No. of Allocation DistributionsSpecifies the number of the allocation distributions.
Max. Iteration StepsSpecifies the maximum number of iterations. If the field is empty, the allocation will be ended after a maximum of 25 iterations.
Min. Iteration AmountSpecifies up to which remaining allocation amount the iteration should be performed. As soon as the absolute value of the remaining allocation amount falls below the specified value, the allocation will be ended.
Credit Cost Type CodeSpecifies the Cost Type for the Credit entries. By specifying an equal sign, the value can be inherited from the Allocation Base entries. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
Credit Cost Dimension CodesSpecifies the cost dimension values for the Credit entries. By specifying an equal sign, the value can be inherited from the Allocation Base entries. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
Reason CodeSpecifies the reason code, a supplementary source code that enables you to trace the entries.
Line No.Specifies the line number.

Recurring Journals, Placeholders

In the Document No. and Description fields, placeholders can be used for recurring journals, which are automatically determined each time the journal is posted. Example: If you want the entry description to be "Billing + number of current month", enter "Billing %3" in the field. The following placeholders are available:
PlaceholderResult
%1Current Day as Number (e.g. 1)
%2Current Week as Number (e.g. 52)
%3Current Month as Number (e.g. 1)
%4Current Month as Name (e.g. January)
%5Current Accounting Period as Name (e.g. March)

Recurring Journals, additional Fields

The following fields are additionally available for recurring journals. The fields correspond to the fields in the general recurring journals. For more information, see [Microsoft Docs] Work with recurring journals
Recurring FrequencySpecifies the recurring frequency for the posting date of the recurring journal.
Expiration DateSpecifies the last date the recurring journal will be posted.
Allocation Base From Recurring FrequencySpecifies the recurring frequency for the Base From date.
Allocation Base To Recurring FrequencySpecifies the recurring frequency for the Base To date.
Reference From Recurring FrequencySpecifies the recurring frequency for the Reference From date of the allocation distributions.
Reference To Recurring FrequencySpecifies the recurring frequency for the Reference To date of the allocation distributions.

Allocation Distribution

In the Allocation Distribution area, the debit is specified. Depending on the settings in the Distribution Type field, different fields are displayed in the allocation distribution. For more information, see Journals, Allocations, Allocation Distribution.

Actions

  • Post

    Finalize the journal by posting the amounts to the cost dimensions.
  • Preview Posting

    Displays a preview of all entries that will be created when posting the journal. For more information, see Journals, Extended, Posting Preview.
  • Post and Print

    Finalize and prepare to print the journal. The values are posted to the cost dimensions. A report request window opens where you can specify what to include on the print-out.
  • Test Report

    View a test report so that you can find and correct any errors before you perform the actual posting of the journal.
  • Allocation Dimensions

    View or set up the cost dimensions for the journal line on a card page.
  • Show Allocation Base

    Displays the cost entries that, based on the current settings, will be used to calculate the base.

    Note

    Note that journal lines that are posted before the current line may change the base.
  • Extended Column View

    Click on the action to switch to the extended or reduced column view. In the journals of NCCA Cost Accounting some fields and actions (depending on e.g. the setting in the journal name or the Cost Accounting Setup) are automatically displayed or hidden. In addition, this action gives you the option to choose a simpler display or to show only the most important fields. Fields such as Work Type, Quantity and Unit of Measure Code are hidden in the simpler display. The settings are saved for each user and journal.
  • Renumber Document Numbers

    Resorts the numbers in the Document No. column. The action corresponds to the action from the General Journals. For more information, see [Microsoft Docs] To renumber document numbers in journals

Docs  /  NCCA Cost Accounting  /  Journals  /  Allocations
Allocation Distribution

In the Allocation Distribution area, the debit is specified. Depending on the settings in the Distribution Type field, different fields are displayed in the allocation distribution. More information will follow soon.

Fields

The following fields are available for all Distribution Types.
Debit Cost Type CodeSpecifies the Cost Type for the Debit entries. By specifying an equal sign, the value can be inherited from the Credit (or Allocation Base) entries. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
Debit Cost Dimension CodesSpecifies the cost dimensions for the Debit entries. By specifying an equal sign, the value can be inherited from the Credit (or Allocation Base) entries. If a * (Asterisk) is specified, allocation distributions will be automatically generated for all cost dimension values during posting. If a *+ is specified, an additional Blank Value is inserted. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
Line No.Specifies the line number.

Distribution Type Fixed Ratio, Fields

Fixed RatioSpecifies the distribution ratio.
Fixed Ratio %Specifies the percentage of the distribution ratio.

Distribution Type Amount Reference and Quantity Reference, Fields

Reference Ledger Entry TypeSpecifies whether cost entries or cost budget entries should be used to calculate the distribution ratio.
Reference Budget NameSpecifies from which budget the entries should be used to calculate the distribution ratio, if the reference is a budget.
Reference Cost Type FilterSpecifies a filter to determine which entries should be used to calculate the distribution ratio. By specifying an equal sign, the value can be inherited from the Debit entries. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
Reference Cost Dimension FiltersSpecifies filters to determine which entries should be used to calculate the distribution ratio. By specifying an equal sign, the value can be inherited from the Debit entries. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
Reference FromSpecifies a filter to determine which entries should be used to calculate the distribution ratio. If the field is empty, the Base From is used.
Reference ToSpecifies a filter to determine which entries should be used to calculate the distribution ratio. If the field is empty, the Base To date is used.
Reference Work Type FilterSpecifies a filter to determine which entries should be used to calculate the distribution ratio.

Actions

  • Asterisks Preview Posting

    If a * (asterisk) or *+ is specified in the Debit Cost Dimension Code fields, this action can be used to display a preview of all allocation distributions that will be automatically generated for the asterisks of the line during posting.
  • Unfold Asterisks

    Unfolds the asterisks of the current allocation distribution line and and thus replaces the automatic unfolding during posting. This replaces the asterisks by the cost dimension values and an allocation distribution line is created for each combination.<

Docs  /  NCCA Cost Accounting  /  Journals  /  Allocations
Calculation Details

More information will follow soon.

Fields

DescriptionSpecifies the description for the line.
AmountSpecifies the amount of the line.
%Specifies whether and if so, which percentage was used to calculate the Amount.
Distribution RatioSpecifies the distribution ratio that was used to calculate the debit amount.
Ratio automatically setSpecifies whether the distribution ratio has been automatically set to 1. This happens when all ratios of the distribution of an allocation are 0.
Ratio is 0Specifies whether the distribution ratio is 0. The field is set only if the distribution ratio is 0 after calculating the allocation.

Note

By default, a filter is set on the field when the page is opened.
Cost Type CodeSpecifies the Cost Type that the entry has been or will be posted to. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
Cost Dimension CodesSpecifies the cost dimension values that the entry has been or will be posted to. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
Work Type CodeSpecifies the work type of the entry.
Ledger Entry No.Specifies the number of the entry that was used for the calculation.
Ledger Entry TypeSpecifies the type of the entry that was used for the calculation or that will be posted.
Allocation by Transaction No.Specifies the Transaction No. of the allocation that marked the entry. If the field Specifies a number, the entry will no longer be used as a basis in further allocations.
Transaction No.Specifies the transaction number assigned to all the entries involved in the same transaction.
Journal Line No.Specifies to which journal line the line belongs to.
Iteration StepSpecifies to which iteration step the line belongs to.
Allocation Base No.Specifies to which allocation base the line belongs to within the journal line and iteration step.
Debit No.Specifies to which debit the line belongs to within the allocation base.
TypeSpecifies the line type.

Actions

  • Ledger Entry

    View the ledger entry.
  • Show Totals

    Displays a message with the totals for the selected or filtered lines.

Docs  /  NCCA Cost Accounting  /  Journals  /  Extended
Posting Preview

The Posting Preview shows a preview of all entries that will be created when posting the journal. For Allocations, the calculation details are also displayed in the posting preview. The preview is available in the following journals:

Fields

DescriptionSpecifies the description of the preview data.
No. of RecordsSpecifies the number of the preview data.

Actions

  • Show Records

    View the preview data.

Docs  /  NCCA Cost Accounting  /  Journals  /  Extended
Cost Registers

The NCCA Cost Registers page displays the history of all postings. An entry is created in the cost register for each posting in the NCCA Cost Accounting. Entries in a cost register may originate as follows:
  • Journal Posting
  • G/L Entry Transfer
  • Calc. FA Entry Transfer
  • Date Compression
  • Reversal

Fields

No.Specifies the number of the cost register.
Creation DateSpecifies the date when the entries in the cost register were posted.
Creation TimeSpecifies the time when the entries in the cost register were posted.
User IDSpecifies the ID of the user who posted the entry.
Source CodeSpecifies the source code for the entries in the cost register.
Source TypeSpecifies the source type for the entries in the cost register.
Calculation Details ExistsSpecifies if there are allocation calculation details for the entries in the cost register.
Journal Batch NameSpecifies the name of the journal that the entries were posted from.
From Cost Entry No.Specifies the first cost entry number in the cost register.
To Cost Entry No.Specifies the last cost entry number in the cost register.
ReversedSpecifies if the register has been part of a reverse transaction (correction) made by the Reverse function.
Reversed by Register No.Specifies the number of the correcting register. If the field Specifies a number, the register cannot be reversed again.
Reversed Register No.Specifies the number of the original register that was undone by the reverse transaction.

Actions

  • Cost Entries

    View the cost entries that resulted in the current cost register entry.
  • Source Entries

    View the source entries for the cost entries in the current cost register entry. Source entries only exist for G/L Entry Transfers and Calc. FA Entry Transfers. For more information, see Entry Transfer, G/L Entry Transfer and Entry Transfer, Calculatory FA Entry Transfer.
  • Calculation Details

    View the allocation calculation details for the cost entries in the current cost register entry. Calculation details only exist for Allocations. For more information, see Journals, Allocations, Calculation Details.
  • Delete Calculation Details

    Deletes the allocation calculation details for the cost entries so that they take up less space in the database.
  • Print

    Prepare to print the Cost Register. A report request window opens where you can specify what to include on the print-out.
  • Reverse Cost Register

    Reverses entries that were incorrectly posted from a journal line or from a previous reversal. For more information, see Journals, Extended, Reversal.

Docs  /  NCCA Cost Accounting  /  Journals  /  Extended
Cost Entries

The NCCA Cost Entries page displays the history of all postings in the NCCA Cost Accounting.

Fields

Cost Type CodeSpecifies the Cost Type that the entry has been posted to. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
Cost Dimension CodesSpecifies the cost dimension values that the entry has been posted to. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
Posting DateSpecifies the entry's posting date.
Document No.Specifies the entry's document no.
DescriptionSpecifies the description of the cost entry.
AmountSpecifies the amount of the cost entry.
Debit AmountSpecifies the debit amount of the cost entry.
Credit AmountSpecifies the credit amount of the cost entry.
Work Type CodeSpecifies the work type of the cost entry. For more information, see Chart of Cost Types & Chart of Cost Dimensions, Work Types.
QuantitySpecifies the quantity that was posted on the cost entry.
Unit of Measure CodeSpecifies the unit of measure of the cost entry. For more information, see Chart of Cost Types & Chart of Cost Dimensions, Unit of Measures.
PriceSpecifies the price of one unit on the cost entry.
User IDSpecifies the ID of the user who posted the entry.
Source CodeSpecifies the source code that specifies where the entry was created. For more information, see Setup, Source Codes.
Source TypeSpecifies the source type for the entry.
Journal Batch NameSpecifies the name of the journal where the entry was posted from.
Reason CodeSpecifies the reason code, a supplementary source code that enables you to trace the entry.
ReversedSpecifies if the entry has been part of a reverse transaction (correction) made by the Reverse function.
Reversed by Entry No.Specifies the number of the correcting entry. If the field Specifies a number, the entry cannot be reversed again.
Reversed Entry No.Specifies the number of the original entry that was undone by the reverse transaction.
Posting TypeSpecifies the type of transaction.
Allocation by Transaction No.Specifies the Transaction No. of the allocation that marked the entry. If the field Specifies a number, the entry will no longer be used as a basis in further allocations.
Transaction No.Specifies the transaction number assigned to all the entries involved in the same transaction.
Entry No.Specifies the number assigned to the entry.

Actions

  • Source Entries

    View the source entries for the cost entry. Source entries only exist for G/L Entry Transfers and Calc. FA Entry Transfers. For more information, see Entry Transfer, G/L Entry Transfer and Entry Transfer, Calculatory FA Entry Transfer.
  • Show Totals

    Displays a message with the totals for the selected or filtered entries.
  • Find entries...

    Find entries and documents that exist for the document number and posting date on the selected document.
  • Reverse Transaction

    Reverses the posted cost entry or transaction. For more information, see Journals, Extended, Reversal.

Docs  /  NCCA Cost Accounting  /  Journals  /  Extended
Reversal

More information will follow soon.

Reverse Entry Transfer

For more information, see Entry Transfer, Reverse Transfer.

Docs  /  NCCA Cost Accounting  /  Budget  /  General
Cost Budgets

More information will follow soon.

Fields

NameSpecifies the name of the cost budget.
DescriptionSpecifies a description of the cost budget.
Allow Modifications FromSpecifies the earliest date on which modifications in the cost budget are allowed.
Allow Modifications ToSpecifies the last date on which modifications in the cost budget are allowed.
BlockedSpecifies whether the cost budget is blocked. A blocked cost budget can not be changed.
Use Service Allocation PricesSpecifies whether the service allocation prices should be used or proposed. For more information, see Journals, Service Allocations, Service Allocation Prices.
Allowed ValuesSpecifies whether amounts, quantities or both can be specified in the cost budget.
Cost Dimension SpecificationsSpecifies whether, and if so, which cost dimensions must be specified in the budget (Mandatory) and which cost dimensions must not be specified (Not allowed). If no specification is selected, the specification of the cost dimension in the budget is optional. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.

Actions

Docs  /  NCCA Cost Accounting  /  Budget  /  General
Cost Budget Entries

More information will follow soon.

Fields

Budget NameSpecifies the name of the cost budget that the entry belongs to.
DateSpecifies the date of the cost budget entry.
Cost Type CodeSpecifies the Cost Type that the cost budget entry applies to. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
Cost Dimension CodesSpecifies the cost dimension values that the cost budget entry applies to. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
Document No.Specifies the entry's document no.
DescriptionSpecifies a description of the cost budget entry.
AmountSpecifies the amount of the cost budget entry.
Work Type CodeSpecifies the work type. For more information, see Chart of Cost Types & Chart of Cost Dimensions, Work Types.
QuantitySpecifies the quantity.

Note

Quantities can only be specified with a Unit of Measure Code.
Unit of Measure CodeSpecifies the Unit of Measure Code of the Cost Type. For more information, see Chart of Cost Types & Chart of Cost Dimensions, Unit of Measures.
PriceSpecifies the price of one unit.
Last Modified By UserSpecifies the user who made the last change to the entry.
Last Date ModifiedSpecifies when the entry was last modified.
Source CodeSpecifies the source code that specifies where the entry was created. For more information, see Setup, Source Codes.
Reason CodeSpecifies the reason code, a supplementary source code that enables you to trace the entry.
Posting TypeSpecifies the type of transaction from the Budget Journal.
Transaction No.Specifies the transaction number assigned to all the entries involved in the same transaction.
Entry No.Specifies the number assigned to the entry.

Actions

  • Show Totals

    Displays a message with the totals for the selected or filtered entries.

Docs  /  NCCA Cost Accounting  /  Budget  /  Journals
Cost Budget Journals

More information will follow soon.

Fields

Budget NameSpecifies the name of the journal budget.
DateSpecifies the entry''s date. The date is always automatically set to a start date of a period, depending on the field Period.
Document No.Specifies the number of the related document.
Posting TypeSpecifies whether to add the amount and the quantity of the journal line to the existing budget of the selected cost dimensions, or to replace the existing budget with the entered values.
Cost Type CodeSpecifies the Cost Type for the entry. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
Cost Dimension CodesSpecifies the cost dimension values for the entry. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
DescriptionSpecifies a description for the entry.
Work Type CodeSpecifies the work type. For more information, see Chart of Cost Types & Chart of Cost Dimensions, Work Types.
QuantitySpecifies the quantity.

Note

Quantities can only be posted with a Unit of Measure Code.
Unit of Measure CodeSpecifies the Unit of Measure Code of the Cost Type. For more information, see Chart of Cost Types & Chart of Cost Dimensions, Unit of Measures.
PriceSpecifies the price of one unit.
AmountSpecifies the total amount that the journal line consists of.
Reason CodeSpecifies the reason code, a supplementary source code that enables you to trace the entries.
Line No.Specifies the line number.

Actions

  • Post

    Finalize the journal by posting the amounts and quantities to the cost dimensions.
  • Preview Posting

    Displays a preview of all entries that will be created when posting the journal. For more information, see Journals, Extended, Posting Preview.
  • Test Report

    View a test report so that you can find and correct any errors before you perform the actual posting of the journal.
  • Cost Entries

    View the history of transactions that have been posted for the Cost Type.
  • Cost Budget Entries

    View the cost budget entries of the Cost Type.
  • Extended Column View

    Click on the action to switch to the extended or reduced column view. In the journals of NCCA Cost Accounting some fields and actions (depending on e.g. the setting in the journal name or the Cost Accounting Setup) are automatically displayed or hidden. In addition, this action gives you the option to choose a simpler display or to show only the most important fields. Fields such as Work Type, Quantity and Unit of Measure Code are hidden in the simpler display. The settings are saved for each user and journal.
  • Import from Excel

    Import journal lines from an Excel file. For more information, see Budget, Journals, Import Cost Budget Journal.
  • Create Excel Workbook for Import

    Creates an Excel workbook that can be used as a template for importing journal lines.
  • Import from File

    Import journal lines from a file.

Docs  /  NCCA Cost Accounting  /  Budget  /  Journals
Import Cost Budget Journal

In the Cost Budget Journal, journal lines can be imported from a file (action Import from File) or from an Excel file (action Import from Excel). This can be used, for example, to transfer postings from other systems.

File structure

The field separator is assumed to be tab when importing from a file. A header line (e.g. line with field names) is not allowed when importing from a file. However, the Excel sheet can optionally contain a header row. In this case you will get a hint when importing the Excel file and you can import the data starting from the 2nd row.

Tip

The Create Excel Workbook for Import action in the Journals can be used to create an Excel workbook that can be used as a template for importing journal lines.

Field order

  1. Date
  2. Document No.
  3. Cost Type Code
  4. Work Type Code
  5. Quantity
  6. Price
  7. Amount
  8. Description
  9. Reason Code
  10. Cost Dimension 1 Code
  11. Cost Dimension 2 Code
  12. Cost Dimension 3 Code
  13. Cost Dimension 4 Code
  14. Cost Dimension 5 Code
  15. Cost Dimension 6 Code
  16. Cost Dimension 7 Code
  17. Cost Dimension 8 Code

Note

If Price and Quantity are specified in the file, the amount is determined automatically. In this case, the amount is read from the file only if the quantity times the price is 0.

Docs  /  NCCA Cost Accounting  /  Budget  /  Extended
Cost Budget Registers

The NCCA Cost Budget Registers page displays the history of all budget postings. An entry is created in the cost budget register for each budget posting in the NCCA Cost Accounting. Entries in a cost budget register may originate as follows:
  • Budget Journal Posting
  • Date Compression

Fields

No.Specifies the number of the cost budget register.
Creation DateSpecifies the date when the entries in the cost budget register were posted.
Creation TimeSpecifies the time when the entries in the cost budget register were posted.
User IDSpecifies the ID of the user who posted the entry.
Source CodeSpecifies the source code for the entries in the cost budget register.
Source TypeSpecifies the source type for the entries in the cost budget register.
Budget NameSpecifies the name of the cost budget that the entries belongs to.
From Cost Budget Entry No.Specifies the first cost budget entry number in the cost budget register.
To Cost Budget Entry No.Specifies the last cost budget entry number in the cost budget register.

Actions

  • Cost Budget Entries

    View the cost budget entries that resulted in the current cost budget register entry.
  • Print

    Prepare to print the Cost Budget Register. A report request window opens where you can specify what to include on the print-out.

Docs  /  NCCA Cost Accounting  /  Reports and Analysis  /  Edit Evaluations
Edit Evaluation

In NCCA Cost Accounting, Evaluations and the Ad Hoc Evaluation are available.
  • Evaluations

    Evaluations are permanently stored with a specific code.
  • Ad Hoc Evaluation

    The ad hoc evaluation is used to create an evaluation spontaneously from a situation. An ad hoc evaluation can also be saved as an evaluation or loaded from an existing evaluation at any time. The settings can then be changed in the ad hoc evaluation without affecting the actually saved evaluation. The ad hoc evaluation is user related, so each user has their own ad hoc evaluation. The current ad hoc evaluation settings are retained when the page is closed.
Basically, Evaluations and Ad Hoc Evaluations are structured identically, i.e. technically speaking, the ad hoc evaluation is also an evaluation. There are differences only in the General, Fields and in the Actions (ad hoc evaluations cannot be archived, for example). On the NCCA Evaluation Card page or the NCCA Ad Hoc Evaluation page, the general settings of the evaluation (or ad hoc evaluation) and its lines and columns are set up.

General, Fields

In the General area, general settings for the evaluation are defined. A checkmark ( ) in the Ad Hoc column indicates whether the field is also available in the ad hoc evaluation.
 Ad Hoc 
Code-Specifies the code for the evaluation.
Description-Specifies a description for the evaluation.
Current Date Filter Calc. DateSpecifies a date that should currently be suggested as Date Filter Calculation Date when the evaluation is executed. The date is recalculated each time the page is opened and is not saved.

Note

It is possible to specify IDs (placeholders) in date filters that will be calculated and replaced based on the Date Filter Calculation Date when the evaluation is executed. A list of Date Filter ID examples can be opened via the lookup of the field. For more information, see Reports and Analysis, Edit Evaluations, Date Filter IDs.
Date Filter Calc. Date FormulaSpecifies a date formula for the Date Filter Calculation Date.
Fixed Date Filter Calc. DateSpecifies a fixed date that should be suggested as the Date Filter Calculation Date when the evaluation is executed.
Default Action-Specifies how the evaluation should be executed by default.
Add to FactBox pane-Specifies whether the evaluation should be displayed in the FactBox pane of the Chart of Cost Dimensions. For more information, see Chart of Cost Types & Chart of Cost Dimensions, Chart of Cost Types & Chart of Cost Dimensions.
Archive Size-Specifies whether there should only be a certain maximum number of archive entries for the evaluation. If the evaluation is archived and the value is exceeded, the oldest entries in the archive are deleted.
No. of Archive Entries-Specifies the number of archive entries for the evaluation. For more information, see Reports and Analysis, Execute Evaluations, Evaluation Archive.
Date Modified-Specifies when the evaluation was last modified.
Modified By-Specifies the user ID of the person who last modified this evaluation.
Change Protection-Specifies whether the settings of the evaluation may be changed.

Tip

Activate the protection for finished evaluations to protect them from accidental changes.

Lines / Columns

The layout or the structure of the lines and columns of an evaluation is defined by the Line Definition and by the Column Definition. Both the line definition and the column definition can be built as a tree structure. This makes it possible to define complex, nested evaluations with so-called Dimension Loops. By default, a simple cost type list is already suggested when creating a new evaluation. This evaluation can be executed immediately and shows the basic operation of a dimension loop.

Line Definition

The Line Definition field displays information about the first line from the line definition of the evaluation. If more than one definition line is set up, the number of lines is shown in brackets. By default, when creating a new evaluation, a dimension loop of type Cost Type is suggested. The following symbols are displayed or used in the line information:
  • Indicates that a loop is started in which the values of the dimension are run through.
  • Indicates that the line will be unfolded or replaced by other lines when the evaluation is executed.
Click on the field to view or edit the line definition. For more information, see Reports and Analysis, Edit Evaluations, Line Definition.

Line Display Options

The following fields define the default settings for lines when the evaluation is executed. If you change the options later when executing the evaluation, it will not affect the existing or saved evaluation, but only the result of the currently created evaluation. For more information, see Reports and Analysis, Execute Evaluations, Execute Evaluation.
Show Line CodesSpecifies whether the codes of all levels (loops), the codes of the lowest level (loop) or no codes should be displayed in the evaluation.
Align Line Codes RightSpecifies whether the codes should be right aligned on the print-out.
Show Line FilterSpecifies whether the filters of the lines should be displayed in the evaluation.
Show IndentationSpecifies whether the indentation of the lines should be displayed in the evaluation.
Print Alternating ShadingSpecifies if you want every second row on the print-out to be shaded.
Splitted Excel SheetsSpecifies whether a new Excel Sheet should be inserted for each record in the parent main loop of the lines. The setting is ignored if there is no clear unique parent main loop.

Column Definition

The Column Definition field displays information about the first line from the column definition of the evaluation. If more than one definition line is set up, the number of lines is shown in brackets. By default, when creating a new evaluation, a column of the type Amount is suggested. The following symbols are displayed or used in the line information:
  • Indicates that a loop is started in which the values of the dimension are run through.
Click on the field to view or edit the column definition. For more information, see Reports and Analysis, Edit Evaluations, Column Definition.

Spalten nach Datum

If the Date View field is enabled, the column definition will be displayed for different time periods when the evaluation is executed. The Date View by field specifies the time period after which values should be displayed in the evaluation.

Column Display Options

The following fields define the default settings for columns when the evaluation is executed. If you change the options later when executing the evaluation, it will not affect the existing or saved evaluation, but only the result of the currently created evaluation. For more information, see Reports and Analysis, Execute Evaluations, Execute Evaluation.
Column HeaderSpecifies whether the codes, the names (or the Period for Date View), or both should be displayed in the column header of the evaluation.
Show Column FilterSpecifies whether the filters of the columns should be added to the column header of the evaluation.
Show ErrorsSpecifies whether error information (e.g. Division by Zero) should be displayed on the print-out or in Excel.

Filter, Fields

In the Filter area, general filters for the evaluation are defined. These filters affect the entire evaluation and thus also additionally restrict filters that are set in the lines and columns.
Date FilterSpecifies a filter that will be used to filter the values.

Note

It is possible to specify IDs (placeholders) in date filters that will be calculated and replaced based on the Date Filter Calculation Date when the evaluation is executed. A list of Date Filter ID examples can be opened via the lookup of the field. For more information, see Reports and Analysis, Edit Evaluations, Date Filter IDs.
Cost Type FilterSpecifies a filter that will be used to filter or calculate the values. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
Cost Dimension FiltersSpecifies filters that will be used to filter or calculate the values. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
Work Type FilterSpecifies a filter that will be used to filter or calculate the values.
Budget FilterSpecifies a filter that will be used to filter or calculate the values.

Actions

Ad-hoc-Auswertung, additional Actions

  • Save as

    Saves the current settings of the ad hoc evaluation in a new evaluation or replaces an existing evaluation.
  • Load

    Apply the settings from a saved evaluation. The settings can be changed in the ad hoc evaluation without affecting the actually saved evaluation.
  • Reset

    Resets all settings (filter, line definition, column definition, etc.) of the ad hoc evaluation.

Docs  /  NCCA Cost Accounting  /  Reports and Analysis  /  Edit Evaluations
Line Definition

Here you can set up the lines of the evaluation. Via the Add action line definition lines can be added. Depending on the selected line from which the action is called, different options are available. More information will follow soon.

Fields

Dimension/LineDisplays information about the line definition line. The symbol indicates that this is a dimension loop in which the values of the dimension are run through. The indentation displayed here has no influence on the display of the evaluation result or the indentation of the lines and is only used to show the structural design of the line scheme. The line type or the dimension of a loop can be changed by clicking on the field.
CodeSpecifies a code that can be displayed in the evaluation line.
IndentationSpecifies the indentation of the description. For dimension loops, the indentation is ignored when the evaluation is executed.
Indentation from Cost Dim. ValueSpecifies whether to use the indentation setting from the cost dimension value. If the field is set on a dimension loop, everything within the loop is additionally indented by the indentation of the parent cost dimension value.
DescriptionSpecifies text that will appear on the line when the evaluation is executed. If no text is specified, the name of the current dimension value of the loop is displayed for value lines that are part of a dimension loop. It is possible to specify the placeholder %1 in the text, which will also be replaced by the name of the current dimension value of the loop. If Unfold Values is activated, the placeholder %2 can be used to output the names of the individual dimension values.
Formula IDSpecifies an ID that can be used to access the lines in formulas. In formulas, only lines from the same loop run and lines from the parent/subordinate loop can be accessed. Lines from higher/lower level loops can only be accessed via intermediate steps.
Value Filter/FormulaSpecifies which dimension values should be calculated or, in the case of a dimension loop, taken into account, or specifies a formula.
Group FilterSpecifies which dimension groups should be calculated or, in the case of a dimension loop, taken into account.
Value TypeSpecifies which dimension value types should be considered or calculated.
  • If no specification is selected, all types are considered.
  • The Standard option considers only the Standard type.
  • The Totals option considers the Heading, Total, Begin-Total and End-Total types.
Unfold ValuesSpecifies whether a single line should be output for each value within the Value Filter and/or Group Filter.
Column ReferenceSpecifies a column reference that is valid from this line within the loop and in all subordinate loops. The reference can then be accessed in the column definition with the operators % and =. The operator % calculates the percentage of the column amount related to the line amount. The = operator can be used to access the line amount directly. The reference can be set in a line of Type Text and thus reset to 0. Any number of column references can be specified.
Line Controlled Column TypeSpecifies which value to calculate in line controlled columns. By default, the individual columns themselves determine what or which values are calculated. For columns of the type Line Controlled it is the other way round. Here the line determines which value is calculated in the column. For more information, see Reports and Analysis, Edit Evaluations, Line Controlled Column Type.
Show Opposite SignSpecifies whether the sign of the result in this line should be reversed.
BoldSpecifies whether to print the line in bold or not. If no specification is selected, the actual bold setting from the cost dimension value will be used.
ItalicSpecifies whether to print the line in italics.
UnderlineSpecifies whether to underline the entire line or only the result area (column area) of the line when printing.
Align RightSpecifies whether to print the description right aligned.
Line Without ShadingSpecifies whether to turn off the automatic shading for this line on the print-out.
ShowSpecifies whether the line should be displayed. The If Any Column Not Zero option is only considered by the print-out and when exporting to Excel.
Blank Line and Page BreakSpecifies whether a blank line should be inserted before or after the current line or whether a page break should occur before the current line.
FilterView or set up the filters that will be used to calculate the values.
Date FilterSpecifies a filter that will be used to calculate the values.

Note

It is possible to specify IDs (placeholders) in date filters that will be calculated and replaced based on the Date Filter Calculation Date when the evaluation is executed. A list of Date Filter ID examples can be opened via the lookup of the field. For more information, see Reports and Analysis, Edit Evaluations, Date Filter IDs.
Cost Type FilterSpecifies a filter that will be used to calculate the values. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
Cost Dimension FiltersSpecifies filters that will be used to calculate the values. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
Work Type FilterSpecifies a filter that will be used to calculate the values.
Budget FilterSpecifies a filter that will be used to calculate the values.
CommentSpecifies a comment.

Actions

  • Add

    Inserts a new line definition line. Depending on the selected line from which the action is called, different options are available.
  • Up / Down

    The position or the order of the lines can be changed with Up and Down.
  • Subordinate

    This action can be used to subordinate a line or a dimension loop to another dimension loop or to move it down one level.
  • Superordinate

    If a line or a dimension loop is subordinated to another dimension loop, this action can be used to remove the subordination or to move it up one level.
  • Copy

    Inserts a copy of the current line. Dimension loops cannot be copied.
  • Clear Filter

    Clears all filter fields of the selected lines.
  • Preview Layout

    Displays a preview of all lines and columns that will be created when executing the evaluation, without the results being calculated.

Docs  /  NCCA Cost Accounting  /  Reports and Analysis  /  Edit Evaluations
Column Definition

Here you can set up the columns of the evaluation. Via the Add action column definition lines can be added. Depending on the selected line from which the action is called, different options are available. More information will follow soon.

Fields

Dimension/ColumnDisplays information about the column definition line. The symbol indicates that this is a dimension loop in which the values of the dimension are run through. The indentation displayed here has no influence on the display of the evaluation result and is only used to show the structural design of the column definition. The column type or the dimension of a loop can be changed by clicking on the field.
HeaderSpecifies text that will be added to the column header. If no text is specified, the type of column will be added.
Formula IDSpecifies an ID that can be used to access the columns in formulas. In formulas, only columns from the same loop run and columns from the parent/subordinate loop can be accessed. Columns from higher/lower level loops can only be accessed via intermediate steps.
Value Filter/FormulaSpecifies which dimension values are to be taken into account in a dimension loop, or specifies a formula. Formula: If a Column Reference is specified in the Line Definition, the reference can be accessed with the % and = operators. The operator % calculates the percentage of the column amount related to the line amount. The = operator can be used to access the line amount directly.
Group FilterSpecifies which dimension groups are to be taken into account in a dimension loop.
Value TypeSpecifies which dimension value types should be considered or calculated in a dimension loop. In contrast to the evaluation lines, only values of the type Standard, Total and End-Total can be displayed in the columns.
  • If no specification is selected, the Standard, Total and End-Total types are considered.
  • The Standard option considers only the Standard type.
  • The Totals option considers the Total and End-Total types.
Rounding FactorSpecifies the factor that should be used to round the result in this column.
Show Opposite SignSpecifies whether the sign of the result in this column should be reversed.
Value Calculation (Date View)Specifies how values are calculated in the column when the Date View is activated in the evaluation.
  • In case of Net Change, the net change within the selected period is calculated.
  • In case of Year to Date, the balance on the last day in the selected period is calculated and the the totalized value is reset to 0 each time the fiscal year changes.
The field is displayed only if the date view is enabled in the evaluation.
Date Formula (Date View)Specifies a date formula that can be used to influence or change the date filter set by the Date View for this column. The field is displayed only if the date view is enabled in the evaluation.
BoldSpecifies whether to print the column in bold or not. If no specification is selected, the actual bold setting from the values will be used.
ItalicSpecifies whether to print the column in italics.
Parting Line LeftSpecifies whether to print a parting line to the left of the entire column or only in the result area (line area) of the column.
Parting Line RightSpecifies whether to print a parting line to the right of the entire column or only in the result area (line area) of the column.
ShowSpecifies whether the column should be displayed.
FilterView or set up the filters that will be used to calculate the values.
Date FilterSpecifies a filter that will be used to calculate the values.

Note

It is possible to specify IDs (placeholders) in date filters that will be calculated and replaced based on the Date Filter Calculation Date when the evaluation is executed. A list of Date Filter ID examples can be opened via the lookup of the field. For more information, see Reports and Analysis, Edit Evaluations, Date Filter IDs.
Cost Type FilterSpecifies a filter that will be used to calculate the values. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
Cost Dimension FiltersSpecifies filters that will be used to calculate the values. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
Work Type FilterSpecifies a filter that will be used to calculate the values.
Budget FilterSpecifies a filter that will be used to calculate the values.
CommentSpecifies a comment.

Actions

  • Add

    Inserts a new column definition line. Depending on the selected line from which the action is called, different options are available.
  • Up / Down

    The position or the order of the columns can be changed with Up and Down.
  • Subordinate

    This action can be used to subordinate a column or a dimension loop to another dimension loop or to move it down one level.
  • Superordinate

    If a column or a dimension loop is subordinated to another dimension loop, this action can be used to remove the subordination or to move it up one level.
  • Copy

    Inserts a copy of the current line. Dimension loops cannot be copied.
  • Clear Filter

    Clears all filter fields of the selected columns.
  • Preview Layout

    Displays a preview of all lines and columns that will be created when executing the evaluation, without the results being calculated.

Docs  /  NCCA Cost Accounting  /  Reports and Analysis  /  Edit Evaluations
Line Controlled Column Type

By default, the individual columns of the Column Definition of an evaluation determine which values are calculated. For example, for columns of type Amount, the amount is calculated for each line of the Line Definition, and for column type Quantity, the quantity is calculated. For columns of the type Line Controlled it is the other way round. Here the individual lines of the Line Definition determine which values are calculated in the column. The column can therefore display amounts and quantities. Via the Line Controlled Column Type field in the Line Definition it is possible to specify for each line which value should be calculated in the column.

Docs  /  NCCA Cost Accounting  /  Reports and Analysis  /  Edit Evaluations
Date Filter IDs

For date filters, IDs (placeholders) can be specified in square brackets [ ] that will be calculated and replaced based on the Date Filter Calculation Date when the evaluation is executed. Basically, the IDs are date formulas. However, the English date formulas are always used, e.g.: D (Day). The advantage over date formulas is that several date values (e.g. a date interval) can be specified combined in one filter. As Date Filter Calculation Date the Work Date is suggested. The suggested date can be additionally modified via the Date Filter Calculation Date Formula of the evaluation. Date Filter IDs can be used, for example, to set up evaluations where the date filter is automatically set to the current month when the evaluation is executed. The following IDs are available:
  • D Day
  • WD Weekday
  • W Week
  • M Month
  • Q Quarter
  • Y Year
  • C meaning 'current' and can be specified as a prefix of an ID
A list of Date Filter ID examples can be opened via the lookup of the date filter field.

Examples

The following table shows some examples of Date Filter ID combinations and their results when the Work Date or the Date Filter Calc. Date is set to 06/30/2020.
ExampleResultComment
[CD]06/30/20Date Filter Calc. Date
..[CD]..06/30/20Until Date Filter Calc. Date
01/01/20..[CD]01/01/20..06/30/2001/01/20 until Date Filter Calc. Date
..[-CM-1D]..05/31/20Until the end of last month (based on the Date Filter Calc. Date)
   
[-CM]..[CM]06/01/20..06/30/20Current Month
[-CM-1M]..[-CM-1D]05/01/20..05/31/20Last Month
[-CM-2M]..[-CM-1M-1D]04/01/20..04/30/202 months ago
[-CM-3M]..[-CM-2M-1D]03/01/20..03/31/203 months ago
[-CY]..[-CY+1M-1D]01/01/20..01/31/20January of the current year
[-CY+1M]..[-CY+2M-1D]02/01/20..02/29/20February of the current year
   
[-CY]..[CY]01/01/20..12/31/20Current Year
[-CY-1Y]..[CY-1Y]01/01/19..12/31/19Last Year
[-CY-2Y]..[CY-2Y]01/01/18..12/31/182 years ago
[-CY-2Y]..[CY]01/01/18..12/31/20The last 3 years
   
[-CQ]..[CQ] 04/01/20..06/30/20Current Quarter
[-CQ-1Q]..[-CQ-1D]01/01/20..03/31/20Last Quarter
[-CQ-2Q]..[-CQ-1Q-1D]10/01/19..12/31/192 quarters ago
[-CY]..[-CY+1Q-1D]01/01/20..03/31/20The first quarter of the current year
[-CY+1Q]..[-CY+2Q-1D]04/01/20..06/30/20The second quarter of the current year
[-CY+2Q]..[-CY+3Q-1D]07/01/20..09/30/20The third quarter of the current year
[-CY+3Q]..[CY]10/01/20..12/31/20The fourth quarter of the current year

Docs  /  NCCA Cost Accounting  /  Reports and Analysis  /  Edit Evaluations
Copy Evaluation

Via this action, a copy of the evaluation can be created.

Copy from

CodeSpecifies the code of the existing evaluation to copy from.
DescriptionSpecifies the description of the existing evaluation.

Copy to

CodeSpecifies the code for the new evaluation.
Code already ExistsSpecifies whether an evaluation with the code already exists. An additional confirmation is necessary for replacing an evaluation.
DescriptionSpecifies a description for the new evaluation.

Docs  /  NCCA Cost Accounting  /  Reports and Analysis  /  Execute Evaluations
Execute Evaluation

Via the actions Execute, Show Matrix, Print and Export to Excel an evaluation can be executed.

Execute

Executes the evaluation with the action specified in the Default Action field of the evaluation.

Show Matrix

Displays the result of the evaluation in a matrix.
  • Fields

    CodesSpecifies the Codes for the line. The Show Line Codes field of the evaluation determines whether and if so, which codes are displayed here.
    DescriptionSpecifies the description for the line.
    FilterSpecifies the filters for the line.
    Column 1 to Column 12Displays the column value for the line cost dimension value. Click on the field to perform the currently specified Click Action.

    Actions

    • Period

      Go to the previous/next period. The action is displayed only if the Date View of the evaluation is enabled.
    • Set

      Go to the previous/next set of data.
    • Column

      Go to the previous/next column.
    • Click Action

      Click the action to specify which action should be performed when you click the results.
      • Open with Filters This opens the Chart of Cost Dimensions for the cost dimension of the line with the corresponding filters of the line/column.
      • Show Filters All filters (including all hidden and overlapping filters) that were used to calculate the result are displayed in a message.
    • Print

      Prepare to print the evaluation. A report request window opens where you can specify what to include on the print-out.
    • Export to Excel

      Export the data in a new Excel workbook according to the selected filters and options. This creates an Excel workbook on your device.

Print

Prepare to print the evaluation. A report request window opens where you can specify what to include on the print-out.

Note

If it is not an ad hoc evaluation, the action can also be scheduled. The following applies for scheduling:
  • As soon as the evaluation has been created, a message appears in the Report Inbox. The evaluation can then be opened directly via the Report Inbox.
  • Options

    Note

    If you change the options when printing, this does not affect the existing or saved evaluation, but only the result of the evaluation currently being created.
    Evaluation CodeSpecifies which evaluation should be printed.
    DescriptionSpecifies a description for the report.
    Date Filter Calc. DateSpecifies the date for calculating the IDs (placeholders) of the date filters. For more information, see Reports and Analysis, Edit Evaluations, Date Filter IDs.

    Lines

    Show Line CodesSpecifies whether the codes of all levels (loops), the codes of the lowest level (loop) or no codes should be displayed in the evaluation.
    Align Line Codes RightSpecifies whether the codes should be right aligned on the print-out.
    Show Line FilterSpecifies whether the filters of the lines should be displayed in the evaluation.
    Show IndentationSpecifies whether the indentation of the lines should be displayed in the evaluation.
    Print Alternating ShadingSpecifies if you want every second row to be shaded.

    Columns

    Column View bySpecifies by which period values should be displayed in the evaluation when the Date View is activated.
    Column HeaderSpecifies whether the codes, the names (or the Period for Date View), or both should be displayed in the column header of the evaluation.
    Show Column FilterSpecifies whether the filters of the columns should be added to the column header of the evaluation.
    Show ErrorsSpecifies whether error information (e.g. Division by Zero) should be displayed.

    Filter

    Date FilterSpecifies a filter that will be used to filter the values. It is possible to specify parameters in date filters, which will be converted when the evaluation is executed based on a calculation date. The calculation date is suggested based on the Work Date and the Date Filter Calc. Date Formula.
    Cost Type FilterSpecifies a filter that will be used to filter or calculate the values. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
    Cost Dimension FiltersSpecifies filters that will be used to filter or calculate the values. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
    Work Type FilterSpecifies a filter that will be used to filter or calculate the values.
    Budget FilterSpecifies a filter that will be used to filter or calculate the values.

Export to Excel

Export the data in a new Excel workbook according to the selected filters and options. This creates an Excel workbook on your device.

Note

If it is not an ad hoc evaluation, the action can also be scheduled. The following applies for scheduling:
  • As soon as the Excel workbook has been created, a message appears in the Report Inbox. The Excel workbook can then be opened directly via the Report Inbox.
  • Options

    Note

    If you change the options when exporting, this does not affect the existing or saved evaluation, but only the result of the evaluation currently being created.
    Evaluation CodeSpecifies which evaluation should be exported.
    DescriptionSpecifies a description for the report.
    Date Filter Calc. DateSpecifies the date for calculating the IDs (placeholders) of the date filters. For more information, see Reports and Analysis, Edit Evaluations, Date Filter IDs.

    Lines

    Show Line CodesSpecifies whether the codes of all levels (loops), the codes of the lowest level (loop) or no codes should be displayed in the evaluation.
    Show Line FilterSpecifies whether the filters of the lines should be displayed in the evaluation.
    Show IndentationSpecifies whether the indentation of the lines should be displayed in the evaluation.
    Splitted Excel SheetsSpecifies whether a new Excel Sheet should be inserted for each record in the parent main loop of the lines. The setting is ignored if there is no clear unique parent main loop.

    Columns

    Column View bySpecifies by which period values should be displayed in the evaluation when the Date View is activated.
    Column HeaderSpecifies whether the codes, the names (or the Period for Date View), or both should be displayed in the column header of the evaluation.
    Show Column FilterSpecifies whether the filters of the columns should be added to the column header of the evaluation.
    Show ErrorsSpecifies whether error information (e.g. Division by Zero) should be displayed.

    Filter

    Date FilterSpecifies a filter that will be used to filter the values. It is possible to specify parameters in date filters, which will be converted when the evaluation is executed based on a calculation date. The calculation date is suggested based on the Work Date and the Date Filter Calc. Date Formula.
    Cost Type FilterSpecifies a filter that will be used to filter or calculate the values. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup.
    Cost Dimension FiltersSpecifies filters that will be used to filter or calculate the values. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup.
    Work Type FilterSpecifies a filter that will be used to filter or calculate the values.
    Budget FilterSpecifies a filter that will be used to filter or calculate the values.

Docs  /  NCCA Cost Accounting  /  Reports and Analysis  /  Execute Evaluations
Archive Evaluation

Via this action, an evaluation can be archived. This will execute calculate the evaluation and save the result in the archive. The action is not available for ad hoc evaluations.

Note

The action can also be scheduled. The following applies for scheduling:

Options

Evaluation CodeSpecifies which evaluation should be archived.
DescriptionSpecifies a description for the archived evaluation.
Archive CommentSpecifies a comment for the archived evaluation.
Date Filter Calc. DateSpecifies the date for calculating the IDs (placeholders) of the date filters. For more information, see Reports and Analysis, Edit Evaluations, Date Filter IDs.

Docs  /  NCCA Cost Accounting  /  Reports and Analysis  /  Execute Evaluations
Evaluation Archive

The NCCA Evaluation Archive page shows an overview of all archive entries of the evaluation and can be accessed directly from the evaluation. The evaluation archive is not available for ad hoc evaluations. For more information, see Reports and Analysis, Execute Evaluations, Archive Evaluation.

Fields

Evaluation CodeSpecifies the code of the archived evaluation.
DescriptionSpecifies the description of the archived evaluation.
Datumsfilter BerechnungsdatumZeigt das Datumsfilter Berechnungsdatum der archivierten Auswertung an.
Archive No.Specifies the number assigned to the archived evaluation.
Date ArchivedSpecifies the date when the evaluation was archived.
Time ArchivedSpecifies what time the evaluation was archived.
Archived BySpecifies the user ID of the person who archived this evaluation.
No. of Column ResultsSpecifies the number of the archived results.
Archive CommentSpecifies a comment for the archived evaluation.
Default ActionSpecifies which action should be executed by default.

Actions

Execute, Show Matrix, Print and Export to Excel in the evaluation archive basically correspond to the actions in the evaluation. However, with a few exceptions, the options can no longer be changed in the evaluation archive. For more information, see Reports and Analysis, Execute Evaluations, Execute Evaluation.

Note

If you click on the results in the evaluation matrix, the Chart of Cost Dimensions for the cost dimension of the line is opened with the corresponding filters of the line/column. The values in the Chart of Cost Dimensions are calculated or displayed based on the current cost entries. The result in the archived evaluation can therefore differ from the result in the Chart of Cost Dimensions.

Docs  /  NCCA Cost Accounting  /  Appendix
Date Compression

You can compress data in Business Central to save space in the database, which in Business Central online can even save you money. The compression is based on dates and works by combining several old entries into one new entry. You can compress Cost Entries and Cost Budget Entries under the following conditions:
  • They're from closed fiscal years.
  • The Open field is set to No. (Cost Entries)
  • They're at least five years old.
The amount in the new entry is the sum of all the compressed entries. The date assigned is the starting date for the period that is compressed, such as the first day of the month (if the entries are compressed by month). After the compression, you can still see the net change for each account in the previous fiscal year. The number of entries that result from a date compression depends on how many filters you set, which fields are combined, and which period length you choose. There will always be at least one entry. When the batch job is finished, you can see the result in the Date Compr. Registers page. When you are defining criteria for the compression, you can use the options under Retain Field Contents to keep the contents of certain fields. After the compression, the contents of the following fields are always retained:
  • Posting Date (Cost Entries)
  • Budget Name (Cost Budget Entries)
  • Date (Cost Budget Entries)
  • Cost Type
  • Cost Dimension (1 to 8)
  • Posting Type
  • Source Type
  • Work Type Code
  • Unit of Measure Code
Date compression creates new entries for the compressed entries.

Important

For Cost Entries applies:
  • The assignment of the G/L entries and the FA entries in the cost entries is not lost during date compression, but points to the new cost entries after compression.
  • It is not possible to reverse the date compression itself. If you reverse the entries created by date compression anyway, the compressed entries are treated as normal entries and will be reversed.

Warning

The Date compression deletes entries. We recommend that you create a backup of the database before you run the batch job.

To run a date compression

  1. Enter Data Administration in the search, and then choose the related link.
  2. Do one of the following:
    • To run compression for Cost Entries, select Date Compression, Compress Entries, and then NCCA Cost Entries from the actions.
    • To run compression for Cost Budget Entries, select Date Compression, Compress Entries, and then NCCA Cost Budget Entries from the actions.

    Tip

    The date compression can also be accessed from the Administration area of the NCCA Cost Accounting menu bar. For more information, see General, Role Center Integration.

    Options

    Starting DateSpecifies the date from which entries should be compressed. Compression affects all entries from this date to the ending date.
    Ending DateSpecifies the date to which entries should be compressed. Compression affects all entries from the starting date to this date.
    Period LengthSpecifies the time interval within entries should be combined into one entry. If you have selected the period length Quarter, Month or Week, only entries with a common accounting period will be summarized.
    Posting DescriptionSpecifies a description for the entries that are generated by the compression. The default description is Date Compressed.
    Document No.Specifies whether the entry's document no. should be retained.

Docs  /  NCCA Cost Accounting  /  Appendix
Reset Cost Accounting Data

The Reset Data action in the NCCA Cost Accounting Setup can be used to reset the NCCA Cost Accounting data. The data can be reset partially or completely.

Which data will be reset when 'Partially' option is selected?

The Partially reset option will delete all posted data in NCCA Cost Accounting. This means that all cost entries, cost budget entries, cost registers and journal lines in the NCCA Cost Accounting will be deleted. All relations between cost entries and possibly transferred G/L entries or FA entries will be reset as well.

Which data will be reset when the 'Complete' option is selected?

The Completely reset option deletes all data that is also deleted with Partially reset. In addition, all setup data of NCCA Cost Accounting will be deleted or removed. This means that all NCCA Cost Accounting fields will be reset and all data in the NCCA Cost Accounting will be completely deleted.

Note

The action can only be performed if the NCCA Allow Data Reset field is set for the user in the User Setup. So before a user can perform the action, the field must be set. The permission is valid once and is automatically removed after the action is called.

Warning

The reset deletes all posted data in NCCA Cost Accounting. Therefore, you should always make a backup copy of the database before performing the action.

Docs  /  NCCA Cost Accounting  /  Appendix
NAVAX License Management

The NAVAX License Management page (in older versions "NAVAX License Overview" or "NCEX License Overview") displays the current license status of the NAVAX extensions. In order for a NAVAX extension to be displayed in this page, the corresponding setup of the extension must first be opened.

Note

Changes as of Version xx.1.16.0 The NAVAX License Management page now supports automatic adding of NAVAX extensions. NAVAX extensions that use this system no longer need to have the corresponding extension setup opened first to be displayed in this page.

Fields

NameSpecifies the name of the Extension.
License StatusSpecifies the current license status of the Extension.
Serial No.Specifies the serial number of the Extension.
VersionSpecifies the currently installed version of the Extension.

Trial Version

A NAVAX extension can be tested or used free of charge for 30 days after installation. After that, the extension can only be used with a valid license.

Note

Changes as of Version xx.1.4.0 The licensing of a NAVAX extension is only necessary in the production environment. In the sandbox environment, NAVAX extensions can be tested unlimited.

Request License

The license can be requested or checked via the Current Status action (in older versions What's New?). This opens a window. The following example shows the NAVAX extension Excel Report Builder. Fill in the fields in the window and then click Send License Request. Please note that the licensing process may take some time. In the next few days you will receive an email with further information.

Note

For licensing, calling the online help and performing some actions, access to https://www.navax.app must be allowed.

Public IP from www.navax.app for setting firewall access:
94.136.22.236, Port: TCP/443

Checking the connection to https://www.navax.app using PS:
Test-NetConnection navax.app -port 443
(PS must be performed with the M-Tier service user)

Activate/Update License

As soon as the licensing has been completed, you will receive an email and the license can be activated via the Update License action. The license is company independent. So it does not matter in which company the action is called.

Note

  • The licence must be updated once a year via the Update License action.
  • The update is only possible or necessary within the last 30 days before the license expires, or afterwards. Within the last 30 days before the license expires, notes are displayed.
  • If the Automatic License Renewal is enabled, the Update License action is called automatically before the license expires. Note that the setting is only active after the license has been activated via the action.

Terms & Conditions

For more information, see https://www.navax.app/EULA.php?L=en

Data Security

For more information, see https://www.navax.app/privacyStatement.php?L=en

Submit Rating

This action can be used to open the Microsoft AppSource ratings page for the extension. We would be very happy if you submit your rating and let us know about your experience with the Extension.

Docs  /  NCCA Cost Accounting  /  Appendix
Installation Notes

Publish and Install the Extension


All necessary steps are described here:
[Microsoft Learn] Business Central - Publishing and Installing an Extension

Dependencies

On-Premises

The following Granules are required for an On-Premises installation:
  • 1001760 NCCA Cost Accounting by NAVAX
  • 1010860 Extension Base by NAVAX

External Addresses

  • https://www.navax.app

    For licensing, calling the online help and performing some actions, access to https://www.navax.app must be allowed.

    Public IP from www.navax.app for setting firewall access:
    94.136.22.236, Port: TCP/443

    Checking the connection to https://www.navax.app using PS:
    Test-NetConnection navax.app -port 443
    (PS must be performed with the M-Tier service user)

Docs  /  NCCA Cost Accounting  /  Appendix
Release Notes

Would you like to know what has changed in the extension?
Below you'll find an overview of the new features and changes made in the updates.

Version 21.2.3.0

as of Business Central 21
2024/03/01
  • Note

    This version is also available as a downgrade version for Business Central 20.
  • Modifications

    • The field captions in the Line Definition of the evaluation have been optimized.
      • The Filter/Totaling/Formula field has been renamed to Value Filter/Formula.
      • The Cost Dim. Value Type field has been renamed to Value Type.
      • The Unfold Lines field has been renamed to Unfold Values.
      For more information, see Reports and Analysis, Edit Evaluations, Line Definition.
    • The field captions in the Column Definition of the evaluation have been optimized.
      • The Filter/Formula field has been renamed to Value Filter/Formula.
      • The Cost Dim. Value Type field has been renamed to Value Type.
      For more information, see Reports and Analysis, Edit Evaluations, Column Definition.
    • The Cues of NCCA Cost Accounting has been optimized. For more information, see General, Role Center Integration.
    • The default settings for the confirmation dialogs have been optimized.
    • NAVAX Extension Base extension update.
      For more information, see [Docs] NAVAX Extension Base - Release Notes

Version 21.2.2.1

as of Business Central 21
2024/01/18
  • Corrections

    • No quantity-only posting was possible in the recurring Cost Journal.

Version 21.2.2.0

as of Business Central 21
2023/12/13

Version 21.2.1.0

as of Business Central 21
2023/07/25
  • Improvements

    • When opening the Allocation Calculation Details page, a filter is now set by default on the Ratio is 0 field.
    • Added the fields G/L Entry Transfer incl. Quantities and FA Entry Transfer incl. Quantities to the Cost Types. If the fields are set for a cost type, the Quantities from G/L Entries or FA Entries will also be transferred by the Entry Transfer. The fields can only be set if a Unit of Measure Code is specified for the cost type.
    • The Add action in the Line Definition and in the Column Definition now inserts new lines at resp. after the current position.
  • Modifications

    • Specifying an * (Asterisk) in the Debit of an Allocation Distribution now only considers dimension values of type Standard.

Version 21.2.0.0

as of Business Central 21
2023/05/19
  • Business Central Update

  • Improvements

    • The menu bar of NCCA Cost Accounting has been revised. For more information, see General, Role Center Integration.
    • The action bars of all pages of NCCA Cost Accounting are now implemented with an improved action bar.
    • The G/L Entry Transfer and the FA Entry Transfer have been revised. For more information, see Entry Transfer, G/L Entry Transfer and Entry Transfer, Calculatory FA Entry Transfer.
    • The evaluations have been revised.
      • Actions have been rearranged and tooltips have been improved.
      • The options for calculating the date filters have been extended and are now available in the General section of the evaluation.
      • For lines the option: Align Line Codes Right was added.
      • Line Schema has been renamed to Line Definition.
      • Column Layout has been renamed to Column Definition.
      • The line definition and the column definition are now built up as a tree structure. The Type and View fields have been combined into one Dimension/Line and Dimension/Column field, respectively. The Indentation displayed in the field has no influence on the display of the evaluation result and is only used to show the structural design of the line/column definition. The line/column type or the dimension of a loop can be changed by clicking on the field.
      • The Insert Line, Insert Values and Copy from actions have been replaced by the Add action. Depending on the selected line from which the action is called, different options are available.
      • Via the actions Subordinate and Superordinate a row/column or a dimension loop can be subordinated to another dimension loop or the subordination can be cancelled. The "End Loop" lines are no longer needed.
      • In the line definition, the Indentation field has been added to control the indentation of the description.
      • The Mixed Result in Column Layout field in the row definition has been renamed to Line Controlled Column Type.
      • If Unfold Values is activated in the line definition, the names of the individual dimension values can now be output in the Description field with the placeholder %2.
      • The Date View Calculation field in the column definition has been renamed to Value Calculation (Date View). The field is displayed only if the date view is enabled in the evaluation.
      • The Date Formula (Date View) field has been added in the column definition. This can be used to specify a date formula to influence or change the date filter set by the date view for the column. The field is displayed only if the date view is enabled in the evaluation.
      • The Date Filter field in the column definition is now only displayed if the date view is enabled in the evaluation.
      For more information, see Reports and Analysis, Edit Evaluations, Edit Evaluation.
    • Chart of Cost Types and Chart of Cost Dimensions have been optimized.
    • The actions of the Journals have been revised.
    • In the Cost, Service Allocation and Cost Budget Journal, the action Create Excel Workbook for Import has been added. The action creates an Excel workbook that can be used as a template for importing journal lines.
    • The performance of the G/L Entry Transfer and the FA Entry Transfer has been improved.
    • NCCA Cost Accounting actions for Date Compression and Delete Empty Registers are now also available via the Data Administration page.
    • Deleting NCCA Journal Templates and Journal Batches must now be confirmed if Journal Lines exists.
    • Added a new option Quantities in the Posting Type field in the Cost Journal. This option can be used to perform a quantity-only posting, where a quantity and no amount must be specified.
    • The online help for NCCA cost accounting has been revised.
  • Modifications

  • Corrections

    • The Source Code of the Calculatory FA Entry Transfer was used for the G/L Entry Transfer.

Version 20.1.5.0

as of Business Central 20
2022/07/25

Version 20.1.4.0

as of Business Central 20
2022/06/01

Version 19.1.3.0

as of Business Central 19
2022/03/01
  • Modifications

  • Corrections

    • If a Formula ID with a length of more than 10 characters was used in an evaluation, the execution of the evaluation aborted with an error message.

Version 19.1.2.0

as of Business Central 19
2022/01/25
  • Improvements

    • NCCA Cost Accounting is now also integrated in the Finance Profile (Role).
  • Modifications

Version 18.1.1.0

as of Business Central 18
2021/08/06

Version 18.0.0.0

as of Business Central 18
2021/06/18
  • Improvements

    • In the Allocation Journal, the action Show Allocation Base has been added. The action can be used to display the cost entries that, based on the current settings, will be used to calculate the base. For more information, see Journals, Allocations, Allocation Journals.
    • In the Allocation Distribution of the Allocation Journal, a * or *+ can now be specified in the Debit Cost Dimension Code fields. If a * (Asterisk) is specified, allocation distributions will be automatically generated for all cost dimension values during posting. If a *+ is specified, an additional blank value is added. The Asterisks Preview Posting action displays a preview of all allocation distributions that will be automatically generated for the asterisks of the allocation distribution line during posting. If required, the asterisks of the allocation distribution line can be unfolded using the Unfold Asterisks action. For more information, see Journals, Allocations, Allocation Journals.
    • The Ratio is 0 field in the Allocation Calculation Details page was previously also set when the distribution ratio was automatically set to 1. The field is now set only if the distribution ratio is 0 after calculating the allocation. For more information, see Journals, Allocations, Calculation Details.
    • Added Date Modified and Modified By fields on the Evaluation Card. The fields show when and by whom the evaluation was last changed. In addition, the Change Protection field has been added. This field can be used to protect an evaluation from changes. For more information, see Reports and Analysis, Edit Evaluations, Edit Evaluation.
    • The Parting Line field in the Evaluation Column Layout has been renamed to Parting Line Left. In addition, a new field Parting Line Right has been added. For more information, see Reports and Analysis, Edit Evaluations, Column Definition.
    • The NCCA Export Evaluation to Excel action can now also be scheduled. When the Excel workbook is ready, a message appears in the Report Inbox from where the Excel workbook can be opened.
    • When the NCCA Archive Evaluation action is scheduled, a message now appears in the Report Inbox when archiving has been performed. The archived evaluation can then be opened directly via the Report Inbox page or via the NCCA Evaluation Archive.
  • Corrections

    • The Reference Filter of the Allocation Distribution in the Allocation Journal was not set to Empty ('') if an equals sign was specified in the Reference Filter and the corresponding dimension value of the Debit was empty.
    • When renaming an evaluation, the entries in the evaluation archive (Evaluation Code field) were not renamed as well.
    • When renaming a dimension, the related cost dimension was not renamed as well.

Version 17.1.0.0

as of Business Central 17
2020/12/04

Version 17.0.0.0

as of Business Central 17
2020/11/06
  • Initial Version

  Print manual  
DE|EN Imprint