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.
Line View: All/Issues
Click on the action to show all lines or only lines that have issues.
Column View: Reduced/Extended
Click on the action to switch between the reduced and the extended 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.
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.
Allocation Dimensions
View or set up the cost dimensions for the journal line on a card page.
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.