Page 9094 Vendor Statistics FactBox

Base Application, Microsoft.Purchases.Vendor

src/Layers/W1/BaseApp/Purchases/Vendor/VendorStatisticsFactBox.Page.al310 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.Purchases.Payables;using Microsoft.Sales.Receivables;page 9094 "Vendor Statistics FactBox"{    Caption = 'Vendor Statistics';    PageType = CardPart;    SourceTable = Vendor;    layout    {        area(content)        {            field("No."; Rec."No.")            {                ApplicationArea = All;                Caption = 'Vendor No.';                trigger OnDrillDown()                begin                    ShowDetails();                end;            }            field("Balance (LCY)"; Rec."Balance (LCY)")            {                ApplicationArea = Basic, Suite;                ToolTip = 'Specifies the total value of your completed purchases from the vendor in the current fiscal year. It is calculated from amounts including VAT on all completed purchase invoices and credit memos.';                trigger OnDrillDown()                var                    VendLedgEntry: Record "Vendor Ledger Entry";                    DtldVendLedgEntry: Record "Detailed Vendor Ledg. Entry";                begin                    DtldVendLedgEntry.SetRange("Vendor No.", Rec."No.");                    Rec.CopyFilter("Global Dimension 1 Filter", DtldVendLedgEntry."Initial Entry Global Dim. 1");                    Rec.CopyFilter("Global Dimension 2 Filter", DtldVendLedgEntry."Initial Entry Global Dim. 2");                    Rec.CopyFilter("Currency Filter", DtldVendLedgEntry."Currency Code");                    VendLedgEntry.DrillDownOnEntries(DtldVendLedgEntry);                end;            }            field(BalanceAsCustomer; BalanceAsCustomer)            {                AutoFormatType = 1;                AutoFormatExpression = Rec."Currency Code";                ApplicationArea = Basic, Suite;                Caption = 'Balance (LCY) As Customer';                Editable = false;                Enabled = BalanceAsCustomerEnabled;                ToolTip = 'Specifies the amount that this company owes you. This is relevant when your vendor is also your customer. Vendor and customer are linked together through their contact record. Using vendor''s contact record you can create linked customer or link contact with existing customer to enable calculation of Balance As Customer amount.';                trigger OnDrillDown()                var                    DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry";                    CustLedgerEntry: Record "Cust. Ledger Entry";                begin                    if LinkedCustomerNo = '' then                        exit;                    DetailedCustLedgEntry.SetRange("Customer No.", LinkedCustomerNo);                    Rec.CopyFilter("Global Dimension 1 Filter", DetailedCustLedgEntry."Initial Entry Global Dim. 1");                    Rec.CopyFilter("Global Dimension 2 Filter", DetailedCustLedgEntry."Initial Entry Global Dim. 2");                    Rec.CopyFilter("Currency Filter", DetailedCustLedgEntry."Currency Code");                    CustLedgerEntry.DrillDownOnEntries(DetailedCustLedgEntry);                end;            }            field("Outstanding Orders (LCY)"; Rec."Outstanding Orders (LCY)")            {                ApplicationArea = Basic, Suite;                ToolTip = 'Specifies the sum of outstanding orders (in LCY) to this vendor.';            }            field("Amt. Rcd. Not Invoiced (LCY)"; Rec."Amt. Rcd. Not Invoiced (LCY)")            {                ApplicationArea = Basic, Suite;                Caption = 'Amt. Rcd. Not Invd. (LCY)';                ToolTip = 'Specifies the total invoice amount (in LCY) for the items you have received but not yet been invoiced for.';            }            field("Outstanding Invoices (LCY)"; Rec."Outstanding Invoices (LCY)")            {                ApplicationArea = Basic, Suite;                ToolTip = 'Specifies the sum of the vendor''s outstanding purchase invoices in LCY.';            }            field(TotalAmountLCY; TotalAmountLCY)            {                ApplicationArea = Basic, Suite;                AutoFormatType = 1;                AutoFormatExpression = '';                Caption = 'Total (LCY)';                ToolTip = 'Specifies the payment amount that you owe the vendor for completed purchases plus purchases that are still ongoing.';            }            field("Balance Due (LCY)"; OverDueBalance)            {                ApplicationArea = Basic, Suite;                AutoFormatType = 1;                AutoFormatExpression = '';                CaptionClass = Format(StrSubstNo(OverdueAmountsLCYTxt, Format(WorkDate())));                Caption = 'Balance Due (LCY)';                trigger OnDrillDown()                var                    VendLedgEntry: Record "Vendor Ledger Entry";                    DtldVendLedgEntry: Record "Detailed Vendor Ledg. Entry";                begin                    DtldVendLedgEntry.SetFilter("Vendor No.", Rec."No.");                    Rec.CopyFilter("Global Dimension 1 Filter", DtldVendLedgEntry."Initial Entry Global Dim. 1");                    Rec.CopyFilter("Global Dimension 2 Filter", DtldVendLedgEntry."Initial Entry Global Dim. 2");                    Rec.CopyFilter("Currency Filter", DtldVendLedgEntry."Currency Code");                    VendLedgEntry.DrillDownOnOverdueEntries(DtldVendLedgEntry);                end;            }            field(GetInvoicedPrepmtAmountLCY; InvoicedPrepmtAmountLCY)            {                ApplicationArea = Prepayments;                AutoFormatType = 1;                AutoFormatExpression = '';                Caption = 'Invoiced Prepayment Amount (LCY)';                ToolTip = 'Specifies your payments to the vendor, based on invoiced prepayments.';            }            field("Payments (LCY)"; Rec."Payments (LCY)")            {                ApplicationArea = Basic, Suite;                ToolTip = 'Specifies the sum of payments paid to the vendor.';                trigger OnDrillDown()                var                    VendorLedgerEntry: Record "Vendor Ledger Entry";                    VendorLedgerEntries: Page "Vendor Ledger Entries";                begin                    Clear(VendorLedgerEntries);                    SetFilterLastPaymentDateEntry(VendorLedgerEntry);                    if VendorLedgerEntry.FindLast() then                        VendorLedgerEntries.SetRecord(VendorLedgerEntry);                    VendorLedgerEntries.SetTableView(VendorLedgerEntry);                    VendorLedgerEntries.Run();                end;            }            field("Refunds (LCY)"; Rec."Refunds (LCY)")            {                ApplicationArea = Basic, Suite;                ToolTip = 'Specifies the sum of refunds paid to the vendor.';                trigger OnDrillDown()                var                    VendorLedgerEntry: Record "Vendor Ledger Entry";                    VendorLedgerEntries: Page "Vendor Ledger Entries";                begin                    Clear(VendorLedgerEntries);                    SetFilterRefundEntry(VendorLedgerEntry);                    if VendorLedgerEntry.FindLast() then                        VendorLedgerEntries.SetRecord(VendorLedgerEntry);                    VendorLedgerEntries.SetTableView(VendorLedgerEntry);                    VendorLedgerEntries.Run();                end;            }            field(LastPaymentDate; LastPaymentDate)            {                AccessByPermission = TableData "Vendor Ledger Entry" = R;                ApplicationArea = Basic, Suite;                Caption = 'Last Payment Date';                ToolTip = 'Specifies the posting date of the last payment paid to the vendor.';                trigger OnDrillDown()                var                    VendorLedgerEntry: Record "Vendor Ledger Entry";                    VendorLedgerEntries: Page "Vendor Ledger Entries";                begin                    Clear(VendorLedgerEntries);                    SetFilterLastPaymentDateEntry(VendorLedgerEntry);                    if VendorLedgerEntry.FindLast() then                        VendorLedgerEntries.SetRecord(VendorLedgerEntry);                    VendorLedgerEntries.SetTableView(VendorLedgerEntry);                    VendorLedgerEntries.Run();                end;            }        }    }    actions    {    }    trigger OnOpenPage()    begin        Rec.SetAutoCalcFields("Balance (LCY)", "Outstanding Orders (LCY)", "Amt. Rcd. Not Invoiced (LCY)", "Outstanding Invoices (LCY)");    end;    trigger OnAfterGetRecord()    var        VendorNo: Code[20];        VendorNoFilter: Text;    begin        TotalAmountLCY := Rec."Balance (LCY)" + Rec."Outstanding Orders (LCY)" + Rec."Amt. Rcd. Not Invoiced (LCY)" + Rec."Outstanding Invoices (LCY)";        // Get the vendor number and set the current vendor number        Rec.FilterGroup(4);        VendorNoFilter := Rec.GetFilter("No.");        if (VendorNoFilter = '') then begin            Rec.FilterGroup(0);            VendorNoFilter := Rec.GetFilter("No.");        end;        VendorNo := CopyStr(VendorNoFilter, 1, MaxStrLen(VendorNo));        if VendorNo <> CurrVendorNo then begin            CurrVendorNo := VendorNo;            CalculateFieldValues(CurrVendorNo);        end;    end;    trigger OnFindRecord(Which: Text): Boolean    begin        TotalAmountLCY := 0;        exit(Rec.Find(Which));    end;    var#pragma warning disable AA0470        OverdueAmountsLCYTxt: Label 'Overdue Amounts (LCY) as of %1';#pragma warning restore AA0470        TaskIdCalculateCue: Integer;        CurrVendorNo: Code[20];        LinkedCustomerNo: Code[20];        BalanceAsCustomerEnabled: Boolean;    protected var        TotalAmountLCY: Decimal;        LastPaymentDate: Date;        InvoicedPrepmtAmountLCY: Decimal;        OverdueBalance: Decimal;        BalanceAsCustomer: Decimal;    procedure CalculateFieldValues(VendorNo: Code[20])    var        CalculateVendorStats: Codeunit "Calculate Vendor Stats.";        Args: Dictionary of [Text, Text];    begin        if (TaskIdCalculateCue <> 0) then            CurrPage.CancelBackgroundTask(TaskIdCalculateCue);        Clear(LastPaymentDate);        Clear(OverdueBalance);        Clear(InvoicedPrepmtAmountLCY);        Clear(LinkedCustomerNo);        Clear(BalanceAsCustomer);        Clear(BalanceAsCustomerEnabled);        if VendorNo = '' then            exit;        Args.Add(CalculateVendorStats.GetVendorNoLabel(), VendorNo);        CurrPage.EnqueueBackgroundTask(TaskIdCalculateCue, Codeunit::"Calculate Vendor Stats.", Args);    end;    trigger OnPageBackgroundTaskCompleted(TaskId: Integer; Results: Dictionary of [Text, Text])    var        CalculateVendorStats: Codeunit "Calculate Vendor Stats.";        DictionaryValue: Text;    begin        if (TaskId = TaskIdCalculateCue) then begin            if Results.Count() = 0 then                exit;            if TryGetDictionaryValueFromKey(Results, CalculateVendorStats.GetLastPaymentDateLabel(), DictionaryValue) then                Evaluate(LastPaymentDate, DictionaryValue);            if TryGetDictionaryValueFromKey(Results, CalculateVendorStats.GetOverdueBalanceLabel(), DictionaryValue) then                Evaluate(OverdueBalance, DictionaryValue);            if TryGetDictionaryValueFromKey(Results, CalculateVendorStats.GetInvoicedPrepmtAmountLCYLabel(), DictionaryValue) then                Evaluate(InvoicedPrepmtAmountLCY, DictionaryValue);            if TryGetDictionaryValueFromKey(Results, CalculateVendorStats.GetLinkedCustomerNoLabel(), DictionaryValue) then                LinkedCustomerNo := CopyStr(DictionaryValue, 1, MaxStrLen(LinkedCustomerNo));            BalanceAsCustomerEnabled := LinkedCustomerNo <> '';            if BalanceAsCustomerEnabled then                if TryGetDictionaryValueFromKey(Results, CalculateVendorStats.GetBalanceAsCustomerLabel(), DictionaryValue) then                    Evaluate(BalanceAsCustomer, DictionaryValue);        end;    end;    [TryFunction]    local procedure TryGetDictionaryValueFromKey(var DictionaryToLookIn: Dictionary of [Text, Text]; KeyToSearchFor: Text; var ReturnValue: Text)    begin        ReturnValue := DictionaryToLookIn.Get(KeyToSearchFor);    end;    local procedure ShowDetails()    begin        PAGE.Run(PAGE::"Vendor Card", Rec);    end;    local procedure SetFilterLastPaymentDateEntry(var VendorLedgerEntry: Record "Vendor Ledger Entry")    begin        VendorLedgerEntry.SetCurrentKey("Document Type", "Vendor No.", "Posting Date", "Currency Code");        VendorLedgerEntry.SetRange("Vendor No.", Rec."No.");        VendorLedgerEntry.SetRange("Document Type", VendorLedgerEntry."Document Type"::Payment);        VendorLedgerEntry.SetRange(Reversed, false);    end;    local procedure SetFilterRefundEntry(var VendorLedgerEntry: Record "Vendor Ledger Entry")    begin        VendorLedgerEntry.SetCurrentKey("Document Type", "Vendor No.", "Posting Date", "Currency Code");        VendorLedgerEntry.SetRange("Vendor No.", Rec."No.");        VendorLedgerEntry.SetRange("Document Type", VendorLedgerEntry."Document Type"::Refund);        VendorLedgerEntry.SetRange(Reversed, false);    end;}