Report 1085 Job Post WIP to G/L

Base Application, Microsoft.Projects.Project.WIP

src/Layers/W1/BaseApp/Projects/Project/WIP/JobPostWIPtoGL.Report.al204 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.WIP;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.NoSeries;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Project.Journal;using Microsoft.Projects.Project.Setup;report 1085 "Job Post WIP to G/L"{    AdditionalSearchTerms = 'posted work in process to general ledger,posted work in progress to general ledger, Job Post WIP to G/L';    ApplicationArea = Jobs;    Caption = 'Project Post WIP to G/L';    ToolTip = 'Post to the general ledger the entries calculated for your projects.';    ProcessingOnly = true;    UsageCategory = Tasks;    dataset    {        dataitem(Job; Job)        {            DataItemTableView = sorting("No.");            RequestFilterFields = "No.";            trigger OnAfterGetRecord()            begin                GLSetup.Get();                if GLSetup."Journal Templ. Name Mandatory" then                    JobCalculateWIP.SetGenJnlBatch(GenJnlBatch);                JobCalculateWIP.CalcGLWIP("No.", JustReverse, DocNo, PostingDate, ReplacePostDate);            end;        }    }    requestpage    {        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(ReversalPostingDate; PostingDate)                    {                        ApplicationArea = Jobs;                        Caption = 'Reversal Posting Date';                        ToolTip = 'Specifies the posting date for the general ledger entries that are posted by this function.';                    }                    field(ReversalDocumentNo; DocNo)                    {                        ApplicationArea = Jobs;                        Caption = 'Reversal Document No.';                        ToolTip = 'Specifies a document number for the general ledger entries that are posted by this function.';                    }                    field(ReverseOnly; JustReverse)                    {                        ApplicationArea = Jobs;                        Caption = 'Reverse Only';                        ToolTip = 'Specifies that you want to reverse previously posted WIP, but not to post new WIP to the general ledger. This is useful, for example, when you have calculated and posted WIP for a project with an incorrect date and want to reverse the incorrect postings without posting new WIP entries.';                    }                    field(UseReversalDate; ReplacePostDate)                    {                        ApplicationArea = Jobs;                        Caption = 'Use Reversal Date';                        ToolTip = 'Specifies if you want to use the reversal date as the posting date for both the reversal of the previous WIP calculation and the posting date for the new WIP calculation. This is useful when you want to calculate and post the historical WIP for a period that is already closed. You can reverse the old postings and post the new calculation in an open period by choosing a reversal date in the open period.';                    }                    field(JnlTemplateName; GenJnlLineReq."Journal Template Name")                    {                        ApplicationArea = Jobs;                        Caption = 'Journal Template Name';                        TableRelation = "Gen. Journal Template";                        ToolTip = 'Specifies the name of the journal template that is used for the posting.';                        Visible = IsJournalTemplNameVisible;                        trigger OnValidate()                        begin                            GenJnlLineReq."Journal Batch Name" := '';                        end;                    }                    field(JnlBatchName; GenJnlLineReq."Journal Batch Name")                    {                        ApplicationArea = Jobs;                        Caption = 'Journal Batch Name';                        ToolTip = 'Specifies the name of the journal batch that is used for the posting.';                        Visible = IsJournalTemplNameVisible;                        trigger OnLookup(var Text: Text): Boolean                        var                            GenJnlManagement: Codeunit GenJnlManagement;                        begin                            GenJnlManagement.SetJnlBatchName(GenJnlLineReq);                            if GenJnlLineReq."Journal Batch Name" <> '' then                                GenJnlBatch.Get(GenJnlLineReq."Journal Template Name", GenJnlLineReq."Journal Batch Name");                        end;                        trigger OnValidate()                        begin                            if GenJnlLineReq."Journal Batch Name" <> '' then begin                                GenJnlLineReq.TestField("Journal Template Name");                                GenJnlBatch.Get(GenJnlLineReq."Journal Template Name", GenJnlLineReq."Journal Batch Name");                            end;                        end;                    }                }            }        }        actions        {        }        trigger OnOpenPage()        var            NoSeries: Codeunit "No. Series";            NewNoSeriesCode: Code[20];        begin            GLSetup.Get();            if GLSetup."Journal Templ. Name Mandatory" then begin                IsJournalTemplNameVisible := true;                GLSetup.TestField("Job WIP Jnl. Template Name");                GLSetup.TestField("Job WIP Jnl. Batch Name");                GenJnlBatch.Get(GLSetup."Job WIP Jnl. Template Name", GLSetup."Job WIP Jnl. Batch Name");            end;            if PostingDate = 0D then                PostingDate := WorkDate();            DocNo := '';            JobsSetup.Get();            JobsSetup.TestField("Job Nos.");                NewNoSeriesCode := JobsSetup."Job WIP Nos.";                DocNo := NoSeries.GetNextNo(NewNoSeriesCode);            ReplacePostDate := false;            JustReverse := false;        end;    }    labels    {    }    trigger OnPostReport()    begin        Commit();        Message(WIPSuccessfullyPostedMsg);    end;    trigger OnPreReport()    var        NoSeries: Codeunit "No. Series";        NewNoSeriesCode: Code[20];    begin        JobsSetup.Get();        if DocNo = '' then begin            JobsSetup.TestField("Job Nos.");                NewNoSeriesCode := JobsSetup."Job WIP Nos.";                DocNo := NoSeries.GetNextNo(NewNoSeriesCode);        end;        if PostingDate = 0D then            PostingDate := WorkDate();        GLSetup.Get();        if GLSetup."Journal Templ. Name Mandatory" then begin            GenJnlBatch.TestField("No. Series");            DocNo := NoSeries.GetNextNo(GenJnlBatch."No. Series", PostingDate);        end;        JobCalculateBatches.BatchError(PostingDate, DocNo);    end;    var        GLSetup: Record "General Ledger Setup";        JobsSetup: Record "Jobs Setup";        GenJnlLineReq: Record "Gen. Journal Line";        GenJnlBatch: Record "Gen. Journal Batch";        JobCalculateWIP: Codeunit "Job Calculate WIP";        JobCalculateBatches: Codeunit "Job Calculate Batches";        WIPSuccessfullyPostedMsg: Label 'WIP was successfully posted to G/L.';        IsJournalTemplNameVisible: Boolean;    protected var        PostingDate: Date;        DocNo: Code[20];        JustReverse: Boolean;        ReplacePostDate: Boolean;    procedure InitializeRequest(NewDocNo: Code[20])    begin        DocNo := NewDocNo;        PostingDate := WorkDate();    end;}