Table 80 "Gen. Journal Template"
Base Application · Microsoft.Finance.GeneralLedger.Journal
- 31fields
- 5procedures
- 3events
- 1Learn pages
- 3countries replace it
- 55fields reference it
- 1event subscribers
- 1objects it calls
Across versions
- BC23present
- BC245 fields changed
- BC251 fields added
- BC26-27unchanged
- BC282 fields added, 1 procedures added
- BC2929 fields changed
- BC30unchanged
Neighbourhood 47 connected objects and pages
Base Application · Microsoft.Finance.GeneralLedger.Journal · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 101 “General Journal Templates” (1 Learn page), Page 250 “General Journal Template List” (1).
Properties
| Property | Value |
|---|---|
| Caption | Gen. Journal Template |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Name Δ BC29 | Code[10] | Specifies the name of the journal template you are creating. | NotBlank |
| 2 | Description Δ BC29 | Text[80] | Specifies a brief description of the journal template you are creating. | |
| 5 | Test Report ID Δ BC29 | Integer | Specifies the test report that is printed when you click Test Report. | TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Report)) |
| 6 | Page ID Δ BC29 | Integer | Specifies the number of the page that is used to show the journal or worksheet that uses the template. | TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Page)) |
| 7 | Posting Report ID Δ BC29 | Integer | Specifies the posting report that is printed when you choose Post and Print. | TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Report)) |
| 8 | Force Posting Report Δ BC29 | Boolean | Specifies whether a report is printed automatically when you post. | |
| 9 | Type Δ BC29 | Enum “Gen. Journal Template Type” | Specifies the journal type. | enum Enum 89 “Gen. Journal Template Type” |
| 10 | Source Code Δ BC29 | Code[10] | Specifies the source code that specifies where the entry was created. | TableRelation Table 230 “Source Code” (Source Code) |
| 11 | Reason Code Δ BC29 | Code[10] | Specifies the reason code, a supplementary source code that enables you to trace the entry. | TableRelation Table 231 “Reason Code” (Reason Code) |
| 12 | Recurring Δ BC29 | Boolean | Specifies whether the journal template will be a recurring journal. | |
| 15 | Test Report Caption Δ BC24 Δ BC29 | Text[250] | Specifies the name of the test report that is printed when you print a journal under this journal template. | FlowField: lookup(AllObjWithCaption.“Object Caption” where(“Object Type” = const(Report), “Object ID” = field(“Test Report ID”))); not editable |
| 16 | Page Caption Δ BC24 Δ BC29 | Text[250] | Specifies the displayed name of the journal or worksheet that uses the template. | FlowField: lookup(AllObjWithCaption.“Object Caption” where(“Object Type” = const(Page), “Object ID” = field(“Page ID”))); not editable |
| 17 | Posting Report Caption Δ BC24 Δ BC29 | Text[250] | Specifies the name of the report that is printed when you print the journal. | FlowField: lookup(AllObjWithCaption.“Object Caption” where(“Object Type” = const(Report), “Object ID” = field(“Posting Report ID”))); not editable |
| 18 | Force Doc. Balance Δ BC29 | Boolean | Specifies whether transactions that are posted in the general journal must balance by document number and document type, in addition to balancing by date. | |
| 19 | Bal. Account Type Δ BC29 | Enum “Gen. Journal Account Type” | Specifies the type of account that a balancing entry is posted to, such as BANK for a cash account. | enum Enum 81 “Gen. Journal Account Type” |
| 20 | Bal. Account No. Δ BC29 | Code[20] | Specifies the number of the general ledger, customer, vendor, or bank account that the balancing entry is posted to, such as a cash account for cash purchases. | TableRelation Table 15 “G/L Account”, Table 18 “Customer”, Table 23 “Vendor” (if (“Bal. Account Type” = const(“G/L Account”)) “G/L Account” else if (“Bal. Account Type” = const(Customer)) Customer else if (“Bal. Account Type” = const(Vendor)) Vendor else if (“Bal. Account Type” = const(“Bank Account”)) “Bank Account” else if (“Bal. Account Type” = const(“Fixed Asset”)) “Fixed…) |
| 21 | No. Series Δ BC29 | Code[20] | Specifies the number series from which entry or record numbers are assigned to new entries or records. | TableRelation Table 308 “No. Series” (No. Series) |
| 22 | Posting No. Series Δ BC29 | Code[20] | Specifies the code for the number series that will be used to assign document numbers to ledger entries that are posted from journals using this template. | TableRelation Table 308 “No. Series” (No. Series) |
| 23 | Copy VAT Setup to Jnl. Lines Δ BC29 | Boolean | Specifies whether the program to calculate VAT for accounts and balancing accounts on the journal line of the selected journal template. | |
| 24 | Allow VAT Difference Δ BC29 | Boolean | Specifies whether to allow the manual adjustment of VAT amounts in journals. | |
| 25 | Cust. Receipt Report ID Δ BC29 | Integer | Specifies how to print customer receipts when you post. | TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Report)) |
| 26 | Cust. Receipt Report Caption Δ BC24 Δ BC29 | Text[250] | Specifies how to print customer receipts when you post. | FlowField: lookup(AllObjWithCaption.“Object Caption” where(“Object Type” = const(Report), “Object ID” = field(“Cust. Receipt Report ID”))); not editable |
| 27 | Vendor Receipt Report ID Δ BC29 | Integer | Specifies how to print vendor receipts when you post. | TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Report)) |
| 28 | Vendor Receipt Report Caption Δ BC24 Δ BC29 | Text[250] | Specifies how to print vendor receipts when you post. | FlowField: lookup(AllObjWithCaption.“Object Caption” where(“Object Type” = const(Report), “Object ID” = field(“Vendor Receipt Report ID”))); not editable |
| 30 | Increment Batch Name Δ BC29 | Boolean | Specifies if batch names using this template are automatically incremented. Example: The posting following BATCH001 is automatically named BATCH002. | |
| 31 | Copy to Posted Jnl. Lines Δ BC29 | Boolean | Specifies whether the journal lines to be copied to posted journal lines of the selected journal template. | |
| 32 | Allow Posting Date From Δ BC29 | Date | Specifies the earliest date when posting to the journal template is allowed. | |
| 33 | Allow Posting Date To Δ BC29 | Date | Specifies the last date when posting to the journal template is allowed. | |
| 34 | Unlink Inc. Doc On Posting + BC25 Δ BC29 | Boolean | Specifies whether the the incoming document will be unlinked from the journal when it is posted. | |
| 35 | Allow Posting From DateFormula + BC28 | DateFormula | Allow Posting From Date Formula caption | |
| 36 | Allow Posting To DateFormula + BC28 | DateFormula | Allow Posting To Date Formula caption |
Keys
- Key1: Name (clustered)
- Key2: Type, Bal. Account Type, Bal. Account No.
- Key3: Type, Recurring, No. Series
Events published
OnAfterValidateType(var GenJournalTemplate: Record "Gen. Journal Template"; SourceCodeSetup: Record "Source Code Setup")(integration): Integration event that occurs after validating the journal template type. Allows customization of template behavior based on type changes and source code setup configuration.- subscribers: Codeunit 1695 “Bank Deposit Subscribers” OnAfterValidateType
OnBeforeNoSeriesValidate(var GenJournalTemplate: Record "Gen. Journal Template"; var IsHandled: Boolean)(integration): Integration event that occurs before validating number series configuration for the journal template. Allows custom handling of number series validation logic and error prevention.OnAfterCheckGLAcc(var GenJournalTemplate: Record "Gen. Journal Template"; GLAccount: Record "G/L Account")(integration): 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.
Procedures
2 local procedures, no public ones.
Triggers
OnDelete, OnInsert
Relations
- lookup page Page 250 “General Journal Template List”
- Bal. Account No.: TableRelation Table 15 “G/L Account” (conditional)
- Bal. Account No.: TableRelation Table 18 “Customer” (conditional)
- Bal. Account No.: TableRelation Table 23 “Vendor” (conditional)
- Source Code: TableRelation Table 230 “Source Code”
- Reason Code: TableRelation Table 231 “Reason Code”
- Bal. Account No.: TableRelation Table 270 “Bank Account” (conditional)
- No. Series: TableRelation Table 308 “No. Series”
- Posting No. Series: TableRelation Table 308 “No. Series”
Referenced by
55 fields in 35 objects relate to this table (TableRelation or CalcFormula).
- Table 311 “Sales & Receivables Setup”: Fin. Charge Jnl. Template Name, IC Sales Cr. Memo Templ. Name, IC Sales Invoice Template Name, Reminder Journal Template Name, S. Cr. Memo Template Name, S. Invoice Template Name, S. Prep. Cr.Memo Template Name, S. Prep. Inv. Template Name
- Table 312 “Purchases & Payables Setup”: IC Purch. Cr. Memo Templ. Name, IC Purch. Invoice Templ. Name, P. Cr. Memo Template Name, P. Invoice Template Name, P. Prep. Cr.Memo Template Name, P. Prep. Inv. Template Name
- Table 5911 “Service Mgt. Setup”: Serv. Contr. Cr.M. Templ. Name, Serv. Contr. Inv. Templ. Name, Serv. Cr. Memo Templ. Name, Serv. Inv. Template Name
- Table 98 “General Ledger Setup”: Adjust ARC Jnl. Template Name, Apply Jnl. Template Name, Bank Acc. Recon. Template Name, Job WIP Jnl. Template Name
- Table 232 “Gen. Journal Batch”: Recurring, Template Type, Journal Template Name
- Table 109 “Net Balances Parameters”: Journal Template Name
- Table 1226 “Payment Export Data”: General Journal Template
- Table 1228 “Payment Jnl. Export Error Text”: Journal Template Name
- Table 131 “Incoming Documents Setup”: General Journal Template Name
- Table 1523 “Workflow Step Argument”: General Journal Template Name
- Table 1660 “Payroll Setup”: General Journal Template Name
- Table 1690 “Bank Deposit Header”: Journal Template Name
- Table 182 “Posted Gen. Journal Batch”: Journal Template Name
- Table 183 “Copy Gen. Journal Parameters”: Journal Template Name
- Table 221 “Gen. Jnl. Allocation”: Journal Template Name
- Table 313 “Inventory Setup”: Invt. Cost Jnl. Template Name
- Table 357 “Gen. Jnl. Dim. Filter”: Journal Template Name
- Table 36 “Sales Header”: Journal Templ. Name
- Table 38 “Purchase Header”: Journal Templ. Name
- Table 443 “IC Setup”: Default IC Gen. Jnl. Template
- Table 5605 “FA Journal Setup”: Gen. Jnl. Template Name
- Table 579 “Apply Unapply Parameters”: Journal Template Name
- Table 5900 “Service Header”: Journal Templ. Name
- Table 6010 “Service Header Archive”: Journal Templ. Name
- Table 6103 “E-Document Service”: General Journal Template Name
- Table 6756 “Issue Reminders Setup”: Journal Template Name
- Table 7250 “Bank Acc. Rec. AI Proposal”: Journal Template Name
- Table 7252 “Trans. to G/L Acc. Jnl. Batch”: Journal Template Name
- Table 750 “Standard General Journal”: Journal Template Name
- Table 751 “Standard General Journal Line”: Journal Template Name
- Table 8051 “Subscription Contract Setup”: Def. Rel. Jnl. Template Name
- Table 81 “Gen. Journal Line”: Journal Template Name
- Table 980 “Payment Registration Setup”: Journal Template Name
- Table extension 4701 “VAT Report Setup Extension”: Group Settle. Gen. Jnl. Templ.
- Table extension 6796 “Withholding Purch Setup Ext”: WHT Post Dated Check Template
Pages and codeunits on this table
- Page 101 “General Journal Templates” (source table)
- Page 250 “General Journal Template List” (source table)
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 5700 “User Setup Management” (1 call:
CheckDateRange → GetDateRange)
Countries that replace it
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Gen. Journal Template"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.