Report 6219 Sust. Track Item of Concern
src/Apps/W1/Sustainability/app/src/Reports/SustTrackItemOfConcern.Report.al450 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.Sustainability.Reports;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Purchases.Document;using Microsoft.Purchases.History;using Microsoft.Sustainability.Ledger;using Microsoft.Sustainability.Setup;report 6219 "Sust. Track Item of Concern"{ ApplicationArea = Basic, Suite; Caption = 'Track Item of Concern'; DefaultLayout = RDLC; UsageCategory = ReportsAndAnalysis; DataAccessIntent = ReadOnly; RDLCLayout = 'src/Reports/TrackItemOfConcern.rdlc'; dataset { dataitem(Item; Item) { DataItemTableView = where("Item of Concern" = const(true)); RequestFilterFields = "No."; dataitem(ItemEmissionBuffer; "Sust. Item Emission Buffer") { DataItemLink = "Item No." = field("No."); UseTemporary = true; DataItemTableView = sorting("Entry No."); column(CompanyName; CompanyProperty.DisplayName()) { } column(Direction; Direction) { } column(Date; Date) { } column(ShowDetails; ShowDetails) { } column(Transaction_Type; "Transaction Type") { } column(Document_No; "Document No.") { } column(Source_No_; "Source No.") { } column(Item_No_; "Item No.") { } column(Item_Name; "Item Name") { } column(Quantity; Quantity) { } column(CO2e_Emission; "CO2e Emission") { } column(Emission_CO2; "Emission CO2") { } column(Emission_CH4; "Emission CH4") { } column(Emission_N2O; "Emission N2O") { } } trigger OnAfterGetRecord() begin InsertItemEmissionBuffer(); end; } } requestpage { AboutText = 'This report provides information on the cumulative greenhouse gas (GHG) emissions across the chosen Sustainability Item.'; AboutTitle = 'Total Emissions'; SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(Show_Details; ShowDetails) { ApplicationArea = Basic, Suite; Caption = 'Show Details'; ToolTip = 'Specifies if the report includes all sustainability entries. By default, the report does not show such entries.'; } } } } } labels { TrackItemOfConcern = 'Item of Concern'; PageCaption = 'Page'; DirectionCaption = 'Direction'; ItemNoCaption = ' Item No.'; DateCaption = 'Posting Date'; TransactionTypeCaption = 'Transaction Type'; DocumentNoCaption = 'Document No.'; SourceNoCaption = 'Source No.'; QuantityCaption = 'Quantity'; CO2eEmissionCaption = 'CO2e'; EmissionCO2Caption = 'CO2'; EmissionCH4Caption = 'CH4'; EmissionN2OCaption = 'N2O'; ItemNameCaption = 'Item Name'; } trigger OnPreReport() var SustainabilitySetup: Record "Sustainability Setup"; begin SustainabilitySetup.GetReportingParameters(ReportingUOMCode, UseReportingUOMFactor, ReportingUOMFactor, RoundingDirection, RoundingPrecision); end; var ReportingUOMCode: Code[10]; RoundingDirection: Text; ShowDetails, UseReportingUOMFactor : Boolean; ReportingUOMFactor, RoundingPrecision : Decimal; local procedure InsertItemEmissionBuffer() var begin InsertItemEmissionBufferFromSustValueEntry(); InsertItemEmissionBufferFromPurchaseInvLine(); InsertItemEmissionBufferFromPurchaseCrMemoLine(); InsertItemEmissionBufferFromReturnShipmentLine(); end; local procedure InsertItemEmissionBufferFromSustValueEntry() var SustainabilityValueEntry: Record "Sustainability Value Entry"; begin SustainabilityValueEntry.SetRange(Type, SustainabilityValueEntry.Type::Item); SustainabilityValueEntry.SetRange("No.", Item."No."); SustainabilityValueEntry.SetRange("Expected Emission", false); SustainabilityValueEntry.SetFilter("Item Ledger Entry Type", '<>%1', SustainabilityValueEntry."Item Ledger Entry Type"::Transfer); if SustainabilityValueEntry.FindSet() then repeat if ShouldInsertItemEmissionBufferFromSustValueEntry(SustainabilityValueEntry) then InsertItemEmissionBuffer(SustainabilityValueEntry); until SustainabilityValueEntry.Next() = 0; end; local procedure InsertItemEmissionBufferFromPurchaseInvLine() var PurchaseInvLine: Record "Purch. Inv. Line"; begin PurchaseInvLine.SetRange(Type, PurchaseInvLine.Type::Item); PurchaseInvLine.SetRange("No.", Item."No."); PurchaseInvLine.SetFilter("Sust. Account No.", '<>%1', ''); PurchaseInvLine.SetFilter(Quantity, '<>%1', 0); if PurchaseInvLine.FindSet() then repeat InsertItemEmissionBuffer(PurchaseInvLine); until PurchaseInvLine.Next() = 0; end; local procedure InsertItemEmissionBufferFromPurchaseCrMemoLine() var PurchaseCrMemoLine: Record "Purch. Cr. Memo Line"; begin PurchaseCrMemoLine.SetRange(Type, PurchaseCrMemoLine.Type::Item); PurchaseCrMemoLine.SetRange("No.", Item."No."); PurchaseCrMemoLine.SetFilter("Sust. Account No.", '<>%1', ''); PurchaseCrMemoLine.SetFilter(Quantity, '<>%1', 0); if PurchaseCrMemoLine.FindSet() then repeat InsertItemEmissionBuffer(PurchaseCrMemoLine); until PurchaseCrMemoLine.Next() = 0; end; local procedure InsertItemEmissionBufferFromReturnShipmentLine() var ReturnShipmentLine: Record "Return Shipment Line"; begin ReturnShipmentLine.SetRange(Type, ReturnShipmentLine.Type::Item); ReturnShipmentLine.SetRange("No.", Item."No."); ReturnShipmentLine.SetFilter("Sust. Account No.", '<>%1', ''); ReturnShipmentLine.SetFilter(Quantity, '<>%1', 0); if ReturnShipmentLine.FindSet() then repeat InsertItemEmissionBuffer(ReturnShipmentLine); until ReturnShipmentLine.Next() = 0; end; local procedure InsertItemEmissionBuffer(SustainabilityValueEntry: Record "Sustainability Value Entry") var ItemLedgerEntry: Record "Item Ledger Entry"; begin ItemEmissionBuffer.Init(); ItemEmissionBuffer."Entry No." := FindLastEntryNo() + 1; ItemEmissionBuffer.Direction := GetDirection(SustainabilityValueEntry."Item Ledger Entry Type"); ItemEmissionBuffer.Date := SustainabilityValueEntry."Posting Date"; ItemEmissionBuffer."Transaction Type" := SustainabilityValueEntry."Item Ledger Entry Type"; ItemEmissionBuffer."Document No." := SustainabilityValueEntry."Document No."; ItemEmissionBuffer."Source Type" := ItemEmissionBuffer."Source Type"::" "; ItemEmissionBuffer."Source No." := ''; if (SustainabilityValueEntry."Item Ledger Entry No." <> 0) then begin ItemLedgerEntry.Get(SustainabilityValueEntry."Item Ledger Entry No."); ItemEmissionBuffer."Source Type" := ItemLedgerEntry."Source Type"; if ItemLedgerEntry."Source Type" in [ItemLedgerEntry."Source Type"::Customer, ItemLedgerEntry."Source Type"::Vendor] then ItemEmissionBuffer."Source No." := ItemLedgerEntry."Source No." end; ItemEmissionBuffer."Item No." := SustainabilityValueEntry."Item No."; ItemEmissionBuffer."Item Name" := Item.Description; ItemEmissionBuffer.Quantity := SustainabilityValueEntry."Item Ledger Entry Quantity"; ItemEmissionBuffer."CO2e Emission" := SustainabilityValueEntry."CO2e Amount (Actual)"; ItemEmissionBuffer."Emission CO2" := 0; ItemEmissionBuffer."Emission CH4" := 0; ItemEmissionBuffer."Emission N2O" := 0; if UseReportingUOMFactor then UpdateEmissionsByReportingUOMFactor(); ItemEmissionBuffer.Insert(); end; local procedure InsertItemEmissionBuffer(PurchaseInvLine: Record "Purch. Inv. Line") var TempItemLedgEntry: Record "Item Ledger Entry" temporary; SustainabilityLedgerEntry: Record "Sustainability Ledger Entry"; GHGCredit: Boolean; Sign: Integer; begin ItemEmissionBuffer.Init(); ItemEmissionBuffer."Entry No." := FindLastEntryNo() + 1; ItemEmissionBuffer.Direction := ItemEmissionBuffer.Direction::Inbound; ItemEmissionBuffer.Date := PurchaseInvLine."Posting Date"; ItemEmissionBuffer."Transaction Type" := ItemEmissionBuffer."Transaction Type"::Purchase; ItemEmissionBuffer."Document No." := PurchaseInvLine."Document No."; ItemEmissionBuffer."Source Type" := ItemEmissionBuffer."Source Type"::Vendor; ItemEmissionBuffer."Source No." := PurchaseInvLine."Buy-from Vendor No."; ItemEmissionBuffer."Item No." := PurchaseInvLine."No."; ItemEmissionBuffer."Item Name" := Item.Description; ItemEmissionBuffer."CO2e Emission" := 0; ItemEmissionBuffer."Emission CO2" := 0; ItemEmissionBuffer."Emission CH4" := 0; ItemEmissionBuffer."Emission N2O" := 0; PurchaseInvLine.GetItemLedgEntries(TempItemLedgEntry, true); TempItemLedgEntry.CalcSums(Quantity); ItemEmissionBuffer.Quantity := TempItemLedgEntry.Quantity; GHGCredit := IsGHGCreditLine(PurchaseInvLine.Type, PurchaseInvLine."No."); Sign := GetPostingSign("Purchase Document Type"::Invoice, GHGCredit); FilterSustainabilityLedgerEntry( SustainabilityLedgerEntry, PurchaseInvLine."Document No.", PurchaseInvLine."Posting Date", PurchaseInvLine."Sust. Account No.", Sign * PurchaseInvLine."Emission CO2", Sign * PurchaseInvLine."Emission CH4", Sign * PurchaseInvLine."Emission N2O"); if SustainabilityLedgerEntry.FindFirst() then begin ItemEmissionBuffer."Emission CO2" := SustainabilityLedgerEntry."Emission CO2"; ItemEmissionBuffer."Emission CH4" := SustainabilityLedgerEntry."Emission CH4"; ItemEmissionBuffer."Emission N2O" := SustainabilityLedgerEntry."Emission N2O"; ItemEmissionBuffer."CO2e Emission" := SustainabilityLedgerEntry."CO2e Emission"; end; if UseReportingUOMFactor then UpdateEmissionsByReportingUOMFactor(); ItemEmissionBuffer.Insert(); end; local procedure InsertItemEmissionBuffer(ReturnShipmentLine: Record "Return Shipment Line") var ItemLedgEntry: Record "Item Ledger Entry"; SustainabilityLedgerEntry: Record "Sustainability Ledger Entry"; GHGCredit: Boolean; Sign: Integer; begin ItemEmissionBuffer.Init(); ItemEmissionBuffer."Entry No." := FindLastEntryNo() + 1; ItemEmissionBuffer.Direction := ItemEmissionBuffer.Direction::Inbound; ItemEmissionBuffer.Date := ReturnShipmentLine."Posting Date"; ItemEmissionBuffer."Transaction Type" := ItemEmissionBuffer."Transaction Type"::Purchase; ItemEmissionBuffer."Document No." := ReturnShipmentLine."Document No."; ItemEmissionBuffer."Source Type" := ItemEmissionBuffer."Source Type"::Vendor; ItemEmissionBuffer."Source No." := ReturnShipmentLine."Buy-from Vendor No."; ItemEmissionBuffer."Item No." := ReturnShipmentLine."No."; ItemEmissionBuffer."Item Name" := Item.Description; ItemEmissionBuffer."CO2e Emission" := 0; ItemEmissionBuffer."Emission CO2" := 0; ItemEmissionBuffer."Emission CH4" := 0; ItemEmissionBuffer."Emission N2O" := 0; ReturnShipmentLine.FilterPstdDocLnItemLedgEntries(ItemLedgEntry); ItemLedgEntry.CalcSums(Quantity); ItemEmissionBuffer.Quantity := ItemLedgEntry.Quantity; GHGCredit := IsGHGCreditLine(ReturnShipmentLine.Type, ReturnShipmentLine."No."); Sign := GetPostingSign("Purchase Document Type"::"Credit Memo", GHGCredit); FilterSustainabilityLedgerEntry( SustainabilityLedgerEntry, ReturnShipmentLine."Document No.", ReturnShipmentLine."Posting Date", ReturnShipmentLine."Sust. Account No.", Sign * ReturnShipmentLine."Emission CO2", Sign * ReturnShipmentLine."Emission CH4", Sign * ReturnShipmentLine."Emission N2O"); if SustainabilityLedgerEntry.FindFirst() then begin ItemEmissionBuffer."Emission CO2" := SustainabilityLedgerEntry."Emission CO2"; ItemEmissionBuffer."Emission CH4" := SustainabilityLedgerEntry."Emission CH4"; ItemEmissionBuffer."Emission N2O" := SustainabilityLedgerEntry."Emission N2O"; ItemEmissionBuffer."CO2e Emission" := SustainabilityLedgerEntry."CO2e Emission"; end; if UseReportingUOMFactor then UpdateEmissionsByReportingUOMFactor(); ItemEmissionBuffer.Insert(); end; local procedure InsertItemEmissionBuffer(PurchCrMemoLine: Record "Purch. Cr. Memo Line") var TempItemLedgEntry: Record "Item Ledger Entry" temporary; SustainabilityLedgerEntry: Record "Sustainability Ledger Entry"; GHGCredit: Boolean; Sign: Integer; begin ItemEmissionBuffer.Init(); ItemEmissionBuffer."Entry No." := FindLastEntryNo() + 1; ItemEmissionBuffer.Direction := ItemEmissionBuffer.Direction::Inbound; ItemEmissionBuffer.Date := PurchCrMemoLine."Posting Date"; ItemEmissionBuffer."Transaction Type" := ItemEmissionBuffer."Transaction Type"::Purchase; ItemEmissionBuffer."Document No." := PurchCrMemoLine."Document No."; ItemEmissionBuffer."Source Type" := ItemEmissionBuffer."Source Type"::Vendor; ItemEmissionBuffer."Source No." := PurchCrMemoLine."Buy-from Vendor No."; ItemEmissionBuffer."Item No." := PurchCrMemoLine."No."; ItemEmissionBuffer."Item Name" := Item.Description; ItemEmissionBuffer."CO2e Emission" := 0; ItemEmissionBuffer."Emission CO2" := 0; ItemEmissionBuffer."Emission CH4" := 0; ItemEmissionBuffer."Emission N2O" := 0; PurchCrMemoLine.GetItemLedgEntries(TempItemLedgEntry, true); TempItemLedgEntry.CalcSums(Quantity); ItemEmissionBuffer.Quantity := TempItemLedgEntry.Quantity; GHGCredit := IsGHGCreditLine(PurchCrMemoLine.Type, PurchCrMemoLine."No."); Sign := GetPostingSign("Purchase Document Type"::"Return Order", GHGCredit); FilterSustainabilityLedgerEntry( SustainabilityLedgerEntry, PurchCrMemoLine."Document No.", PurchCrMemoLine."Posting Date", PurchCrMemoLine."Sust. Account No.", Sign * PurchCrMemoLine."Emission CO2", Sign * PurchCrMemoLine."Emission CH4", Sign * PurchCrMemoLine."Emission N2O"); if SustainabilityLedgerEntry.FindFirst() then begin ItemEmissionBuffer."Emission CO2" := SustainabilityLedgerEntry."Emission CO2"; ItemEmissionBuffer."Emission CH4" := SustainabilityLedgerEntry."Emission CH4"; ItemEmissionBuffer."Emission N2O" := SustainabilityLedgerEntry."Emission N2O"; ItemEmissionBuffer."CO2e Emission" := SustainabilityLedgerEntry."CO2e Emission"; end; if UseReportingUOMFactor then UpdateEmissionsByReportingUOMFactor(); ItemEmissionBuffer.Insert(); end; local procedure GetDirection(EntryType: Enum "Item Ledger Entry Type") Direction: Option Inbound,Outbound begin case EntryType of EntryType::Purchase, EntryType::Output, EntryType::"Assembly Output", EntryType::"Positive Adjmt.": exit(Direction::Inbound); EntryType::Sale, EntryType::Consumption, EntryType::"Negative Adjmt.", EntryType::"Assembly Consumption": exit(Direction::Outbound); else exit(Direction::Outbound); end; end; local procedure FilterSustainabilityLedgerEntry(var SustainabilityLedgerEntry: Record "Sustainability Ledger Entry"; DocumentNo: Code[20]; PostingDate: Date; AccountNo: Code[20]; EmissionCO2: Decimal; EmissionCH4: Decimal; EmissionN2O: Decimal): Decimal begin SustainabilityLedgerEntry.Reset(); SustainabilityLedgerEntry.SetRange("Document No.", DocumentNo); SustainabilityLedgerEntry.SetRange("Posting Date", PostingDate); SustainabilityLedgerEntry.SetRange("Account No.", AccountNo); SustainabilityLedgerEntry.SetRange("Emission CO2", EmissionCO2); SustainabilityLedgerEntry.SetRange("Emission CH4", EmissionCH4); SustainabilityLedgerEntry.SetRange("Emission N2O", EmissionN2O); end; local procedure UpdateEmissionsByReportingUOMFactor() begin ItemEmissionBuffer."CO2e Emission" := Round(ItemEmissionBuffer."CO2e Emission" * ReportingUOMFactor, RoundingPrecision, RoundingDirection); ItemEmissionBuffer."Emission CO2" := Round(ItemEmissionBuffer."Emission CO2" * ReportingUOMFactor, RoundingPrecision, RoundingDirection); ItemEmissionBuffer."Emission CH4" := Round(ItemEmissionBuffer."Emission CH4" * ReportingUOMFactor, RoundingPrecision, RoundingDirection); ItemEmissionBuffer."Emission N2O" := Round(ItemEmissionBuffer."Emission N2O" * ReportingUOMFactor, RoundingPrecision, RoundingDirection); end; internal procedure GetPostingSign(PurchaseDocumentType: Enum "Purchase Document Type"; GHGCredit: Boolean): Integer var Sign: Integer; begin Sign := 1; case PurchaseDocumentType of PurchaseDocumentType::"Credit Memo", PurchaseDocumentType::"Return Order": if not GHGCredit then Sign := -1; else if GHGCredit then Sign := -1; end; exit(Sign); end; internal procedure IsGHGCreditLine(PurchaseLineType: Enum "Purchase Line Type"; ItemNo: Code[20]): Boolean var Item: Record Item; begin if PurchaseLineType <> PurchaseLineType::Item then exit(false); if ItemNo = '' then exit(false); Item.Get(ItemNo); exit(Item."GHG Credit"); end; local procedure FindLastEntryNo(): Integer begin ItemEmissionBuffer.Reset(); if ItemEmissionBuffer.FindLast() then exit(ItemEmissionBuffer."Entry No."); end; local procedure ShouldInsertItemEmissionBufferFromSustValueEntry(SustainabilityValueEntry: Record "Sustainability Value Entry"): Boolean begin if (SustainabilityValueEntry."Item Ledger Entry Type" = SustainabilityValueEntry."Item Ledger Entry Type"::Purchase) and (SustainabilityValueEntry."Document Type" <> SustainabilityValueEntry."Document Type"::" ") then exit(false); exit(true); end;}