335
Hi Everyone,
I want to create a cue showing the Due Items from Purchase Line table and Purchase Order Subform page, The cue should show the of count of the number of items having today and future as their Promised Receipt date.
Regards,
Rupali
Send me the new code
Remove the variable declaration in the OnOpenPage trigger.
You are applying a filter on a different record, you need to apply it on the Page Record, remove the variable declaration in the OnOpenPage
Thanks, I removed that field, It is still not filtering the items having Promised Receipt date as Today and tomorrow,It shows all the items that are there in Purchase line Table without filtering anything ,Can you please help?
You have defined New Date Filter has flow filter not as flow field and you can use CalcFields only on flow fields, there is a difference between flow filter and flow field.
Please check below
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");
}
#1
André Arnaud de Cal...
294,321
Super User 2025 Season 1
#2
Martin Dráb
233,025
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
