Page 605 IC Chart of Accounts
src/Layers/W1/BaseApp/Finance/Intercompany/GLAccount/ICChartofAccounts.Page.al378 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.Intercompany.GLAccount;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Intercompany.Setup;using System.IO;using System.Telemetry;/// <summary>/// Main interface for managing the intercompany chart of accounts structure./// Provides comprehensive functionality for account creation, mapping, import/export, and synchronization./// </summary>page 605 "IC Chart of Accounts"{ ApplicationArea = Intercompany; Caption = 'Intercompany Chart of Accounts'; CardPageID = "IC G/L Account Card"; PageType = List; SourceTable = "IC G/L Account"; UsageCategory = Administration; RefreshOnActivate = true; layout { area(content) { repeater(Control1) { IndentationColumn = NameIndent; IndentationControls = Name; ShowCaption = false; field("No."; Rec."No.") { ApplicationArea = Intercompany; Style = Strong; StyleExpr = Emphasize; ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.'; } field(Name; Rec.Name) { ApplicationArea = Intercompany; Style = Strong; StyleExpr = Emphasize; ToolTip = 'Specifies the name of the IC general ledger account.'; } field("Income/Balance"; Rec."Income/Balance") { ApplicationArea = Intercompany; ToolTip = 'Specifies whether a general ledger account is an income statement account or a balance sheet account.'; } field("Account Type"; Rec."Account Type") { ApplicationArea = Intercompany; ToolTip = 'Specifies the purpose of the account. Total: Used to total a series of balances on accounts from many different account groupings. To use Total, leave this field blank. Begin-Total: A marker for the beginning of a series of accounts to be totaled that ends with an End-Total account. End-Total: A total of a series of accounts that starts with the preceding Begin-Total account. The total is defined in the Totaling field.'; } field(Blocked; Rec.Blocked) { ApplicationArea = Intercompany; ToolTip = 'Specifies that the related record is blocked from being posted in transactions, for example a customer that is declared insolvent or an item that is placed in quarantine.'; } } } } actions { area(processing) { group("F&unctions") { Caption = 'F&unctions'; Image = "Action"; action(OpenChartOfAccountsMapping) { ApplicationArea = Intercompany; Caption = 'Chart of Accounts Mapping'; Image = Intercompany; RunObject = Page "IC Mapping Chart of Account"; ToolTip = 'Open the mapping between the intercompany chart of accounts and the chart of accounts of the current company.'; } action("Copy from Chart of Accounts") { ApplicationArea = Intercompany; Caption = 'Copy from Chart of Accounts'; Image = CopyFromChartOfAccounts; ToolTip = 'Create intercompany accounts from G/L accounts.'; trigger OnAction() var FeatureTelemetry: Codeunit "Feature Telemetry"; ICMapping: Codeunit "IC Mapping"; begin CopyFromChartOfAccounts(); FeatureTelemetry.LogUptake('0000IL7', ICMapping.GetFeatureTelemetryName(), Enum::"Feature Uptake Status"::"Set up"); end; } action("In&dent IC Chart of Accounts") { ApplicationArea = Intercompany; Caption = 'In&dent IC Chart of Accounts'; Image = Indent; ToolTip = 'Indent accounts between a Begin-Total and the matching End-Total one level to make the chart of accounts easier to read.'; trigger OnAction() var IndentCOA: Codeunit "G/L Account-Indent"; begin IndentCOA.RunICAccountIndent(); end; } separator(Action21) { } action(Import) { ApplicationArea = Intercompany; Caption = 'Import'; Ellipsis = true; Image = Import; ToolTip = 'Import an intercompany chart of accounts from a file.'; trigger OnAction() var FeatureTelemetry: Codeunit "Feature Telemetry"; ICMapping: Codeunit "IC Mapping"; begin ImportFromXML(); FeatureTelemetry.LogUptake('0000IL8', ICMapping.GetFeatureTelemetryName(), Enum::"Feature Uptake Status"::"Set up"); end; } action("E&xport") { ApplicationArea = Intercompany; Caption = 'E&xport'; Ellipsis = true; Image = Export; ToolTip = 'Export the intercompany chart of accounts to a file.'; trigger OnAction() var FeatureTelemetry: Codeunit "Feature Telemetry"; ICMapping: Codeunit "IC Mapping"; begin ExportToXML(); FeatureTelemetry.LogUptake('0000IL9', ICMapping.GetFeatureTelemetryName(), Enum::"Feature Uptake Status"::"Set up"); end; } action(SynchronizationSetup) { ApplicationArea = Intercompany; Caption = 'Synchronization Setup'; Image = Setup; ShortcutKey = 'S'; ToolTip = 'Open the setup for the synchronization of the chart of accounts of intercompany.'; Enabled = EnableSynchronization; trigger OnAction() var ICSetup: Record "IC Setup"; ICMapping: Codeunit "IC Mapping"; ICChartOfAccountsSetup: Page "IC Chart of Accounts Setup"; ICPartnerCode: Code[20]; begin ICSetup.Get(); if ICSetup."IC Inbox Type" <> ICSetup."IC Inbox Type"::Database then begin Message(OnlyAvailableForICUsingDatabaseLbl); exit; end; ICPartnerCode := ICSetup."Partner Code for Acc. Syn."; if (ICPartnerCode <> '') then if Confirm(StrSubstNo(SynchronizeIntercompanyQst, ICPartnerCode), true) then begin ICMapping.SynchronizeAccounts(false, ICPartnerCode); exit; end; ICChartOfAccountsSetup.Run(); end; } } } area(Promoted) { group(Category_Process) { Caption = 'Process', Comment = 'Generated from the PromotedActionCategories property index 1.'; actionref(OpenChartOfAccountsMapping_Promoted; OpenChartOfAccountsMapping) { } actionref("Copy from Chart of Accounts_Promoted"; "Copy from Chart of Accounts") { } actionref("In&dent IC Chart of Accounts_Promoted"; "In&dent IC Chart of Accounts") { } actionref(SynchronizationSetup_Promoted; SynchronizationSetup) { } } group(Category_Report) { Caption = 'Report', Comment = 'Generated from the PromotedActionCategories property index 2.'; } group(Category_Category4) { Caption = 'Import/Export', Comment = 'Generated from the PromotedActionCategories property index 3.'; actionref(Import_Promoted; Import) { } actionref("E&xport_Promoted"; "E&xport") { } } } } trigger OnOpenPage() var ICSetup: Record "IC Setup"; FeatureTelemetry: Codeunit "Feature Telemetry"; ICMapping: Codeunit "IC Mapping"; begin FeatureTelemetry.LogUptake('0000ILA', ICMapping.GetFeatureTelemetryName(), Enum::"Feature Uptake Status"::Discovered); if ICSetup.FindFirst() then EnableSynchronization := (ICSetup."IC Inbox Type" = ICSetup."IC Inbox Type"::Database); end; trigger OnAfterGetRecord() begin NameIndent := 0; FormatLine(); end; var Emphasize: Boolean; NameIndent: Integer; EnableSynchronization: Boolean; SelectFileToImportLbl: Label 'Select file to import into the chart of accounts of intercompany'; DefaultNameForExportFileLbl: Label 'ICChartOfAccounts.xml'; CopyFromChartOfAccountsQst: Label 'Are you sure you want to copy from chart of accounts?'; RequestUserForFileNameLbl: Label 'Enter the file name.'; SupportedFileTypesLbl: Label 'XML Files (*.xml)|*.xml|All Files (*.*)|*.*'; CleanICAccountsBeforeCopyingChartOfAccountsQst: Label 'This will clear the existing IC Chart of Accounts before copying. Do you want to continue?'; SplitMessageTxt: Label '%1\%2', Comment = '%1 = First part of the message, %2 = Second part of the message.', Locked = true; SynchronizeIntercompanyQst: Label 'Partner %1 has been set for the synchronization of intercompany. Do you want to synchronize instead of switching to another partner?', Comment = '%1 = IC Partner code'; OnlyAvailableForICUsingDatabaseLbl: Label 'Synchronization is only available for companies using a database for intercompany transactions. Select this option in the setup if you want to use this action.'; local procedure CopyFromChartOfAccounts() var GLAccount: Record "G/L Account"; ICAccount: Record "IC G/L Account"; PrevIndentation: Integer; begin if GuiAllowed() then if not UserConfirmsToProceedWithChanges() then exit; ICAccount.LockTable(); if GLAccount.Find('-') then repeat if GLAccount."Account Type" = GLAccount."Account Type"::"End-Total" then PrevIndentation := PrevIndentation - 1; if not GLAccount.Blocked then begin ICAccount.Init(); ICAccount."No." := GLAccount."No."; ICAccount.Name := GLAccount.Name; ICAccount."Account Type" := GLAccount."Account Type"; ICAccount."Income/Balance" := GLAccount."Income/Balance"; ICAccount.Validate(Indentation, PrevIndentation); OnCopyFromChartOfAccountsOnBeforeICGLAccInsert(ICAccount, GLAccount); ICAccount.Insert(); end; PrevIndentation := GLAccount.Indentation; if GLAccount."Account Type" = GLAccount."Account Type"::"Begin-Total" then PrevIndentation := PrevIndentation + 1; until GLAccount.Next() = 0; end; local procedure UserConfirmsToProceedWithChanges(): Boolean var ICAccount: Record "IC G/L Account"; MessageText: Text; ICAccountIsEmpty: Boolean; UserResponse: Boolean; begin MessageText := CopyFromChartOfAccountsQst; ICAccountIsEmpty := ICAccount.IsEmpty(); if not ICAccountIsEmpty then MessageText := StrSubstNo(SplitMessageTxt, MessageText, CleanICAccountsBeforeCopyingChartOfAccountsQst); UserResponse := Confirm(MessageText, false); if not ICAccountIsEmpty and UserResponse then ICAccount.DeleteAll(); exit(UserResponse); end; local procedure ImportFromXML() var ICSetup: Record "IC Setup"; ICGLAccIO: XMLport "IC G/L Account Import/Export"; IFile: File; IStr: InStream; FileName: Text[1024]; StartFileName: Text[1024]; begin ICSetup.Get(); StartFileName := ICSetup."IC Inbox Details"; if StartFileName <> '' then begin if StartFileName[StrLen(StartFileName)] <> '\' then StartFileName := StartFileName + '\'; StartFileName := StartFileName + '*.xml'; end; if not Upload(SelectFileToImportLbl, '', SupportedFileTypesLbl, StartFileName, FileName) then Error(RequestUserForFileNameLbl); IFile.Open(FileName); IFile.CreateInStream(IStr); ICGLAccIO.SetSource(IStr); ICGLAccIO.Import(); end; local procedure ExportToXML() var ICSetup: Record "IC Setup"; FileMgt: Codeunit "File Management"; ICGLAccIO: XMLport "IC G/L Account Import/Export"; OFile: File; OStr: OutStream; FileName: Text; DefaultFileName: Text; begin ICSetup.Get(); DefaultFileName := ICSetup."IC Inbox Details"; if DefaultFileName <> '' then if DefaultFileName[StrLen(DefaultFileName)] <> '\' then DefaultFileName := DefaultFileName + '\'; DefaultFileName := DefaultFileName + DefaultNameForExportFileLbl; FileName := FileMgt.ServerTempFileName('xml'); if FileName = '' then exit; OFile.Create(FileName); OFile.CreateOutStream(OStr); ICGLAccIO.SetDestination(OStr); ICGLAccIO.Export(); OFile.Close(); Clear(OStr); Download(FileName, 'Export', TemporaryPath, '', DefaultFileName); end; local procedure FormatLine() begin NameIndent := Rec.Indentation; Emphasize := Rec."Account Type" <> Rec."Account Type"::Posting; end; /// <summary> /// Integration event raised before inserting IC G/L account during copy from chart of accounts operation. /// Allows modification of IC account data before insertion. /// </summary> /// <param name="ICGLAccount">IC G/L account being inserted</param> /// <param name="GLAccount">Source G/L account being copied from</param> [IntegrationEvent(false, false)] local procedure OnCopyFromChartOfAccountsOnBeforeICGLAccInsert(var ICGLAccount: Record "IC G/L Account"; GLAccount: Record "G/L Account") begin end;}