Codeunit 1026 Job Link Usage
src/Layers/W1/BaseApp/Projects/Project/Job/JobLinkUsage.Codeunit.al384 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.Job;using Microsoft.Assembly.History;using Microsoft.Foundation.UOM;using Microsoft.Projects.Project.Journal;using Microsoft.Projects.Project.Ledger;using Microsoft.Projects.Project.Planning;using Microsoft.Projects.Project.Posting;using Microsoft.Projects.Resources.Resource;codeunit 1026 "Job Link Usage"{ Permissions = TableData "Job Usage Link" = rimd; trigger OnRun() begin end; var UOMMgt: Codeunit "Unit of Measure Management"; CalledFromInvtPutawayPick: Boolean;#pragma warning disable AA0074#pragma warning disable AA0470 Text001: Label 'The specified %1 does not have %2 enabled.', Comment = 'The specified Project Planning Line does not have Usage Link enabled.';#pragma warning restore AA0470#pragma warning restore AA0074 ConfirmUsageWithBlankLineTypeQst: Label 'Usage will not be linked to the project planning line because the Line Type field is empty.\\Do you want to continue?'; internal procedure ApplyUsage(JobLedgerEntry: Record "Job Ledger Entry"; JobJournalLine: Record "Job Journal Line"; IsCalledFromInventoryPutawayPick: Boolean) begin CalledFromInvtPutawayPick := IsCalledFromInventoryPutawayPick; ApplyUsage(JobLedgerEntry, JobJournalLine); end; procedure ApplyUsage(JobLedgerEntry: Record "Job Ledger Entry"; JobJournalLine: Record "Job Journal Line") begin if JobJournalLine."Job Planning Line No." = 0 then MatchUsageUnspecified(JobLedgerEntry, JobJournalLine."Line Type" = JobJournalLine."Line Type"::" ") else MatchUsageSpecified(JobLedgerEntry, JobJournalLine); OnAfterApplyUsage(JobLedgerEntry, JobJournalLine); end; local procedure MatchUsageUnspecified(JobLedgerEntry: Record "Job Ledger Entry"; EmptyLineType: Boolean) var JobPlanningLine: Record "Job Planning Line"; JobUsageLink: Record "Job Usage Link"; Confirmed, IsHandled : Boolean; MatchedQty: Decimal; MatchedTotalCost: Decimal; MatchedLineAmount: Decimal; RemainingQtyToMatch, RemainingQtyToMatchPerUoM : Decimal; begin RemainingQtyToMatch := JobLedgerEntry."Quantity (Base)"; repeat if not FindMatchingJobPlanningLine(JobPlanningLine, JobLedgerEntry) then if EmptyLineType then begin OnMatchUsageUnspecifiedOnBeforeConfirm(JobPlanningLine, JobLedgerEntry, Confirmed); if not Confirmed then Confirmed := Confirm(ConfirmUsageWithBlankLineTypeQst, false); if not Confirmed then Error(''); RemainingQtyToMatch := 0; end else CreateJobPlanningLine(JobPlanningLine, JobLedgerEntry, RemainingQtyToMatch); IsHandled := false; OnMatchUsageUnspecifiedOnBeforeCheckPostedQty(JobPlanningLine, JobLedgerEntry, RemainingQtyToMatch, IsHandled); if not IsHandled then begin RemainingQtyToMatchPerUoM := UOMMgt.CalcQtyFromBase(RemainingQtyToMatch, JobPlanningLine."Qty. per Unit of Measure"); if (RemainingQtyToMatchPerUoM = JobPlanningLine."Qty. Posted") and (JobPlanningLine."Remaining Qty. (Base)" = 0) then exit; end; if RemainingQtyToMatch <> 0 then begin JobUsageLink.Create(JobPlanningLine, JobLedgerEntry); if Abs(RemainingQtyToMatch) > Abs(JobPlanningLine."Remaining Qty. (Base)") then MatchedQty := JobPlanningLine."Remaining Qty. (Base)" else MatchedQty := RemainingQtyToMatch; OnMatchUsageUnspecifiedOnAfterCalcMatchedQty(JobLedgerEntry, MatchedQty); MatchedTotalCost := (JobLedgerEntry."Total Cost" / JobLedgerEntry."Quantity (Base)") * MatchedQty; MatchedLineAmount := (JobLedgerEntry."Line Amount" / JobLedgerEntry."Quantity (Base)") * MatchedQty; OnBeforeJobPlanningLineUse(JobPlanningLine, JobLedgerEntry); JobPlanningLine.Use( UOMMgt.CalcQtyFromBase( JobPlanningLine."No.", JobPlanningLine."Variant Code", JobPlanningLine."Unit of Measure Code", MatchedQty, JobPlanningLine."Qty. per Unit of Measure"), MatchedTotalCost, MatchedLineAmount, JobLedgerEntry."Posting Date", JobLedgerEntry."Currency Factor"); RemainingQtyToMatch -= MatchedQty; OnMatchUsageUnspecifiedOnAfterUpdateRemainingQtyToMatch(JobLedgerEntry, RemainingQtyToMatch); end; until RemainingQtyToMatch = 0; end; local procedure MatchUsageSpecified(JobLedgerEntry: Record "Job Ledger Entry"; JobJournalLine: Record "Job Journal Line") var JobPlanningLine: Record "Job Planning Line"; IsHandled: Boolean; begin IsHandled := false; OnBeforeMatchUsageSpecified(JobPlanningLine, JobJournalLine, JobLedgerEntry, IsHandled); if IsHandled then exit; JobPlanningLine.Get(JobLedgerEntry."Job No.", JobLedgerEntry."Job Task No.", JobJournalLine."Job Planning Line No."); if not JobPlanningLine."Usage Link" then Error(Text001, JobPlanningLine.TableCaption(), JobPlanningLine.FieldCaption("Usage Link")); HandleMatchUsageSpecifiedJobPlanningLine(JobPlanningLine, JobJournalLine, JobLedgerEntry); OnAfterMatchUsageSpecified(JobPlanningLine, JobJournalLine, JobLedgerEntry); end; procedure HandleMatchUsageSpecifiedJobPlanningLine(var JobPlanningLine: Record "Job Planning Line"; JobJournalLine: Record "Job Journal Line"; JobLedgerEntry: Record "Job Ledger Entry") var JobUsageLink: Record "Job Usage Link"; PostedQtyBase: Decimal; TotalQtyBase: Decimal; TotalRemainingQtyPrePostBase: Decimal; PartialJobPlanningLineQuantityPosting, UpdateQuantity : Boolean; begin if JobPlanningLine."Assemble to Order" then begin PostedQtyBase := AssembledQtyBase(JobPlanningLine); TotalRemainingQtyPrePostBase := JobPlanningLine."Qty. to Assemble (Base)" - AssembledQtyBase(JobPlanningLine); end else begin PostedQtyBase := JobPlanningLine."Quantity (Base)" - JobPlanningLine."Remaining Qty. (Base)"; TotalRemainingQtyPrePostBase := JobJournalLine."Quantity (Base)" + JobJournalLine."Remaining Qty. (Base)"; end; TotalQtyBase := PostedQtyBase + TotalRemainingQtyPrePostBase; OnBeforeHandleMatchUsageSpecifiedJobPlanningLine(PostedQtyBase, TotalRemainingQtyPrePostBase, TotalQtyBase, JobPlanningLine, JobJournalLine); JobPlanningLine.SetBypassQtyValidation(true); if Abs(UOMMgt.CalcQtyFromBase(JobPlanningLine."No.", JobPlanningLine."Variant Code", JobPlanningLine."Unit of Measure Code", TotalQtyBase, JobPlanningLine."Qty. per Unit of Measure")) < Abs(JobPlanningLine.Quantity) then begin PartialJobPlanningLineQuantityPosting := (JobLedgerEntry."Serial No." <> '') or (JobLedgerEntry."Lot No." <> ''); HandleMatchUsageSpecifiedJobPlanningLineOnAfterCalcPartialJobPlanningLineQuantityPosting(JobPlanningLine, JobJournalLine, JobLedgerEntry, PartialJobPlanningLineQuantityPosting); end; // CalledFromInvtPutawayPick - Skip this quantity validation for Inventory Pick posting as quantity cannot be updated with an active Warehouse Activity Line. UpdateQuantity := not (CalledFromInvtPutawayPick or PartialJobPlanningLineQuantityPosting); OnHandleMatchUsageSpecifiedJobPlanningLineOnBeforeUpdateQuantity(JobPlanningLine, JobJournalLine, UpdateQuantity); if UpdateQuantity then if (TotalQtyBase > JobPlanningLine.Quantity) or (JobPlanningLine.Quantity = 0) then JobPlanningLine.Validate(Quantity, UOMMgt.CalcQtyFromBase( JobPlanningLine."No.", JobPlanningLine."Variant Code", JobPlanningLine."Unit of Measure Code", TotalQtyBase, JobPlanningLine."Qty. per Unit of Measure")); JobPlanningLine.CopyTrackingFromJobLedgEntry(JobLedgerEntry); OnHandleMatchUsageSpecifiedJobPlanningLineOnBeforeJobPlanningLineUse(JobPlanningLine, JobJournalLine, JobLedgerEntry); JobPlanningLine.Use( UOMMgt.CalcQtyFromBase( JobPlanningLine."No.", JobPlanningLine."Variant Code", JobPlanningLine."Unit of Measure Code", JobLedgerEntry."Quantity (Base)", JobPlanningLine."Qty. per Unit of Measure"), JobLedgerEntry."Total Cost", JobLedgerEntry."Line Amount", JobLedgerEntry."Posting Date", JobLedgerEntry."Currency Factor"); OnHandleMatchUsageSpecifiedJobPlanningLineOnAfterJobPlanningLineUse(JobPlanningLine, JobJournalLine, JobLedgerEntry); JobUsageLink.Create(JobPlanningLine, JobLedgerEntry); end; procedure FindMatchingJobPlanningLine(var JobPlanningLine: Record "Job Planning Line"; JobLedgerEntry: Record "Job Ledger Entry"): Boolean var Resource: Record Resource; "Filter": Text; JobPlanningLineFound: Boolean; begin JobPlanningLine.Reset(); JobPlanningLine.SetCurrentKey("Job No.", "Schedule Line", Type, "No.", "Planning Date"); JobPlanningLine.SetRange("Job No.", JobLedgerEntry."Job No."); JobPlanningLine.SetRange("Job Task No.", JobLedgerEntry."Job Task No."); JobPlanningLine.SetRange(Type, JobLedgerEntry.Type); JobPlanningLine.SetRange("No.", JobLedgerEntry."No."); JobPlanningLine.SetRange("Location Code", JobLedgerEntry."Location Code"); JobPlanningLine.SetRange("Schedule Line", true); JobPlanningLine.SetRange("Usage Link", true); if JobLedgerEntry.Type = JobLedgerEntry.Type::Resource then begin Filter := Resource.GetUnitOfMeasureFilter(JobLedgerEntry."No.", JobLedgerEntry."Unit of Measure Code"); JobPlanningLine.SetFilter("Unit of Measure Code", Filter); end; if (JobLedgerEntry."Line Type" = JobLedgerEntry."Line Type"::Billable) or (JobLedgerEntry."Line Type" = JobLedgerEntry."Line Type"::"Both Budget and Billable") then JobPlanningLine.SetRange("Contract Line", true); if JobLedgerEntry.Quantity > 0 then JobPlanningLine.SetFilter("Remaining Qty.", '>0') else JobPlanningLine.SetFilter("Remaining Qty.", '<0'); case JobLedgerEntry.Type of JobLedgerEntry.Type::Item: JobPlanningLine.SetRange("Variant Code", JobLedgerEntry."Variant Code"); JobLedgerEntry.Type::Resource: JobPlanningLine.SetRange("Work Type Code", JobLedgerEntry."Work Type Code"); end; // Match most specific Job Planning Line. OnFindMatchingJobPlanningLineOnBeforeMatchSpecificJobPlanningLine(JobPlanningLine, JobLedgerEntry); if JobPlanningLine.FindFirst() then exit(true); JobPlanningLine.SetRange("Variant Code", ''); JobPlanningLine.SetRange("Work Type Code", ''); // Match Location Code, while Variant Code and Work Type Code are blank. OnFindMatchingJobPlanningLineOnBeforeMatchJobPlanningLineLocation(JobPlanningLine, JobLedgerEntry); if JobPlanningLine.FindFirst() then exit(true); JobPlanningLine.SetRange("Location Code", ''); case JobLedgerEntry.Type of JobLedgerEntry.Type::Item: JobPlanningLine.SetRange("Variant Code", JobLedgerEntry."Variant Code"); JobLedgerEntry.Type::Resource: JobPlanningLine.SetRange("Work Type Code", JobLedgerEntry."Work Type Code"); end; // Match Variant Code / Work Type Code, while Location Code is blank. if JobPlanningLine.FindFirst() then exit(true); JobPlanningLine.SetRange("Variant Code", ''); JobPlanningLine.SetRange("Work Type Code", ''); // Match unspecific Job Planning Line. if JobPlanningLine.FindFirst() then exit(true); JobPlanningLineFound := false; OnAfterFindMatchingJobPlanningLine(JobPlanningLine, JobLedgerEntry, JobPlanningLineFound); exit(JobPlanningLineFound); end; local procedure CreateJobPlanningLine(var JobPlanningLine: Record "Job Planning Line"; JobLedgerEntry: Record "Job Ledger Entry"; RemainingQtyToMatch: Decimal) var Job: Record Job; JobPostLine: Codeunit "Job Post-Line"; begin RemainingQtyToMatch := UOMMgt.CalcQtyFromBase( JobLedgerEntry."No.", JobLedgerEntry."Variant Code", JobLedgerEntry."Unit of Measure Code", RemainingQtyToMatch, JobLedgerEntry."Qty. per Unit of Measure"); case JobLedgerEntry."Line Type" of JobLedgerEntry."Line Type"::" ": JobLedgerEntry."Line Type" := JobLedgerEntry."Line Type"::Budget; JobLedgerEntry."Line Type"::Billable: JobLedgerEntry."Line Type" := JobLedgerEntry."Line Type"::"Both Budget and Billable"; end; JobPlanningLine.Reset(); JobPostLine.InsertPlLineFromLedgEntry(JobLedgerEntry); // Retrieve the newly created Job PlanningLine. JobPlanningLine.SetRange("Job No.", JobLedgerEntry."Job No."); JobPlanningLine.SetRange("Job Task No.", JobLedgerEntry."Job Task No."); JobPlanningLine.SetRange("Schedule Line", true); JobPlanningLine.FindLast(); JobPlanningLine.Validate("Usage Link", true); JobPlanningLine.Validate(Quantity, RemainingQtyToMatch); OnBeforeModifyJobPlanningLine(JobPlanningLine, JobLedgerEntry); JobPlanningLine.Modify(); // If type is Both Budget And Billable and that type isn't allowed, // retrieve the Billabe line and modify the quantity as well. // Do the same if the type is G/L Account (Job Planning Lines will always be split in one Budget and one Billable line). Job.Get(JobLedgerEntry."Job No."); if (JobLedgerEntry."Line Type" = JobLedgerEntry."Line Type"::"Both Budget and Billable") and ((not Job."Allow Schedule/Contract Lines") or (JobLedgerEntry.Type = JobLedgerEntry.Type::"G/L Account")) then begin JobPlanningLine.Get(JobLedgerEntry."Job No.", JobLedgerEntry."Job Task No.", JobPlanningLine."Line No." + 10000); JobPlanningLine.Validate(Quantity, RemainingQtyToMatch); JobPlanningLine.Modify(); JobPlanningLine.Get(JobLedgerEntry."Job No.", JobLedgerEntry."Job Task No.", JobPlanningLine."Line No." - 10000); end; end; local procedure AssembledQtyBase(var JobPlanningLine: Record "Job Planning Line") AssembledQty: Decimal var PostedATOLink: Record "Posted Assemble-to-Order Link"; begin PostedATOLink.SetCurrentKey("Job No.", "Job Task No.", "Document Line No."); PostedATOLink.SetRange("Job No.", JobPlanningLine."Job No."); PostedATOLink.SetRange("Job Task No.", JobPlanningLine."Job Task No."); PostedATOLink.SetRange("Document Line No.", JobPlanningLine."Line No."); if PostedATOLink.FindSet() then repeat AssembledQty += PostedATOLink."Assembled Quantity (Base)"; until PostedATOLink.Next() = 0; end; [IntegrationEvent(false, false)] local procedure OnAfterFindMatchingJobPlanningLine(var JobPlanningLine: Record "Job Planning Line"; JobLedgerEntry: Record "Job Ledger Entry"; var JobPlanningLineFound: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterMatchUsageSpecified(var JobPlanningLine: Record "Job Planning Line"; var JobJournalLine: Record "Job Journal Line"; var JobLedgerEntry: Record "Job Ledger Entry"); begin end; [IntegrationEvent(false, false)] local procedure OnBeforeModifyJobPlanningLine(var JobPlanningLine: Record "Job Planning Line"; JobLedgerEntry: Record "Job Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeJobPlanningLineUse(var JobPlanningLine: Record "Job Planning Line"; JobLedgerEntry: Record "Job Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeMatchUsageSpecified(var JobPlanningLine: Record "Job Planning Line"; var JobJournalLine: Record "Job Journal Line"; var JobLedgerEntry: Record "Job Ledger Entry"; var IsHandled: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnHandleMatchUsageSpecifiedJobPlanningLineOnAfterJobPlanningLineUse(var JobPlanningLine: Record "Job Planning Line"; JobJournalLine: Record "Job Journal Line"; JobLedgerEntry: Record "Job Ledger Entry"); begin end; [IntegrationEvent(false, false)] local procedure OnHandleMatchUsageSpecifiedJobPlanningLineOnBeforeJobPlanningLineUse(var JobPlanningLine: Record "Job Planning Line"; JobJournalLine: Record "Job Journal Line"; JobLedgerEntry: Record "Job Ledger Entry"); begin end; [IntegrationEvent(false, false)] local procedure OnMatchUsageUnspecifiedOnBeforeConfirm(JobPlanningLine: Record "Job Planning Line"; JobLedgerEntry: Record "Job Ledger Entry"; var Confirmed: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnMatchUsageUnspecifiedOnAfterCalcMatchedQty(var JobLedgerEntry: Record "Job Ledger Entry"; var MatchedQty: Decimal) begin end; [IntegrationEvent(false, false)] local procedure OnMatchUsageUnspecifiedOnAfterUpdateRemainingQtyToMatch(var JobLedgerEntry: Record "Job Ledger Entry"; var RemainingQtyToMatch: Decimal) begin end; [IntegrationEvent(false, false)] local procedure OnFindMatchingJobPlanningLineOnBeforeMatchSpecificJobPlanningLine(var JobPlanningLine: Record "Job Planning Line"; JobLedgerEntry: Record "Job Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnFindMatchingJobPlanningLineOnBeforeMatchJobPlanningLineLocation(var JobPlanningLine: Record "Job Planning Line"; JobLedgerEntry: Record "Job Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure HandleMatchUsageSpecifiedJobPlanningLineOnAfterCalcPartialJobPlanningLineQuantityPosting(JobPlanningLine: Record "Job Planning Line"; JobJournalLine: Record "Job Journal Line"; JobLedgerEntry: Record "Job Ledger Entry"; var PartialJobPlanningLineQuantityPosting: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeHandleMatchUsageSpecifiedJobPlanningLine(var PostedQtyBase: Decimal; var TotalQtyBase: Decimal; var TotalRemainingQtyPrePostBase: Decimal; JobPlanningLine: Record "Job Planning Line"; JobJournalLine: Record "Job Journal Line") begin end; [IntegrationEvent(false, false)] local procedure OnHandleMatchUsageSpecifiedJobPlanningLineOnBeforeUpdateQuantity(var JobPlanningLine: Record "Job Planning Line"; JobJournalLine: Record "Job Journal Line"; var UpdateQuantity: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnMatchUsageUnspecifiedOnBeforeCheckPostedQty(JobPlanningLine: Record "Job Planning Line"; JobLedgerEntry: Record "Job Ledger Entry"; RemainingQtyToMatch: Decimal; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterApplyUsage(var JobLedgerEntry: Record "Job Ledger Entry"; var JobJournalLine: Record "Job Journal Line") begin end;}