Validation List

Software: MoneyWorks accounting software

In our earlier post we discussed about using a Transaction User field as a “Ship Via” field to record the goods transported via a Sea Freight, Air Freight, Courier, or Self-collection. To ease in data entry, a Custom Validation list can be added to the transaction field to serve as a “dropdown” list and to keep a consistency in data entry.

Right-click the transaction field, field that you wanted to set with a validation list, and select the Custom Validation function from the sub-menu. From the Field Validation window, click the “Make a New List” button to create a Custom Validation list (Refer to MoneyWorks v7 User Guide, page 49 — “Custom Validation Lists” for more information).

Custom Validation

Besides using in transaction user field, a Custom Validation list can be used in a Category, Custom or even in the Country field of a name profile. For example, you can create a Custom Validation list for the Country field, a list of countries which you often used, to prevent misspell or being omitted during data entry.