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)

Rajiv Sewsarran 55 on at

Like (0)

Report

RE: Trigger for Drilldown

resolved with above solution

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

Like (0)

Report

RE: Trigger for Drilldown

Hi Brad,

This was a great help!

thanks

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,666 Moderator on at

Like (0)

Report

RE: Trigger for Drilldown

Hi,

You have to replace this below line with Setrange and please try to put unique name of each field, variable, pages and functions I can see you are using same name everywhere.

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

Thanks.

Was this reply helpful? Yes No
Verified answer

Brad_P 1,549 on at

Like (0)

Report

RE: Trigger for Drilldown

I have created a small model which you can follow.

Added a field to the Customer to count the Open Cust. Ledger Entries:

field(50100; "BP Open Entry Count"; Integer)
{
Caption = 'Open Entry Count';
Editable = false;
FieldClass = FlowField;
CalcFormula = count("Cust. Ledger Entry" WHERE("Customer No." = FIELD("No."), Open = Const(true)));
}

On the Customer Card I added the field and a drilldown:

addlast(General)
{
field(BalanceDrillDown; Rec."BP Open Entry Count")
{
ApplicationArea = All;
Caption = 'Drill Down Balance';
DrillDown = true;

trigger OnDrillDown()
var
CustLedgerEntry: Record "Cust. Ledger Entry";
begin
CustLedgerEntry.SetRange("Customer No.", Rec."No.");
CustLedgerEntry.SetRange(Open, true);
Page.RunModal(Page::"Customer Ledger Entries", CustLedgerEntry);
end;

}
}

This should give you enough to go on with your example. I am not clear on your requirements, but you may want to filter the journals a bit more than just a match on No.

If the flowfield source has a page assigned to it, you do not need to specify the page in the parameter and can use 0.

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

Like (0)

Report

RE: Trigger for Drilldown

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

Like (0)

Report

RE: Trigger for Drilldown

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

RE: Trigger for Drilldown

sorry im not sure i follow

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

Like (0)

Report

RE: Trigger for Drilldown

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

RE: Trigger for Drilldown

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

RE: Trigger for Drilldown

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

Was this reply helpful? Yes No