Accountants Enterprise only

Validation Tables are pick-lists that can be defined by the user (or other MYOB applications) to limit the values attached to a sort view to items in the relevant validation table.

Tax, for example, uses a validation table for occupation codes - the table is maintained centrally by Central Database but used primarily from within a tax return. The benefit of the table being in Central Database is that the user can then use these values for sorting and filtering in reports and letters.

All system generated Validation tables show a system required icon in the Use column. No user defined Validation table shows the system required icon.

Buttons available on this window are:

Open: Opens the validation table. For example, if an ATO Occupation code is being processed, click Open to display the Occupation code table which is used in your Tax ledger. You may only edit the description of a System Required table, but you may edit both the Value and Description for there tables you define yourself.

Properties: Click Properties to open the Validation Table Properties window. You can edit the code and description of the table. Refer to Validation Table Properties.

New: Click New to open the Validation Table Properties window. You can create a new Validation table by providing a unique code and a description.

Delete: Click Delete to remove an entire Validation table.

Cancel: Exits the window.

List: Right-click to access the List option for the Validation Tables.

To create a validation table:

1. Click Maintenance > Validation Table.

2. Select New.

3. Complete the code and description fields.

4. Save the new Validation Table.

5. Attach values to the new table

Back to Table Maintenance

Validation Table Entries

Accountants Enterprise only

This window lists all the entries in the Validation Table.

Buttons on the window are:

Properties: Displays the details for the current line in the table so that you can edit the code and value. Refer to Validation Values.

New: Opens the Validation table for the <table> window, so that you can add a new code and value to the Validation table.

Delete: Deletes a line from the list of values in the Validation table.

Cancel: Exits the window.

Back to Table Maintenance

Validation Values

Accountants Enterprise only

This window allows you to add or edit an entry in the Validation table. These details are recorded for each entry:

Value: This is up to ten alphanumeric characters to uniquely identify the value you are adding to or editing in the validation table.

If you are editing a value that is used by Tax, you will only be able to edit the description. You will not be able to edit the Value field.

Description: This is up to 60 characters to describe the value you are adding to or editing in the validation table.

Back to Table Maintenance

Validation Table Properties

Accountants Enterprise only

This window allows you to add or edit a validation table in Central Database. If you are adding a new table, enter values for Table and Description as described below:

Table: Enter a unique ten character alphanumeric code for the table you wish to add to Central Database.

Description: Enter a relevant description (of up to sixty characters) for the table you wish to add to Central Database.

If you are editing a table, over type the existing value(s).

Back to Table Maintenance

Address Browser

Accountants Enterprise only

The browser lists information for all contacts in the data base. The details include:

• Contact code

• Table indicates the type of address (Type cannot be modified from this browser)

• Use - the two heads icon denotes that contacts share this address.

• Street

• Town/suburb

• State

• Postcode

• Country

To sort the list into descending or ascending order, click the column headings for Contacts, Tables, Town/suburb, State or Postcode.

Properties of an Address

To modify an address select the Properties button and the address details are displayed and may be edited, except for the Type. Refer to Addresses in the Address Book,