Report 5855 Implement Standard Cost Change
src/Layers/W1/BaseApp/Manufacturing/StandardCost/ImplementStandardCostChange.Report.al548 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.Manufacturing.StandardCost;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.NoSeries;using Microsoft.Inventory.Costing;using Microsoft.Inventory.Item;using Microsoft.Inventory.Journal;using Microsoft.Inventory.Location;using Microsoft.Manufacturing.MachineCenter;using Microsoft.Manufacturing.Setup;using Microsoft.Manufacturing.WorkCenter;using Microsoft.Pricing.Calculation;using Microsoft.Pricing.PriceList;using Microsoft.Projects.Resources.Pricing;using Microsoft.Projects.Resources.Resource;report 5855 "Implement Standard Cost Change"{ Caption = 'Implement Standard Cost Change'; ProcessingOnly = true; dataset { dataitem("Standard Cost Worksheet"; "Standard Cost Worksheet") { DataItemTableView = sorting("Standard Cost Worksheet Name", Type, "No."); RequestFilterFields = Type, "No."; trigger OnAfterGetRecord() begin Window.Update(1, Type); Window.Update(2, "No."); case Type of Type::Item: begin UpdateItem("Standard Cost Worksheet"); UpdateSKU("Standard Cost Worksheet"); InsertRevalItemJnlLine(); end; Type::"Work Center": UpdateWorkCenter("Standard Cost Worksheet"); Type::"Machine Center": UpdateMachCenter("Standard Cost Worksheet"); Type::Resource: UpdateRes("Standard Cost Worksheet"); end; UpdateStdCostWksh("Standard Cost Worksheet") end; trigger OnPostDataItem() begin if not NoMessage then Message(GetMessage()); end; trigger OnPreDataItem() begin SetRange("Standard Cost Worksheet Name", StdCostWkshName); if IsEmpty() then Error(Text013, StdCostWkshName); Window.Open( Text000 + Text007 + Text008); ItemJnlLine.LockTable(); LockTable(); RevalJnlCreated := false; LoadSKUCostOnMfg := LoadSKUCostOnManufacturing(); end; } } requestpage { SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(PostingDate; PostingDate) { ApplicationArea = Basic, Suite; Caption = 'Posting Date'; NotBlank = true; ToolTip = 'Specifies the date that the revaluation should take place.'; } field(DocumentNo; DocNo) { ApplicationArea = Basic, Suite; Caption = 'Document No.'; ToolTip = 'Specifies the number of the revaluation journal lines.'; } field(ItemJournalTemplate; RevalItemJnlTemplate.Name) { ApplicationArea = Basic, Suite; Caption = 'Item Journal Template '; NotBlank = true; TableRelation = "Item Journal Template" where(Type = const(Revaluation)); ToolTip = 'Specifies the name of the revaluation journal template.'; } field(ItemJournalBatchName; RevalItemJnlBatch.Name) { ApplicationArea = Basic, Suite; Caption = 'Item Journal Batch Name'; NotBlank = true; TableRelation = "Item Journal Batch".Name; ToolTip = 'Specifies the name of the actual revaluation journal.'; trigger OnLookup(var Text: Text): Boolean begin RevalItemJnlBatch.SetFilter("Journal Template Name", RevalItemJnlTemplate.Name); if PAGE.RunModal(0, RevalItemJnlBatch) = ACTION::LookupOK then begin Text := Text + RevalItemJnlBatch.Name; exit(true); end; exit(false); end; trigger OnValidate() begin RevalItemJnlBatchNameOnAfterVa(); end; } } } } actions { } trigger OnOpenPage() begin OnBeforeOnOpenPage(DocNo); if PostingDate = 0D then PostingDate := WorkDate(); ValidatePostingDate(); end; } labels { } trigger OnPreReport() begin OnBeforeOnPreReport(DocNo, NoMessage); RevalItemJnlTemplate.Get(RevalItemJnlTemplate.Name); RevalItemJnlTemplate.TestField(Type, RevalItemJnlTemplate.Type::Revaluation); RevalItemJnlBatch.Get(RevalItemJnlTemplate.Name, RevalItemJnlBatch.Name); if DocNo = '' then Error(Text001); if StdCostWkshName = '' then Error(Text002); end; var ItemJnlLine: Record "Item Journal Line"; RevalItemJnlTemplate: Record "Item Journal Template"; RevalItemJnlBatch: Record "Item Journal Batch"; Window: Dialog; StdCostWkshName: Code[10]; DocNo: Code[20];#pragma warning disable AA0074 Text000: Label 'Implementing standard cost changes...\\'; Text001: Label 'You must specify a document no.'; Text002: Label 'You must specify a worksheet to implement from.';#pragma warning disable AA0470 Text007: Label 'Type #1##########\'; Text008: Label 'No. #2##########';#pragma warning restore AA0470 Text009: Label '\Revaluation journal lines have also been created.';#pragma warning restore AA0074 RevalJnlCreated: Boolean; ItemCostsUpdated: Boolean; MachCtrCostsUpdated: Boolean; WorkCtrCostsUpdated: Boolean; ResCostsUpdated: Boolean; SKUCostsUpdated: Boolean; SKUCostUpdateSkipped: Boolean; LoadSKUCostOnMfg: Boolean; NoMessage: Boolean; HideDuplWarning: Boolean;#pragma warning disable AA0074 Text010: Label 'Costs have been updated on the following: '; Text011: Label ', '; Text012: Label '.';#pragma warning disable AA0470 Text013: Label 'Standard Cost Worksheet %1 is empty.';#pragma warning restore AA0470#pragma warning restore AA0074 SKUCalcStdCostInstructionMsg: Label 'To update the standard cost on stockkeeping units, open the Stockkeeping Unit Card and use the Calc. Standard Cost action.'; protected var PostingDate: Date; local procedure UpdateItem(StdCostWksh: Record "Standard Cost Worksheet") var Item: Record Item; begin OnBeforeUpdateItem(StdCostWksh, PostingDate); Item.Get(StdCostWksh."No."); Item.Validate("Indirect Cost %", StdCostWksh."New Indirect Cost %"); Item.Validate("Overhead Rate", StdCostWksh."New Overhead Rate"); Item.Validate("Standard Cost", StdCostWksh."New Standard Cost"); Item."Single-Level Material Cost" := StdCostWksh."New Single-Lvl Material Cost"; Item."Single-Level Capacity Cost" := StdCostWksh."New Single-Lvl Cap. Cost"; Item."Single-Level Subcontrd. Cost" := StdCostWksh."New Single-Lvl Subcontrd Cost"; Item."Single-Level Cap. Ovhd Cost" := StdCostWksh."New Single-Lvl Cap. Ovhd Cost"; Item."Single-Level Mfg. Ovhd Cost" := StdCostWksh."New Single-Lvl Mfg. Ovhd Cost"; Item."Rolled-up Material Cost" := StdCostWksh."New Rolled-up Material Cost"; Item."Rolled-up Capacity Cost" := StdCostWksh."New Rolled-up Cap. Cost"; Item."Rolled-up Subcontracted Cost" := StdCostWksh."New Rolled-up Subcontrd Cost"; Item."Rolled-up Mfg. Ovhd Cost" := StdCostWksh."New Rolled-up Mfg. Ovhd Cost"; Item."Rolled-up Cap. Overhead Cost" := StdCostWksh."New Rolled-up Cap. Ovhd Cost"; Item."Last Unit Cost Calc. Date" := PostingDate; OnUpdateItemOnBeforeModify(StdCostWksh, Item); Item.Modify(true); ItemCostsUpdated := true; end; local procedure UpdateSKU(StdCostWksh: Record "Standard Cost Worksheet") var SKU: Record "Stockkeeping Unit"; IsHandled: Boolean; begin SKU.SetRange("Item No.", StdCostWksh."No."); if SKU.Find('-') then begin if LoadSKUCostOnMfg then begin SKUCostUpdateSkipped := true; exit; end; SKUCostsUpdated := true; repeat IsHandled := false; OnUpdateSKUOnBeforeValidateStandardCost(StdCostWksh, SKU, IsHandled); if not IsHandled then SKU.Validate("Standard Cost", StdCostWksh."New Standard Cost"); SKU.Modify(true); until SKU.Next() = 0; end; end; local procedure LoadSKUCostOnManufacturing(): Boolean var ManufacturingSetup: Record "Manufacturing Setup"; begin if not ManufacturingSetup.Get() then exit(false); exit(ManufacturingSetup."Load SKU Cost on Manufacturing"); end; local procedure UpdateMachCenter(StdCostWksh: Record "Standard Cost Worksheet") var MachCtr: Record "Machine Center"; begin OnBeforeUpdateMachCenter(StdCostWksh, PostingDate); MachCtr.Get(StdCostWksh."No."); MachCtr.Validate("Overhead Rate", StdCostWksh."New Overhead Rate"); MachCtr.Validate("Indirect Cost %", StdCostWksh."New Indirect Cost %"); MachCtr.Validate("Unit Cost", StdCostWksh."New Standard Cost"); MachCtr.Modify(true); MachCtrCostsUpdated := true; end; local procedure UpdateWorkCenter(StdCostWksh: Record "Standard Cost Worksheet") var WorkCtr: Record "Work Center"; begin OnBeforeUpdateWorkCenter(StdCostWksh, PostingDate); WorkCtr.Get(StdCostWksh."No."); WorkCtr.Validate("Overhead Rate", StdCostWksh."New Overhead Rate"); WorkCtr.Validate("Indirect Cost %", StdCostWksh."New Indirect Cost %"); WorkCtr.Validate("Unit Cost", StdCostWksh."New Standard Cost"); WorkCtr.Modify(true); WorkCtrCostsUpdated := true; end; local procedure UpdateRes(StdCostWksh: Record "Standard Cost Worksheet") var Resource: Record Resource; begin Resource.Get(StdCostWksh."No."); Resource.Validate(Resource."Indirect Cost %", StdCostWksh."New Indirect Cost %"); Resource.Validate(Resource."Unit Cost", StdCostWksh."New Standard Cost"); Resource.Modify(true); ResCostsUpdated := true; UpdateResourceCost(StdCostWksh, Resource); end; local procedure UpdateStdCostWksh(var StdCostWksh: Record "Standard Cost Worksheet") begin StdCostWksh.Implemented := true; StdCostWksh.Modify(true); end; local procedure InsertRevalItemJnlLine() var GLSetup: Record "General Ledger Setup"; ItemJnlLine2: Record "Item Journal Line"; IsHandled: Boolean; begin ItemJnlLine2.SetRange("Journal Template Name", RevalItemJnlTemplate.Name); ItemJnlLine2.SetRange("Journal Batch Name", RevalItemJnlBatch.Name); if ItemJnlLine2.Find('+') then; CalculateInventoryValue(); HideDuplWarning := true; GLSetup.Get(); IsHandled := false; OnInsertRevalItemJnlLineOnBeforeItemJnlLineLoop(ItemJnlLine2, RevalJnlCreated, IsHandled); if not IsHandled then if ItemJnlLine2.Next() <> 0 then repeat ItemJnlLine2.Validate( "Unit Cost (Revalued)", Round("Standard Cost Worksheet"."New Standard Cost", GLSetup."Unit-Amount Rounding Precision")); ItemJnlLine2.Modify(true); RevalJnlCreated := true; until ItemJnlLine2.Next() = 0; end; procedure SetStdCostWksh(NewStdCostWkshName: Code[10]) begin StdCostWkshName := NewStdCostWkshName; end; local procedure GetMessage() TheMsg: Text var Item: Record Item; MachCtr: Record "Machine Center"; WorkCtr: Record "Work Center"; Res: Record Resource; SKU: Record "Stockkeeping Unit"; begin TheMsg := ''; if ItemCostsUpdated then TheMsg := Item.TableCaption(); if SKUCostsUpdated then begin TheMsg := TheMsg + Text011; TheMsg := TheMsg + SKU.TableCaption(); end; if MachCtrCostsUpdated then begin if TheMsg <> '' then TheMsg := TheMsg + Text011; TheMsg := TheMsg + MachCtr.TableCaption(); end; if WorkCtrCostsUpdated then begin if TheMsg <> '' then TheMsg := TheMsg + Text011; TheMsg := TheMsg + WorkCtr.TableCaption(); end; if ResCostsUpdated then begin if TheMsg <> '' then TheMsg := TheMsg + Text011; TheMsg := TheMsg + Res.TableCaption(); end; if TheMsg <> '' then TheMsg := Text010 + TheMsg + Text012; if SKUCostUpdateSkipped then begin if TheMsg <> '' then TheMsg += '\'; TheMsg += SKUCalcStdCostInstructionMsg; end; if RevalJnlCreated then TheMsg := TheMsg + Text009; exit(TheMsg); end; local procedure ValidatePostingDate() var NoSeries: Codeunit "No. Series"; begin if RevalItemJnlBatch.Get(RevalItemJnlTemplate.Name, RevalItemJnlBatch.Name) then if RevalItemJnlBatch."No. Series" = '' then DocNo := '' else DocNo := NoSeries.PeekNextNo(RevalItemJnlBatch."No. Series", PostingDate); end; procedure Initialize() begin Initialize('', 0D, '', '', false); end; procedure Initialize(DocNo2: Code[20]; PostingDate2: Date; RevalItemJnlTemplate2: Code[10]; RevalItemJnlBatch2: Code[10]; NoMessage2: Boolean) begin PostingDate := PostingDate2; DocNo := DocNo2; RevalItemJnlTemplate.Get(RevalItemJnlTemplate2); RevalItemJnlBatch.Get(RevalItemJnlTemplate2, RevalItemJnlBatch2); NoMessage := NoMessage2; end; local procedure RevalItemJnlBatchNameOnAfterVa() begin ValidatePostingDate(); end; local procedure CalculateInventoryValue() var Item: Record Item; CalcInvtValue: Report "Calculate Inventory Value"; CalculatePer: Enum "Inventory Value Calc. Per"; IsHandled: Boolean; begin OnBeforeCalculateInventoryValue(RevalItemJnlTemplate, "Standard Cost Worksheet", PostingDate, DocNo, HideDuplWarning, IsHandled, RevalItemJnlBatch); if IsHandled then exit; ItemJnlLine."Journal Template Name" := RevalItemJnlTemplate.Name; ItemJnlLine."Journal Batch Name" := RevalItemJnlBatch.Name; CalcInvtValue.SetItemJnlLine(ItemJnlLine); Clear(Item); Item.SetRange("No.", "Standard Cost Worksheet"."No."); CalcInvtValue.SetTableView(Item); CalcInvtValue.SetParameters(PostingDate, DocNo, HideDuplWarning, CalculatePer::Item, false, false, false, "Inventory Value Calc. Base"::" ", false); CalcInvtValue.UseRequestPage(false); OnCalculateInventoryValueOnBeforeCalcInvtValueRun(CalcInvtValue, PostingDate, DocNo, HideDuplWarning); CalcInvtValue.Run(); end; local procedure UpdateResourceCost(StandardCostWorksheet: Record "Standard Cost Worksheet"; Resource: Record Resource) var PriceListLine: Record "Price List Line"; IsHandled: Boolean; begin IsHandled := false; OnBeforeUpdateResourceCost(StandardCostWorksheet, Resource, IsHandled); if IsHandled then exit; if UpdateOldResourceCost(StandardCostWorksheet, Resource) then exit; PriceListLine.Reset(); PriceListLine.SetRange("Price Type", PriceListLine."Price Type"::Purchase); PriceListLine.SetRange("Source Type", PriceListLine."Source Type"::"All Jobs"); PriceListLine.SetRange("Asset Type", PriceListLine."Asset Type"::Resource); PriceListLine.SetRange("Asset No.", Resource."No."); PriceListLine.SetRange("Work Type Code", ''); PriceListLine.SetRange("Starting Date", 0D); PriceListLine.SetRange("Ending Date", 0D); PriceListLine.SetRange("Minimum Quantity", 0); PriceListLine.SetRange(Status, PriceListLine.Status::Draft, PriceListLine.Status::Active); if PriceListLine.FindFirst() then begin if PriceListLine.Status = PriceListLine.Status::Active then begin PriceListLine.Status := PriceListLine.Status::Draft; PriceListLine.Modify(); end; PriceListLine.Validate("Direct Unit Cost", Resource."Direct Unit Cost"); PriceListLine.Validate("Unit Cost", StandardCostWorksheet."New Standard Cost"); PriceListLine.Status := PriceListLine.Status::Active; PriceListLine.Modify(true); end; end; local procedure UpdateOldResourceCost(StandardCostWorksheet: Record "Standard Cost Worksheet"; Resource: Record Resource): Boolean; var ResourceCost: Record "Resource Cost"; PriceCalculationMgt: Codeunit "Price Calculation Mgt."; begin if PriceCalculationMgt.IsExtendedPriceCalculationEnabled() then exit(false); ResourceCost.Type := ResourceCost.Type::Resource; ResourceCost.Code := StandardCostWorksheet."No."; ResourceCost.Validate("Direct Unit Cost", Resource."Direct Unit Cost"); ResourceCost.Validate("Unit Cost", StandardCostWorksheet."New Standard Cost"); if not ResourceCost.Modify(true) then; exit(true); end; [IntegrationEvent(false, false)] local procedure OnBeforeCalculateInventoryValue(var ItemJournalTemplate: Record "Item Journal Template"; var StandardCostWorksheet: Record "Standard Cost Worksheet"; PostingDate: Date; DocNo: Code[20]; HideDuplWarning: Boolean; var IsHandled: Boolean; var ItemJournalBatch: Record "Item Journal Batch"); begin end; [IntegrationEvent(false, false)] local procedure OnBeforeUpdateResourceCost(StandardCostWorksheet: Record "Standard Cost Worksheet"; Resource: Record Resource; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeUpdateItem(var StandardCostWorksheet: Record "Standard Cost Worksheet"; PostingDate: Date) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeUpdateMachCenter(var StandardCostWorksheet: Record "Standard Cost Worksheet"; PostingDate: Date) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeUpdateWorkCenter(var StandardCostWorksheet: Record "Standard Cost Worksheet"; PostingDate: Date) begin end; [IntegrationEvent(false, false)] local procedure OnUpdateItemOnBeforeModify(StandardCostWorksheet: Record "Standard Cost Worksheet"; var Item: Record Item) begin end; [IntegrationEvent(false, false)] local procedure OnCalculateInventoryValueOnBeforeCalcInvtValueRun(var CalculateInventoryValue: Report "Calculate Inventory Value"; NewPostingDate: Date; NewDocNo: Code[20]; NewHideDuplWarning: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnUpdateSKUOnBeforeValidateStandardCost(StandardCostWorksheet: Record "Standard Cost Worksheet"; var StockkeepingUnit: Record "Stockkeeping Unit"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnInsertRevalItemJnlLineOnBeforeItemJnlLineLoop(var ItemJournalLine: Record "Item Journal Line"; var RevalJnlCreated: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeOnPreReport(var DocNo: Code[20]; var NoMessage: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeOnOpenPage(DocNo: Code[20]) begin end;}