Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5

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.

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
expandedtrue
titleTo 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

HTML
</span>
HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks
Table Maintenance