Thanks.
I have my code below. It gives me error that "The New Date Filter field in the Purchase Cue table must be a FlowField".I have already described it as FlowFilter,Can you please help..
tableextension 50129 PurchCue extends "Purchase cue"
{
fields
{
// Add changes to table fields here
field(50121; "New Date Filter"; Date)
{
FieldClass = FlowFilter;
}
field(50120; PendingItems; Integer)
{
FieldClass = FlowField;
CalcFormula = count("Purchase Line" where("Document Type" = filter(Order), "Type" = Const(item), "Promised Receipt Date" = FIELD( "New Date Filter")));
Caption = 'Due Items';
}
}
}
pageextension 50130 PurchseOrdercuepage extends "Purchase Agent Activities"
{
layout
{
addbefore("Post Arrival Follow-up")
{
cuegroup(Itemdue)
{
caption = 'ItemDue';
field("PendingItems"; PendingItems)
{
ApplicationArea = All;
Caption = 'Due Items';
}
}
}
}
// actions{}
trigger OnOpenPage()
var
Rec: Record "Purchase cue";
begin
Rec.Reset();
Rec.SetRange("New Date Filter", CALCDATE('<-CM>', TODAY), CALCDATE('<CM>', TODAY + 1));
Rec.CalcFields("New Date Filter");
}
