Ctrl F1
Flaffer
Member Posts: 11
Hi Guys and Girls
I have experience with C5,XAL, AXAPTA and as XAL is doing the last dance, I’m looking at Navision, and have lately used a loot of my spare time to bring me up to date.
But I have a question, when I use a report, example calling report Debtor – Balance you can select with Ctrl F1 from the account numbers, but it seems to me that it have no effect, I want to get the ones I have selected.
Please help.
I have experience with C5,XAL, AXAPTA and as XAL is doing the last dance, I’m looking at Navision, and have lately used a loot of my spare time to bring me up to date.
But I have a question, when I use a report, example calling report Debtor – Balance you can select with Ctrl F1 from the account numbers, but it seems to me that it have no effect, I want to get the ones I have selected.
Please help.
0
Comments
-
Flaffer, when you open a Lookup window (through clicking the upside arrow on the right side of the field), all you have is a list of valid data that you can input on your filters.
CTLR+F1 actually doesn't make any difference in this case.
If you want to select only some records, you should make a correct filter on the field you want.
Marcelo Borges
D365 Business Central Solutions Architect
BC AL/NAV C/AL Developer
BC Repositories.com0 -
Hi markborges
So there is no chance to select 2 specific accounts, unless they can be filtered through a unique field value?
Where do u use Ctrl-F1 and why.0 -
Hi there,
Yes there is. Let's suppose the 2 specific accounts you want are "10005" and "88694". Then, in "No." field of the record, you should input the following criteria:Flaffer wrote:So there is no chance to select 2 specific accounts, unless they can be filtered through a unique field value?
10005|88694
Where the pipe sign '|' means an OR sentence (select accounts where number is equal to 10005 or is equal to 88694).
You may use Ctrl+F1 when you have a bunch of records in a list form, and you want to select a lot of records apart away from each other. Then, you mark every record you want with Ctrl+F1 and then go to "View" Menu and then "Marked Only". This will make only the marked ones visible. And then you may, for example, post this set of records.Flaffer wrote:Where do u use Ctrl-F1 and why.
It's one application I know, but there must be some so much others.
Marcelo Borges
D365 Business Central Solutions Architect
BC AL/NAV C/AL Developer
BC Repositories.com0 -
Hi again markborges
I don’t hope I’m annoying.
If I want a report for example a sales letter and the user want to point out X numbers of accounts to be printed, and the filter is of no use because the selection is specific accounts, I have done the programming of the sales letter, it is only the selection I’m interested in as it seemed it was more advanced than damgaards, what can i do?
:shock:0 -
another way is to add a boolean field to the customer card that can be checked off for customers that you want to print something out for. It's easier than typing in every customer number - plus you can create somekind of update report to clear and/or populate this field depending on a criteria.
for example you can pick a specific salesperson with a balance greater than 1000 and the report will fill in this boolean with a check mark.
then you can filter on nthe check mark to print your choices.
this is very flexible.
yu can also create a optins tab on the same report to either clear the field or fill the field so it can be used over and over again.0 -
I'd have to check for syntax, but I think you're looking for SETSELECTIONFILTER. Check F1 help for that keyword, and if you don't find anything let us know and I'll see if I can find an example.0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions

