Report 1095 Update Job Item Cost
src/Layers/W1/BaseApp/Projects/Project/Job/UpdateJobItemCost.Report.al319 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.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Projects.Project.Ledger;using Microsoft.Projects.Project.Planning;report 1095 "Update Job Item Cost"{ AdditionalSearchTerms = 'Update Job Item Cost'; ApplicationArea = Jobs; Caption = 'Update Project Item Cost'; ToolTip = 'Update the usage costs in the project ledger entries to match the actual costs in the item ledger entry. If adjustment value entries have a different date than the original value entry, such as when the inventory period is closed, then the project ledger is not updated.'; Permissions = TableData "Job Ledger Entry" = rm, TableData "Value Entry" = rm; ProcessingOnly = true; UsageCategory = Tasks; dataset { dataitem(Job; Job) { DataItemTableView = sorting("No.") where(Status = filter(Planning | Quote | Open)); RequestFilterFields = "No."; dataitem("Job Ledger Entry"; "Job Ledger Entry") { DataItemLink = "Job No." = field("No."); DataItemTableView = sorting(Type, "Entry Type", "Country/Region Code", "Source Code", "Posting Date") where(Type = filter(= Item), "Entry Type" = filter(= Usage)); RequestFilterFields = "Posting Date"; dataitem("Item Ledger Entry"; "Item Ledger Entry") { DataItemLink = "Entry No." = field("Ledger Entry No."); DataItemTableView = sorting("Entry No."); dataitem("Job Planning Line"; "Job Planning Line") { DataItemLink = "Job No." = field("Job No."), "Job Task No." = field("Job Task No."), "Ledger Entry No." = field("Entry No."); DataItemTableView = sorting("Job No.", "Job Task No.", "Line No."); trigger OnAfterGetRecord() begin CalcFields("Qty. Transferred to Invoice"); if ("Qty. Transferred to Invoice" <> 0) or not "System-Created Entry" or ("Ledger Entry Type" <> "Ledger Entry Type"::Item) then CurrReport.Skip(); Validate("Unit Cost (LCY)", "Job Ledger Entry"."Unit Cost (LCY)"); Validate("Line Discount Amount (LCY)", "Job Ledger Entry"."Line Discount Amount (LCY)"); Modify(); "Job Ledger Entry".Validate("Unit Price", "Unit Price"); "Job Ledger Entry".Validate("Unit Price (LCY)", "Unit Price (LCY)"); "Job Ledger Entry".Validate("Total Price", "Total Price"); "Job Ledger Entry".Validate("Total Price (LCY)", "Total Price (LCY)"); "Job Ledger Entry".Validate("Line Amount (LCY)", "Line Amount (LCY)"); "Job Ledger Entry".Validate("Line Amount", "Line Amount"); "Job Ledger Entry".Modify(); end; trigger OnPreDataItem() begin if NoOfJobLedgEntry = 0 then CurrReport.Break(); LockTable(); end; } trigger OnAfterGetRecord() var ValueEntry: Record "Value Entry"; ValueEntry2: Record "Value Entry"; Item: Record Item; JobLedgerEntryCostValue: Decimal; JobLedgerEntryCostValueACY: Decimal; IsHandled: Boolean; begin IsHandled := false; OnItemLedgerEntryOnAfterGetRecord("Item Ledger Entry", IsHandled); if IsHandled then CurrReport.Skip(); SetValueEntryFilters(ValueEntry, "Item Ledger Entry", "Job Ledger Entry"); if ValueEntry.IsEmpty() then begin Item.Get("Item No."); if Item.Type = Item.Type::Inventory then begin CalcFields("Cost Amount (Expected)", "Cost Amount (Expected) (ACY)", "Cost Amount (Actual)", "Cost Amount (Actual) (ACY)"); JobLedgerEntryCostValue := "Cost Amount (Expected)" + "Cost Amount (Actual)"; JobLedgerEntryCostValueACY := "Cost Amount (Expected) (ACY)" + "Cost Amount (Actual) (ACY)"; end else begin CalcFields("Cost Amount (Non-Invtbl.)", "Cost Amount (Non-Invtbl.)(ACY)"); JobLedgerEntryCostValue := "Cost Amount (Non-Invtbl.)"; JobLedgerEntryCostValueACY := "Cost Amount (Non-Invtbl.)(ACY)"; end; end else begin ValueEntry.SetRange(Adjustment, false); if ValueEntry.FindFirst() then begin AddJobCostValue(JobLedgerEntryCostValue, JobLedgerEntryCostValueACY, ValueEntry, ValueEntry.Inventoriable); ValueEntry2.SetRange("Item Ledger Entry No.", "Entry No."); ValueEntry2.SetRange("Document No.", ValueEntry."Document No."); ValueEntry2.SetRange("Item Ledger Entry Type", ValueEntry."Item Ledger Entry Type"::"Negative Adjmt."); ValueEntry2.SetRange("Document Type", ValueEntry."Document Type"::"Purchase Invoice"); ValueEntry2.SetRange(Adjustment, true); if ValueEntry.Inventoriable then ValueEntry2.CalcSums("Cost Amount (Actual)", "Cost Amount (Actual) (ACY)") else ValueEntry2.CalcSums("Cost Amount (Non-Invtbl.)", "Cost Amount (Non-Invtbl.)(ACY)"); AddJobCostValue(JobLedgerEntryCostValue, JobLedgerEntryCostValueACY, ValueEntry2, ValueEntry.Inventoriable); ValueEntry2.SetRange("Job Ledger Entry No.", 0); ModifyAllValueEntries(ValueEntry2, ValueEntry); end; end; PostTotalCostAdjustment("Job Ledger Entry", JobLedgerEntryCostValue, JobLedgerEntryCostValueACY); end; trigger OnPreDataItem() begin LockTable(); end; } trigger OnPreDataItem() begin LockTable(); end; } trigger OnPostDataItem() begin OnBeforeOnPostDataItemJob(NoOfJobLedgEntry, HideResult); if not HideResult then if NoOfJobLedgEntry <> 0 then Message(StrSubstNo(Text001, NoOfJobLedgEntry)) else Message(Text003); end; trigger OnPreDataItem() begin NoOfJobLedgEntry := 0; LockTable(); end; } } requestpage { layout { } actions { } } labels { } trigger OnPreReport() begin OnAfterOnPreReport(); end; var#pragma warning disable AA0074#pragma warning disable AA0470 Text001: Label 'The project ledger entry item costs have now been updated to equal the related item ledger entry actual costs.\\The number of project ledger entries modified = %1.', Comment = 'The Project Ledger Entry item costs have now been updated to equal the related item ledger entry actual costs.\\Number of Project Ledger Entries modified = 2.';#pragma warning restore AA0470#pragma warning restore AA0074 NoOfJobLedgEntry: Integer;#pragma warning disable AA0074 Text003: Label 'There were no project ledger entries that needed to be updated.';#pragma warning restore AA0074 HideResult: Boolean; procedure SetProperties(SuppressSummary: Boolean) begin HideResult := SuppressSummary; end; local procedure SetValueEntryFilters(var ValueEntry: Record "Value Entry"; ItemLedgEntry: Record "Item Ledger Entry"; JobLedgEntry: Record "Job Ledger Entry"); begin ValueEntry.SetRange("Job No.", JobLedgEntry."Job No."); ValueEntry.SetRange("Job Task No.", JobLedgEntry."Job Task No."); ValueEntry.SetRange("Job Ledger Entry No.", JobLedgEntry."Entry No."); ValueEntry.SetRange("Item Ledger Entry No.", ItemLedgEntry."Entry No."); ValueEntry.SetRange("Item Ledger Entry Type", ValueEntry."Item Ledger Entry Type"::"Negative Adjmt."); ValueEntry.SetRange("Document Type", ValueEntry."Document Type"::"Purchase Invoice"); OnAfterSetValueEntryFilters(ValueEntry, ItemLedgEntry, JobLedgEntry); end; local procedure ModifyAllValueEntries(var ToValueEntry: Record "Value Entry"; var FromValueEntry: Record "Value Entry") begin ToValueEntry.ModifyAll("Job No.", FromValueEntry."Job No."); ToValueEntry.ModifyAll("Job Task No.", FromValueEntry."Job Task No."); ToValueEntry.ModifyAll("Job Ledger Entry No.", FromValueEntry."Job Ledger Entry No."); OnAfterModifyAllValueEntries(ToValueEntry, FromValueEntry); end; protected procedure UpdatePostedTotalCost(var JobLedgerEntry: Record "Job Ledger Entry"; AdjustJobCost: Decimal; AdjustJobCostLCY: Decimal) var JobUsageLink: Record "Job Usage Link"; JobPlanningLine: Record "Job Planning Line"; begin JobUsageLink.SetRange("Entry No.", JobLedgerEntry."Entry No."); if JobUsageLink.FindSet() then repeat JobPlanningLine.Get(JobUsageLink."Job No.", JobUsageLink."Job Task No.", JobUsageLink."Line No."); JobPlanningLine.UpdatePostedTotalCost(AdjustJobCost, AdjustJobCostLCY); JobPlanningLine.Modify(); until JobUsageLink.Next() = 0; end; local procedure PostTotalCostAdjustment(var JobLedgEntry: Record "Job Ledger Entry"; JobLedgerEntryCostValue: Decimal; JobLedgerEntryCostValueACY: Decimal) var AdjustJobCost: Decimal; AdjustJobCostLCY: Decimal; IsHandled: Boolean; begin IsHandled := false; OnBeforePostTotalCostAdjustment( JobLedgEntry, "Item Ledger Entry", JobLedgerEntryCostValue, JobLedgerEntryCostValueACY, AdjustJobCost, AdjustJobCostLCY, NoOfJobLedgEntry, IsHandled); if IsHandled then exit; if JobLedgEntry."Total Cost (LCY)" <> -JobLedgerEntryCostValue then begin // Update Total Costs AdjustJobCostLCY := -JobLedgerEntryCostValue - JobLedgEntry."Total Cost (LCY)"; JobLedgEntry."Total Cost (LCY)" := -JobLedgerEntryCostValue; if JobLedgEntry."Currency Code" = '' then begin AdjustJobCost := -JobLedgerEntryCostValue - JobLedgEntry."Total Cost"; JobLedgEntry."Total Cost" := -JobLedgerEntryCostValue end else begin AdjustJobCost := -JobLedgerEntryCostValue * JobLedgEntry."Currency Factor" - JobLedgEntry."Total Cost"; JobLedgEntry."Total Cost" := -JobLedgerEntryCostValue * JobLedgEntry."Currency Factor"; end; if JobLedgerEntryCostValueACY <> 0 then JobLedgEntry."Additional-Currency Total Cost" := -JobLedgerEntryCostValueACY; // Update Unit Costs if JobLedgEntry.Quantity = 0 then begin JobLedgEntry."Unit Cost (LCY)" := JobLedgEntry."Total Cost (LCY)"; JobLedgEntry."Unit Cost" := JobLedgEntry."Total Cost"; end else begin JobLedgEntry."Unit Cost (LCY)" := JobLedgEntry."Total Cost (LCY)" / JobLedgEntry.Quantity; JobLedgEntry."Unit Cost" := JobLedgEntry."Total Cost" / JobLedgEntry.Quantity; end; JobLedgEntry.Adjusted := true; JobLedgEntry."DateTime Adjusted" := CurrentDateTime; OnPostTotalCostAdjustmentOnBeforeJobLedgEntryModify(JobLedgEntry, "Item Ledger Entry"); JobLedgEntry.Modify(); UpdatePostedTotalCost(JobLedgEntry, AdjustJobCost, AdjustJobCostLCY); NoOfJobLedgEntry += 1; end; end; local procedure AddJobCostValue(var JobLedgerEntryCostValue: Decimal; var JobLedgerEntryCostValueACY: Decimal; ValueEntry: Record "Value Entry"; InventoriableItem: Boolean) begin if InventoriableItem then begin JobLedgerEntryCostValue += ValueEntry."Cost Amount (Actual)"; JobLedgerEntryCostValueACY += ValueEntry."Cost Amount (Actual) (ACY)"; end else begin JobLedgerEntryCostValue += ValueEntry."Cost Amount (Non-Invtbl.)"; JobLedgerEntryCostValueACY += ValueEntry."Cost Amount (Non-Invtbl.)(ACY)"; end; end; [IntegrationEvent(false, false)] local procedure OnAfterModifyAllValueEntries(var ToValueEntry: Record "Value Entry"; FromValueEntry: Record "Value Entry") begin end; [IntegrationEvent(false, false)] local procedure OnAfterSetValueEntryFilters(var ValueEntry: Record "Value Entry"; ItemLedgEntry: Record "Item Ledger Entry"; JobLedgEntry: Record "Job Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnAfterOnPreReport() begin end; [IntegrationEvent(false, false)] local procedure OnBeforePostTotalCostAdjustment(var JobLedgEntry: Record "Job Ledger Entry"; ItemLedgerEntry: Record "Item Ledger Entry"; var JobLedgerEntryCostValue: Decimal; var JobLedgerEntryCostValueACY: Decimal; var AdjustJobCost: Decimal; var AdjustJobCostLCY: Decimal; var NoOfJobLedgEntry: Integer; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeOnPostDataItemJob(NoOfJobLedgEntry: Integer; var HideResult: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnPostTotalCostAdjustmentOnBeforeJobLedgEntryModify(var JobLedgerEntry: Record "Job Ledger Entry"; ItemLedgerEntry: Record "Item Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnItemLedgerEntryOnAfterGetRecord(ItemLedgerEntry: Record "Item Ledger Entry"; var IsHandled: Boolean) begin end;}