Skip to main content
Answered

Job List Page. Sum of 2 Fields (AL Code)

editSubscribe (0) ShareShare
ReportReport
Posted on by 190

Dear Experts

Am really new to this BC and coding, really using this forum and online platform for my learning.  pls kindly request all for you kind help in my issues and correcting it in the correct way .

Right now am trying to How we can bring the Total of Actual Total cost  and Total of Billable Price (from Jobs Planning lines -Job Task table (1001)) on JOB List page. Actually Total can see also at right side from Job Cost Factbox (1030, CardPart) also

jobpost.JPG

am trying like this... pls correct me to get the desired result in attached code

 pageextension 60017 JOBPageExtension50000_50951 extends "Job List"
 {
     layout
     {
     addafter("No.")
     {

    field("Actual Total Cost"; Rec."Actual Total Cost")
    {
                ApplicationArea = All;
                Width = 14;
                Caption = 'Acutal Total Cost';
                Editable = false;

     }

            field ("Billable Total Price";Rec."Billable Total Price")
            {
                ApplicationArea = All;
                Width = 14;
                Editable = false;
            }
        }
        
    }           trigger OnafterGetRecord()
                 var
                    JobSum : Record "Job Task";
                    JobTotal : Record "Job Ledger Entry";
                    TotalCost :  Decimal;
                    TotalBill   : Decimal;

                begin

                    JobSum.SetRange("Job No.");
                    JobTotal.SetRange("Job No.");
                    JobSum.CalcSums(Jobsum.Billable Total Price);
                    JobSum.CalcSums(Jobsum.Actual Total Cost);


                    end;
                    var

                        Jobsum  Decimal;
    }

    
}