Table 1017 Job Buffer
src/Layers/W1/BaseApp/Projects/Project/Journal/JobBuffer.Table.al311 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.Journal;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.Inventory.Item;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Project.Ledger;using Microsoft.Projects.Project.WIP;table 1017 "Job Buffer"{ Caption = 'Project Buffer'; ReplicateData = false; DataClassification = CustomerContent; fields { field(1; "Account No. 1"; Code[20]) { Caption = 'Account No. 1'; DataClassification = SystemMetadata; } field(2; "Account No. 2"; Code[20]) { Caption = 'Account No. 2'; DataClassification = SystemMetadata; } field(3; "Amount 1"; Decimal) { AutoFormatType = 0; Caption = 'Amount 1'; DataClassification = SystemMetadata; } field(4; "Amount 2"; Decimal) { AutoFormatType = 0; Caption = 'Amount 2'; DataClassification = SystemMetadata; } field(5; "Amount 3"; Decimal) { AutoFormatType = 0; Caption = 'Amount 3'; DataClassification = SystemMetadata; } field(6; "Amount 4"; Decimal) { AutoFormatType = 0; Caption = 'Amount 4'; DataClassification = SystemMetadata; } field(7; "Amount 5"; Decimal) { AutoFormatType = 0; Caption = 'Amount 5'; DataClassification = SystemMetadata; } field(10; Description; Text[100]) { Caption = 'Description'; DataClassification = SystemMetadata; } field(11; "New Total"; Boolean) { Caption = 'New Total'; DataClassification = SystemMetadata; } } keys { key(Key1; "Account No. 1", "Account No. 2") { Clustered = true; } } fieldgroups { } var TempJobBuffer: array[2] of Record "Job Buffer" temporary; procedure InsertWorkInProgress(var Job: Record Job) var JobWIPGLEntry: Record "Job WIP G/L Entry"; begin Clear(TempJobBuffer); JobWIPGLEntry.SetCurrentKey("Job No."); JobWIPGLEntry.SetRange("Job No.", Job."No."); JobWIPGLEntry.SetRange(Reversed, false); JobWIPGLEntry.SetRange("Job Complete", false); JobWIPGLEntry.SetFilter("Posting Date", Job.GetFilter("Posting Date Filter")); if JobWIPGLEntry.Find('-') then repeat Clear(TempJobBuffer); if JobWIPGLEntry."G/L Account No." <> '' then begin TempJobBuffer[1]."Account No. 1" := JobWIPGLEntry."G/L Account No."; TempJobBuffer[1]."Account No. 2" := JobWIPGLEntry."Job Posting Group"; if (JobWIPGLEntry.Type = JobWIPGLEntry.Type::"Applied Costs") or (JobWIPGLEntry.Type = JobWIPGLEntry.Type::"Recognized Costs") then TempJobBuffer[1]."Amount 1" := JobWIPGLEntry."WIP Entry Amount" else if JobWIPGLEntry.Type = JobWIPGLEntry.Type::"Accrued Costs" then TempJobBuffer[1]."Amount 2" := JobWIPGLEntry."WIP Entry Amount"; if (JobWIPGLEntry.Type = JobWIPGLEntry.Type::"Applied Sales") or (JobWIPGLEntry.Type = JobWIPGLEntry.Type::"Recognized Sales") then TempJobBuffer[1]."Amount 4" := JobWIPGLEntry."WIP Entry Amount" else if JobWIPGLEntry.Type = JobWIPGLEntry.Type::"Accrued Sales" then TempJobBuffer[1]."Amount 5" := JobWIPGLEntry."WIP Entry Amount"; TempJobBuffer[2] := TempJobBuffer[1]; if TempJobBuffer[2].Find() then begin TempJobBuffer[2]."Amount 1" := TempJobBuffer[2]."Amount 1" + TempJobBuffer[1]."Amount 1"; TempJobBuffer[2]."Amount 2" := TempJobBuffer[2]."Amount 2" + TempJobBuffer[1]."Amount 2"; TempJobBuffer[2]."Amount 4" := TempJobBuffer[2]."Amount 4" + TempJobBuffer[1]."Amount 4"; TempJobBuffer[2]."Amount 5" := TempJobBuffer[2]."Amount 5" + TempJobBuffer[1]."Amount 5"; TempJobBuffer[2].Modify(); end else TempJobBuffer[1].Insert(); end; until JobWIPGLEntry.Next() = 0; end; procedure InitJobBuffer() begin Clear(TempJobBuffer); TempJobBuffer[1].DeleteAll(); end; procedure GetJobBuffer(var Job: Record Job; var JobBuffer2: Record "Job Buffer") var GLEntry: Record "G/L Entry"; OldAcc: Code[20]; begin JobBuffer2.DeleteAll(); GLEntry.SetCurrentKey("G/L Account No.", "Job No.", "Posting Date"); GLEntry.SetFilter("Posting Date", Job.GetFilter("Posting Date Filter")); OldAcc := ''; if TempJobBuffer[1].Find('+') then repeat if TempJobBuffer[1]."Account No. 1" <> OldAcc then begin GLEntry.SetRange("G/L Account No.", TempJobBuffer[1]."Account No. 1"); GLEntry.SetFilter("Job No.", Job.GetFilter("No.")); GLEntry.CalcSums(Amount); TempJobBuffer[1]."Amount 3" := GLEntry.Amount; if TempJobBuffer[1]."Amount 3" <> 0 then TempJobBuffer[1]."New Total" := true; OldAcc := TempJobBuffer[1]."Account No. 1"; end; JobBuffer2 := TempJobBuffer[1]; JobBuffer2.Insert(); until TempJobBuffer[1].Next(-1) = 0; TempJobBuffer[1].DeleteAll(); end; procedure ReportJobItem(var Job: Record Job; var item2: Record Item; var JobBuffer2: Record "Job Buffer") var Item: Record Item; Item3: Record Item; JobLedgEntry: Record "Job Ledger Entry"; InFilter: Boolean; Itemfilter: Boolean; begin Clear(JobBuffer2); Clear(TempJobBuffer); JobBuffer2.DeleteAll(); TempJobBuffer[1].DeleteAll(); if Job."No." = '' then exit; Item.Copy(item2); Itemfilter := Item.GetFilters <> ''; Item.SetCurrentKey("No."); JobLedgEntry.SetCurrentKey("Job No.", "Posting Date"); JobLedgEntry.SetRange("Job No.", Job."No."); JobLedgEntry.SetFilter("Posting Date", Job.GetFilter("Posting Date Filter")); if JobLedgEntry.Find('-') then repeat if (JobLedgEntry."Entry Type" = JobLedgEntry."Entry Type"::Usage) and (JobLedgEntry.Type = JobLedgEntry.Type::Item) and (JobLedgEntry."No." <> '') then begin InFilter := true; if Itemfilter then begin Item.Init(); Item."No." := JobLedgEntry."No."; InFilter := Item.Find(); end; if InFilter then begin Item3.Init(); if Item3.Get(JobLedgEntry."No.") then; Clear(TempJobBuffer[1]); TempJobBuffer[1]."Account No. 1" := JobLedgEntry."No."; TempJobBuffer[1]."Account No. 2" := JobLedgEntry."Unit of Measure Code"; TempJobBuffer[1].Description := Item3.Description; TempJobBuffer[1]."Amount 1" := JobLedgEntry.Quantity; TempJobBuffer[1]."Amount 2" := JobLedgEntry."Total Cost (LCY)"; TempJobBuffer[1]."Amount 3" := JobLedgEntry."Line Amount (LCY)"; TempJobBuffer[2] := TempJobBuffer[1]; OnReportJobItemOnBeforeUpsertJobBuffer(TempJobBuffer, JobLedgEntry, Item3); if TempJobBuffer[2].Find() then begin TempJobBuffer[2]."Amount 1" := TempJobBuffer[2]."Amount 1" + TempJobBuffer[1]."Amount 1"; TempJobBuffer[2]."Amount 2" := TempJobBuffer[2]."Amount 2" + TempJobBuffer[1]."Amount 2"; TempJobBuffer[2]."Amount 3" := TempJobBuffer[2]."Amount 3" + TempJobBuffer[1]."Amount 3"; OnReportJobItemOnBeforeModifyJobBuffer(TempJobBuffer, JobLedgEntry); TempJobBuffer[2].Modify(); end else TempJobBuffer[1].Insert(); end; end; until JobLedgEntry.Next() = 0; if TempJobBuffer[1].Find('-') then repeat JobBuffer2 := TempJobBuffer[1]; JobBuffer2.Insert(); until TempJobBuffer[1].Next() = 0; TempJobBuffer[1].DeleteAll(); end; procedure ReportItemJob(var Item: Record Item; var Job2: Record Job; var JobBuffer2: Record "Job Buffer") var JobLedgEntry: Record "Job Ledger Entry"; Job: Record Job; Job3: Record Job; InFilter: Boolean; JobFilter: Boolean; begin Clear(JobBuffer2); Clear(TempJobBuffer); JobBuffer2.DeleteAll(); TempJobBuffer[1].DeleteAll(); if Item."No." = '' then exit; Job.Copy(Job2); JobFilter := Job.GetFilters <> ''; Job.SetCurrentKey("No."); JobLedgEntry.SetCurrentKey("Entry Type", Type, "No.", "Posting Date"); JobLedgEntry.SetRange("Entry Type", JobLedgEntry."Entry Type"::Usage); JobLedgEntry.SetRange(Type, JobLedgEntry.Type::Item); JobLedgEntry.SetRange("No.", Item."No."); JobLedgEntry.SetFilter("Posting Date", Job.GetFilter("Posting Date Filter")); if JobLedgEntry.Find('-') then repeat InFilter := true; if JobFilter then begin Job.Init(); Job."No." := JobLedgEntry."Job No."; InFilter := Job.Find(); end; if InFilter then begin Job3.Init(); if Job3.Get(JobLedgEntry."Job No.") then; Clear(TempJobBuffer[1]); TempJobBuffer[1]."Account No. 1" := JobLedgEntry."Job No."; TempJobBuffer[1]."Account No. 2" := JobLedgEntry."Unit of Measure Code"; TempJobBuffer[1].Description := Job3.Description; TempJobBuffer[1]."Amount 1" := JobLedgEntry.Quantity; TempJobBuffer[1]."Amount 2" := JobLedgEntry."Total Cost (LCY)"; TempJobBuffer[1]."Amount 3" := JobLedgEntry."Line Amount (LCY)"; TempJobBuffer[2] := TempJobBuffer[1]; if TempJobBuffer[2].Find() then begin TempJobBuffer[2]."Amount 1" := TempJobBuffer[2]."Amount 1" + TempJobBuffer[1]."Amount 1"; TempJobBuffer[2]."Amount 2" := TempJobBuffer[2]."Amount 2" + TempJobBuffer[1]."Amount 2"; TempJobBuffer[2]."Amount 3" := TempJobBuffer[2]."Amount 3" + TempJobBuffer[1]."Amount 3"; TempJobBuffer[2].Modify(); end else TempJobBuffer[1].Insert(); end; until JobLedgEntry.Next() = 0; if TempJobBuffer[1].Find('-') then repeat JobBuffer2 := TempJobBuffer[1]; JobBuffer2.Insert(); until TempJobBuffer[1].Next() = 0; TempJobBuffer[1].DeleteAll(); end; [IntegrationEvent(false, false)] local procedure OnReportJobItemOnBeforeUpsertJobBuffer(var TempJobBuffer: array[2] of Record "Job Buffer" temporary; JobLedgerEntry: Record "Job Ledger Entry"; Item: Record Item) begin end; [IntegrationEvent(false, false)] local procedure OnReportJobItemOnBeforeModifyJobBuffer(var TempJobBuffer: array[2] of Record "Job Buffer" temporary; JobLedgerEntry: Record "Job Ledger Entry") begin end;}