How to filter on default customer entered order values

How to filter on default customer entered order values

You can display custom entered values on the screen.  However, you can only filter on them if values have been entered. This is because the default value is not actually stored in the database, but is displayed on the screen.

If you want to filter on the custom entered values, including the default value you can use the following approach to achieve this.

1 Install the Standard Plus, or higher version of the software.
2 Run the Advanced Order Processor for One Stop Order Processing.
3 Add a new Rule that has a type of Use custom SQL:
4 Enter the following SQL into the box below the selection

INSERT INTO TCustomValues (nOrderSeq,C8) SELECT nOrderSeq,'DEFAULT' from TOrder

5 Under if an order has been found set this to Do nothing.
6 In Automation for One Stop Order Processing click on Options and add a new Task.
7 Give the task a name and tick Advanced Order Processor.
8 Tick Other Rules.
9 Set the task to run this as orders are downloaded or at a specific time or at regular intervals, e.g. every hour.

Whenever this task is automatically run it will add the default value in for all newly created created or added orders.