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)

Sort by

Brad_P 1,551 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,551 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,551 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

sorry im not sure i follow

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

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

Was this reply helpful? Yes No

Join the conversation

Community site session details

Trigger for Drilldown

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Trigger for Drilldown

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates