[NAV2017] Drilldown page on flowfield not showing
thijsniehof
Member Posts: 3
On the sales order subform page (displaying Sales order lines), I've added the flowfields Item."Qty. on Purch. Order" and Item."Qty. on Sales Order".
They're showing up just fine, with the correct values.
I now want to show the pages Purchase Order Lines respectively Sales Order Lines with the lines corresponding to the item in the sales order subform, when clicking on the values.
If I set the DrilldownPageID property to "Purchase Lines" in case of the "Qty on Purch. order", nothing happens.
If I set a local variable PagePurchaseLines of type Page, subtype Purchase Lines and write PagePurchaseLines.RUN in the OnDrillDown trigger, the page Purchase Lines opens, but with no filtering whatsoever.
In what way can I open the correct pages with filtering on the Item on the selected line in the subform?
They're showing up just fine, with the correct values.
I now want to show the pages Purchase Order Lines respectively Sales Order Lines with the lines corresponding to the item in the sales order subform, when clicking on the values.
If I set the DrilldownPageID property to "Purchase Lines" in case of the "Qty on Purch. order", nothing happens.
If I set a local variable PagePurchaseLines of type Page, subtype Purchase Lines and write PagePurchaseLines.RUN in the OnDrillDown trigger, the page Purchase Lines opens, but with no filtering whatsoever.
In what way can I open the correct pages with filtering on the Item on the selected line in the subform?
0
Best Answer
-
Hello thijsniehof,
if I understand you correctly, then you have a global record Item with the FlowFields.
The automatic Drilldown cannot work.
One possibility: Create the FlowFields in Sales Line itself and use automatic Drilldown.
The other possibility:
Code the OnDrillDown yourself.
Therefore you need a local record Purchase Line.
Set the corresponding Filters on Purchase Line.
Call PAGE.RUNMODAL(0, PurchaseLine)
(Or replace the 0 with your favorite page.)
With kindly regards
s_keims_keim (Germany)
inhouse developer on NAV2016 (9.00.47838) NAVDE5
Answers
-
Hello thijsniehof,
if I understand you correctly, then you have a global record Item with the FlowFields.
The automatic Drilldown cannot work.
One possibility: Create the FlowFields in Sales Line itself and use automatic Drilldown.
The other possibility:
Code the OnDrillDown yourself.
Therefore you need a local record Purchase Line.
Set the corresponding Filters on Purchase Line.
Call PAGE.RUNMODAL(0, PurchaseLine)
(Or replace the 0 with your favorite page.)
With kindly regards
s_keims_keim (Germany)
inhouse developer on NAV2016 (9.00.47838) NAVDE5 -
Thanks for your tips!
I coded it myself, using your guidance.
It now works like a charm.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions