Skip to Main Content
Sage 200 UKI Ideas Portal
Status Further Information Required
Categories Features
Created by Su Larcombe
Created on Oct 23, 2024

Use wildcards at time of running a query

It would be useful to be able to use a wildcard in a filter which prompts for data at time of running the filter.

An example might be perhaps using and & (or another wildcard) to trigger a pop-up window where a customer/supplier code is entered dynamically at the time the filter is run. Example might be for a customer account and the example might be "&Enter Customer Code" which triggers the pop-up box requesting that is entered. This would be more flexible than having to set up separate filters for customers and could be used for suppliers, nominals or anywhere in the system. Hope the explains it a bit more.

Idea Benefit Gives flexibility to set up a generic filter which prompts for user data at time of running, rather than having to set up a specific filter for a particular, customer, supplier etc.
Product Variant Sage 200 Standard
  • Su Larcombe
    Reply
    |
    Oct 29, 2024

    An example might be perhaps using and & (or another wildcard) to trigger a pop-up window where a customer/supplier code is entered dynamically at the time the filter is run. Example might be for a customer account and the example might be "&Enter Customer Code" which triggers the pop-up box requesting that is entered. This would be more flexible than having to set up separate filters for customers and could be used for suppliers, nominals or anywhere in the system. Hope the explains it a bit more.

  • Admin
    Jo Kirkup
    Reply
    |
    Oct 28, 2024

    Thanks for the idea, could you give us an example of what you're looking for?