This section includes various journal template properties.
General
Name
Name of the journal template.
Description
A detailed description of the journal template.
Journal Template
Journal Template Type
A journal template can either be standard or auto approved. If auto approved, a user can create a journal from the template with limited editing ability meaning permission to change name, description, and so forth. After pressing Save, the line items are validated, and the journal skips the approval process and becomes approved.
If the journal needs to be edited, it is handled like any other journal from that point forward. Someone in the Approve Journals group must reject it for the original user to edit it. Then, the regular Submit, Approve steps will occur. This approach is needed because the person who created the auto approved template only pre-approved certain numbers to be put in the system.
The user does not need to be in the ApproveJournals security group to do this. They only need to be in the ProcessJournals security group which is normally the group for end users to save or submit journals.
Journal Template Group
This displays the journal template group that was created under the new template.
Journal Requirement Level
This setting works together with Frequency and determines when a journal is required. The options available are Not Used (anymore), Optional, or Required.
Journal Frequency
All Time Periods
This allows the journal to display every period.
Monthly
This allows the journal to display every month. If this is for a weekly application, it will display the last week of each month.
Quarterly
This allows the journal to display every quarter, or four times a year.
Half Yearly
This allows the journal to display two times a year; once in June and December.
Yearly
This allows the journal to display once a year in December.
Member Filter
This turns on the Frequency Member filter and then the filters can be defined in that section. For example, if this journal only needs to be completed in September, use the filter T#WFYearM9.
Frequency Member Filter
This becomes available when Member Filter is chosen in the Forms Frequency options above, otherwise this is gray for all the others. The purpose of this option is to allow the ability to filter by time.
The following settings control what the user can modify when creating a journal. Settings are True or False.
Can Change Journal Settings
Can Change Journal POV
Can change Journal Line Items
Can change Journal Amounts
Journal
Journal Type
The options are Standard, Auto Reversing, or Allocation. When posting an Auto Reversing journal, the auto reversal journal is automatically created in the next time period and set to the Approved state. The Auto Reversal journal has all the debits and credits reversed.
When un-posting an Auto Reversing journal, check to make sure the auto reversal is not posted first. Ifnot, delete the Auto Reversal journal from the next time period and un-post.
An Allocation journal can be set up to perform simple or more intricate allocations, such as creating the weighting of the allocation, previewing the actual allocation entries, and un-posting them if they need to be run again.
Journal Balance Type
Balanced
The entire set of journal lines must balance between the debits and credits.
Balance by Entity
Debits and credits in a multi-Entity journal must balance for each entity.
Unbalanced
Balance check will not be performed. This is normally used for one-sided journals.
Is Single Entity
If True, the entity name is entered in the Journal POV and all journal lines relate to this one entity. If False, the Cube, Entity and Parent columns must be filled out for every line in the journal instance.
Entity Member Filter
This Member Filter will help limit the list of entities presented to the user in the Journal POV and journal lines.
Point of View
In order to limit the amount of setup for every journal line, the items that remain constant (e.g. Flow = None) can be set in the Journal POV instead of in every line Item.
TIP: A Journal template can be repeated on a regular basis if values are placed in the journal lines and journal’s settings require repeating upon a certain frequency.
