Substitution Lists

Form ID: (SM206026)

You use this form to view, add, remove, and edit substitution lists. A substitution list consists of pairs of source values (which may be found in the data prepared for import or export) and the corresponding substitution values (which serve as replacements for the source values during data import to MYOB Advanced or data export from MYOB Advanced, respectively). For example, suppose that the data for import contains country codes that are different from the country codes registered in MYOB Advanced. You can define a substitution list that defines the correspondence between the country codes in the data and the country codes registered in MYOB Advanced.

You can use the substitution lists in the SubstituteListed (sourceField, substitutionList) and SubstituteAll (sourceField, substitutionList) functions in formulas in mappings of import and export scenarios. For details about the functions, see Functions.

Form Toolbar

The form toolbar includes only standard buttons. For the list of standard buttons, see Form Toolbar and More Menu.

Summary Area

In this area, you can enter the name of a new substitution list or select the name of an existing one to edit the list.


Element	Description
Substitution List	Required. The name of the substitution list.
Table Name	The name of the table where a field for the substitution value is located.
Field Name	The name of the field which values should be used as substitution values.

Table Toolbar

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Table Columns

This table contains pairs of values, with each row containing the original value that is being replaced and the substitute value that will be used instead of the original value.
Column	Description
Original Value	The value that you want to replace in the data prepared for import or export.
Substitution Value	The value that replaces the value specified in the Original Value box.