Table 750 Standard General Journal
src/Layers/W1/BaseApp/Finance/GeneralLedger/Journal/StandardGeneralJournal.Table.al321 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Foundation.NoSeries;/// <summary>/// Table for storing standard general journal templates that can be reused for recurring journal entries./// Enables users to save journal line configurations as templates for quick journal entry creation./// </summary>/// <remarks>/// Standard journal functionality for creating reusable journal entry templates./// Templates store complete journal configurations including accounts, amounts, dimensions, and descriptions./// Key features: Template-based journal creation, recurring entry support, standardized posting procedures./// Integration: Links to Standard General Journal Line table for detailed line information./// </remarks>table 750 "Standard General Journal"{ Caption = 'Standard General Journal'; LookupPageID = "Standard General Journals"; DataClassification = CustomerContent; fields { /// <summary> /// References the general journal template that defines posting setup and numbering for this standard journal. /// </summary> field(1; "Journal Template Name"; Code[10]) { Caption = 'Journal Template Name'; NotBlank = true; TableRelation = "Gen. Journal Template"; } /// <summary> /// Unique identifier for this standard journal template within the journal template context. /// </summary> field(2; "Code"; Code[10]) { Caption = 'Code'; ToolTip = 'Specifies a code to identify the standard general journal that you are about to save.'; NotBlank = true; } /// <summary> /// Descriptive text explaining the purpose and usage of this standard journal template. /// </summary> field(3; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies a text that indicates the purpose of the standard general journal.'; } } keys { key(Key1; "Journal Template Name", "Code") { Clustered = true; } } fieldgroups { } trigger OnDelete() var StdGenJnlLine: Record "Standard General Journal Line"; begin StdGenJnlLine.SetRange("Journal Template Name", "Journal Template Name"); StdGenJnlLine.SetRange("Standard Journal Code", Code); StdGenJnlLine.DeleteAll(true); end; var GenJnlBatch: Record "Gen. Journal Batch"; LastGenJnlLine: Record "Gen. Journal Line"; GenJnlLine: Record "Gen. Journal Line"; Window: Dialog; WindowUpdateDateTime: DateTime; NoOfJournalsToBeCreated: Integer;#pragma warning disable AA0074 Text000: Label 'Getting Standard General Journal Lines @1@@@@@@@';#pragma warning restore AA0074 NoOfJournalsCreated: Integer; /// <summary> /// Creates general journal lines from a standard general journal template. /// Copies all lines from the standard journal template to the specified journal batch with automatic document numbering. /// </summary> /// <param name="StdGenJnl">Standard general journal record to copy from</param> /// <param name="JnlBatchName">Target journal batch name to create journal lines in</param> procedure CreateGenJnlFromStdJnl(StdGenJnl: Record "Standard General Journal"; JnlBatchName: Code[10]) var DocumentNo: Code[20]; begin if StdGenJnl.IsZeroAmountJournal() then DocumentNo := TryGetNextDocumentNo(StdGenJnl."Journal Template Name", JnlBatchName); CreateGenJnl(StdGenJnl, JnlBatchName, DocumentNo, 0D); end; /// <summary> /// Creates general journal lines from a standard journal template with specific document number and posting date. /// Copies all lines from the standard journal with the specified document details instead of automatic numbering. /// </summary> /// <param name="StdGenJnl">Standard general journal record to copy from</param> /// <param name="JnlBatchName">Target journal batch name to create journal lines in</param> /// <param name="DocumentNo">Document number to assign to created journal lines</param> /// <param name="PostingDate">Posting date to assign to created journal lines</param> procedure CreateGenJnlFromStdJnlWithDocNo(StdGenJnl: Record "Standard General Journal"; JnlBatchName: Code[10]; DocumentNo: Code[20]; PostingDate: Date) begin if DocumentNo = '' then CreateGenJnl(StdGenJnl, JnlBatchName, '', PostingDate) else CreateGenJnl(StdGenJnl, JnlBatchName, DocumentNo, PostingDate); end; /// <summary> /// Initializes general journal line context and batch information for standard journal creation. /// Sets up journal template name, batch name, and locates the last journal line for proper sequencing. /// </summary> /// <param name="StdGenJnl">Standard general journal record providing template context</param> /// <param name="JnlBatchName">Target journal batch name for line creation</param> procedure Initialize(var StdGenJnl: Record "Standard General Journal"; JnlBatchName: Code[10]) begin GenJnlLine."Journal Template Name" := StdGenJnl."Journal Template Name"; GenJnlLine."Journal Batch Name" := JnlBatchName; GenJnlLine.SetRange("Journal Template Name", StdGenJnl."Journal Template Name"); GenJnlLine.SetRange("Journal Batch Name", JnlBatchName); LastGenJnlLine.SetRange("Journal Template Name", StdGenJnl."Journal Template Name"); LastGenJnlLine.SetRange("Journal Batch Name", JnlBatchName); if LastGenJnlLine.FindLast() then; GenJnlBatch.SetRange("Journal Template Name", StdGenJnl."Journal Template Name"); GenJnlBatch.SetRange(Name, JnlBatchName); if GenJnlBatch.FindFirst() then; end; local procedure CopyGenJnlFromStdJnl(StdGenJnlLine: Record "Standard General Journal Line"; DocumentNo: Code[20]; PostingDate: date) var GenJnlManagement: Codeunit GenJnlManagement; Balance: Decimal; TotalBalance: Decimal; ShowBalance: Boolean; ShowTotalBalance: Boolean; begin GenJnlLine.Init(); GenJnlLine."Line No." := 0; GenJnlManagement.CalcBalance(GenJnlLine, LastGenJnlLine, Balance, TotalBalance, ShowBalance, ShowTotalBalance); GenJnlLine.SetUpNewLine(LastGenJnlLine, Balance, true); if LastGenJnlLine."Line No." <> 0 then GenJnlLine."Line No." := LastGenJnlLine."Line No." + 10000 else GenJnlLine."Line No." := 10000; OnCopyGenJnlFromStdJnlOnBeforeGenJnlLineTransferFields(GenJnlLine, StdGenJnlLine); GenJnlLine.TransferFields(StdGenJnlLine, false); if (GenJnlLine."Account Type" <> GenJnlLine."Account Type"::"G/L Account") and (GenJnlLine."Account No." <> '') then GenJnlLine.Validate("Account No."); if (GenJnlLine."Bal. Account Type" <> GenJnlLine."Bal. Account Type"::"G/L Account") and (GenJnlLine."Bal. Account No." <> '') then GenJnlLine.Validate("Bal. Account No."); GenJnlLine.UpdateLineBalance(); GenJnlLine."Currency Factor" := 0; GenJnlLine.Validate("Currency Code"); if GenJnlLine."VAT Prod. Posting Group" <> '' then GenJnlLine.Validate("VAT Prod. Posting Group"); if (GenJnlLine."VAT %" <> 0) and GenJnlBatch."Allow VAT Difference" then GenJnlLine.Validate("VAT Amount", StdGenJnlLine."VAT Amount"); GenJnlLine.Validate("Bal. VAT Prod. Posting Group"); GenJnlLine."Shortcut Dimension 1 Code" := StdGenJnlLine."Shortcut Dimension 1 Code"; GenJnlLine."Shortcut Dimension 2 Code" := StdGenJnlLine."Shortcut Dimension 2 Code"; GenJnlLine."Dimension Set ID" := StdGenJnlLine."Dimension Set ID"; if GenJnlBatch."Allow VAT Difference" then GenJnlLine.Validate("Bal. VAT Amount", StdGenJnlLine."Bal. VAT Amount"); if DocumentNo <> '' then GenJnlLine."Document No." := DocumentNo; if PostingDate <> 0D then GenJnlLine.Validate("Posting Date", PostingDate); GenJnlLine.Validate("Currency Code", StdGenJnlLine."Currency Code"); OnAfterCopyGenJnlFromStdJnl(GenJnlLine, StdGenJnlLine); GenJnlLine.Insert(true); OnCopyGenJnlFromStdJnlOnAfterInsertGenJnlLineFrmStandard(GenJnlLine, StdGenJnlLine); LastGenJnlLine := GenJnlLine; end; local procedure CreateGenJnl(StdGenJnl: Record "Standard General Journal"; JnlBatchName: Code[10]; DocumentNo: Code[20]; PostingDate: Date) var StdGenJnlLine: Record "Standard General Journal Line"; IsHandled: Boolean; begin IsHandled := false; OnBeforeCreateGenJnl(StdGenJnl, JnlBatchName, DocumentNo, PostingDate, IsHandled); if IsHandled then exit; Initialize(StdGenJnl, JnlBatchName); StdGenJnlLine.SetRange("Journal Template Name", StdGenJnl."Journal Template Name"); StdGenJnlLine.SetRange("Standard Journal Code", StdGenJnl.Code); OpenWindow(Text000, StdGenJnlLine.Count); if StdGenJnlLine.Find('-') then repeat UpdateWindow(); OnCreateGenJnlOnBeforeCopyGenJnlFromStdJnl(StdGenJnl, StdGenJnlLine); CopyGenJnlFromStdJnl(StdGenJnlLine, DocumentNo, PostingDate); until StdGenJnlLine.Next() = 0; end; /// <summary> /// Determines if this standard journal contains only zero-amount lines. /// Used to determine if document numbering should be applied when creating journal lines. /// </summary> /// <returns>True if all journal lines have zero amounts, false if any line has non-zero amounts</returns> [Scope('OnPrem')] procedure IsZeroAmountJournal(): Boolean var StandardGeneralJournalLine: Record "Standard General Journal Line"; begin StandardGeneralJournalLine.SetRange("Journal Template Name", "Journal Template Name"); StandardGeneralJournalLine.SetRange("Standard Journal Code", Code); StandardGeneralJournalLine.CalcSums("Debit Amount", "Credit Amount"); exit((StandardGeneralJournalLine."Debit Amount" = 0) and (StandardGeneralJournalLine."Credit Amount" = 0)); end; local procedure TryGetNextDocumentNo(TemplateName: Code[10]; BatchName: Code[10]): Code[20] var GenJournalBatch: Record "Gen. Journal Batch"; NoSeries: Codeunit "No. Series"; begin GenJournalBatch.Get(TemplateName, BatchName); if GenJournalBatch."No. Series" = '' then exit(''); exit(NoSeries.PeekNextNo(GenJournalBatch."No. Series")); end; local procedure OpenWindow(DisplayText: Text[250]; NoOfJournalsToBeCreated2: Integer) begin NoOfJournalsCreated := 0; NoOfJournalsToBeCreated := NoOfJournalsToBeCreated2; WindowUpdateDateTime := CurrentDateTime; Window.Open(DisplayText); end; local procedure UpdateWindow() begin NoOfJournalsCreated := NoOfJournalsCreated + 1; if CurrentDateTime - WindowUpdateDateTime >= 300 then begin WindowUpdateDateTime := CurrentDateTime; Window.Update(1, Round(NoOfJournalsCreated / NoOfJournalsToBeCreated * 10000, 1)); end; end; /// <summary> /// Integration event raised after copying standard journal line data to general journal line. /// Enables custom field mapping and additional data processing during journal creation. /// </summary> /// <param name="GenJournalLine">Destination general journal line with copied data</param> /// <param name="StdGenJournalLine">Source standard journal line providing template data</param> [IntegrationEvent(false, false)] local procedure OnAfterCopyGenJnlFromStdJnl(var GenJournalLine: Record "Gen. Journal Line"; StdGenJournalLine: Record "Standard General Journal Line") begin end; /// <summary> /// Integration event raised before transferring fields from standard journal line to general journal line. /// Enables custom field preparation and validation before standard field transfer. /// </summary> /// <param name="GenJournalLine">Destination general journal line for field transfer</param> /// <param name="StdGenJournalLine">Source standard journal line with template data</param> [IntegrationEvent(false, false)] local procedure OnCopyGenJnlFromStdJnlOnBeforeGenJnlLineTransferFields(var GenJournalLine: Record "Gen. Journal Line"; var StdGenJournalLine: Record "Standard General Journal Line") begin end; /// <summary> /// Integration event raised after inserting general journal line created from standard journal template. /// Enables custom post-insertion processing and validation of generated journal entries. /// </summary> /// <param name="GenJournalLine">Newly inserted general journal line</param> /// <param name="StdGenJournalLine">Standard journal line template used for creation</param> [IntegrationEvent(false, false)] local procedure OnCopyGenJnlFromStdJnlOnAfterInsertGenJnlLineFrmStandard(var GenJournalLine: Record "Gen. Journal Line"; StdGenJournalLine: Record "Standard General Journal Line") begin end; /// <summary> /// Integration event raised before copying standard journal lines during journal creation process. /// Enables custom filtering and preparation of standard journal templates. /// </summary> /// <param name="StandardGeneralJournal">Standard journal header providing template context</param> /// <param name="StandardGeneralJournalLine">Standard journal line to be processed</param> [IntegrationEvent(false, false)] local procedure OnCreateGenJnlOnBeforeCopyGenJnlFromStdJnl(var StandardGeneralJournal: Record "Standard General Journal"; var StandardGeneralJournalLine: Record "Standard General Journal Line") begin end; /// <summary> /// Integration event raised before starting general journal creation from standard journal template. /// Enables custom validation and preparation logic before journal generation begins. /// </summary> /// <param name="StandardGeneralJournal">Standard journal template for journal creation</param> /// <param name="JnlBatchName">Target journal batch name for created entries</param> /// <param name="DocumentNo">Document number for generated journal lines</param> /// <param name="PostingDate">Posting date for generated journal entries</param> /// <param name="IsHandled">Set to true to skip standard journal creation logic</param> [IntegrationEvent(false, false)] local procedure OnBeforeCreateGenJnl(var StandardGeneralJournal: Record "Standard General Journal"; var JnlBatchName: Code[10]; var DocumentNo: Code[20]; var PostingDate: Date; var IsHandled: Boolean) begin end;}