Page 354 Item Turnover Lines
src/Layers/W1/BaseApp/Inventory/Analysis/ItemTurnoverLines.Page.al216 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.Inventory.Analysis;using Microsoft.Foundation.Enums;using Microsoft.Foundation.Period;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using System.Utilities;page 354 "Item Turnover Lines"{ Caption = 'Lines'; LinksAllowed = false; PageType = ListPart; SourceTable = "Item Turnover Buffer"; SourceTableTemporary = true; layout { area(content) { repeater(Control1) { Editable = false; ShowCaption = false; field("Period Start"; Rec."Period Start") { ApplicationArea = Basic, Suite; Caption = 'Period Start'; } field("Period Name"; Rec."Period Name") { ApplicationArea = Basic, Suite; Caption = 'Period Name'; } field(PurchasesQty; Rec."Purchases (Qty.)") { ApplicationArea = Basic, Suite; Caption = 'Purchases (Qty.)'; DecimalPlaces = 0 : 5; DrillDown = true; ToolTip = 'Specifies how many units of the item have been purchased. The program automatically calculates and updates the contents of the field, using the Invoiced Quantity field in the Item Ledger Entry table for those entries of the Purchase type.'; trigger OnDrillDown() begin ShowItemEntries(false); end; } field(PurchasesLCY; Rec."Purchases (LCY)") { ApplicationArea = Basic, Suite; AutoFormatType = 1; Caption = 'Purchases (LCY)'; DrillDown = true; ToolTip = 'Specifies the total purchase amount, in LCY, of the item that has been purchased. The program automatically calculates and updates the contents of the field, using the Sales Amount (Actual) field in the Value Entry table for those entries that have been posted as purchases.'; trigger OnDrillDown() begin ShowValueEntries(false); end; } field(SalesQty; Rec."Sales (Qty.)") { ApplicationArea = Basic, Suite; Caption = 'Sales (Qty.)'; DecimalPlaces = 0 : 5; DrillDown = true; ToolTip = 'Specifies how many units of the item have been sold. The program automatically calculates and updates the contents of the field, using the Invoiced Quantity field in the Item Ledger Entry table for those entries of the Sales type.'; trigger OnDrillDown() begin ShowItemEntries(true); end; } field(SalesLCY; Rec."Sales (LCY)") { ApplicationArea = Basic, Suite; AutoFormatType = 1; Caption = 'Sales (LCY)'; DrillDown = true; ToolTip = 'Specifies the sales amount, in LCY, of the item that has been sold. The program automatically calculates and updates the contents of the field, using the Sales Amount (Actual) field in the Value Entry table for those entries that have been posted as sales.'; trigger OnDrillDown() begin ShowValueEntries(true); end; } } } } actions { } trigger OnAfterGetRecord() begin if DateRec.Get(Rec."Period Type", Rec."Period Start") then; SetDateFilter(); CalcLine(); end; local procedure CalcLine() begin Item.CalcFields("Purchases (Qty.)", "Purchases (LCY)", "Sales (Qty.)", "Sales (LCY)"); Rec."Purchases (Qty.)" := Item."Purchases (Qty.)"; Rec."Purchases (LCY)" := Item."Purchases (LCY)"; Rec."Sales (Qty.)" := Item."Sales (Qty.)"; Rec."Sales (LCY)" := Item."Sales (LCY)"; OnAfterCalcLine(Item, Rec); end; trigger OnFindRecord(Which: Text) FoundDate: Boolean var VariantRec: Variant; begin VariantRec := Rec; FoundDate := PeriodFormLinesMgt.FindDate(VariantRec, DateRec, Which, PeriodType.AsInteger()); Rec := VariantRec; end; trigger OnNextRecord(Steps: Integer) ResultSteps: Integer var VariantRec: Variant; begin VariantRec := Rec; ResultSteps := PeriodFormLinesMgt.NextDate(VariantRec, DateRec, Steps, PeriodType.AsInteger()); Rec := VariantRec; end; trigger OnOpenPage() begin Rec.Reset(); end; var DateRec: Record Date; PeriodFormLinesMgt: Codeunit "Period Form Lines Mgt."; PeriodType: Enum "Analysis Period Type"; AmountType: Enum "Analysis Amount Type"; protected var Item: Record Item; procedure SetLines(var NewItem: Record Item; NewPeriodType: Enum "Analysis Period Type"; NewAmountType: Enum "Analysis Amount Type") begin Item.Copy(NewItem); Rec.DeleteAll(); PeriodType := NewPeriodType; AmountType := NewAmountType; CurrPage.Update(false); end; procedure ShowItemEntries(ShowSales: Boolean) var ItemLedgEntry: Record "Item Ledger Entry"; begin SetDateFilter(); ItemLedgEntry.Reset(); ItemLedgEntry.SetCurrentKey("Item No.", "Entry Type", "Variant Code", "Drop Shipment", "Location Code", "Posting Date"); ItemLedgEntry.SetRange("Item No.", Item."No."); ItemLedgEntry.SetFilter("Variant Code", Item.GetFilter("Variant Filter")); ItemLedgEntry.SetFilter("Drop Shipment", Item.GetFilter("Drop Shipment Filter")); ItemLedgEntry.SetFilter("Location Code", Item.GetFilter("Location Filter")); ItemLedgEntry.SetFilter("Global Dimension 1 Code", Item.GetFilter("Global Dimension 1 Filter")); ItemLedgEntry.SetFilter("Global Dimension 2 Code", Item.GetFilter("Global Dimension 2 Filter")); ItemLedgEntry.SetFilter("Posting Date", Item.GetFilter("Date Filter")); if ShowSales then ItemLedgEntry.SetRange("Entry Type", ItemLedgEntry."Entry Type"::Sale) else ItemLedgEntry.SetRange("Entry Type", ItemLedgEntry."Entry Type"::Purchase); PAGE.Run(0, ItemLedgEntry); end; procedure ShowValueEntries(ShowSales: Boolean) var ValueEntry: Record "Value Entry"; begin SetDateFilter(); ValueEntry.Reset(); ValueEntry.SetCurrentKey( "Item No.", "Posting Date", "Item Ledger Entry Type", "Entry Type", "Variance Type", "Item Charge No.", "Location Code", "Variant Code", "Global Dimension 1 Code", "Global Dimension 2 Code", "Source Type", "Source No."); ValueEntry.SetRange("Item No.", Item."No."); ValueEntry.SetFilter("Variant Code", Item.GetFilter("Variant Filter")); ValueEntry.SetFilter("Drop Shipment", Item.GetFilter("Drop Shipment Filter")); ValueEntry.SetFilter("Location Code", Item.GetFilter("Location Filter")); ValueEntry.SetFilter("Global Dimension 1 Code", Item.GetFilter("Global Dimension 1 Filter")); ValueEntry.SetFilter("Global Dimension 2 Code", Item.GetFilter("Global Dimension 2 Filter")); ValueEntry.SetFilter("Posting Date", Item.GetFilter("Date Filter")); if ShowSales then ValueEntry.SetRange("Item Ledger Entry Type", ValueEntry."Item Ledger Entry Type"::Sale) else ValueEntry.SetRange("Item Ledger Entry Type", ValueEntry."Item Ledger Entry Type"::Purchase); PAGE.Run(0, ValueEntry); end; protected procedure SetDateFilter() begin if AmountType = AmountType::"Net Change" then Item.SetRange("Date Filter", Rec."Period Start", Rec."Period End") else Item.SetRange("Date Filter", 0D, Rec."Period End"); end; [IntegrationEvent(true, false)] local procedure OnAfterCalcLine(var Item: Record Item; var ItemTurnoverBuffer: Record "Item Turnover Buffer") begin end;}