Page 161 Purchase Statistics

Base Application, Microsoft.Purchases.Document

src/Layers/W1/BaseApp/Purchases/Document/PurchaseStatistics.Page.al428 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.VAT.Calculation;using Microsoft.Purchases.Posting;using Microsoft.Purchases.Setup;using Microsoft.Purchases.Vendor;page 161 "Purchase Statistics"{    Caption = 'Purchase Statistics';    DeleteAllowed = false;    InsertAllowed = false;    LinksAllowed = false;    PageType = ListPlus;    SourceTable = "Purchase Header";    layout    {        area(content)        {            group(General)            {                Caption = 'General';                field(Amount; TotalPurchLine."Line Amount")                {                    ApplicationArea = Basic, Suite;                    AutoFormatExpression = Rec."Currency Code";                    AutoFormatType = 1;                    CaptionClass = GetCaptionClass(Text001, false);                    Caption = 'Amount';                    Editable = false;                    ToolTip = 'Specifies the net amount of all the lines in the purchase document.';                }                field(InvDiscountAmount; TotalPurchLine."Inv. Discount Amount")                {                    ApplicationArea = Basic, Suite;                    AutoFormatExpression = Rec."Currency Code";                    AutoFormatType = 1;                    Caption = 'Inv. Discount Amount';                    ToolTip = 'Specifies the invoice discount amount for the purchase document.';                    trigger OnValidate()                    begin                        UpdateInvDiscAmount();                    end;                }                field(TotalAmount1; TotalAmount1)                {                    ApplicationArea = Basic, Suite;                    AutoFormatExpression = Rec."Currency Code";                    AutoFormatType = 1;                    CaptionClass = GetCaptionClass(Text002, false);                    Caption = 'Total';                    ToolTip = 'Specifies the total amount less any invoice discount amount and excluding VAT for the purchase document.';                    trigger OnValidate()                    begin                        UpdateTotalAmount();                    end;                }                field(VATAmount; VATAmount)                {                    ApplicationArea = Basic, Suite;                    AutoFormatExpression = Rec."Currency Code";                    AutoFormatType = 1;                    CaptionClass = '3,' + Format(VATAmountText);                    Caption = 'VAT Amount';                    Editable = false;                    ToolTip = 'Specifies the total VAT amount that has been calculated for all the lines in the purchase document.';                }                field(TotalAmount2; TotalAmount2)                {                    ApplicationArea = Basic, Suite;                    AutoFormatExpression = Rec."Currency Code";                    AutoFormatType = 1;                    CaptionClass = GetCaptionClass(Text002, true);                    Caption = 'Total Incl. VAT';                    Editable = false;                    ToolTip = 'Specifies the total amount including VAT that will be posted to the vendor''s account for all the lines in the purchase document. This is the amount that you owe the vendor based on this purchase document. If the document is a credit memo, it is the amount that the vendor owes you.';                }                field("TotalPurchLineLCY.Amount"; TotalPurchLineLCY.Amount)                {                    ApplicationArea = Basic, Suite;                    AutoFormatType = 1;                    Caption = 'Purchase (LCY)';                    Editable = false;                    ToolTip = 'Specifies your total purchases. It is calculated from amounts excluding VAT on all completed and open purchase invoices and credit memos.';                }                field(Quantity; TotalPurchLine.Quantity)                {                    ApplicationArea = Basic, Suite;                    Caption = 'Quantity';                    DecimalPlaces = 0 : 5;                    Editable = false;                    ToolTip = 'Specifies the total quantity of G/L account entries, items, and/or resources in the purchase document.';                }#pragma warning disable AA0100                field("TotalPurchLine.""Units per Parcel"""; TotalPurchLine."Units per Parcel")#pragma warning restore AA0100                {                    ApplicationArea = Basic, Suite;                    Caption = 'Parcels';                    DecimalPlaces = 0 : 5;                    Editable = false;                    ToolTip = 'Specifies the total number of parcels in the purchase document.';                }#pragma warning disable AA0100                field("TotalPurchLine.""Net Weight"""; TotalPurchLine."Net Weight")#pragma warning restore AA0100                {                    ApplicationArea = Basic, Suite;                    Caption = 'Net Weight';                    DecimalPlaces = 0 : 5;                    Editable = false;                    ToolTip = 'Specifies the total net weight of the items in the purchase document.';                }#pragma warning disable AA0100                field("TotalPurchLine.""Gross Weight"""; TotalPurchLine."Gross Weight")#pragma warning restore AA0100                {                    ApplicationArea = Basic, Suite;                    Caption = 'Gross Weight';                    DecimalPlaces = 0 : 5;                    Editable = false;                    ToolTip = 'Specifies the total gross weight of the items in the purchase document.';                }#pragma warning disable AA0100                field("TotalPurchLine.""Unit Volume"""; TotalPurchLine."Unit Volume")#pragma warning restore AA0100                {                    ApplicationArea = Basic, Suite;                    Caption = 'Volume';                    DecimalPlaces = 0 : 5;                    Editable = false;                    ToolTip = 'Specifies the total volume of the items in the purchase document.';                }            }            part(SubForm; "VAT Specification Subform")            {                ApplicationArea = Basic, Suite;            }            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)';                    Editable = false;                    ToolTip = 'Specifies the balance on the vendor''s account.';                }            }        }    }    actions    {    }    trigger OnAfterGetRecord()    begin        CurrPage.Caption(StrSubstNo(Text000, Rec."Document Type"));        if PrevNo = Rec."No." then begin            GetVATSpecification();            exit;        end;        PrevNo := Rec."No.";        Rec.FilterGroup(2);        Rec.SetRange("No.", PrevNo);        Rec.FilterGroup(0);        CalculateTotals();    end;    trigger OnOpenPage()    begin        Rec.PrepareOpeningDocumentStatistics();        PurchSetup.Get();        AllowInvDisc :=          not (PurchSetup."Calc. Inv. Discount" and VendInvDiscRecExists(Rec."Invoice Disc. Code"));        AllowVATDifference :=          PurchSetup."Allow VAT Difference" and          not (Rec."Document Type" in [Rec."Document Type"::Quote, Rec."Document Type"::"Blanket Order"]);        OnOpenPageOnBeforeSetEditable(AllowInvDisc, AllowVATDifference, Rec, PurchSetup);        CurrPage.Editable := AllowVATDifference or AllowInvDisc;        SetVATSpecification();    end;    trigger OnClosePage()    var        PurchCalcDiscountByType: Codeunit "Purch - Calc Disc. By Type";    begin        PurchCalcDiscountByType.ResetRecalculateInvoiceDisc(Rec);    end;    trigger OnQueryClosePage(CloseAction: Action): Boolean    begin        GetVATSpecification();        if TempVATAmountLine.GetAnyLineModified() then            UpdateVATOnPurchLines();        exit(true);    end;    var#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'Purchase %1 Statistics';#pragma warning restore AA0470        Text001: Label 'Amount';        Text002: Label 'Total';#pragma warning disable AA0470        Text003: Label '%1 must not be 0.';        Text004: Label '%1 must not be greater than %2.';        Text005: Label 'You cannot change the invoice discount because a vendor invoice discount with the code %1 exists.';#pragma warning restore AA0470#pragma warning restore AA0074        PurchSetup: Record "Purchases & Payables Setup";    protected var        Vend: Record Vendor;        TempVATAmountLine: Record "VAT Amount Line" temporary;        TotalPurchLine: Record "Purchase Line";        TotalPurchLineLCY: Record "Purchase Line";        PurchPost: Codeunit "Purch.-Post";        VATAmount: Decimal;        TotalAmount1: Decimal;        TotalAmount2: Decimal;        VATAmountText: Text[30];        PrevNo: Code[20];        AllowInvDisc: Boolean;        AllowVATDifference: Boolean;    local procedure UpdateHeaderInfo()    var        CurrExchRate: Record "Currency Exchange Rate";        UseDate: Date;    begin        TotalPurchLine."Inv. Discount Amount" := TempVATAmountLine.GetTotalInvDiscAmount();        TotalAmount1 :=          TotalPurchLine."Line Amount" - TotalPurchLine."Inv. Discount Amount";        VATAmount := TempVATAmountLine.GetTotalVATAmount();        if Rec."Prices Including VAT" then begin            TotalAmount1 := TempVATAmountLine.GetTotalAmountInclVAT();            TotalAmount2 := TotalAmount1 - VATAmount;            TotalPurchLine."Line Amount" := TotalAmount1 + TotalPurchLine."Inv. Discount Amount";        end else            TotalAmount2 := TotalAmount1 + VATAmount;        if Rec."Prices Including VAT" then            TotalPurchLineLCY.Amount := TotalAmount2        else            TotalPurchLineLCY.Amount := TotalAmount1;        if Rec."Currency Code" <> '' then begin            if (Rec."Document Type" in [Rec."Document Type"::"Blanket Order", Rec."Document Type"::Quote]) and               (Rec."Posting Date" = 0D)            then                UseDate := WorkDate()            else                UseDate := Rec."Posting Date";            TotalPurchLineLCY.Amount :=              CurrExchRate.ExchangeAmtFCYToLCY(                UseDate, Rec."Currency Code", TotalPurchLineLCY.Amount, Rec."Currency Factor");        end;        OnAfterUpdateHeaderInfo();    end;    local procedure GetVATSpecification()    begin        CurrPage.SubForm.PAGE.GetTempVATAmountLine(TempVATAmountLine);        if TempVATAmountLine.GetAnyLineModified() then            UpdateHeaderInfo();    end;    local procedure SetVATSpecification()    begin        CurrPage.SubForm.PAGE.SetTempVATAmountLine(TempVATAmountLine);        CurrPage.SubForm.PAGE.InitGlobals(          Rec."Currency Code", AllowVATDifference, AllowVATDifference,          Rec."Prices Including VAT", AllowInvDisc, Rec."VAT Base Discount %");    end;    protected procedure UpdateTotalAmount()    var        SaveTotalAmount: Decimal;    begin        CheckAllowInvDisc();        if Rec."Prices Including VAT" then begin            SaveTotalAmount := TotalAmount1;            UpdateInvDiscAmount();            TotalAmount1 := SaveTotalAmount;        end;        TotalPurchLine."Inv. Discount Amount" := TotalPurchLine."Line Amount" - TotalAmount1;        UpdateInvDiscAmount();    end;    protected procedure UpdateInvDiscAmount()    var        InvDiscBaseAmount: Decimal;    begin        CheckAllowInvDisc();        InvDiscBaseAmount := TempVATAmountLine.GetTotalInvDiscBaseAmount(false, Rec."Currency Code");        if InvDiscBaseAmount = 0 then            Error(Text003, TempVATAmountLine.FieldCaption("Inv. Disc. Base Amount"));        if TotalPurchLine."Inv. Discount Amount" / InvDiscBaseAmount > 1 then            Error(              Text004,              TotalPurchLine.FieldCaption("Inv. Discount Amount"),              TempVATAmountLine.FieldCaption("Inv. Disc. Base Amount"));        TempVATAmountLine.SetInvoiceDiscountAmount(          TotalPurchLine."Inv. Discount Amount", Rec."Currency Code", Rec."Prices Including VAT", Rec."VAT Base Discount %");        CurrPage.SubForm.PAGE.SetTempVATAmountLine(TempVATAmountLine);        UpdateHeaderInfo();        Rec."Invoice Discount Calculation" := Rec."Invoice Discount Calculation"::Amount;        Rec."Invoice Discount Value" := TotalPurchLine."Inv. Discount Amount";        Rec.Modify();        UpdateVATOnPurchLines();    end;    protected procedure GetCaptionClass(FieldCaption: Text[100]; ReverseCaption: Boolean): Text[80]    begin        if Rec."Prices Including VAT" xor ReverseCaption then            exit('2,1,' + FieldCaption);        exit('2,0,' + FieldCaption);    end;    procedure UpdateVATOnPurchLines()    var        PurchLine: Record "Purchase Line";    begin        GetVATSpecification();        if TempVATAmountLine.GetAnyLineModified() then begin            PurchLine.UpdateVATOnLines(0, Rec, PurchLine, TempVATAmountLine);            PurchLine.UpdateVATOnLines(1, Rec, PurchLine, TempVATAmountLine);        end;        PrevNo := '';    end;    local procedure VendInvDiscRecExists(InvDiscCode: Code[20]): Boolean    var        VendInvDisc: Record "Vendor Invoice Disc.";    begin        VendInvDisc.SetRange(Code, InvDiscCode);        exit(VendInvDisc.FindFirst());    end;    local procedure CheckAllowInvDisc()    begin        if not AllowInvDisc then            Error(Text005, Rec."Invoice Disc. Code");    end;    local procedure CalculateTotals()    var        PurchLine: Record "Purchase Line";        TempPurchLine: Record "Purchase Line" temporary;    begin        Clear(PurchLine);        Clear(TotalPurchLine);        Clear(TotalPurchLineLCY);        Clear(PurchPost);        PurchPost.GetPurchLines(Rec, TempPurchLine, 0);        Clear(PurchPost);        PurchPost.SumPurchLinesTemp(          Rec, TempPurchLine, 0, TotalPurchLine, TotalPurchLineLCY, VATAmount, VATAmountText);        OnCalculateTotalsOnAfterPurchPostSumPurchLinesTemp(Rec, TempPurchLine, AllowVATDifference, TotalAmount1, TotalAmount2, VATAmount, TotalPurchLine, TotalPurchLineLCY);        if Rec."Prices Including VAT" then begin            TotalAmount2 := TotalPurchLine.Amount;            TotalAmount1 := TotalAmount2 + VATAmount;            TotalPurchLine."Line Amount" := TotalAmount1 + TotalPurchLine."Inv. Discount Amount";        end else begin            TotalAmount1 := TotalPurchLine.Amount;            TotalAmount2 := TotalPurchLine."Amount Including VAT";        end;        if Vend.Get(Rec."Pay-to Vendor No.") then            Vend.CalcFields("Balance (LCY)")        else            Clear(Vend);        PurchLine.CalcVATAmountLines(0, Rec, TempPurchLine, TempVATAmountLine);        TempVATAmountLine.ModifyAll(Modified, false);        SetVATSpecification();        OnAfterCalculateTotals(Rec, TotalPurchLine, TotalPurchLineLCY, TempVATAmountLine, TotalAmount1, TotalAmount2);    end;    [IntegrationEvent(true, false)]    local procedure OnAfterCalculateTotals(var PurchHeader: Record "Purchase Header"; var TotalPurchLine: Record "Purchase Line"; var TotalPurchLineLCY: Record "Purchase Line"; var TempVATAmountLine: Record "VAT Amount Line" temporary; var TotalAmt1: Decimal; var TotalAmt2: Decimal)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnAfterUpdateHeaderInfo()    begin    end;    [IntegrationEvent(true, false)]    local procedure OnCalculateTotalsOnAfterPurchPostSumPurchLinesTemp(var PurchHeader: Record "Purchase Header"; var TempPurchLine: Record "Purchase Line"; var AllowVATDifference: Boolean; var TotalAmount1: Decimal; var TotalAmount2: Decimal; var VATAmount: Decimal; var PurchaseLineTotal: Record "Purchase Line"; var PurchaseLineTotalLCY: Record "Purchase Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnOpenPageOnBeforeSetEditable(var AllowInvDisc: Boolean; var AllowVATDifference: Boolean; PurchaseHeader: Record "Purchase Header"; var PurchSetup: Record "Purchases & Payables Setup")    begin    end;}