Report extension 6299 Sust. Standard Sales Invoice
src/Apps/W1/Sustainability/app/src/Reports/SustStandardSalesInvoice.ReportExt.al224 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.Ledger;using Microsoft.Manufacturing.Capacity;using Microsoft.Sales.History;using Microsoft.Sustainability.Posting;using Microsoft.Sustainability.Setup;using System.Utilities;reportextension 6299 "Sust. Standard Sales Invoice" extends "Standard Sales - Invoice"{ dataset { add(Header) { column(Disclaimer_Lbl; GetDisclaimer()) { } column(CO2ePerUnit_Lbl; CO2ePerUnitTxt) { } column(TotalCO2e_Lbl; TotalCO2eTxt) { } } add("line") { column(CO2ePerUnit_Line; FormattedCO2ePerUnit) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); } } add("Totals") { column(TotalCO2e; TotalCO2e) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); } } modify("Line") { trigger OnBeforePreDataItem() begin AddLoadFields("No.", "CO2e per Unit", "Total CO2e"); TotalCO2e := 0; end; trigger OnAfterAfterGetRecord() begin LineUsesItemTracking := UseItemTrackingDetails("No."); if LineUsesItemTracking then FormattedCO2ePerUnit := '' else begin FormattedCO2ePerUnit := Format("CO2e per Unit", 0, SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"))); TotalCO2e += "Total CO2e"; end; end; } addlast("Line") { dataitem(ItemTrackingEmissionDetail; Integer) { DataItemTableView = sorting(Number); column(ItemTrackingEmissionLotNo; TempItemLedgerEntry."Lot No.") { } column(ItemTrackingEmissionSerialNo; TempItemLedgerEntry."Serial No.") { } column(ItemTrackingEmissionTracking; ItemTrackingEmissionTracking) { } column(ItemTrackingEmissionQuantity; ItemTrackingEmissionQuantity) { } column(ItemTrackingEmissionCO2ePerUnit; ItemTrackingEmissionCO2ePerUnit) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); } column(ItemTrackingEmissionTotalCO2e; ItemTrackingEmissionTotalCO2e) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); } trigger OnPreDataItem() begin TempItemLedgerEntry.Reset(); TempItemLedgerEntry.DeleteAll(); if not LineUsesItemTracking then CurrReport.Break(); Line.GetItemLedgEntries(TempItemLedgerEntry, false); if TempItemLedgerEntry.IsEmpty() then begin TotalCO2e += Line."Total CO2e"; CurrReport.Break(); end; SetRange(Number, 1, TempItemLedgerEntry.Count()); end; trigger OnAfterGetRecord() begin if Number = 1 then TempItemLedgerEntry.FindSet() else TempItemLedgerEntry.Next(); ItemTrackingEmissionQuantity := Abs(TempItemLedgerEntry.Quantity); ItemTrackingEmissionTracking := GetItemTrackingText(TempItemLedgerEntry); ItemTrackingEmissionTotalCO2e := 0; SustainabilityPostMgt.GetTotalCO2eAmount(TempItemLedgerEntry, CapacityTypeJournal::" ", ItemTrackingEmissionTotalCO2e, 0); if ItemTrackingEmissionQuantity <> 0 then ItemTrackingEmissionCO2ePerUnit := ItemTrackingEmissionTotalCO2e / ItemTrackingEmissionQuantity else ItemTrackingEmissionCO2ePerUnit := 0; TotalCO2e += ItemTrackingEmissionTotalCO2e; end; } } } requestpage { layout { addlast(Options) { field(SustEmissionBasis; EmissionBasis) { ApplicationArea = Basic, Suite; Caption = 'Emission Basis'; ToolTip = 'Specifies whether the report prints average emissions or emission details for each lot or serial number used for items with Specific carbon tracking.'; } } } } rendering { layout("StandardESGSalesInvoice.docx") { Type = Word; Caption = 'Standard ESG Sales Invoice (Word)'; Summary = 'The Standard ESG Sales Invoice (Word) provides a basic layout.'; LayoutFile = 'src\Reports\StandardESGSalesInvoice.docx'; } layout("StandardESGSalesInvoiceBlueSimple.docx") { Type = Word; Caption = 'Standard ESG Sales Invoice - Blue (Word)'; Summary = 'The Standard ESG Sales Invoice (Word) provides a basic layout with blue theme.'; LayoutFile = 'src\Reports\StandardESGSalesInvoiceBlueSimple.docx'; } } trigger OnPreReport() begin SetCO2ePerUnitAndTotalCO2eCaption(); end; var TempItemLedgerEntry: Record "Item Ledger Entry" temporary; SustainabilitySetup: Record "Sustainability Setup"; SustainabilityPostMgt: Codeunit "Sustainability Post Mgt"; CapacityTypeJournal: Enum "Capacity Type Journal"; EmissionBasis: Enum "Sust. Emission Basis"; TotalCO2e: Decimal; ItemTrackingEmissionQuantity: Decimal; ItemTrackingEmissionCO2ePerUnit: Decimal; ItemTrackingEmissionTotalCO2e: Decimal; CO2ePerUnitTxt: Text; TotalCO2eTxt: Text; FormattedCO2ePerUnit: Text; ItemTrackingEmissionTracking: Text; LineUsesItemTracking: Boolean; CO2ePerUnitLbl: Label 'CO2e [%1] per Unit', Comment = '%1 = Emission Unit of Measure'; TotalCO2eLbl: Label '%1 [%2]', Comment = '%1 = Field Caption, %2 = Emission Unit of Measure'; local procedure SetCO2ePerUnitAndTotalCO2eCaption() begin SustainabilitySetup.GetRecordOnce(); if SustainabilitySetup."Emission Unit of Measure Code" <> '' then CO2ePerUnitTxt := StrSubstNo(CO2ePerUnitLbl, SustainabilitySetup."Emission Unit of Measure Code") else CO2ePerUnitTxt := Line.FieldCaption("CO2e per Unit"); if SustainabilitySetup."Emission Unit of Measure Code" <> '' then TotalCO2eTxt := StrSubstNo(TotalCO2eLbl, Line.FieldCaption("Total CO2e"), SustainabilitySetup."Emission Unit of Measure Code") else TotalCO2eTxt := Line.FieldCaption("Total CO2e"); end; local procedure UseItemTrackingDetails(ItemNo: Code[20]): Boolean begin exit((EmissionBasis = EmissionBasis::"Details by Item Tracking") and SustainabilityPostMgt.IsCarbonTrackingSpecificItem(ItemNo)); end; // Separator sits inside the value because Word trims leading and trailing spaces in a run. local procedure GetItemTrackingText(ItemLedgerEntry: Record "Item Ledger Entry"): Text begin if (ItemLedgerEntry."Lot No." <> '') and (ItemLedgerEntry."Serial No." <> '') then exit(ItemLedgerEntry."Lot No." + ' ' + ItemLedgerEntry."Serial No."); exit(ItemLedgerEntry."Lot No." + ItemLedgerEntry."Serial No."); end; local procedure GetDisclaimer(): Text var SustainabilityDisclaimer: Record "Sustainability Disclaimer"; begin SustainabilityDisclaimer.SetRange("Document Type", SustainabilityDisclaimer."Document Type"::"Posted Sales Invoice"); if SustainabilityDisclaimer.FindFirst() then exit(SustainabilityDisclaimer.Disclaimer); end;}