Page 376 Job Journal Reconcile
src/Layers/W1/BaseApp/Projects/Project/Journal/JobJournalReconcile.Page.al154 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.Projects.Project.Journal;using Microsoft.Projects.Resources.Resource;page 376 "Job Journal Reconcile"{ Caption = 'Project Journal Reconcile'; DataCaptionExpression = Caption(); Editable = false; PageType = List; SourceTable = "Job Journal Quantity"; SourceTableTemporary = true; layout { area(content) { repeater(Control1) { ShowCaption = false; field("Unit of Measure Code"; Rec."Unit of Measure Code") { ApplicationArea = Jobs; Style = Strong; StyleExpr = Emphasize; } field("Work Type Code"; Rec."Work Type Code") { ApplicationArea = Jobs; } field(Quantity; Rec.Quantity) { ApplicationArea = Jobs; Style = Strong; StyleExpr = Emphasize; } } } } actions { } trigger OnAfterGetRecord() begin FormatLine(Format(Rec."Unit of Measure Code")); end; trigger OnOpenPage() begin JobJnlLine.SetCurrentKey("Journal Template Name", "Journal Batch Name", Type, "No.", "Unit of Measure Code", "Work Type Code"); if JobJnlLine.Find('-') then begin OldUnitOfMeasureCode := JobJnlLine."Unit of Measure Code"; OldWorkTypeCode := JobJnlLine."Work Type Code"; repeat if OldUnitOfMeasureCode <> JobJnlLine."Unit of Measure Code" then begin InsertUnitOfMeasureQty(); InsertWorkTypeQty(); end else if OldWorkTypeCode <> JobJnlLine."Work Type Code" then InsertWorkTypeQty(); OldUnitOfMeasureCode := JobJnlLine."Unit of Measure Code"; OldWorkTypeCode := JobJnlLine."Work Type Code"; UnitOfMeasureQty := UnitOfMeasureQty + JobJnlLine.Quantity; WorkTypeQty := WorkTypeQty + JobJnlLine.Quantity; TotalQty := TotalQty + JobJnlLine.Quantity; until (JobJnlLine.Next() = 0); InsertUnitOfMeasureQty(); InsertWorkTypeQty(); Rec.Init(); Rec."Is Total" := true; Rec."Unit of Measure Code" := ''; Rec."Line Type" := Rec."Line Type"::Total; Rec."Work Type Code" := ''; Rec.Quantity := TotalQty; Rec.Insert(); TotalQty := 0; end; end; var JobJnlLine: Record "Job Journal Line"; UnitOfMeasureQty: Decimal; WorkTypeQty: Decimal; TotalQty: Decimal; OldUnitOfMeasureCode: Text[10]; OldWorkTypeCode: Code[10]; Emphasize: Boolean;#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'Total %1';#pragma warning restore AA0470#pragma warning restore AA0074 procedure SetJobJnlLine(var JobJnlLine2: Record "Job Journal Line") begin JobJnlLine2.TestField(Type, JobJnlLine2.Type::Resource); JobJnlLine.CopyFilters(JobJnlLine2); JobJnlLine.SetRange(Type, JobJnlLine2.Type::Resource); JobJnlLine.SetRange("No.", JobJnlLine2."No."); end; local procedure InsertUnitOfMeasureQty() begin Rec.Init(); Rec."Is Total" := false; Rec."Unit of Measure Code" := OldUnitOfMeasureCode; Rec."Line Type" := Rec."Line Type"::Total; Rec."Work Type Code" := ''; Rec.Quantity := UnitOfMeasureQty; Rec.Insert(); UnitOfMeasureQty := 0; end; local procedure InsertWorkTypeQty() begin Rec.Init(); Rec."Is Total" := false; Rec."Unit of Measure Code" := OldUnitOfMeasureCode; Rec."Line Type" := 0; Rec."Work Type Code" := OldWorkTypeCode; Rec.Quantity := WorkTypeQty; Rec.Insert(); WorkTypeQty := 0; end; procedure Caption(): Text var Res: Record Resource; begin Res.Get(JobJnlLine.GetRangeMin("No.")); exit(Res."No." + ' ' + Res.Name); end; local procedure FormatLine(Text: Text[1024]) begin if Rec."Line Type" = Rec."Line Type"::Total then begin Emphasize := true; Text := StrSubstNo(Text000, Text); end; end;}