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. 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. UI Expand |
---|
title | To create a validation table |
---|
| : | Click Maintenance > Validation Table. Select New. Complete the code and description fields. Save the new Validation Table. Attach values to the new table
|
Back to Table Maintenance Validation Table EntriesAccountants 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 ValuesAccountants 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 PropertiesAccountants 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 BrowserAccountants Enterprise only The browser lists information for all contacts in the data base. The details include: To sort the list into descending or ascending order, click the column headings for Contacts, Tables, Town/suburb, State or Postcode. Properties of an AddressTo 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, |