Table "Gen. Journal Template"
Stores journal template definitions that control journal behavior, validation rules, and user interface features. Templates provide the framework for different types of journals with specialized functionality for specific business processes.
Remarks
Templates define default settings for journal batches including source codes, number series, posting reports, and page assignments. Key relationships: Used by Gen. Journal Batch for template-based configuration inheritance. Extensibility: Template types can be extended to support custom journal workflows and validation requirements.
Properties
| Name | Value |
|---|---|
| Caption | Gen. Journal Template |
| LookupPageID | Page Microsoft.Finance.GeneralLedger.Journal."General Journal Template List" |
| ReplicateData | True |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| Name | Code[10] | Unique identifier for the journal template used to reference and configure journal batches. |
| Description | Text[80] | Descriptive name for the journal template providing user-friendly identification. |
| "Test Report ID" | Integer | Report ID used for testing journal lines before posting to validate transactions. |
| "Page ID" | Integer | Page ID that defines the user interface for entering journal lines with this template. |
| "Posting Report ID" | Integer | Report ID for the posting report that prints after successful journal posting. |
| "Force Posting Report" | Boolean | Indicates whether the posting report must be printed after journal posting. |
| Type | Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Template Type" | Template type that determines journal behavior and specialized functionality for different business scenarios. |
| "Source Code" | Code[10] | Source code automatically applied to all journal lines created with this template for audit tracking. |
| "Reason Code" | Code[10] | Default reason code applied to journal lines created with this template for transaction classification. |
| Recurring | Boolean | Indicates whether this template is used for recurring journal entries with automated posting schedules. |
| "Test Report Caption" | Text[250] | Display caption for the test report used with this journal template. |
| "Page Caption" | Text[250] | Display caption for the page used for journal line entry with this template. |
| "Posting Report Caption" | Text[250] | Display caption for the posting report used with this journal template. |
| "Force Doc. Balance" | Boolean | Requires journal documents to have balanced debit and credit amounts before posting. |
| "Bal. Account Type" | Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Account Type" | Account type for the default balancing account used in journal lines created with this template. |
| "Bal. Account No." | Code[20] | Account number for the default balancing account used in journal lines created with this template. |
| "No. Series" | Code[20] | Number series used for automatic document number assignment in journal lines. |
| "Posting No. Series" | Code[20] | Number series used for posted document numbers after journal posting completion. |
| "Copy VAT Setup to Jnl. Lines" | Boolean | Automatically copies VAT posting setup from accounts to journal lines for VAT calculation. |
| "Allow VAT Difference" | Boolean | Allows manual adjustment of VAT amounts in journal lines when posting with this template. |
| "Cust. Receipt Report ID" | Integer | Report ID for customer receipt reports generated from journal postings with this template. |
| "Cust. Receipt Report Caption" | Text[250] | Display caption for the customer receipt report used with this journal template. |
| "Vendor Receipt Report ID" | Integer | Report ID for vendor receipt reports generated from journal postings with this template. |
| "Vendor Receipt Report Caption" | Text[250] | Display caption for the vendor receipt report used with this journal template. |
| "Increment Batch Name" | Boolean | Automatically increments batch names when creating new batches with this template. |
| "Copy to Posted Jnl. Lines" | Boolean | Creates copies of posted journal lines in the Posted General Journal Line table for audit history. |
| "Allow Posting Date From" | Date | Start date for allowable posting dates when using this journal template. |
| "Allow Posting Date To" | Date | End date for allowable posting dates when using this journal template. |
| "Unlink Inc. Doc On Posting" | Boolean | Automatically unlinks incoming documents from journal lines when posting for document workflow management. |
| "Allow Posting From DateFormula" | DateFormula | |
| "Allow Posting To DateFormula" | DateFormula | |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemCreatedByUserName | Text[50] | |
| SystemCreatedByFullName | Text[80] | |
| SystemModifiedByUserName | Text[50] | |
| SystemModifiedByFullName | Text[80] | |
| SystemRowVersion | BigInteger |
Events
OnAfterValidateType
Integration event that occurs after validating the journal template type. Allows customization of template behavior based on type changes and source code setup configuration.
[IntegrationEvent(False,False)]
local procedure OnAfterValidateType(var GenJournalTemplate: Record "Gen. Journal Template"; SourceCodeSetup: Record "Source Code Setup")Parameters
| Name | Type | Description |
|---|---|---|
| GenJournalTemplate | Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Template" |
The journal template record being validated. |
| SourceCodeSetup | Table Microsoft.Foundation.AuditCodes."Source Code Setup" |
Source code setup record containing configuration for source codes. |
OnBeforeNoSeriesValidate
Integration event that occurs before validating number series configuration for the journal template. Allows custom handling of number series validation logic and error prevention.
[IntegrationEvent(False,False)]
local procedure OnBeforeNoSeriesValidate(var GenJournalTemplate: Record "Gen. Journal Template"; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| GenJournalTemplate | Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Template" |
The journal template record with number series being validated. |
| IsHandled | Boolean |
Set to true to skip standard validation processing. |
OnAfterCheckGLAcc
Integration event that occurs after checking G/L Account configuration for the journal template. Allows additional validation or processing based on the associated G/L Account settings.
[IntegrationEvent(False,False)]
local procedure OnAfterCheckGLAcc(var GenJournalTemplate: Record "Gen. Journal Template"; GLAccount: Record "G/L Account")Parameters
| Name | Type | Description |
|---|---|---|
| GenJournalTemplate | Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Template" |
The journal template record being checked. |
| GLAccount | Table Microsoft.Finance.GeneralLedger.Account."G/L Account" |
The G/L Account record associated with the template for validation. |