Table 318 Tax Area
src/Layers/W1/BaseApp/Finance/SalesTax/TaxArea.Table.al165 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.SalesTax;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Sales.History;using System.Globalization;/// <summary>/// Stores sales tax area definitions with associated jurisdictions./// Tax areas group multiple tax jurisdictions for comprehensive tax calculations on transactions./// </summary>table 318 "Tax Area"{ Caption = 'Tax Area'; DataCaptionFields = "Code", Description; LookupPageID = "Tax Area List"; DataClassification = CustomerContent; fields { /// <summary> /// Unique identifier for the tax area. /// </summary> field(1; "Code"; Code[20]) { Caption = 'Code'; ToolTip = 'Specifies the code you want to assign to this tax area. You can enter up to 20 characters, both numbers and letters. It is a good idea to enter a code that is easy to remember.'; NotBlank = true; } /// <summary> /// Descriptive name for the tax area. /// </summary> field(2; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies a description of the tax area. If you use a number as the tax code, you might want to describe the tax area in this field.'; } /// <summary> /// Timestamp of the last modification to this tax area record. /// </summary> field(10; "Last Modified Date Time"; DateTime) { Caption = 'Last Modified Date Time'; Editable = false; } } keys { key(Key1; "Code") { Clustered = true; } } fieldgroups { } trigger OnDelete() begin if IsTaxAreaInUse() then Error(TaxAreaInUseErr); end; trigger OnInsert() begin SetLastModifiedDateTime(); end; trigger OnModify() begin SetLastModifiedDateTime(); end; trigger OnRename() begin SetLastModifiedDateTime(); end; var TaxAreaInUseErr: Label 'You cannot delete this tax rate because it is used on one or more existing documents.'; /// <summary> /// Creates a new tax area with associated tax jurisdictions for city and state. /// </summary> /// <param name="NewTaxAreaCode">Code for the new tax area</param> /// <param name="City">City name to create jurisdiction for</param> /// <param name="State">State name to create jurisdiction for</param> procedure CreateTaxArea(NewTaxAreaCode: Code[20]; City: Text[50]; State: Text[50]) begin Init(); Code := NewTaxAreaCode; Description := NewTaxAreaCode; if Insert() then; if City <> '' then CreateTaxAreaLine(Code, CopyStr(City, 1, 10)); if State <> '' then CreateTaxAreaLine(Code, CopyStr(State, 1, 10)); if (City = '') and (State = '') then CreateTaxAreaLine(Code, CopyStr(NewTaxAreaCode, 1, 10)); end; local procedure CreateTaxAreaLine(NewTaxArea: Code[20]; NewJurisdictionCode: Code[10]) var TaxAreaLine: Record "Tax Area Line"; TaxJurisdiction: Record "Tax Jurisdiction"; begin if TaxAreaLine.Get(NewTaxArea, NewJurisdictionCode) then exit; TaxAreaLine.Init(); TaxAreaLine."Tax Area" := NewTaxArea; TaxAreaLine."Tax Jurisdiction Code" := NewJurisdictionCode; TaxAreaLine.Insert(); TaxJurisdiction.CreateTaxJurisdiction(NewJurisdictionCode); end; /// <summary> /// Returns the tax area description in the user's current language. /// Falls back to the default description if no translation is available. /// </summary> /// <returns>Localized description text</returns> procedure GetDescriptionInCurrentLanguageFullLength(): Text[100] var TaxAreaTranslation: Record "Tax Area Translation"; Language: Codeunit Language; begin if TaxAreaTranslation.Get(Code, Language.GetUserLanguageCode()) then exit(TaxAreaTranslation.Description); exit(Description); end; local procedure SetLastModifiedDateTime() begin "Last Modified Date Time" := CurrentDateTime; end; local procedure IsTaxAreaInUse(): Boolean var SalesHeader: Record "Sales Header"; SalesInvoiceHeader: Record "Sales Invoice Header"; Customer: Record Customer; begin Customer.SetRange("Tax Area Code", Code); if not Customer.IsEmpty() then exit(true); SalesHeader.SetRange("Tax Area Code", Code); if not SalesHeader.IsEmpty() then exit(true); SalesInvoiceHeader.SetRange("Tax Area Code", Code); if not SalesInvoiceHeader.IsEmpty() then exit(true); exit(false); end;}