Cost Accounting - up to 8 dimensions, allocations with many variants, comprehensive evaluations.
Current Version: 24.2.6.2as of Business Central 24. For older BC versions, downgrades are available. AppSource Name: NCCA Cost Accounting
Manual
Creation date: 2024/11/22 The current version of this manual can be found at:
☰ Contents
General
NCCA Cost Accounting The NCCA Cost Accounting adds a cost accounting module to Microsoft Dynamics 365 Business Central that has its own data model...
Role Center Integration The NCCA Cost Accounting menu bar is integrated into 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 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...
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...
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...
Information for Developers
Indiv. Fields The following events are available in NCCA Cost Accounting for fields that have been added via individual programming...
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
The 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
The NCCA Cost Accounting is integrated into the Finance, Accountant and Accounting Manager roles, but can be accessed from any role via the Search function.
For more information, see General, Role Center Integration.
Fields, actions, pages and reports originating from the extension are labled with 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".
Note
The NCCA Cost Accounting was developed with the prefix NCCA resp. NVXCA.
NCCA resp. NVXCA stands for NAVAX Consulting resp. NAVAXCost Accounting.
Permission Sets
The following permission sets are available for the NCCA Cost Accounting:
Name
Description
NCCA
NCCA Cost Accounting
You need these permissions to use the NCCA Cost Accounting.
NCCA, SETUP
NCCA Cost Accounting Setup
You need these permissions to set up the NCCA Cost Accounting.
For more information, see Setup, Cost Accounting Setup.
Docs / NCCA Cost Accounting / General Role Center Integration
The NCCA Cost Accounting menu bar is integrated into 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 Transfer
Specifies 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 Transfer
Specifies the number of errors that occurred when transferring the FA Entries to NCCA Cost Accounting.
For more information, see Entry Transfer, Transfer Errors.
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 From
Specifies the earliest date on which posting in NCCA Cost Accounting is allowed.
Allow Posting To
Specifies the last date on which posting in NCCA Cost Accounting is allowed.
Allow Deletion Before
Specifies 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 2
Specifies which combination of cost dimension 1 and 2 is allowed when posting.
Enable Data Check
Specifies whether Business Central should check the journal lines while entering the data. The result of the check resp. the current messages are shown in the Journal Check FactBox.
Note
This functionality is only available as of Business Central 24.
Default Net Change Date Filter
Specifies 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 Transfer
Specifies the earliest posting date on which G/L Entries can be transferred to the NCCA Cost Accounting.
Cumulate G/L Entries
Specifies 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 Transfer
Specifies whether the NCCA Cost Accounting should be updated on each posting in the general ledger.
Specifies the Depreciation Book with which the FA Entries must be posted in order to be transferred.
FA Posting Types
Specifies 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 Transfer
Specifies the earliest posting date on which FA Entries can be transferred to the NCCA Cost Accounting.
Cumulate FA Entries
Specifies 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 Transfer
Specifies 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 Level
Specifies 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 Limit
Specifies 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.
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
NAVAX License Management
Opens the NAVAX License Management which displays the current license status of the NAVAX extensions.
For more information, see Appendix, NAVAX License Management.
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 Dimension
Specifies 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.
Note
Optionally, it is also possible to set up a related dimension for the cost type that allows you to specify the cost type for certain postings already in the journal or to specify it manually for the entry transfer.
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 Values
Displays how many Values the Related Dimension has.
Cost Dimension Caption
Specifies 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 Values
Displays 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 Automatically
Specifies 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 Rule
Specifies 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 Caption
Specifies the caption for the Code fields of the Cost Dimension.
Filter Caption
Specifies the caption for the Filter fields of the Cost Dimension.
Name Caption
Specifies the caption for the Name fields of the Cost Dimension.
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 Name
Specifies the name of the G/L Account.
Type of G/L Account
Specifies the purpose of the G/L Account.
Income/Balance
Specifies whether the G/L Account is an income statement account or a balance sheet account.
Synchronization
Specifies 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 Code
Specifies the Cost Type that is assigned to the G/L Account.
Cost Type Name
Specifies the name of the Cost Type.
Type of Cost Type
Specifies the purpose of the Cost Type.
Cumulate G/L Entries
Specifies 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 Accounts
Specifies the number of the selected G/L Accounts that are considered by the action.
Length of new Cost Types
Specifies 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 Prefix
Specifies 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 Code
Specifies the Cost Type that is assigned to the G/L Account.
NCCA Cost Type Name
Specifies the name of the Cost Type.
Type of NCCA Cost Type
Specifies the purpose of the Cost Type.
NCCA Cumulate G/L Entries
Specifies 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 Synchronization
Specifies whether the G/L Account should be considered by the creation/update or not (Synchronization Exception).
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 Code
Specifies the code of the dimension value.
Dimension Value Name
Specifies the name of the dimension value.
Type of Dimension Value
Specifies the purpose of the dimension value.
Synchronization
Specifies 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 Exists
Specifies if there is a cost dimension value for the dimension value.
Cost Dimension Value Name
Specifies the name of the cost dimension value.
Type of Cost Dimension Value
Specifies 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.
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 Code
Specifies the code of the cost dimension value.
Cost Dimension Value Name
Specifies the name of the cost dimension value.
Type of Cost Dimension Value
Specifies the purpose of the cost dimension value.
Synchronization
Specifies 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 Exists
Specifies if there is a dimension value for the cost dimension value.
Dimension Value Name
Specifies the name of the dimension value.
Type of Dimension Value
Specifies 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.
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 ID
Specifies a language code.
Language Name
Specifies the name of the language.
Caption
Specifies the caption of the Cost Dimension.
Code Caption
Specifies the caption for the Code fields of the Cost Dimension.
Filter Caption
Specifies the caption for the Filter fields of the Cost Dimension.
Name Caption
Specifies 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 Transfer
Specifies the code assigned to entries that are posted from the G/L Entry Transfer.
Default value: CAGLTRAN
NCCA Calc. FA Entry Transfer
Specifies 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 Reversal
Specifies the code assigned to entries that are posted when reversing cost entries.
Default value: CAREVERSE
NCCA Compress Entries
Specifies 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, all pages are structured identically, with a few exceptions. The screenshots shown here mostly show the Chart of Cost Types.
Fields
Code
Specifies the code for the cost dimension value.
Name
Specifies a descriptive name for the code dimension value.
Comments
Specifies if there are comments for the cost dimension value. Click on the field to view or edit the comments.
Direct Posting
Specifies whether you will be able to post directly or only indirectly to this cost dimension value.
Net Change
Specifies 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.
Balance
Specifies 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 Amount
Specifies either the code dimension value's total budget or, if you have specified a name in the Budget Name field, a specific budget.
Blocked
Specifies that the cost dimension value is blocked from being posted in transactions.
Type
Specifies 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.
Totaling
Specifies 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.
Specifies 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. Quantities
Specifies 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 Exists
Specifies 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 Accounts
Specifies if there are G/L Accounts that are related to the Cost Type.
The field available only for cost types.
Dimension Value Exists
Specifies if there is a dimension value for the cost dimension value.
The field is available only for cost dimensions.
Search Name
Specifies 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 Modified
Specifies when the cost dimension value was last modified.
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:
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.
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.
There must be no cost entry and no cost budget entry for the cost type that is on or after the Allow Deletion Before (Cost Accounting Setup) date.
For more information, see Setup, Cost Accounting Setup.
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.
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.
Depending on where the page is called from, an input is allowed or not. The field is automatically displayed if an input is allowed.
Group
Specifies 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.
Code
Specifies the code of the group.
Description
Specifies 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 Date
Specifies the earliest posting date on which G/L Entries can be transferred to the NCCA Cost Accounting.
From Posting Date
Specifies 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 Date
Specifies the posting date to which G/L Entries should be transferred to the NCCA Cost Accounting.
Reason Code
Specifies the reason code, a supplementary source code that enables you to trace the entries.
Include Transfer Errors
Specifies 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 Transfer
Specifies 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
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:
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 Code
Specifies the Depreciation Book for the calculatory FA Entry Transfer.
FA Posting Types
Specifies which FA Posting Types should be transferred by the calculatory FA Entry Transfer.
Starting Date
Specifies the earliest posting date on which FA Entries can be transferred to the NCCA Cost Accounting.
From Posting Date
Specifies 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 Date
Specifies the posting date to which FA Entries should be transferred to the NCCA Cost Accounting.
Reason Code
Specifies the reason code, a supplementary source code that enables you to trace the entries.
Include Transfer Errors
Specifies 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 Transfer
Specifies 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
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 Code
Specifies 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 Code
Specifies 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 Code
Specifies 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:
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 entry 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:
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.
Specifies which data should be displayed on the page.
The Errors option displays entries with status Error and Error (Corrections OK).
Posting Date
Specifies the Entry's posting date.
Document Type
Specifies 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 Code
Specifies the code of the depreciation book that the FA Entry has been posted to.
FA Posting Category
Specifies the FA Entry's posting category.
FA Posting Type
Specifies the FA Entry's posting type.
Description
Specifies the description of the Entry.
Amount
Specifies the amount of the Entry.
User ID
Specifies the ID of the user who posted the Entry.
Source Code
Specifies the source code that specifies where the Entry was created.
Entry No.
Specifies the number assigned to the Entry.
Dimension Set ID
Specifies a reference to the posted general ledger dimensions.
NCCA Transfer Status
Displays 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 Message
Displays information about the transfer error.
NCCA Correction Cost Type Code
Displays 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 Codes
Displays 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.
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.
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
Name
Specifies the name of the journal template.
Description
Specifies a brief description of the journal template.
Type
Specifies for which journal type the template should be used.
Recurring
Specifies whether the journals of the template are recurring.
No. Series
Specifies the number series from which entry or record numbers are assigned to new entries or records.
Posting No. Series
Specifies the number series that will be used to assign document numbers to entries that are posted from this journals using this template.
Source Code
Specifies the source code that specifies where the entry was created.
Reason Code
Specifies the reason code, a supplementary source code that enables you to trace the entries.
Increment Batch Name
Specifies if batch names using this template are automatically incremented.
Example: The posting following BATCH001 is automatically named BATCH002.
Page ID
Specifies the number of the journal page that should be used for the template.
Page Caption
Specifies the name of the selected Page.
Test Report ID
Specifies the report that is printed when you click on the Test Report action in the journal.
Test Report Caption
Specifies the name of the selected Test Report.
Posting Report ID
Specifies the report that is printed when you click on the Post and Print action in the journal.
Posting Report Caption
Specifies the name of the selected Posting Report.
Force Posting Report
Specifies 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
Name
Specifies the name of the journal.
Description
Specifies a brief description of the journal.
Use Service Allocation Prices
Specifies 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 Amount
Specifies 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 Amount
Specifies whether a fixed amount should be used for the Allocation or not.
The field is displayed only for Allocation Journal Batches.
Allocation Without Credit
Specifies whether the Allocation should be posted without Credit or not.
The field is displayed only for Allocation Journal Batches.
Archive Allocation Calculation Details
Specifies 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.
Recurring
Specifies whether the journal template and thus also the journal is recurring.
No. Series
Specifies the number series from which entry or record numbers are assigned to new entries or records.
Posting No. Series
Specifies the number series that will be used to assign document numbers to entries that are posted from this journal.
Reason Code
Specifies the reason code, a supplementary source code that enables you to trace the entries.
Cost Type Appearance
Specifies 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 Appearances
Specifies 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.
In the Cost Journals you can post Amounts and/or Quantities to Cost Types and Cost Dimensions.
Via the Import actions, postings that have been prepared externally in Excel, for example, can be imported directly into the journal.
Fields
Batch Name
Specifies the name of the journal batch.
Posting Date
Specifies the posting date for the entry.
Document No.
Specifies the number of the related document.
Posting Type
Specifies 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 Code
Specifies 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 Codes
Specifies 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.
Specifies the total amount that the journal line consists of.
Debit Amount
Specifies the total amount that the journal line consists of, if it is a debit amount.
Credit Amount
Specifies the total amount that the journal line consists of, if it is a credit amount.
Balance
Specifies the balance of the journal line if Posting Type Transfer.
Reason Code
Specifies the reason code, a supplementary source code that enables you to trace the entries.
Correction
Specifies 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:
Placeholder
Result
%1
Current Day as Number (e.g. 1)
%2
Current Week as Number (e.g. 52)
%3
Current Month as Number (e.g. 1)
%4
Current Month as Name (e.g. January)
%5
Current 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 Method
Specifies a recurring method for the recurring journal.
Recurring Frequency
Specifies the recurring frequency for the posting date of the recurring journal.
Expiration Date
Specifies 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.
Creates an Excel workbook that can be used as a template for importing journal lines.
Import from File
Import journal lines from a file.
FactBoxes
Journal Check
This area is displayed if the Enable Data Check field in the NCCA Cost Accounting Setup is activated. The result of the check resp. the current messages are shown in this FactBox.
For more information, see Setup, Cost Accounting Setup.
Cost Dimensions
In this area, the Cost Dimensions of the line and their names are displayed.
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
Posting Date
Document No.
Cost Type Code
Work Type Code
Quantity
Price
Amount
Description
Reason Code
Cost Dimension 1 Code
Cost Dimension 2 Code
Cost Dimension 3 Code
Cost Dimension 4 Code
Cost Dimension 5 Code
Cost Dimension 6 Code
Cost Dimension 7 Code
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.
If only a Quantity is specified in the file, the Posting Type of the line is set to Quantities.
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 Name
Specifies the name of the journal batch.
Posting Date
Specifies the posting date for the entries.
Document No.
Specifies the number of the related document.
Credit Cost Dimension Codes
Specifies 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 Codes
Specifies 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 Code
Specifies 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 Code
Specifies 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 Code
Specifies 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.
Description
Specifies a description for the entries.
Quantity
Specifies the quantity.
Note
Quantities can only be posted with a Unit of Measure Code.
Specifies the total amount that the journal line consists of.
Reason Code
Specifies the reason code, a supplementary source code that enables you to trace the entries.
Correction
Specifies 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:
Placeholder
Result
%1
Current Day as Number (e.g. 1)
%2
Current Week as Number (e.g. 52)
%3
Current Month as Number (e.g. 1)
%4
Current Month as Name (e.g. January)
%5
Current 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 Method
Specifies a recurring method for the recurring journal.
Recurring Frequency
Specifies the recurring frequency for the posting date of the recurring journal.
Expiration Date
Specifies 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.
Creates an Excel workbook that can be used as a template for importing journal lines.
Import from File
Import journal lines from a file.
FactBoxes
Journal Check
This area is displayed if the Enable Data Check field in the NCCA Cost Accounting Setup is activated. The result of the check resp. the current messages are shown in this FactBox.
For more information, see Setup, Cost Accounting Setup.
Cost Dimensions
In this area, the Cost Dimensions of the line and their names are displayed.
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 Code
Specifies 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 Name
Specifies 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 Code
Specifies 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 Code
Specifies 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 Code
Specifies the Unit of Measure Code of the Work Type.
Starting Date
Specifies the date from which the price is valid.
Price
Specifies the price
Process of pricing in the journal
If a work type is specified, pricing first searches for a price for Cost Dimension 1 and the specified Work Type Code.
If no price is found, a search is made for a price without Cost Dimension 1 but with the specified Work Type Code.
If no price is found, a price is searched for Cost Dimension 1 and the specified Unit of Measure Code.
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 Code
Unit of Measure Code
Work Type Code
Work Type Unit of Measure Code
Price
HOUR
10
INTERNAL
HOUR
20
PROD
HOUR
30
PROD
EXTERNAL
HOUR
40
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 Code
Unit of Measure Code
Work Type Code
Price found
Note
ADMIN
HOUR
10
The general price for Unit of Measure Code HOUR was found.
ADMIN
HOUR
INTERNAL
20
The general price for Work Type Code INTERNAL was found.
ADMIN
HOUR
EXTERNAL
10
No price found for Work Type Code EXTERNAL. The general price for Unit of Measure Code HOUR was found.
PROD
HOUR
30
PROD
HOUR
INTERNAL
20
No price found for Work Type Code INTERNAL. The general price for Work Type Code INTERNAL was found.
PROD
HOUR
EXTERNAL
40
PROD
HOUR
EXTERNAL
30
No price found for Work Type Code EXTERNAL. The price for Unit of Measure Code HOUR was found.
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
Posting Date
Document No.
Work Type Code
Credit Cost Type Code
Debit Cost Type Code
Quantity
Price
Amount
Description
Reason Code
Credit Cost Dimension 1 Code
Debit Cost Dimension 1 Code
Credit Cost Dimension 2 Code
Debit Cost Dimension 2 Code
Credit Cost Dimension 3 Code
Debit Cost Dimension 3 Code
Credit Cost Dimension 4 Code
Debit Cost Dimension 4 Code
Credit Cost Dimension 5 Code
Debit Cost Dimension 5 Code
Credit Cost Dimension 6 Code
Debit Cost Dimension 6 Code
Credit Cost Dimension 7 Code
Debit Cost Dimension 7 Code
Credit Cost Dimension 8 Code
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.
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 Name
Specifies the name of the journal batch.
Posting Date
Specifies the posting date for the entries.
Document No.
Specifies the number of the related document.
Description
Specifies a description for the entries.
Allocation Base From
Specifies a filter to determine which entries should be allocated.
Allocation Base To
Specifies a filter to determine which entries should be allocated.
Allocation Base Cost Type Filter
Specifies 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 Filters
Specifies 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 Filter
Specifies a filter to determine which entries should be allocated.
Fixed Allocation Amount
Specifies 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/Credit
Prevents 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 Type
Specifies 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 Distributions
Specifies the number of the allocation distributions.
Max. Iteration Steps
Specifies the maximum number of iterations. If the field is empty, the allocation will be ended after a maximum of 25 iterations.
Min. Iteration Amount
Specifies 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 Code
Specifies 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 Codes
Specifies 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 Code
Specifies 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:
Placeholder
Result
%1
Current Day as Number (e.g. 1)
%2
Current Week as Number (e.g. 52)
%3
Current Month as Number (e.g. 1)
%4
Current Month as Name (e.g. January)
%5
Current 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 Frequency
Specifies the recurring frequency for the posting date of the recurring journal.
Expiration Date
Specifies the last date the recurring journal will be posted.
Allocation Base From Recurring Frequency
Specifies the recurring frequency for the Base From date.
Allocation Base To Recurring Frequency
Specifies the recurring frequency for the Base To date.
Reference From Recurring Frequency
Specifies the recurring frequency for the Reference From date of the allocation distributions.
Reference To Recurring Frequency
Specifies 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.
This area is displayed if the Enable Data Check field in the NCCA Cost Accounting Setup is activated. The result of the check resp. the current messages are shown in this FactBox.
For more information, see Setup, Cost Accounting Setup.
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 Code
Specifies 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 Codes
Specifies 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 Ratio
Specifies the distribution ratio.
Fixed Ratio %
Specifies the percentage of the distribution ratio.
Distribution Type Amount Reference and Quantity Reference, Fields
Reference Ledger Entry Type
Specifies whether cost entries or cost budget entries should be used to calculate the distribution ratio.
Reference Budget Name
Specifies from which budget the entries should be used to calculate the distribution ratio, if the reference is a budget.
Reference Cost Type Filter
Specifies 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 Filters
Specifies 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 From
Specifies 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 To
Specifies 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 Filter
Specifies 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.<
Specifies whether and if so, which percentage was used to calculate the Amount.
Distribution Ratio
Specifies the distribution ratio that was used to calculate the debit amount.
Ratio automatically set
Specifies 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 0
Specifies 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 Code
Specifies 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 Codes
Specifies 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 Code
Specifies the work type of the entry.
Ledger Entry No.
Specifies the number of the entry that was used for the calculation.
Ledger Entry Type
Specifies 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 Step
Specifies 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.
Type
Specifies the line type.
Actions
Ledger Entry
View the ledger entry.
Show Totals
Displays a message with the totals for the selected or filtered lines.
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:
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 Date
Specifies the date when the entries in the cost register were posted.
Creation Time
Specifies the time when the entries in the cost register were posted.
User ID
Specifies the ID of the user who posted the entry.
Source Code
Specifies the source code for the entries in the cost register.
Source Type
Specifies the source type for the entries in the cost register.
Calculation Details Exists
Specifies if there are allocation calculation details for the entries in the cost register.
Journal Batch Name
Specifies 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.
Reversed
Specifies 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.
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.
The NCCA Cost Entries page displays the history of all postings in the NCCA Cost Accounting.
Fields
Cost Type Code
Specifies 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 Codes
Specifies 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.
Specifies the price of one unit on the cost entry.
User ID
Specifies the ID of the user who posted the entry.
Source Code
Specifies the source code that specifies where the entry was created.
For more information, see Setup, Source Codes.
Source Type
Specifies the source type for the entry.
Journal Batch Name
Specifies the name of the journal where the entry was posted from.
Reason Code
Specifies the reason code, a supplementary source code that enables you to trace the entry.
Reversed
Specifies 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 Type
Specifies 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.
Specifies whether amounts, quantities or both can be specified in the cost budget.
Cost Dimension Specifications
Specifies 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.
Specifies the name of the cost budget that the entry belongs to.
Date
Specifies the date of the cost budget entry.
Cost Type Code
Specifies 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 Codes
Specifies 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.
Specifies 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 Type
Specifies 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 Code
Specifies 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 Codes
Specifies 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.
Specifies the total amount that the journal line consists of.
Reason Code
Specifies 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.
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
Date
Document No.
Cost Type Code
Work Type Code
Quantity
Price
Amount
Description
Reason Code
Cost Dimension 1 Code
Cost Dimension 2 Code
Cost Dimension 3 Code
Cost Dimension 4 Code
Cost Dimension 5 Code
Cost Dimension 6 Code
Cost Dimension 7 Code
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.
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 Date
Specifies the date when the entries in the cost budget register were posted.
Creation Time
Specifies the time when the entries in the cost budget register were posted.
User ID
Specifies the ID of the user who posted the entry.
Source Code
Specifies the source code for the entries in the cost budget register.
Source Type
Specifies the source type for the entries in the cost budget register.
Budget Name
Specifies 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.
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. Date
Specifies 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 Formula
Specifies a date formula for the Date Filter Calculation Date.
Fixed Date Filter Calc. Date
Specifies 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.
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.
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.
The ⭮ symbol indicates that a loop is started in which the values of the dimension are run through.
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.
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 Codes
Specifies 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 Right
Specifies whether the codes should be right aligned on the print-out.
Show Line Filter
Specifies whether the filters of the lines should be displayed in the evaluation.
Show Indentation
Specifies whether the indentation of the lines should be displayed in the evaluation.
Print Alternating Shading
Specifies if you want every second row on the print-out to be shaded.
Splitted Excel Sheets
Specifies 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.
The ⭮ symbol indicates that a loop is started in which the values of the dimension are run through.
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.
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 Header
Specifies whether the codes, the text (or the Period for Date View), or both should be displayed in the column header of the evaluation.
Show Column Filter
Specifies whether the filters of the columns should be added to the column header of the evaluation.
Show Errors
Specifies 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 Filter
Specifies 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 Filter
Specifies 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 Filters
Specifies 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 Filter
Specifies a filter that will be used to filter or calculate the values.
Budget Filter
Specifies a filter that will be used to filter or calculate the values.
Displays a preview of all lines and columns that will be created when executing the evaluation, without the results being calculated.
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.
Add
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/Line Type
Displays 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.
Code
Specifies a code that can be displayed in the evaluation line.
Indentation
Specifies the indentation of the description. For dimension loops, the indentation is ignored when the evaluation is executed.
Indentation from Cost Dim. Value
Specifies 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.
Description
Specifies text that will appear on the line when the evaluation is executed. If no text is specified, the description is determined automatically.
It is possible to specify the placeholder %1 in the text, which will be replaced by the name of the current dimension value of the loop.
The placeholder %2 can be used to output the name of the dimension value from a parent loop.
Formula ID
Specifies 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 or subordinated loop can be accessed. Lines from higher/lower level loops can only be accessed via intermediate steps.
Value Filter/Formula
Specifies which dimension values should be calculated or, in the case of a dimension loop, taken into account, or specifies a formula.
Group Filter
Specifies which dimension groups should be calculated or, in the case of a dimension loop, taken into account. Click on the field to edit the group filters.
Value Type
Specifies 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.
Column Reference
Specifies 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 Type
Specifies 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 Sign
Specifies whether the sign of the result in this line should be reversed.
Bold
Specifies 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.
Italic
Specifies whether to print the line in italics.
Underline
Specifies whether to underline the entire line or only the result area (column area) of the line when printing.
Align Right
Specifies whether to print the description right aligned.
Line Without Shading
Specifies whether to turn off the automatic shading for this line on the print-out.
Show
Specifies 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 Break
Specifies whether a blank line should be inserted before or after the current line or whether a page break should occur before the current line.
Additional Filter
Specifies additional filters that will be used to calculate the values.
Note
These filters only affect the current line. Filters set on evaluation level cannot be cancelled with the filters of the line and are still valid. The filters of the line are only set additionally.
Click on the field to edit the additional filters.
Date Filter
Specifies 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 Filter
Specifies 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 Filters
Specifies 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 Filter
Specifies a filter that will be used to calculate the values.
Budget Filter
Specifies a filter that will be used to calculate the values.
Comment
Specifies 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.
Deleting a loop
When you delete a dimension loop, you can choose whether you want to
remove only the loop
In this case, all subordinate loops and their lines will be preserved and moved up one level.
delete all
In this case, the entire child tree structure is deleted.
Here you can set up the columns of the evaluation.
Add
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/Column Type
Displays 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.
Code
Specifies a code that can be displayed in the column header.
Header
Specifies text that will be added to the column header. If no text is specified, the header is determined automatically.
It is possible to specify the placeholder %1 in the text, which will be replaced by the name of the current dimension value of the loop.
The placeholder %2 can be used to output the name of the dimension value from a parent loop.
Formula ID
Specifies 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 or subordinated loop can be accessed. Columns from higher/lower level loops can only be accessed via intermediate steps.
Value Filter/Formula
Specifies which dimension values should be calculated or, in the case of a dimension loop, taken into account, 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 Filter
Specifies which dimension groups should be calculated or, in the case of a dimension loop, taken into account. Click on the field to edit the group filters.
Value Type
Specifies which dimension value types should be considered or calculated.
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 Factor
Specifies the factor that should be used to round the result in this column.
Show Opposite Sign
Specifies 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.
Bold
Specifies whether to print the column in bold or not. If no specification is selected, the actual bold setting from the values will be used.
Italic
Specifies whether to print the column in italics.
Parting Line Left
Specifies 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 Right
Specifies whether to print a parting line to the right of the entire column or only in the result area (line area) of the column.
Show
Specifies whether the column should be displayed.
The If Any Line Not Zero option is only considered by the print-out and when exporting to Excel.
Additional Filter
Specifies additional filters that will be used to calculate the values.
Note
These filters only affect the current column. Filters set on evaluation level and line level cannot be cancelled with the filters of the column and are still valid. The filters of the column are only set additionally.
Click on the field to edit the additional filters.
Date Filter
Specifies 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 Filter
Specifies 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 Filters
Specifies 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 Filter
Specifies a filter that will be used to calculate the values.
Budget Filter
Specifies a filter that will be used to calculate the values.
Comment
Specifies 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.
Deleting a loop
When you delete a dimension loop, you can choose whether you want to
remove only the loop
In this case, all subordinate loops and their columns will be preserved and moved up one level.
delete all
In this case, the entire child tree structure is deleted.
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.
Example
Result
Comment
[CD]
06/30/20
Date Filter Calc. Date
..[CD]
..06/30/20
Until Date Filter Calc. Date
01/01/20..[CD]
01/01/20..06/30/20
01/01/20 until Date Filter Calc. Date
..[-CM-1D]
..05/31/20
Until the end of last month (based on the Date Filter Calc. Date)
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
Codes
Specifies the Codes for the line.
The Show Line Codes field of the evaluation determines whether and if so, which codes are displayed here.
Description
Specifies the description for the line.
Filter
Specifies the filters for the line.
Column 1 to Column 12
Displays 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.
Specifies 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 Right
Specifies whether the codes should be right aligned on the print-out.
Show Line Filter
Specifies whether the filters of the lines should be displayed in the evaluation.
Show Indentation
Specifies whether the indentation of the lines should be displayed in the evaluation.
Print Alternating Shading
Specifies if you want every second row to be shaded.
Columns
Column View by
Specifies by which period values should be displayed in the evaluation when the Date View is activated.
Column Header
Specifies whether the codes, the text (or the Period for Date View), or both should be displayed in the column header of the evaluation.
Show Column Filter
Specifies whether the filters of the columns should be added to the column header of the evaluation.
Show Errors
Specifies whether error information (e.g. Division by Zero) should be displayed.
Filter
Date Filter
Specifies 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 Filter
Specifies 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 Filters
Specifies 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 Filter
Specifies a filter that will be used to filter or calculate the values.
Budget Filter
Specifies 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.
Specifies 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 Filter
Specifies whether the filters of the lines should be displayed in the evaluation.
Show Indentation
Specifies whether the indentation of the lines should be displayed in the evaluation.
Splitted Excel Sheets
Specifies 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 by
Specifies by which period values should be displayed in the evaluation when the Date View is activated.
Column Header
Specifies whether the codes, the text (or the Period for Date View), or both should be displayed in the column header of the evaluation.
Show Column Filter
Specifies whether the filters of the columns should be added to the column header of the evaluation.
Show Errors
Specifies whether error information (e.g. Division by Zero) should be displayed.
Filter
Date Filter
Specifies 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 Filter
Specifies 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 Filters
Specifies 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 Filter
Specifies a filter that will be used to filter or calculate the values.
Budget Filter
Specifies a filter that will be used to filter or calculate the values.
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:
As soon as archiving has been performed, a message appears in the Report Inbox.
The archived evaluation can then be opened directly via the Report Inbox or via the Evaluation Archive.
For more information, see Reports and Analysis, Execute Evaluations, Evaluation Archive.
Options
Evaluation Code
Specifies which evaluation should be archived.
Description
Specifies a description for the archived evaluation.
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 Code
Specifies the code of the archived evaluation.
Description
Specifies the description of the archived evaluation.
Datumsfilter Berechnungsdatum
Zeigt das Datumsfilter Berechnungsdatum der archivierten Auswertung an.
Archive No.
Specifies the number assigned to the archived evaluation.
Date Archived
Specifies the date when the evaluation was archived.
Time Archived
Specifies what time the evaluation was archived.
Archived By
Specifies the user ID of the person who archived this evaluation.
No. of Column Results
Specifies the number of the archived results.
Archive Comment
Specifies a comment for the archived evaluation.
Default Action
Specifies 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 / Information for Developers Indiv. Fields
The following events are available in NCCA Cost Accounting for fields that have been added via individual programming.
From G/L Entry/FA Entry to Cost Journal
Via the OnAfterCopyFromGLEntry or OnAfterCopyFromFALedgerEntry event in codeunit "NCCA Cost Jnl.-Trans. Mgt.", fields can be transferred from the G/L Entries or the FA Entries to the Cost Journal during Entry Transfer.
Example
[EventSubscriber(ObjectType::Codeunit, Codeunit::NCCA Cost Jnl.-Trans. Mgt., 'OnAfterCopyFromGLEntry', '', false, false)]
local procedure NCCACostJnlTransMgt_OnAfterCopyFromGLEntry(GLEntry: Record "G/L Entry"; var NCCACostJnlLine: Record "NCCA Cost Jnl. Line")
begin
NCCACostJnlLine."Indiv. Field" := GLEntry."Indiv. Field";
end;
Accumulate G/L Entries/FA Entries
Note that you can transfer G/L Entries/FA Entries individually or cumulatively to NCCA Cost Accounting with a manual transfer.
The behavior for cumulation can be defined via the OnCumulateTempCostJnlLine event in codeunit "NCCA Cost Jnl.-Trans. Mgt.".
Example for the cumulation of a decimal field
[EventSubscriber(ObjectType::Codeunit, Codeunit::NCCA Cost Jnl.-Trans. Mgt., 'OnCumulateTempCostJnlLine', '', false, false)]
local procedure NCCACostJnlTransMgt_OnCumulateTempCostJnlLine(NCCACostJnlLine: Record "NCCA Cost Jnl. Line"; var TempNCCACostJnlLine: Record "NCCA Cost Jnl. Line" temporary)
begin
TempNCCACostJnlLine."Indiv. Field" := TempNCCACostJnlLine."Indiv. Field" + NCCACostJnlLine."Indiv. Field";
end;
Note
In order for the field to be transferred from the Cost Journal to the Cost Entries, another event must be included.
For information on this, please refer to the next section From Cost Journal to Cost Entries.
From Cost Journal to Cost Entries
The event OnAfterCopyFromCostJnlLine in table "NCCA Cost Entry" can be used to transfer fields from the Cost Journal to the Cost Entries when posting.
Example
[EventSubscriber(ObjectType::Table, Table::"NCCA Cost Entry", 'OnAfterCopyFromCostJnlLine', '', false, false)]
local procedure NCCACostEntry_OnAfterCopyFromCostJnlLine(var NCCACostEntry: Record "NCCA Cost Entry"; var NCCACostJnlLine: Record "NCCA Cost Jnl. Line")
begin
NCCACostEntry."Indiv. Field" := NCCACostJnlLine."Indiv. Field";
end;
Fields in the Service Allocation Journal
The various NCCA journals are always posted internally via the NCCA Cost Journal.
The event OnAfterCopyFromServAJnlLine in table "NCCA Cost Jnl. Line" can be used to transfer fields from the Service Allocation Journal to the Cost Journal when posting.
Example
[EventSubscriber(ObjectType::Table, Table::"NCCA Cost Jnl. Line", 'OnAfterCopyFromServAJnlLine', '', false, false)]
local procedure NCCACostJnlLine_OnAfterCopyFromServAJnlLine(var NCCACostJnlLine: Record "NCCA Cost Jnl. Line"; var NCCAServAJnlLine: Record "NCCA Serv. A. Jnl. Line")
begin
NCCACostJnlLine."Indiv. Field" := NCCAServAJnlLine."Indiv. Field";
end;
Fields in Allocation Journal
The various NCCA journals are always posted internally via the NCCA Cost Journal.
The event OnAfterCopyFromAllocJnlLine in table "NCCA Cost Jnl. Line" can be used to transfer fields from the Allocation Journal to the Cost Journal when posting.
Example
[EventSubscriber(ObjectType::Table, Table::"NCCA Cost Jnl. Line", 'OnAfterCopyFromAllocJnlLine', '', false, false)]
local procedure NCCACostJnlLine_OnAfterCopyFromAllocJnlLine(var NCCACostJnlLine: Record "NCCA Cost Jnl. Line"; var NCCAAllocJnlLine: Record "NCCA Alloc. Jnl. Line")
begin
NCCACostJnlLine."Indiv. Field" := NCCAAllocJnlLine."Indiv. Field";
end;
From Cost Budget Journal to Cost Budget Entries
The event OnAfterCopyFromCostBudgetJnlLine in table "NCCA Cost Budget Entry" can be used to transfer fields from the Cost Budget Journal to the Cost Budget Entries when posting.
Example
[EventSubscriber(ObjectType::Table, Table::"NCCA Cost Budget Entry", 'OnAfterCopyFromCostBudgetJnlLine', '', false, false)]
local procedure NCCACostBudgetEntry_OnAfterCopyFromCostBudgetJnlLine(var NCCACostBudgetEntry: Record "NCCA Cost Budget Entry"; var NCCACostBudgetJnlLine: Record "NCCA Cost Budget Jnl. Line")
begin
NCCACostBudgetEntry."Indiv. Field" := NCCACostBudgetJnlLine."Indiv. Field";
end;
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
Enter Data Administration in the search, and then choose the related link.
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 Date
Specifies the date from which entries should be compressed.
Compression affects all entries from this date to the ending date.
Ending Date
Specifies the date to which entries should be compressed.
Compression affects all entries from the starting date to this date.
Period Length
Specifies 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 Description
Specifies 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.
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.
Only users with the SUPER permission set can perform this action.
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.
The NAVAX License Management page (in older versions "NAVAX License Overview" or "NCEX License Overview") displays the current license status of the NAVAX extensions.
Fields
Name
Specifies the name of the Extension.
License Status
Specifies the current license status of the Extension.
Serial No.
Specifies the serial number of the Extension.
Version
Specifies 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.
Request License
The license can be requested or checked via the Current Status action. 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 granted.
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)
CRL Servers In addition, the following CRL Servers must also be accessible for the certificate check: https://certificates.godaddy.com/* http://crl.godaddy.com/* or their IP: 192.124.249.36
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.
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.
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 granted.
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)
CRL Servers In addition, the following CRL Servers must also be accessible for the certificate check: https://certificates.godaddy.com/* http://crl.godaddy.com/* or their IP: 192.124.249.36
When importing a cost journal, the Posting Type is now set to Quantities if only a Quantity is specified in the file.
For more information, see Journals, Costs, Import Cost Journal.
Version 24.2.5.1
as of Business Central 24 2024/07/03
Modifications
The logo of the extension has been changed.
Version 24.2.5.0
as of Business Central 24 2024/07/01
Important
For On-Premises an update of the License or the following granules is required:
The Enable Data Check field has been added to the NCCA Cost Accounting Setup page.
The field specifies whether Business Central should check the journal lines while entering the data. The result of the check resp. the current messages are shown in the Journal Check FactBox.
Note
This functionality is only available as of Business Central 24.
The files for an upgrade from NAV to Business Central have been updated.
Modifications
The field or functionality Unfold Values in the Line Definition of the evaluations has been removed.
Lines in which the field is set are automatically converted into a Dimension Loop during the update.
For more information, see Reports and Analysis, Edit Evaluations, Line Definition.
Version 21.2.3.0
as of Business Central 21 2024/03/01
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.
If the fields Reference From and Reference To of an amount based Allocation Distribution were empty, they were not filled with the date values of the allocation base.
For more information, see Journals, Allocations, Allocation Distribution.
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.
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 Type and Dimension/Column Type 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.
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.
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
Added action NAVAX License Overview in the NCCA Cost Accounting Setup page.
Other licensing actions and fields have been removed from the setup.
For more information, see Setup, Cost Accounting Setup.
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.