Report 1137 Transfer Budget to Actual
src/Layers/W1/BaseApp/CostAccounting/Budget/TransferBudgettoActual.Report.al141 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.CostAccounting.Budget;using Microsoft.CostAccounting.Journal;using Microsoft.CostAccounting.Posting;using Microsoft.Foundation.AuditCodes;report 1137 "Transfer Budget to Actual"{ ApplicationArea = CostAccounting; Caption = 'Transfer Budget to Actual'; ToolTip = 'Transfer the budgeted costs to the actual costs of cost centers or cost objects. At the beginning of the year, some companies establish a cost budget and then transfer these budgeted costs to cost centers or cost objects. The budget entries can be transferred to a cost journal and posted as actual costs in the journal.'; ProcessingOnly = true; UsageCategory = Tasks; dataset { dataitem("Cost Budget Entry"; "Cost Budget Entry") { DataItemTableView = sorting("Budget Name", "Cost Type No.", Date); RequestFilterFields = "Budget Name", Date, Allocated, "Cost Type No.", "Cost Center Code", "Cost Object Code"; trigger OnAfterGetRecord() var SourceCodeSetup: Record "Source Code Setup"; begin SourceCodeSetup.Get(); SourceCodeSetup.TestField("Transfer Budget to Actual"); TempCostJnlLine.Init(); LastEntryNo := LastEntryNo + 1; TempCostJnlLine."Line No." := LastEntryNo; TempCostJnlLine."Cost Type No." := "Cost Type No."; TempCostJnlLine."Posting Date" := Date; TempCostJnlLine."Document No." := "Document No."; if TempCostJnlLine."Document No." = '' then TempCostJnlLine."Document No." := 'BUDGET'; TempCostJnlLine.Description := Description; TempCostJnlLine.Amount := Amount; TempCostJnlLine."Cost Center Code" := "Cost Center Code"; TempCostJnlLine."Cost Object Code" := "Cost Object Code"; TempCostJnlLine."Source Code" := SourceCodeSetup."Transfer Budget to Actual"; TempCostJnlLine."Allocation Description" := "Allocation Description"; TempCostJnlLine."Allocation ID" := "Allocation ID"; TempCostJnlLine.Insert(); NoInserted := NoInserted + 1; if (NoInserted mod 100) = 0 then Window.Update(2, NoInserted); end; trigger OnPostDataItem() begin Window.Close(); if not Confirm(Text004, true, NoInserted) then Error(''); PostCostJournalLines(); end; trigger OnPreDataItem() begin if GetFilter("Budget Name") = '' then Error(Text000); if GetFilter(Date) = '' then Error(Text001); if not Confirm(Text002, true, GetFilter("Budget Name"), GetFilter(Date)) then Error(''); LockTable(); Window.Open(Text003); Window.Update(1, Count); end; } } requestpage { SaveValues = true; layout { } actions { } } labels { } var TempCostJnlLine: Record "Cost Journal Line" temporary; Window: Dialog; LastEntryNo: Integer; NoInserted: Integer;#pragma warning disable AA0074 Text000: Label 'Define the name of the source budget.'; Text001: Label 'Date range must be defined.';#pragma warning disable AA0470 Text002: Label 'The cost budget "%1" for the date range of "%2" will be transferred to the actual cost entries. \Do you want to start the job?'; Text003: Label 'Copying budget entries\No of entries #1#####\Copied #2#####'; Text004: Label '%1 budget entries were transferred to actual cost entries.\\Do you want to copy entries?';#pragma warning restore AA0470 Text005: Label 'Posting Cost Entries @1@@@@@@@@@@\';#pragma warning restore AA0074 local procedure PostCostJournalLines() var CostJnlLine: Record "Cost Journal Line"; CAJnlPostLine: Codeunit "CA Jnl.-Post Line"; Window2: Dialog; JournalLineCount: Integer; CostJnlLineStep: Integer; begin TempCostJnlLine.Reset(); Window2.Open( Text005); if TempCostJnlLine.Count > 0 then JournalLineCount := 10000 * 100000 div TempCostJnlLine.Count(); if TempCostJnlLine.FindSet() then repeat CostJnlLineStep := CostJnlLineStep + JournalLineCount; Window2.Update(1, CostJnlLineStep div 100000); CostJnlLine := TempCostJnlLine; CAJnlPostLine.RunWithCheck(CostJnlLine); until TempCostJnlLine.Next() = 0; Window2.Close(); end;}