Trigger for Drilldown

(0) Share

Report

Posted on by Rajiv Sewsarran

Hi All,

I'm trying to create a drilldown for my table and page extension that i recently created.

The Table extension is called "Selected Pmts"

I added this trigger to the Pageextension, but i'm not sure where i went wrong.

Can anyone assist?

pageextension 50103 "Selected Pmts" extends "Bank Account List"
{
layout
{
addafter(BalanceAmt)

field("Selected Pmts"; Rec."Selected Pmts")
            {
                ApplicationArea = all;
                Caption = 'Selected Pmts';
                DrillDown = true;
                 trigger OnDrillDown()
                var
                selpmt: Record "Bank Account"
                begin
                    selpmt."Selected Pmts"(Rec."Selected Pmts");
                    Page.Run(Page:: "Payment Journal");
                end;
                }
                }
                }

I have the same question (0)

All responses (14)

Answers (1)

Brad_P 1,549 on at

Like (0)

Report

Do you have additional information? What are you trying to do specifically? Do you intent to run the payment journal page or a filtered set of records from your table?

Was this reply helpful? Yes No
Rajiv Sewsarran 55 on at

Like (0)

Report

Hi Brad,

i created a Calculated field called "Selected Payments" on the Bank Account List. The field is the sum of all payments made in the Payments Journal for each Entity. The Entity code is represented by Short Dimension Code 1.

The issue is, when i pull up the bank account list screen, i need to be able to drilldown into the "Selected Payments" to see what makes up that payment.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi coding noob ,

Please use change your code with below:

pageextension 50103 "Selected Pmts" extends "Bank Account List"

{

layout

{

addafter(BalanceAmt)

field("Selected Pmts"; Rec."Selected Pmts")

{

ApplicationArea = all;

Caption = 'Selected Pmts';

DrillDown = true;

trigger OnDrillDown()

var

selpmt: Record "Bank Account"

begin

selpmt."Selected Pmts"(Rec."Selected Pmts");

Page.Run(Page:: "Payment Journal",selpmt);

end;

}

}

}

Was this reply helpful? Yes No
Rajiv Sewsarran 55 on at

Like (0)

Report

Hi Nitin,

I'm getting the error,

"Selected pmts cannot be used like a method (Al0127)"

Was this reply helpful? Yes No
Brad_P 1,549 on at

Like (0)

Report

What is the CalcFormula properties on the field that you added?

Was this reply helpful? Yes No
Rajiv Sewsarran 55 on at

Like (0)

Report

HI Brad,

Here's the calcformula

procedure GetProjBal(): Decimal

begin

CalcFields(Balance, "Selected Pmts");

exit(Rec.Balance - Rec."Selected Pmts");

end;

Was this reply helpful? Yes No
Brad_P 1,549 on at

Like (0)

Report

This is not the calcformula property on the field that you had added.

Was this reply helpful? Yes No
Rajiv Sewsarran 55 on at

Like (0)

Report

sorry im not sure i follow

Was this reply helpful? Yes No
Rajiv Sewsarran 55 on at

Like (0)

Report

Apologies,

Here it is

CalcFormula = Sum("Gen. Journal Line".Amount WHERE("Bal. Account No." = FIELD("No.")));

Was this reply helpful? Yes No
Rajiv Sewsarran 55 on at

Like (0)

Report

Was this reply helpful? Yes No