During Sales Ledger processing the system hides accounts flagged as prospects from selection.Similarly Sales and Purchase Order Processing allow the facility to ‘hide’ selected items on the stock file from selection during order entry, this can be used to prevent selection of items that are no longer sold or are no longer available from the supplier.
A new feature now adds a similar facility to the
Ledger Enquiry and is available for all of the enquiry applications. When selecting a record to enquire within the
Ledger Enquiry via F4-Select you now have the facility to hide, for example,
prospect accounts on the sales enquiry, deleted orders on the sales and
purchase order enquiry or ‘dead’ stock records on the stock enquiry.
On the above enquiry any account record flagged as a
prospect is excluded from the F4 search results within the sales enquiry.
Depending on configuration of the filter options by
selecting the OPTIONS button at the bottom right of the search screen, or by
pressing the <F7-Option> key, the facility is available to view all
records that match the search results.
Note that operators can manually enter a reference for a filtered record where this is known and the record will be displayed. Filtered records though will not be updated to the enquiry history panel.
This new feature is enabled via the Enquires
Configuration options within the Ledger Enquiry Manager. To set a ledger enquiry filter select Installation from the main menu
followed by Ledger Enquiry Manager and then Enquiries Configuration. Select the application required before
selecting the new option to Ignore
Records on F4 Lookup
Ignore Records on F4 Lookup – set to allow the option to filter records from the F4 search results for this application enquiry.
Item to Test – select the data item on the main application enquiry database to perform the filter check against.
Test Equal or Not Equal – set whether the filter test is to be applied on an equal (E) or not-equal (N) basis.
Value to Test against – enter the match value to test. Any enquiry record where the set condition is true will be hidden from the F4 search results.
Allow Option to View All– set to allow the use of the <F7-Option> key within the F4 search results to view the hidden records.
Article ID: 1924
Created On: Fri, Oct 26, 2012 at 11:53 AM
Last Updated On: Tue, Jun 20, 2023 at 6:00 PM
Online URL: https://kb.datafile.co.uk/article/filter-records-on-enquiry-search-1924.html