Previous  Next          Contents  Index  Navigation  Glossary  Library

Defining a Lookup Set

To define a lookup set, you specify pairs of values. For each intermediate value, you specify a corresponding account segment value. One or more related pairs of intermediate values and segment values form a lookup set.

For example, if the phrase "World Headquarters" corresponds to a Company segment value of 01, use World Headquarters as the intermediate value and 01 as the segment value.

Or, suppose your business has five major regions (Northeast, South, Middle States, Southwest, and West), and you have a Region segment in your Accounting Flexfield. You probably need to create a lookup set that maps region names to the corresponding region code:

Name Region Code
Description Map region names to the corresponding Accounting Flexfield region segment code
Segment Value Lookups
Intermediate Value Segment Value
Northeast 01
South 02
Middle States 03
Southwest 04
West 05

You may need several lookup sets to map organizations to cost centers, expenditure types to account codes, event types to account codes, or for other situations where the segment value depends upon a particular predefined parameter.

You can use a lookup set more than once; several AutoAccounting rules can use the same lookup set.

You define and modify lookup sets using the AutoAccounting Lookup Sets window.

See Also

AutoAccounting Lookup Sets Window Reference


         Previous  Next          Contents  Index  Navigation  Glossary  Library