Page 400 Purchase Invoice Statistics
src/Layers/W1/BaseApp/Purchases/History/PurchaseInvoiceStatistics.Page.al274 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.History;using Microsoft.Finance.Currency;using Microsoft.Finance.VAT.Calculation;using Microsoft.Purchases.Payables;using Microsoft.Purchases.Vendor;page 400 "Purchase Invoice Statistics"{ Caption = 'Purchase Invoice Statistics'; Editable = false; LinksAllowed = false; PageType = ListPlus; SourceTable = "Purch. Inv. Header"; layout { area(content) { group(General) { Caption = 'General'; field("VendAmount + InvDiscAmount"; VendAmount + InvDiscAmount) { ApplicationArea = Basic, Suite; AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'Amount'; ToolTip = 'Specifies the net amount of all the lines in the purchase document.'; } field(InvDiscAmount; InvDiscAmount) { ApplicationArea = Basic, Suite; AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'Inv. Discount Amount'; ToolTip = 'Specifies the invoice discount amount for the purchase document.'; } field(VendAmount; VendAmount) { ApplicationArea = Basic, Suite; AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'Total'; ToolTip = 'Specifies the total amount, less any invoice discount amount, and excluding VAT for the purchase document.'; } field(VATAmount; VATAmount) { ApplicationArea = Basic, Suite; AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; CaptionClass = '3,' + Format(VATAmountText); Caption = 'VAT Amount'; ToolTip = 'Specifies the total VAT amount that has been calculated for all the lines in the purchase document.'; } field(AmountInclVAT; AmountInclVAT) { ApplicationArea = Basic, Suite; AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'Total Incl. VAT'; ToolTip = 'Specifies the total amount, including VAT, that will be posted to the vendor''s account for all the lines in the purchase document.'; } field(AmountLCY; AmountLCY) { ApplicationArea = Basic, Suite; AutoFormatType = 0; AutoFormatExpression = ''; Caption = 'Purchase (LCY)'; ToolTip = 'Specifies your total purchases.'; } field(LineQty; LineQty) { ApplicationArea = Basic, Suite; AutoFormatType = 0; Caption = 'Quantity'; DecimalPlaces = 0 : 5; ToolTip = 'Specifies the total quantity of G/L account entries, items and/or resources in the purchase document.'; } field(TotalParcels; TotalParcels) { ApplicationArea = Basic, Suite; AutoFormatType = 0; Caption = 'Parcels'; DecimalPlaces = 0 : 5; ToolTip = 'Specifies the total number of parcels in the purchase document.'; } field(TotalNetWeight; TotalNetWeight) { ApplicationArea = Basic, Suite; AutoFormatType = 0; Caption = 'Net Weight'; DecimalPlaces = 0 : 5; ToolTip = 'Specifies the total net weight of the items in the purchase document.'; } field(TotalGrossWeight; TotalGrossWeight) { ApplicationArea = Basic, Suite; AutoFormatType = 0; Caption = 'Gross Weight'; DecimalPlaces = 0 : 5; ToolTip = 'Specifies the total gross weight of the items in the purchase document.'; } field(TotalVolume; TotalVolume) { ApplicationArea = Basic, Suite; AutoFormatType = 0; Caption = 'Volume'; DecimalPlaces = 0 : 5; ToolTip = 'Specifies the total volume of the items in the purchase document.'; } } part(SubForm; "VAT Specification Subform") { ApplicationArea = Basic, Suite; Editable = false; } group(Vendor) { Caption = 'Vendor';#pragma warning disable AA0100 field("Vend.""Balance (LCY)"""; Vend."Balance (LCY)")#pragma warning restore AA0100 { ApplicationArea = Basic, Suite; AutoFormatType = 1; Caption = 'Balance (LCY)'; ToolTip = 'Specifies the balance in LCY on the vendor''s account.'; } } } } actions { } trigger OnAfterGetRecord() var VendLedgEntry: Record "Vendor Ledger Entry"; begin ClearAll(); Currency.Initialize(Rec."Currency Code"); CalculateTotals(); VATAmount := AmountInclVAT - VendAmount; InvDiscAmount := Round(InvDiscAmount, Currency."Amount Rounding Precision"); if VATPercentage <= 0 then VATAmountText := Text000 else VATAmountText := StrSubstNo(Text001, VATPercentage); if Rec."Currency Code" = '' then AmountLCY := VendAmount else AmountLCY := CurrExchRate.ExchangeAmtFCYToLCY( WorkDate(), Rec."Currency Code", VendAmount, Rec."Currency Factor"); VendLedgEntry.SetCurrentKey("Document No."); VendLedgEntry.SetRange("Document No.", Rec."No."); VendLedgEntry.SetRange("Document Type", VendLedgEntry."Document Type"::Invoice); VendLedgEntry.SetRange("Vendor No.", Rec."Pay-to Vendor No."); if VendLedgEntry.FindFirst() then AmountLCY := -(VendLedgEntry."Purchase (LCY)"); if not Vend.Get(Rec."Pay-to Vendor No.") then Clear(Vend); Vend.CalcFields("Balance (LCY)"); PurchInvLine.CalcVATAmountLines(Rec, TempVATAmountLine); OnOnAfterGetRecordOnBeforeUpdateSubForm(Rec); CurrPage.SubForm.PAGE.SetTempVATAmountLine(TempVATAmountLine); CurrPage.SubForm.PAGE.InitGlobals(Rec."Currency Code", false, false, false, false, Rec."VAT Base Discount %"); end; var#pragma warning disable AA0074 Text000: Label 'VAT Amount';#pragma warning disable AA0470 Text001: Label '%1% VAT';#pragma warning restore AA0470#pragma warning restore AA0074 CurrExchRate: Record "Currency Exchange Rate"; PurchInvLine: Record "Purch. Inv. Line"; Vend: Record Vendor; TempVATAmountLine: Record "VAT Amount Line" temporary; VendAmount: Decimal; InvDiscAmount: Decimal; LineQty: Decimal; TotalNetWeight: Decimal; TotalGrossWeight: Decimal; TotalVolume: Decimal; TotalParcels: Decimal; VATAmount: Decimal; VATPercentage: Decimal; VATAmountText: Text[30]; protected var Currency: Record Currency; AmountInclVAT: Decimal; AmountLCY: Decimal; local procedure CalculateTotals() var IsHandled: Boolean; begin IsHandled := false; OnBeforeCalculateTotals( Rec, VendAmount, AmountInclVAT, InvDiscAmount, LineQty, TotalNetWeight, TotalGrossWeight, TotalVolume, TotalParcels, IsHandled); if IsHandled then exit; PurchInvLine.SetRange("Document No.", Rec."No."); if PurchInvLine.Find('-') then repeat VendAmount += PurchInvLine.Amount; AmountInclVAT += PurchInvLine."Amount Including VAT"; if Rec."Prices Including VAT" then InvDiscAmount += PurchInvLine."Inv. Discount Amount" / (1 + PurchInvLine.GetVATPct() / 100) else InvDiscAmount += PurchInvLine."Inv. Discount Amount"; LineQty += PurchInvLine.Quantity; TotalNetWeight += PurchInvLine.Quantity * PurchInvLine."Net Weight"; TotalGrossWeight += PurchInvLine.Quantity * PurchInvLine."Gross Weight"; TotalVolume += PurchInvLine.Quantity * PurchInvLine."Unit Volume"; if PurchInvLine."Units per Parcel" > 0 then TotalParcels += Round(PurchInvLine.Quantity / PurchInvLine."Units per Parcel", 1, '>'); if PurchInvLine."VAT %" <> VATPercentage then if VATPercentage = 0 then VATPercentage := PurchInvLine.GetVATPct() else VATPercentage := -1; OnCalculateTotalsOnAfterAddLineTotals( PurchInvLine, VendAmount, AmountInclVAT, InvDiscAmount, LineQty, TotalNetWeight, TotalGrossWeight, TotalVolume, TotalParcels, VATPercentage, Rec) until PurchInvLine.Next() = 0; OnAfterCalculateTotals( Rec, VendAmount, AmountInclVAT, InvDiscAmount, LineQty, TotalNetWeight, TotalGrossWeight, TotalVolume, TotalParcels); end; [IntegrationEvent(false, false)] local procedure OnBeforeCalculateTotals(PurchInvHeader: Record "Purch. Inv. Header"; var VendAmount: Decimal; var AmountInclVAT: Decimal; var InvDiscAmount: Decimal; var LineQty: Decimal; var TotalNetWeight: Decimal; var TotalGrossWeight: Decimal; var TotalVolume: Decimal; var TotalParcels: Decimal; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnCalculateTotalsOnAfterAddLineTotals(var PurchInvLine: Record "Purch. Inv. Line"; var VendAmount: Decimal; var AmountInclVAT: Decimal; var InvDiscAmount: Decimal; var LineQty: Decimal; var TotalNetWeight: Decimal; var TotalGrossWeight: Decimal; var TotalVolume: Decimal; var TotalParcels: Decimal; var VATPercentage: Decimal; PurchInvHeader: Record "Purch. Inv. Header") begin end; [IntegrationEvent(true, false)] local procedure OnAfterCalculateTotals(PurchInvHeader: Record "Purch. Inv. Header"; var VendAmount: Decimal; var AmountInclVAT: Decimal; var InvDiscAmount: Decimal; var LineQty: Decimal; var TotalNetWeight: Decimal; var TotalGrossWeight: Decimal; var TotalVolume: Decimal; var TotalParcels: Decimal) begin end; [IntegrationEvent(true, false)] local procedure OnOnAfterGetRecordOnBeforeUpdateSubForm(var PurchInvHeader: Record "Purch. Inv. Header") begin end;}