Table 551 VAT Rate Change Conversion
src/Layers/W1/BaseApp/Finance/VAT/RateChange/VATRateChangeConversion.Table.al125 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.VAT.RateChange;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.VAT.Setup;/// <summary>/// Defines conversion mappings from old posting groups to new posting groups for VAT rate changes./// Supports both VAT product posting group and general product posting group conversions./// </summary>table 551 "VAT Rate Change Conversion"{ Caption = 'VAT Rate Change Conversion'; DataClassification = CustomerContent; fields { /// <summary> /// Specifies whether this conversion applies to VAT product posting groups or general product posting groups. /// </summary> field(1; Type; Option) { Caption = 'Type'; OptionCaption = 'VAT Prod. Posting Group,Gen. Prod. Posting Group'; OptionMembers = "VAT Prod. Posting Group","Gen. Prod. Posting Group"; } /// <summary> /// Current posting group code that will be replaced during conversion. /// </summary> field(2; "From Code"; Code[20]) { Caption = 'From Code'; ToolTip = 'Specifies the current VAT product posting group that will be changed in connection with the VAT rate conversion.'; NotBlank = true; TableRelation = if (Type = const("VAT Prod. Posting Group")) "VAT Product Posting Group" else if (Type = const("Gen. Prod. Posting Group")) "Gen. Product Posting Group"; trigger OnValidate() begin CheckforLoop(); end; } /// <summary> /// New posting group code that will replace the "From Code" during conversion. /// </summary> field(3; "To Code"; Code[20]) { Caption = 'To Code'; ToolTip = 'Specifies the new general product posting group that will result from the conversion in connection with the VAT rate conversion.'; NotBlank = true; TableRelation = if (Type = const("VAT Prod. Posting Group")) "VAT Product Posting Group" else if (Type = const("Gen. Prod. Posting Group")) "Gen. Product Posting Group"; trigger OnValidate() begin if "To Code" <> xRec."To Code" then "Converted Date" := 0D; CheckforLoop(); end; } /// <summary> /// Date when this conversion mapping was applied, populated after successful conversion. /// </summary> field(10; "Converted Date"; Date) { Caption = 'Converted Date'; ToolTip = 'Specifies the date on which the VAT rate change conversion was performed.'; Editable = false; } } keys { key(Key1; Type, "From Code") { Clustered = true; } } fieldgroups { } trigger OnInsert() begin TestField("To Code"); end; trigger OnRename() begin "Converted Date" := 0D; end; var#pragma warning disable AA0074#pragma warning disable AA0470 Text0001: Label 'This entry will create a loop with the entry where the %1 field is set to %2.';#pragma warning restore AA0470#pragma warning restore AA0074 local procedure CheckforLoop() var VATRateChangeConversion: Record "VAT Rate Change Conversion"; begin VATRateChangeConversion.Reset(); VATRateChangeConversion.SetRange(Type, Type); VATRateChangeConversion.SetRange("From Code", "To Code"); if VATRateChangeConversion.FindFirst() then Error(Text0001, FieldCaption("From Code"), VATRateChangeConversion."From Code"); VATRateChangeConversion.Reset(); VATRateChangeConversion.SetRange(Type, Type); VATRateChangeConversion.SetRange("To Code", "From Code"); if VATRateChangeConversion.FindFirst() then Error(Text0001, FieldCaption("To Code"), VATRateChangeConversion."To Code"); end;}