Page 453 Issued Fin. Charge Memo Stat.
src/Layers/W1/BaseApp/Sales/FinanceCharge/IssuedFinChargeMemoStat.Page.al143 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.Sales.FinanceCharge;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.VAT.Setup;using Microsoft.Sales.Customer;/// <summary>/// Displays statistical information for posted finance charge memos including interest amounts, VAT, and customer credit status./// </summary>page 453 "Issued Fin. Charge Memo Stat."{ Caption = 'Issued Fin. Charge Memo Stat.'; Editable = false; LinksAllowed = false; PageType = Card; SourceTable = "Issued Fin. Charge Memo Header"; layout { area(content) { group(General) { Caption = 'General'; field(Interest; Interest) { ApplicationArea = Basic, Suite; AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'Interest Amount'; DrillDown = false; ToolTip = 'Specifies the interest amount that has been calculated on the finance charge memo that has been issued.'; } field("Additional Fee"; Rec."Additional Fee") { ApplicationArea = Basic, Suite; DrillDown = false; } field(VatAmount; VatAmount) { ApplicationArea = Basic, Suite; AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'VAT Amount'; DrillDown = false; ToolTip = 'Specifies the VAT amount that has been calculated on the finance charge memo that has been issued.'; } field(FinChrgMemoTotal; FinChrgMemoTotal) { ApplicationArea = Basic, Suite; AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'Total'; ToolTip = 'Specifies the total amount that has been calculated on the issued finance charge memo.'; } } group(Customer) { Caption = 'Customer';#pragma warning disable AA0100 field("Cust.""Balance (LCY)"""; Cust."Balance (LCY)")#pragma warning restore AA0100 { ApplicationArea = Basic, Suite; AutoFormatType = 1; Caption = 'Balance (LCY)'; ToolTip = 'Specifies the balance in LCY on the customer''s account.'; }#pragma warning disable AA0100 field("Cust.""Credit Limit (LCY)"""; Cust."Credit Limit (LCY)")#pragma warning restore AA0100 { ApplicationArea = Basic, Suite; AutoFormatType = 1; AutoFormatExpression = ''; Caption = 'Credit Limit (LCY)'; ToolTip = 'Specifies the credit limit in local currency for the customer''s account. The value 0 represents unlimited credit.'; } field(CreditLimitLCYExpendedPct; CreditLimitLCYExpendedPct) { ApplicationArea = Basic, Suite; AutoFormatType = 0; Caption = 'Expended % of Credit Limit (LCY)'; ExtendedDatatype = Ratio; ToolTip = 'Specifies the expended percentage of the credit limit in (LCY).'; } } } } actions { } trigger OnAfterGetRecord() var CustPostingGr: Record "Customer Posting Group"; GLAcc: Record "G/L Account"; VATPostingSetup: Record "VAT Posting Setup"; VATInterest: Decimal; begin Rec.CalcFields("Interest Amount", "VAT Amount"); FinChrgMemoTotal := Rec."Additional Fee" + Rec."Interest Amount" + Rec."VAT Amount"; CustPostingGr.Get(Rec."Customer Posting Group"); GLAcc.Get(CustPostingGr.GetInterestAccount()); VATPostingSetup.Get(Rec."VAT Bus. Posting Group", GLAcc."VAT Prod. Posting Group"); OnAfterGetVATPostingSetup(VATPostingSetup); VATInterest := VATPostingSetup."VAT %"; GLAcc.Get(CustPostingGr.GetAdditionalFeeAccount()); VATPostingSetup.Get(Rec."VAT Bus. Posting Group", GLAcc."VAT Prod. Posting Group"); OnAfterGetVATPostingSetup(VATPostingSetup); Interest := (FinChrgMemoTotal - Rec."Additional Fee" * (VATPostingSetup."VAT %" / 100 + 1)) / (VATInterest / 100 + 1); VatAmount := Interest * VATInterest / 100 + Rec."Additional Fee" * VATPostingSetup."VAT %" / 100; if Cust.Get(Rec."Customer No.") then Cust.CalcFields("Balance (LCY)") else Clear(Cust); if Cust."Credit Limit (LCY)" = 0 then CreditLimitLCYExpendedPct := 0 else CreditLimitLCYExpendedPct := Round(Cust."Balance (LCY)" / Cust."Credit Limit (LCY)" * 10000, 1); end; var Cust: Record Customer; FinChrgMemoTotal: Decimal; CreditLimitLCYExpendedPct: Decimal; Interest: Decimal; VatAmount: Decimal; [IntegrationEvent(false, false)] local procedure OnAfterGetVATPostingSetup(var VATPostingSetup: Record "VAT Posting Setup") begin end;}