Table 175 Standard Vendor Purchase Code
src/Layers/W1/BaseApp/Purchases/Document/StandardVendorPurchaseCode.Table.al352 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.Purchases.Document;using Microsoft.Finance.Currency;using Microsoft.Finance.Dimension;using Microsoft.Foundation.ExtendedText;using Microsoft.Purchases.Vendor;table 175 "Standard Vendor Purchase Code"{ Caption = 'Standard Vendor Purchase Code'; DataClassification = CustomerContent; fields { field(1; "Vendor No."; Code[20]) { Caption = 'Vendor No.'; ToolTip = 'Specifies the number of the vendor to which the standard purchase code is assigned.'; NotBlank = true; TableRelation = Vendor; } field(2; "Code"; Code[10]) { Caption = 'Code'; ToolTip = 'Specifies a standard purchase code from the Standard Purchase Code table.'; NotBlank = true; TableRelation = "Standard Purchase Code"; trigger OnValidate() var StdPurchCode: Record "Standard Purchase Code"; begin if Code = '' then exit; StdPurchCode.Get(Code); Description := StdPurchCode.Description; "Currency Code" := StdPurchCode."Currency Code"; end; } field(3; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies a description of the standard purchase code.'; } field(13; "Currency Code"; Code[10]) { Caption = 'Currency Code'; Editable = false; TableRelation = Currency; } field(15; "Insert Rec. Lines On Quotes"; Option) { Caption = 'Insert Rec. Lines On Quotes'; ToolTip = 'Specifies how you want to use standard purchase codes on purchase quotes.'; DataClassification = SystemMetadata; OptionCaption = 'Manual,Automatic,Always Ask'; OptionMembers = Manual,Automatic,"Always Ask"; } field(16; "Insert Rec. Lines On Orders"; Option) { Caption = 'Insert Rec. Lines On Orders'; ToolTip = 'Specifies how you want to use standard purchase codes on purchase orders.'; DataClassification = SystemMetadata; OptionCaption = 'Manual,Automatic,Always Ask'; OptionMembers = Manual,Automatic,"Always Ask"; } field(17; "Insert Rec. Lines On Invoices"; Option) { Caption = 'Insert Rec. Lines On Invoices'; ToolTip = 'Specifies how you want to use standard purchase codes on purchase invoices.'; DataClassification = SystemMetadata; OptionCaption = 'Manual,Automatic,Always Ask'; OptionMembers = Manual,Automatic,"Always Ask"; } field(18; "Insert Rec. Lines On Cr. Memos"; Option) { Caption = 'Insert Rec. Lines On Cr. Memos'; ToolTip = 'Specifies how you want to use standard purchase codes on purchase credit memos.'; DataClassification = SystemMetadata; OptionCaption = 'Manual,Automatic,Always Ask'; OptionMembers = Manual,Automatic,"Always Ask"; } } keys { key(Key1; "Vendor No.", "Code") { Clustered = true; } key(Key2; Code, "Currency Code") { } } fieldgroups { } trigger OnRename() begin Error(RenameErr); end; var RenameErr: Label 'You cannot rename the line.'; procedure InsertPurchLines(PurchHeader: Record "Purchase Header") var StdVendPurchCode: Record "Standard Vendor Purchase Code"; StdVendPurchCodes: Page "Standard Vendor Purchase Codes"; IsHandled: Boolean; begin PurchHeader.TestField("No."); PurchHeader.TestField("Buy-from Vendor No."); StdVendPurchCode.FilterGroup := 2; StdVendPurchCode.SetRange("Vendor No.", PurchHeader."Buy-from Vendor No."); StdVendPurchCode.FilterGroup := 0; IsHandled := false; OnInsertPurchLinesOnBeforeApplyStdVendPurchCodes(StdVendPurchCode, IsHandled, PurchHeader); if not IsHandled then begin StdVendPurchCodes.SetTableView(StdVendPurchCode); StdVendPurchCodes.LookupMode(true); if StdVendPurchCodes.RunModal() = ACTION::LookupOK then begin StdVendPurchCodes.GetSelected(StdVendPurchCode); if StdVendPurchCode.FindSet() then repeat ApplyStdCodesToPurchaseLines(PurchHeader, StdVendPurchCode); until StdVendPurchCode.Next() = 0; end; end; end; procedure ApplyStdCodesToPurchaseLines(PurchHeader: Record "Purchase Header"; StdVendPurchCode: Record "Standard Vendor Purchase Code") var Currency: Record Currency; PurchLine: Record "Purchase Line"; StdPurchLine: Record "Standard Purchase Line"; StdPurchCode: Record "Standard Purchase Code"; Factor: Integer; IsHandled: Boolean; begin Currency.Initialize(PurchHeader."Currency Code"); StdVendPurchCode.TestField(Code); StdVendPurchCode.TestField("Vendor No.", PurchHeader."Buy-from Vendor No."); StdPurchCode.Get(StdVendPurchCode.Code); StdPurchCode.TestField("Currency Code", PurchHeader."Currency Code"); StdPurchLine.SetRange("Standard Purchase Code", StdVendPurchCode.Code); PurchLine."Document Type" := PurchHeader."Document Type"; PurchLine."Document No." := PurchHeader."No."; PurchLine.SetRange("Document Type", PurchHeader."Document Type"); PurchLine.SetRange("Document No.", PurchHeader."No."); if PurchHeader."Prices Including VAT" then Factor := 1 else Factor := 0; OnApplyStdCodesToPurchaseLinesOnBeforeStdPurchLineFind(Rec, StdPurchLine, PurchLine, PurchHeader, StdPurchCode); PurchLine.LockTable(); StdPurchLine.LockTable(); if StdPurchLine.Find('-') then repeat PurchLine.Init(); PurchLine.SetPurchHeader(PurchHeader); PurchLine."Line No." := 0; PurchLine.Validate(Type, StdPurchLine.Type); IsHandled := false; OnApplyStdCodesToPurchaseLinesOnLoopStdPurchLine(Rec, StdPurchLine, PurchLine, PurchHeader, StdPurchCode, IsHandled); if not IsHandled then if StdPurchLine.Type = StdPurchLine.Type::" " then begin PurchLine.Validate("No.", StdPurchLine."No."); PurchLine.Description := StdPurchLine.Description; PurchLine."Buy-from Vendor No." := PurchHeader."Buy-from Vendor No."; end else if not StdPurchLine.EmptyLine() then begin StdPurchLine.TestField("No."); PurchLine.Validate("No.", StdPurchLine."No."); if StdPurchLine."Variant Code" <> '' then PurchLine.Validate("Variant Code", StdPurchLine."Variant Code"); PurchLine.Validate(Quantity, StdPurchLine.Quantity); if StdPurchLine."Unit of Measure Code" <> '' then PurchLine.Validate("Unit of Measure Code", StdPurchLine."Unit of Measure Code"); if StdPurchLine.Description <> '' then PurchLine.Validate(Description, StdPurchLine.Description); if (StdPurchLine.Type = StdPurchLine.Type::"G/L Account") or (StdPurchLine.Type = StdPurchLine.Type::"Charge (Item)") then PurchLine.Validate( "Direct Unit Cost", Round(StdPurchLine."Amount Excl. VAT" * (PurchLine."VAT %" / 100 * Factor + 1), Currency."Unit-Amount Rounding Precision")); end; PurchLine."Shortcut Dimension 1 Code" := StdPurchLine."Shortcut Dimension 1 Code"; PurchLine."Shortcut Dimension 2 Code" := StdPurchLine."Shortcut Dimension 2 Code"; CombineDimensions(PurchLine, StdPurchLine); OnBeforeApplyStdCodesToPurchaseLines(PurchLine, StdPurchLine); if StdPurchLine.InsertLine() then begin PurchLine."Line No." := GetNextLineNo(PurchLine); PurchLine.Insert(true); OnApplyStdCodesToPurchaseLinesOnAfterPurchLineInsert(PurchLine, PurchHeader, StdPurchLine); InsertExtendedText(PurchLine, PurchHeader); end; until StdPurchLine.Next() = 0; OnAfterApplyStdCodesToPurchaseLines(Rec, StdPurchLine, PurchLine, PurchHeader, StdPurchCode); end; local procedure CombineDimensions(var PurchaseLine: Record "Purchase Line"; StdPurchaseLine: Record "Standard Purchase Line") var DimensionManagement: Codeunit DimensionManagement; DimensionSetIDArr: array[10] of Integer; begin DimensionSetIDArr[1] := PurchaseLine."Dimension Set ID"; DimensionSetIDArr[2] := StdPurchaseLine."Dimension Set ID"; PurchaseLine."Dimension Set ID" := DimensionManagement.GetCombinedDimensionSetID( DimensionSetIDArr, PurchaseLine."Shortcut Dimension 1 Code", PurchaseLine."Shortcut Dimension 2 Code"); OnAfterCombineDimensions(PurchaseLine, StdPurchaseLine); end; procedure InsertExtendedText(PurchLine: Record "Purchase Line") var TransferExtendedText: Codeunit "Transfer Extended Text"; begin if PurchLine.Type = PurchLine.Type::" " then exit; if TransferExtendedText.PurchCheckIfAnyExtText(PurchLine, false) then TransferExtendedText.InsertPurchExtText(PurchLine); end; procedure InsertExtendedText(PurchLine: Record "Purchase Line"; PurchaseHeader: Record "Purchase Header") var TransferExtendedText: Codeunit "Transfer Extended Text"; begin if TransferExtendedText.PurchCheckIfAnyExtText(PurchLine, false, PurchaseHeader) then TransferExtendedText.InsertPurchExtText(PurchLine); end; procedure GetNextLineNo(PurchLine: Record "Purchase Line"): Integer begin PurchLine.SetRange("Document Type", PurchLine."Document Type"); PurchLine.SetRange("Document No.", PurchLine."Document No."); if PurchLine.FindLast() then exit(PurchLine."Line No." + 10000); exit(10000); end; procedure SetFilterByAutomaticAndAlwaysAskCodes(PurchaseHeader: Record "Purchase Header") begin SetRange("Vendor No.", PurchaseHeader."Buy-from Vendor No."); SetRange("Currency Code", PurchaseHeader."Currency Code"); case PurchaseHeader."Document Type" of PurchaseHeader."Document Type"::Quote: SetFilter("Insert Rec. Lines On Quotes", '<>%1', "Insert Rec. Lines On Quotes"::Manual); PurchaseHeader."Document Type"::Order: SetFilter("Insert Rec. Lines On Orders", '<>%1', "Insert Rec. Lines On Orders"::Manual); PurchaseHeader."Document Type"::Invoice: SetFilter("Insert Rec. Lines On Invoices", '<>%1', "Insert Rec. Lines On Invoices"::Manual); PurchaseHeader."Document Type"::"Credit Memo": SetFilter("Insert Rec. Lines On Cr. Memos", '<>%1', "Insert Rec. Lines On Cr. Memos"::Manual); end; OnAfterSetFilterByAutomaticAndAlwaysAskCodes(Rec, PurchaseHeader); end; procedure IsInsertRecurringLinesOnDocumentAutomatic(PurchaseHeader: Record "Purchase Header"): Boolean begin case PurchaseHeader."Document Type" of PurchaseHeader."Document Type"::Quote: exit("Insert Rec. Lines On Quotes" = "Insert Rec. Lines On Quotes"::Automatic); PurchaseHeader."Document Type"::Order: exit("Insert Rec. Lines On Orders" = "Insert Rec. Lines On Orders"::Automatic); PurchaseHeader."Document Type"::Invoice: exit("Insert Rec. Lines On Invoices" = "Insert Rec. Lines On Invoices"::Automatic); PurchaseHeader."Document Type"::"Credit Memo": exit("Insert Rec. Lines On Cr. Memos" = "Insert Rec. Lines On Cr. Memos"::Automatic); else exit(false); end; end; procedure ShouldAutoInsertRecurringLinesOnDocument(PurchaseHeader: Record "Purchase Header"): Boolean begin case PurchaseHeader."Document Type" of PurchaseHeader."Document Type"::Quote: exit("Insert Rec. Lines On Quotes" <> "Insert Rec. Lines On Quotes"::Manual); PurchaseHeader."Document Type"::Order: exit("Insert Rec. Lines On Orders" <> "Insert Rec. Lines On Orders"::Manual); PurchaseHeader."Document Type"::Invoice: exit("Insert Rec. Lines On Invoices" <> "Insert Rec. Lines On Invoices"::Manual); PurchaseHeader."Document Type"::"Credit Memo": exit("Insert Rec. Lines On Cr. Memos" <> "Insert Rec. Lines On Cr. Memos"::Manual); else exit(false); end; end; [IntegrationEvent(false, false)] local procedure OnBeforeApplyStdCodesToPurchaseLines(var PurchLine: Record "Purchase Line"; StdPurchLine: Record "Standard Purchase Line") begin end; [IntegrationEvent(false, false)] local procedure OnAfterCombineDimensions(var PurchaseLine: Record "Purchase Line"; StdPurchaseLine: Record "Standard Purchase Line") begin end; [IntegrationEvent(false, false)] local procedure OnAfterApplyStdCodesToPurchaseLines(var StandardVendorPurchaseCode: Record "Standard Vendor Purchase Code"; var StandardPurchaseLine: Record "Standard Purchase Line"; var PurchaseLine: Record "Purchase Line"; PurchaseHeader: Record "Purchase Header"; StandardPurchaseCode: Record "Standard Purchase Code") begin end; [IntegrationEvent(false, false)] local procedure OnApplyStdCodesToPurchaseLinesOnBeforeStdPurchLineFind(var StandardVendorPurchaseCode: Record "Standard Vendor Purchase Code"; var StandardPurchaseLine: Record "Standard Purchase Line"; var PurchaseLine: Record "Purchase Line"; PurchaseHeader: Record "Purchase Header"; StandardPurchaseCode: Record "Standard Purchase Code") begin end; [IntegrationEvent(false, false)] local procedure OnApplyStdCodesToPurchaseLinesOnLoopStdPurchLine(var StandardVendorPurchaseCode: Record "Standard Vendor Purchase Code"; var StandardPurchaseLine: Record "Standard Purchase Line"; var PurchaseLine: Record "Purchase Line"; var PurchaseHeader: Record "Purchase Header"; var StandardPurchaseCode: Record "Standard Purchase Code"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnApplyStdCodesToPurchaseLinesOnAfterPurchLineInsert(var PurchaseLine: Record "Purchase Line"; var PurchaseHeader: Record "Purchase Header"; var StandardPurchaseLine: Record "Standard Purchase Line") begin end; [IntegrationEvent(false, false)] local procedure OnInsertPurchLinesOnBeforeApplyStdVendPurchCodes(var StandardVendorPurchaseCode: Record "Standard Vendor Purchase Code"; var IsHandled: Boolean; var PurchaseHeader: Record "Purchase Header") begin end; [IntegrationEvent(false, false)] local procedure OnAfterSetFilterByAutomaticAndAlwaysAskCodes(var StandardVendorPurchaseCode: Record "Standard Vendor Purchase Code"; var PurchaseHeader: Record "Purchase Header") begin end;}