Table 2672 Allocation Line
src/Layers/W1/BaseApp/Finance/AllocationAccount/AllocationLine.Table.al339 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.AllocationAccount;using Microsoft.Bank.BankAccount;using Microsoft.Finance.AllocationAccount.Purchase;using Microsoft.Finance.AllocationAccount.Sales;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Purchases.Document;using Microsoft.Sales.Document;/// <summary>/// Temporary table storing calculated allocation lines for distribution processing and preview./// Contains detailed allocation results including amounts, percentages, and destination account information./// </summary>table 2672 "Allocation Line"{ DataClassification = SystemMetadata; Caption = 'Allocation Line'; TableType = Temporary; fields { /// <summary> /// Allocation account number that generated this allocation line. /// </summary> field(1; "Allocation Account No."; Code[20]) { DataClassification = SystemMetadata; Caption = 'Allocation Account No.'; TableRelation = "Allocation Account"."No."; } /// <summary> /// Sequential line number for the allocation line. /// </summary> field(2; "Line No."; Integer) { DataClassification = SystemMetadata; Caption = 'Primary Key'; } /// <summary> /// Type of destination account for the allocation (G/L Account, Bank Account, etc.). /// </summary> field(3; "Destination Account Type"; Enum "Destination Account Type") { DataClassification = SystemMetadata; Caption = 'Destination Account Type'; ToolTip = 'Specifies the type of the Destination Account.'; } /// <summary> /// Account number for the allocation destination based on the destination account type. /// </summary> field(4; "Destination Account Number"; Code[20]) { DataClassification = SystemMetadata; Caption = 'Destination Account Number'; ToolTip = 'Specifies the number of the Destination Account.'; TableRelation = if ("Destination Account Type" = const("G/L Account")) "G/L Account" where("Account Type" = const(Posting), "Direct Posting" = const(true)) else if ("Destination Account Type" = const("Bank Account")) "Bank Account"; } /// <summary> /// Name of the destination account for display purposes. /// </summary> field(5; "Destination Account Name"; Text[2048]) { DataClassification = SystemMetadata; Caption = 'Destination Account Name'; ToolTip = 'Specifies the name of the Destination Account.'; } /// <summary> /// Allocated amount for this destination account. /// </summary> field(6; Amount; Decimal) { AutoFormatExpression = ''; AutoFormatType = 1; DataClassification = SystemMetadata; Caption = 'Amount'; ToolTip = 'Specifies the amount to be allocated to the Destination Account.'; } /// <summary> /// Account number used for breakdown calculations in variable allocation methods. /// </summary> field(10; "Breakdown Account Number"; Code[20]) { DataClassification = SystemMetadata; Caption = 'Breakdown Account Number'; ToolTip = 'Specifies the number of the Breakdown Account that is used to calculate the amount to be distributed to the destination account.'; } /// <summary> /// Balance of the breakdown account used for calculation purposes. /// </summary> field(11; "Breakdown Account Balance"; Decimal) { AutoFormatExpression = ''; AutoFormatType = 1; DataClassification = SystemMetadata; Caption = 'Breakdown Account Balance'; ToolTip = 'Specifies the balance of the Breakdown Account that is used to calculate the amount to be distributed to the destination account.'; } /// <summary> /// Name of the breakdown account for display purposes. /// </summary> field(12; "Breakdown Account Name"; Text[2048]) { DataClassification = SystemMetadata; Caption = 'Breakdown Account Name'; ToolTip = 'Specifies the name of the Breakdown Account that is used to calculate the amount to be distributed to the destination account.'; } /// <summary> /// Percentage of the total allocation assigned to this destination account. /// </summary> field(13; Percentage; Decimal) { AutoFormatType = 0; DataClassification = SystemMetadata; Caption = 'Percentage'; ToolTip = 'Specifies the percentage that is used to calculate the amount to be assinged to the destination account.'; } /// <summary> /// Quantity allocated to this destination account for quantity-based allocations. /// </summary> field(20; Quantity; Decimal) { AutoFormatType = 0; DataClassification = SystemMetadata; Caption = 'Quantity'; ToolTip = 'Specifies the quantity to be allocated to the Destination Account.'; DecimalPlaces = 0 : 5; } /// <summary> /// Global dimension 1 code for the allocation line posting. /// </summary> field(37; "Global Dimension 1 Code"; Code[20]) { CaptionClass = '1,1,1'; Caption = 'Global Dimension 1 Code'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1), Blocked = const(false)); } /// <summary> /// Global dimension 2 code for the allocation line posting. /// </summary> field(38; "Global Dimension 2 Code"; Code[20]) { CaptionClass = '1,1,2'; Caption = 'Global Dimension 2 Code'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2), Blocked = const(false)); } /// <summary> /// Dimension set ID linking to dimension combinations for the allocation line. /// </summary> field(480; "Dimension Set ID"; Integer) { Caption = 'Dimension Set ID'; Editable = false; TableRelation = "Dimension Set Entry"; } } keys { key(Key1; "Allocation Account No.", "Line No.") { Clustered = true; } } internal procedure GetQuantityVisible(var AllocationLine: Record "Allocation Line"): Boolean var AllocationAccount: Record "Allocation Account"; begin if not AllocationAccount.Get(AllocationLine."Allocation Account No.") then exit(false); exit(AllocationAccount."Document Lines Split" = AllocationAccount."Document Lines Split"::"Split Quantity"); end; internal procedure GetQuantityDataForRedistributePage(var AllocationLine: Record "Allocation Line"; ParentSystemId: Guid; ParentTableId: Integer; var AmountPerQuantity: Decimal; var QuantityToDistribute: Decimal) var SalesLine: Record "Sales Line"; PurchaseLine: Record "Purchase Line"; begin case ParentTableId of Database::"Sales Line": begin SalesLine.GetBySystemId(ParentSystemId); AmountPerQuantity := SalesLine."Unit Price"; QuantityToDistribute := SalesLine.Quantity; end; Database::"Purchase Line": begin PurchaseLine.GetBySystemId(ParentSystemId); AmountPerQuantity := PurchaseLine."Unit Cost"; QuantityToDistribute := PurchaseLine.Quantity; end; else exit; end; end; internal procedure GetOrGenerateAllocationLines(var AllocationLine: Record "Allocation Line"; ParentSystemId: Guid; ParentTableId: Integer; var AmountToAllocate: Decimal; var PostingDate: Date) var GenJournalAllocAccMgt: Codeunit "Gen. Journal Alloc. Acc. Mgt."; SalesAllocAccMgt: Codeunit "Sales Alloc. Acc. Mgt."; PurchaseAllocAccMgt: Codeunit "Purchase Alloc. Acc. Mgt."; begin VerifyParentInformationProvided(ParentSystemId, ParentTableId); case ParentTableId of database::"Gen. Journal Line": GenJournalAllocAccMgt.GetOrGenerateAllocationLines(AllocationLine, ParentSystemId, AmountToAllocate, PostingDate); database::"Sales Line": SalesAllocAccMgt.GetOrGenerateAllocationLines(AllocationLine, ParentSystemId, AmountToAllocate, PostingDate); database::"Purchase Line": PurchaseAllocAccMgt.GetOrGenerateAllocationLines(AllocationLine, ParentSystemId, AmountToAllocate, PostingDate); else OnGetOrGenerateAllocationLines(ParentTableId, ParentSystemId, AllocationLine, AmountToAllocate, PostingDate); end; end; internal procedure SaveChangesToAllocationLines(var AllocationLine: Record "Allocation Line"; ParentSystemId: Guid; ParentTableId: Integer; AmountToAllocate: Decimal) var ExistingAllocAccManualOverride: Record "Alloc. Acc. Manual Override"; AllocAccManualOverride: Record "Alloc. Acc. Manual Override"; NewAllocAccManualOverride: Record "Alloc. Acc. Manual Override"; AllocAccTelemetry: Codeunit "Alloc. Acc. Telemetry"; begin VerifyParentInformationProvided(ParentSystemId, ParentTableId); ExistingAllocAccManualOverride.SetRange("Parent System Id", ParentSystemId); ExistingAllocAccManualOverride.SetRange("Parent Table Id", ParentTableId); ExistingAllocAccManualOverride.ReadIsolation := IsolationLevel::ReadUncommitted; if not ExistingAllocAccManualOverride.IsEmpty() then ExistingAllocAccManualOverride.DeleteAll(); AllocationLine.Reset(); if not AllocationLine.FindSet() then exit; AllocAccTelemetry.LogDefinedOverride(); repeat Clear(AllocAccManualOverride); AllocAccManualOverride."Parent System Id" := ParentSystemId; AllocAccManualOverride."Parent Table Id" := ParentTableId; AllocAccManualOverride.Amount := AllocationLine.Amount; AllocAccManualOverride."Line No." := AllocationLine."Line No."; AllocAccManualOverride."Allocation Account No." := AllocationLine."Allocation Account No."; AllocAccManualOverride."Destination Account Number" := AllocationLine."Destination Account Number"; AllocAccManualOverride."Destination Account Type" := AllocationLine."Destination Account Type"; AllocAccManualOverride."Dimension Set ID" := AllocationLine."Dimension Set ID"; AllocAccManualOverride."Global Dimension 1 Code" := AllocationLine."Global Dimension 1 Code"; AllocAccManualOverride."Global Dimension 2 Code" := AllocationLine."Global Dimension 2 Code"; AllocAccManualOverride.Quantity := AllocationLine.Quantity; OnSaveChangesToAllocationLinesOnBeforeAllocAccManualOverrideInsert(AllocAccManualOverride, AllocationLine); AllocAccManualOverride.Insert(); until AllocationLine.Next() = 0; NewAllocAccManualOverride.ReadIsolation := IsolationLevel::ReadUncommitted; NewAllocAccManualOverride.SetRange("Parent System Id", ParentSystemId); NewAllocAccManualOverride.SetRange("Parent Table Id", ParentTableId); NewAllocAccManualOverride.CalcSums(Amount); if AmountToAllocate <> NewAllocAccManualOverride.Amount then Error(AllocAccManualOverrideAmountDoesNotMatchErr, NewAllocAccManualOverride.Amount - AmountToAllocate); end; internal procedure ResetToDefault(var AllocationLine: Record "Allocation Line"; ParentSystemId: Guid; ParentTableId: Integer) var AllocAccManualOverride: Record "Alloc. Acc. Manual Override"; AmountToAllocate: Decimal; PostingDate: Date; begin VerifyParentInformationProvided(ParentSystemId, ParentTableId); AllocationLine.Reset(); AllocationLine.DeleteAll(); AllocAccManualOverride.SetRange("Parent System Id", ParentSystemId); AllocAccManualOverride.SetRange("Parent Table Id", ParentTableId); AllocAccManualOverride.ReadIsolation := IsolationLevel::ReadUncommitted; if not AllocAccManualOverride.IsEmpty() then AllocAccManualOverride.DeleteAll(); GetOrGenerateAllocationLines(AllocationLine, ParentSystemId, ParentTableId, AmountToAllocate, PostingDate); end; local procedure VerifyParentInformationProvided(ParentSystemId: Guid; ParentTableId: Integer) begin if IsNullGuid(ParentSystemId) then Error(ParentSystemIdIsNotProvidedErr); if ParentTableId = 0 then Error(ParenTableIsNotProvidedErr); end; internal procedure ShowDimensions() var DimensionManagement: Codeunit DimensionManagement; begin "Dimension Set ID" := DimensionManagement.EditDimensionSet("Dimension Set ID", StrSubstNo(DimensionPageCaptionLbl, Rec.TableCaption(), Rec."Allocation Account No.", Rec."Line No.")); DimensionManagement.UpdateGlobalDimFromDimSetID("Dimension Set ID", "Global Dimension 1 Code", "Global Dimension 2 Code"); end; internal procedure GetQuantityPrecision(): Decimal begin exit(0.00001); end; /// <summary> /// Integration event raised to retrieve or generate allocation lines for processing. /// </summary> /// <param name="ParentTableId">ID of the parent table containing the allocation request</param> /// <param name="ParentSystemId">System ID of the parent record</param> /// <param name="AllocationLine">Allocation line record to populate</param> /// <param name="AmountToAllocate">Amount to be allocated across distribution lines</param> /// <param name="PostingDate">Date to use for allocation calculations</param> [IntegrationEvent(false, false)] local procedure OnGetOrGenerateAllocationLines(ParentTableId: Integer; ParentSystemId: Guid; var AllocationLine: Record "Allocation Line"; var AmountToAllocate: Decimal; var PostingDate: Date) begin end; [IntegrationEvent(false, false)] local procedure OnSaveChangesToAllocationLinesOnBeforeAllocAccManualOverrideInsert(var AllocAccManualOverride: Record "Alloc. Acc. Manual Override"; var AllocationLine: Record "Allocation Line") begin end; var ParentSystemIdIsNotProvidedErr: Label 'Parent System Id is not provided'; ParenTableIsNotProvidedErr: Label 'Parent Table Id is not provided'; AllocAccManualOverrideAmountDoesNotMatchErr: Label 'The sum of the allocation lines does not match the amount to allocate. Difference is %1.', Comment = '%1 Amount e.g. 1231.71'; DimensionPageCaptionLbl: Label '%1 %2 %3', Locked = true;}