Table extension 6233 Sust. Item Journal Line
src/Apps/W1/Sustainability/app/src/Journal/SustItemJournalLine.TableExt.al282 lines, Copyright (c) Microsoft Corporation. MIT
namespace Microsoft.Sustainability.Journal;using Microsoft.Foundation.AuditCodes;using Microsoft.Inventory.Item;using Microsoft.Inventory.Journal;using Microsoft.Sustainability.Account;using Microsoft.Sustainability.Setup;tableextension 6233 "Sust. Item Journal Line" extends "Item Journal Line"{ fields { field(6210; "Sust. Account No."; Code[20]) { Caption = 'Sustainability Account No.'; TableRelation = "Sustainability Account" where("Account Type" = const(Posting), Blocked = const(false)); DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Sust. Account No." <> xRec."Sust. Account No." then ClearEmissionInformation(Rec); if Rec."Sust. Account No." = '' then begin Rec.Validate("Sust. Account Category", ''); "Sust. Account Name" := ''; end else begin ValidateEmissionPrerequisite(Rec, Rec.FieldNo("Sust. Account No.")); CopyFromSustainabilityAccount(Rec); if Rec.IsSourceItemJournal() then UpdateCO2eInformation(); end; Rec.CreateDimFromDefaultDim(FieldNo(Rec."Sust. Account No.")); end; } field(6211; "Sust. Account Name"; Text[100]) { Caption = 'Sustainability Account Name'; DataClassification = CustomerContent; } field(6212; "Sust. Account Category"; Code[20]) { Caption = 'Sustainability Account Category'; Editable = false; TableRelation = "Sustain. Account Category"; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Sust. Account Category" <> '' then ValidateEmissionPrerequisite(Rec, Rec.FieldNo("Sust. Account Category")) else Rec.Validate("Sust. Account Subcategory", ''); end; } field(6213; "Sust. Account Subcategory"; Code[20]) { Caption = 'Sustainability Account Subcategory'; Editable = false; TableRelation = "Sustain. Account Subcategory".Code where("Category Code" = field("Sust. Account Category")); DataClassification = CustomerContent; } field(6214; "Emission CO2"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Emission CO2'; DataClassification = CustomerContent; } field(6215; "Emission CH4"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Emission CH4'; DataClassification = CustomerContent; } field(6216; "Emission N2O"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Emission N2O'; DataClassification = CustomerContent; } field(6217; "CO2e per Unit"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'CO2e per Unit'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."CO2e per Unit" <> 0 then ValidateEmissionPrerequisite(Rec, Rec.FieldNo("CO2e per Unit")); UpdateSustainabilityEmission(Rec); end; } field(6218; "Total CO2e"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Total CO2e'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Total CO2e" <> 0 then ValidateEmissionPrerequisite(Rec, Rec.FieldNo("Total CO2e")); UpdateEmissionPerUnit(Rec); end; } field(6219; "EPR Fee per Unit"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'EPR Fee per Unit'; DataClassification = CustomerContent; } field(6220; "Total EPR Fee"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Total EPR Fee'; DataClassification = CustomerContent; } } procedure GetPostingSign(GHGCredit: Boolean): Integer var Sign: Integer; begin Sign := 1; case Rec."Entry Type" of Rec."Entry Type"::Consumption, Rec."Entry Type"::Sale, Rec."Entry Type"::"Negative Adjmt.": if not GHGCredit then Sign := -1; else if GHGCredit then Sign := -1; end; exit(Sign); end; procedure IsGHGCreditLine(): Boolean var Item: Record Item; begin if Rec."Item No." = '' then exit(false); Item.Get(Rec."Item No."); exit(Item."GHG Credit"); end; procedure UpdateSustainabilityEmission(var ItemJournalLine: Record "Item Journal Line") begin if (ItemJournalLine."Operation No." <> '') and (ItemJournalLine."No." <> '') and (ItemJournalLine."Unit Cost Calculation" = ItemJournalLine."Unit Cost Calculation"::Time) then ItemJournalLine."Total CO2e" := ItemJournalLine."CO2e per Unit" * GetTotalTimePerOperation(ItemJournalLine) else ItemJournalLine."Total CO2e" := ItemJournalLine."CO2e per Unit" * ItemJournalLine."Qty. per Unit of Measure" * ItemJournalLine.Quantity; end; internal procedure ShouldUpdateJournalLineWithPostingSign(): Boolean begin exit((Rec."Order Type" = Rec."Order Type"::Production) or IsSourceItemJournal() or IsSourceItemReclassJournal()) end; internal procedure IsSourceItemJournal(): Boolean var SourceCodeSetup: Record "Source Code Setup"; begin SourceCodeSetup.SetLoadFields("Item Journal"); SourceCodeSetup.Get(); exit(Rec."Source Code" = SourceCodeSetup."Item Journal"); end; internal procedure IsSourceItemReclassJournal(): Boolean var SourceCodeSetup: Record "Source Code Setup"; begin SourceCodeSetup.SetLoadFields("Item Reclass. Journal"); SourceCodeSetup.Get(); exit(Rec."Source Code" = SourceCodeSetup."Item Reclass. Journal"); end; local procedure GetTotalTimePerOperation(var ItemJournalLine: Record "Item Journal Line"): Decimal begin exit((ItemJournalLine."Run Time" + ItemJournalLine."Setup Time" + ItemJournalLine."Stop Time") * ItemJournalLine."Qty. per Cap. Unit of Measure"); end; local procedure ClearEmissionInformation(var ItemJournalLine: Record "Item Journal Line") begin ItemJournalLine.Validate("CO2e per Unit", 0); end; local procedure UpdateEmissionPerUnit(var ItemJournalLine: Record "Item Journal Line") var Denominator: Decimal; begin ItemJournalLine."CO2e Per Unit" := 0; if (ItemJournalLine."Operation No." <> '') and (ItemJournalLine."No." <> '') and (ItemJournalLine."Unit Cost Calculation" = ItemJournalLine."Unit Cost Calculation"::Time) then begin UpdateEmissionPerUnitForOperation(ItemJournalLine); exit; end; if (ItemJournalLine."Qty. per Unit of Measure" = 0) or (ItemJournalLine.Quantity = 0) then exit; Denominator := ItemJournalLine."Qty. per Unit of Measure" * ItemJournalLine.Quantity; if ItemJournalLine."Total CO2e" <> 0 then ItemJournalLine."CO2e per Unit" := ItemJournalLine."Total CO2e" / Denominator; end; local procedure UpdateEmissionPerUnitForOperation(var ItemJournalLine: Record "Item Journal Line") var Denominator: Decimal; begin if (GetTotalTimePerOperation(ItemJournalLine) = 0) then exit; Denominator := GetTotalTimePerOperation(ItemJournalLine); if ItemJournalLine."Total CO2e" <> 0 then ItemJournalLine."CO2e per Unit" := ItemJournalLine."Total CO2e" / Denominator; end; local procedure ValidateEmissionPrerequisite(ItemJournalLine: Record "Item Journal Line"; CurrentFieldNo: Integer) begin case CurrentFieldNo of ItemJournalLine.FieldNo("CO2e per Unit"), ItemJournalLine.FieldNo("Total CO2e"): ItemJournalLine.TestField("Sust. Account No."); ItemJournalLine.FieldNo("Sust. Account No."), ItemJournalLine.FieldNo("Sust. Account Category"), ItemJournalLine.FieldNo("Sust. Account Subcategory"), ItemJournalLine.FieldNo("Sust. Account Name"): ItemJournalLine.TestField("Item No."); end; end; local procedure CopyFromSustainabilityAccount(var ItemJournalLine: Record "Item Journal Line") var SustainabilityAccount: Record "Sustainability Account"; begin SustainabilityAccount.Get(ItemJournalLine."Sust. Account No."); SustainabilityAccount.CheckAccountReadyForPosting(); SustainabilityAccount.TestField("Direct Posting", true); ItemJournalLine.Validate("Sust. Account Name", SustainabilityAccount.Name); ItemJournalLine.Validate("Sust. Account Category", SustainabilityAccount.Category); ItemJournalLine.Validate("Sust. Account Subcategory", SustainabilityAccount.Subcategory); end; local procedure UpdateCO2eInformation() var Item: Record Item; begin Item.Get(Rec."Item No."); Rec.Validate("CO2e per Unit", Item."CO2e per Unit"); end; var SustainabilitySetup: Record "Sustainability Setup";}