Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 302 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Modify Request Page
Normajm
Member Posts: 82
Good morning,
I would like to create a custom report from #297 (batch post sales orders) that has the request fields autopopulated except for posting date. When I look at the request page, it has only the "Options" section. I need to autopopulate the Sales Invoice section with two specific fields - Order Category and Package Exists. No. and Status are not needed. The goal is to eventually set this up as a job to run automatically and have the posting date set. But, for now, one step at a time.
Where does the Sales Invoice section come from? Is it common to other reports? If so, would it be necessary to set up a custom sales invoice filter, how is that done and how should it be linked to the custom report request page?
Thank you!
I would like to create a custom report from #297 (batch post sales orders) that has the request fields autopopulated except for posting date. When I look at the request page, it has only the "Options" section. I need to autopopulate the Sales Invoice section with two specific fields - Order Category and Package Exists. No. and Status are not needed. The goal is to eventually set this up as a job to run automatically and have the posting date set. But, for now, one step at a time.
Where does the Sales Invoice section come from? Is it common to other reports? If so, would it be necessary to set up a custom sales invoice filter, how is that done and how should it be linked to the custom report request page?
Thank you!
0
Answers
The Sales Invoice fast tab comes from the Sales Invoice DataItem of your report.
If you go ahead to that DataItem and go to properties, you'll find the ReqFilterFields property with "No.,Status" filled in.
If you'll want to set the two new fields to be filled in manually, just add them to that same property above.
If you'll want to set it with values, you'll have to call the report via code and send a sales invoice record filtering the two new fields with the values you want.
Here is the documentation of the REPORT.RUN function https://docs.microsoft.com/en-us/dynamics-nav/report-run-function