Table 93 Vendor Posting Group
src/Layers/W1/BaseApp/Purchases/Vendor/VendorPostingGroup.Table.al482 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.Vendor;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.ReceivablesPayables;using Microsoft.Foundation.PaymentTerms;using Microsoft.Purchases.Payables;using Microsoft.Purchases.Setup;table 93 "Vendor Posting Group"{ Caption = 'Vendor Posting Group'; LookupPageID = "Vendor Posting Groups"; DataClassification = CustomerContent; fields { field(1; "Code"; Code[20]) { Caption = 'Code'; ToolTip = 'Specifies an identifier for the vendor posting group.'; NotBlank = true; } field(2; "Payables Account"; Code[20]) { Caption = 'Payables Account'; ToolTip = 'Specifies the general ledger account to use when you post payables due to vendors in this posting group.'; TableRelation = "G/L Account"; trigger OnLookup() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.LookupGLAccountWithoutCategory("Payables Account") else LookupGLAccount( "Payables Account", GLAccountCategory."Account Category"::Liabilities, GLAccountCategoryMgt.GetCurrentLiabilities()); Validate("Payables Account"); end; trigger OnValidate() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.CheckGLAccountWithoutCategory("Payables Account", false, false) else CheckGLAccount( FieldNo("Payables Account"), "Payables Account", false, false, GLAccountCategory."Account Category"::Liabilities, GLAccountCategoryMgt.GetCurrentLiabilities()); CheckGLAccSourceCurrencyRevaluation("Payables Account"); end; } field(7; "Service Charge Acc."; Code[20]) { Caption = 'Service Charge Acc.'; ToolTip = 'Specifies the general ledger account to use when you post service charges due to vendors in this posting group.'; TableRelation = "G/L Account"; trigger OnLookup() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.LookupGLAccountWithoutCategory("Service Charge Acc.") else LookupGLAccount( "Service Charge Acc.", GLAccountCategory."Account Category"::Liabilities, GLAccountCategoryMgt.GetFeesExpense()); Validate("Service Charge Acc."); end; trigger OnValidate() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.CheckGLAccountWithoutCategory("Service Charge Acc.", true, true) else CheckGLAccount( FieldNo("Service Charge Acc."), "Service Charge Acc.", true, true, GLAccountCategory."Account Category"::Liabilities, GLAccountCategoryMgt.GetFeesExpense()); end; } field(8; "Payment Disc. Debit Acc."; Code[20]) { Caption = 'Payment Disc. Debit Acc.'; ToolTip = 'Specifies the general ledger account to use when you post reductions in payment discounts received from vendors in this posting group.'; TableRelation = "G/L Account"; trigger OnLookup() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.LookupGLAccountWithoutCategory("Payment Disc. Debit Acc.") else LookupGLAccount("Payment Disc. Debit Acc.", GLAccountCategory."Account Category"::Income, ''); Validate("Payment Disc. Debit Acc."); end; trigger OnValidate() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.CheckGLAccountWithoutCategory("Payment Disc. Debit Acc.", false, false) else CheckGLAccount(FieldNo("Payment Disc. Debit Acc."), "Payment Disc. Debit Acc.", false, false, GLAccountCategory."Account Category"::Income, ''); end; } field(9; "Invoice Rounding Account"; Code[20]) { Caption = 'Invoice Rounding Account'; ToolTip = 'Specifies the general ledger account to use when amounts result from invoice rounding when you post transactions that involve vendors.'; TableRelation = "G/L Account"; trigger OnLookup() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.LookupGLAccountWithoutCategory("Invoice Rounding Account") else LookupGLAccount("Invoice Rounding Account", GLAccountCategory."Account Category"::Expense, ''); Validate("Invoice Rounding Account"); end; trigger OnValidate() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.CheckGLAccountWithoutCategory("Invoice Rounding Account", true, false) else CheckGLAccount(FieldNo("Invoice Rounding Account"), "Invoice Rounding Account", true, false, GLAccountCategory."Account Category"::Expense, ''); end; } field(10; "Debit Curr. Appln. Rndg. Acc."; Code[20]) { Caption = 'Debit Curr. Appln. Rndg. Acc.'; ToolTip = 'Specifies the general ledger account to use when you post rounding differences. These differences can occur when you apply entries in different currencies to one another.'; TableRelation = "G/L Account"; trigger OnLookup() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.LookupGLAccountWithoutCategory("Debit Curr. Appln. Rndg. Acc.") else LookupGLAccount("Debit Curr. Appln. Rndg. Acc.", GLAccountCategory."Account Category"::Income, ''); Validate("Debit Curr. Appln. Rndg. Acc."); end; trigger OnValidate() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.CheckGLAccountWithoutCategory("Debit Curr. Appln. Rndg. Acc.", false, false) else CheckGLAccount( FieldNo("Debit Curr. Appln. Rndg. Acc."), "Debit Curr. Appln. Rndg. Acc.", false, false, GLAccountCategory."Account Category"::Income, ''); end; } field(11; "Credit Curr. Appln. Rndg. Acc."; Code[20]) { Caption = 'Credit Curr. Appln. Rndg. Acc.'; ToolTip = 'Specifies the general ledger account to use when you post rounding differences. These differences can occur when you apply entries in different currencies to one another.'; TableRelation = "G/L Account"; trigger OnLookup() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.LookupGLAccountWithoutCategory("Credit Curr. Appln. Rndg. Acc.") else LookupGLAccount("Credit Curr. Appln. Rndg. Acc.", GLAccountCategory."Account Category"::Income, ''); Validate("Credit Curr. Appln. Rndg. Acc."); end; trigger OnValidate() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.CheckGLAccountWithoutCategory("Credit Curr. Appln. Rndg. Acc.", false, false) else CheckGLAccount( FieldNo("Credit Curr. Appln. Rndg. Acc."), "Credit Curr. Appln. Rndg. Acc.", false, false, GLAccountCategory."Account Category"::Income, ''); end; } field(12; "Debit Rounding Account"; Code[20]) { Caption = 'Debit Rounding Account'; ToolTip = 'Specifies the general ledger account number to use when you post rounding differences from a remaining amount.'; TableRelation = "G/L Account"; trigger OnLookup() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.LookupGLAccountWithoutCategory("Debit Rounding Account") else LookupGLAccount("Debit Rounding Account", GLAccountCategory."Account Category"::Expense, ''); Validate("Debit Rounding Account"); end; trigger OnValidate() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.CheckGLAccountWithoutCategory("Debit Rounding Account", false, false) else CheckGLAccount(FieldNo("Debit Rounding Account"), "Debit Rounding Account", false, false, GLAccountCategory."Account Category"::Expense, ''); end; } field(13; "Credit Rounding Account"; Code[20]) { Caption = 'Credit Rounding Account'; ToolTip = 'Specifies the general ledger account number to use when you post rounding differences from a remaining amount.'; TableRelation = "G/L Account"; trigger OnLookup() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.LookupGLAccountWithoutCategory("Credit Rounding Account") else LookupGLAccount("Credit Rounding Account", GLAccountCategory."Account Category"::Expense, ''); Validate("Credit Rounding Account"); end; trigger OnValidate() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.CheckGLAccountWithoutCategory("Credit Rounding Account", false, false) else CheckGLAccount(FieldNo("Credit Rounding Account"), "Credit Rounding Account", false, false, GLAccountCategory."Account Category"::Expense, ''); end; } field(16; "Payment Disc. Credit Acc."; Code[20]) { Caption = 'Payment Disc. Credit Acc.'; ToolTip = 'Specifies the general ledger account to use when you post payment discounts received from vendors in this posting group.'; TableRelation = "G/L Account"; trigger OnLookup() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.LookupGLAccountWithoutCategory("Payment Disc. Credit Acc.") else LookupGLAccount("Payment Disc. Credit Acc.", GLAccountCategory."Account Category"::Income, ''); Validate("Payment Disc. Credit Acc."); end; trigger OnValidate() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.CheckGLAccountWithoutCategory("Payment Disc. Credit Acc.", false, false) else CheckGLAccount(FieldNo("Payment Disc. Credit Acc."), "Payment Disc. Credit Acc.", false, false, GLAccountCategory."Account Category"::Income, ''); end; } field(17; "Payment Tolerance Debit Acc."; Code[20]) { Caption = 'Payment Tolerance Debit Acc.'; ToolTip = 'Specifies the general ledger account number to use when you post purchase tolerance amounts and payments for purchases. This applies to this particular combination of business posting group and product posting group.'; TableRelation = "G/L Account"; trigger OnLookup() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.LookupGLAccountWithoutCategory("Payment Tolerance Debit Acc.") else LookupGLAccount( "Payment Tolerance Debit Acc.", GLAccountCategory."Account Category"::Income, GLAccountCategoryMgt.GetIncomeInterest()); Validate("Payment Tolerance Debit Acc."); end; trigger OnValidate() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.CheckGLAccountWithoutCategory("Payment Tolerance Debit Acc.", false, false) else CheckGLAccount( FieldNo("Payment Tolerance Debit Acc."), "Payment Tolerance Debit Acc.", false, false, GLAccountCategory."Account Category"::Income, GLAccountCategoryMgt.GetIncomeInterest()); end; } field(18; "Payment Tolerance Credit Acc."; Code[20]) { Caption = 'Payment Tolerance Credit Acc.'; ToolTip = 'Specifies the general ledger account number to use when you post purchase tolerance amounts and payments for purchases. This applies to this particular combination of business posting group and product posting group.'; TableRelation = "G/L Account"; trigger OnLookup() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.LookupGLAccountWithoutCategory("Payment Tolerance Credit Acc.") else LookupGLAccount( "Payment Tolerance Credit Acc.", GLAccountCategory."Account Category"::Income, GLAccountCategoryMgt.GetIncomeInterest()); Validate("Payment Tolerance Credit Acc."); end; trigger OnValidate() begin if "View All Accounts on Lookup" then GLAccountCategoryMgt.CheckGLAccountWithoutCategory("Payment Tolerance Credit Acc.", false, false) else CheckGLAccount( FieldNo("Payment Tolerance Credit Acc."), "Payment Tolerance Credit Acc.", false, false, GLAccountCategory."Account Category"::Income, GLAccountCategoryMgt.GetIncomeInterest()); end; } field(20; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies the description for the vendor posting group.'; } field(21; "View All Accounts on Lookup"; Boolean) { Caption = 'View All Accounts on Lookup'; ToolTip = 'Specifies that all possible accounts are shown when you look up from a field. If the check box is not selected, then only accounts related to the involved account category are shown.'; } } keys { key(Key1; "Code") { Clustered = true; } } fieldgroups { fieldgroup(Brick; "Code") { } } trigger OnDelete() begin CheckGroupUsage(); end; var GLSetup: Record "General Ledger Setup"; GLAccountCategory: Record "G/L Account Category"; GLAccountCategoryMgt: Codeunit "G/L Account Category Mgt."; PostingSetupMgt: Codeunit PostingSetupManagement; YouCannotDeleteErr: Label 'You cannot delete %1.', Comment = '%1 = Code'; SourceCurrRevalNotAllowedErr: Label 'G/L Account %1 has Source Currency Revaluation enabled or has a Source Currency Code and cannot be used as a Payables Account.', Comment = '%1 = G/L Account No.'; local procedure CheckGLAccSourceCurrencyRevaluation(AccNo: Code[20]) var GLAccount: Record "G/L Account"; begin if AccNo = '' then exit; if GLAccount.Get(AccNo) then if (GLAccount."Source Currency Revaluation") or (GLAccount."Source Currency Code" <> '') then Error(SourceCurrRevalNotAllowedErr, AccNo); end; local procedure CheckGroupUsage() var Vendor: Record Vendor; VendorLedgerEntry: Record "Vendor Ledger Entry"; begin Vendor.SetRange("Vendor Posting Group", Code); if not Vendor.IsEmpty() then Error(YouCannotDeleteErr, Code); VendorLedgerEntry.SetRange("Vendor Posting Group", Code); if not VendorLedgerEntry.IsEmpty() then Error(YouCannotDeleteErr, Code); end; procedure GetPayablesAccount(): Code[20] begin if "Payables Account" = '' then PostingSetupMgt.LogVendPostingGroupFieldError(Rec, FieldNo("Payables Account")); exit("Payables Account"); end; procedure GetPmtDiscountAccount(Debit: Boolean): Code[20] begin if Debit then begin if "Payment Disc. Debit Acc." = '' then PostingSetupMgt.LogVendPostingGroupFieldError(Rec, FieldNo("Payment Disc. Debit Acc.")); exit("Payment Disc. Debit Acc."); end; if "Payment Disc. Credit Acc." = '' then PostingSetupMgt.LogVendPostingGroupFieldError(Rec, FieldNo("Payment Disc. Credit Acc.")); exit("Payment Disc. Credit Acc."); end; procedure GetPmtToleranceAccount(Debit: Boolean): Code[20] begin if Debit then begin if "Payment Tolerance Debit Acc." = '' then PostingSetupMgt.LogVendPostingGroupFieldError(Rec, FieldNo("Payment Tolerance Debit Acc.")); exit("Payment Tolerance Debit Acc."); end; if "Payment Tolerance Credit Acc." = '' then PostingSetupMgt.LogVendPostingGroupFieldError(Rec, FieldNo("Payment Tolerance Credit Acc.")); exit("Payment Tolerance Credit Acc."); end; procedure GetRoundingAccount(Debit: Boolean): Code[20] begin if Debit then begin if "Debit Rounding Account" = '' then PostingSetupMgt.LogVendPostingGroupFieldError(Rec, FieldNo("Debit Rounding Account")); exit("Debit Rounding Account"); end; if "Credit Rounding Account" = '' then PostingSetupMgt.LogVendPostingGroupFieldError(Rec, FieldNo("Credit Rounding Account")); exit("Credit Rounding Account"); end; procedure GetApplRoundingAccount(Debit: Boolean): Code[20] begin if Debit then begin if "Debit Curr. Appln. Rndg. Acc." = '' then PostingSetupMgt.LogVendPostingGroupFieldError(Rec, FieldNo("Debit Curr. Appln. Rndg. Acc.")); exit("Debit Curr. Appln. Rndg. Acc."); end; if "Credit Curr. Appln. Rndg. Acc." = '' then PostingSetupMgt.LogVendPostingGroupFieldError(Rec, FieldNo("Credit Curr. Appln. Rndg. Acc.")); exit("Credit Curr. Appln. Rndg. Acc."); end; procedure GetInvRoundingAccount(): Code[20] var GLAccount: Record "G/L Account"; begin if "Invoice Rounding Account" <> '' then begin GLAccount.Get("Invoice Rounding Account"); GLAccount.CheckGenProdPostingGroup(); end else PostingSetupMgt.LogVendPostingGroupFieldError(Rec, FieldNo("Invoice Rounding Account")); exit("Invoice Rounding Account"); end; procedure GetServiceChargeAccount(): Code[20] begin if "Service Charge Acc." = '' then PostingSetupMgt.LogVendPostingGroupFieldError(Rec, FieldNo("Service Charge Acc.")); exit("Service Charge Acc."); end; procedure SetAccountVisibility(var PmtToleranceVisible: Boolean; var PmtDiscountVisible: Boolean; var InvRoundingVisible: Boolean; var ApplnRoundingVisible: Boolean) var PurchSetup: Record "Purchases & Payables Setup"; PaymentTerms: Record "Payment Terms"; begin GLSetup.Get(); PmtToleranceVisible := GLSetup.GetPmtToleranceVisible(); PmtDiscountVisible := PaymentTerms.UsePaymentDiscount(); PurchSetup.Get(); InvRoundingVisible := PurchSetup."Invoice Rounding"; ApplnRoundingVisible := PurchSetup."Appln. between Currencies" <> PurchSetup."Appln. between Currencies"::None; end; local procedure CheckGLAccount(ChangedFieldNo: Integer; AccNo: Code[20]; CheckProdPostingGroup: Boolean; CheckDirectPosting: Boolean; AccountCategory: Option; AccountSubcategory: Text) begin GLAccountCategoryMgt.CheckGLAccount(Database::"Vendor Posting Group", ChangedFieldNo, AccNo, CheckProdPostingGroup, CheckDirectPosting, AccountCategory, AccountSubcategory); end; local procedure LookupGLAccount(var AccountNo: Code[20]; AccountCategory: Option; AccountSubcategoryFilter: Text) begin GLAccountCategoryMgt.LookupGLAccount(Database::"Vendor Posting Group", CurrFieldNo, AccountNo, AccountCategory, AccountSubcategoryFilter); end;}