Expense Dictionary Designer
The Expense Dictionary Designer is used to design expense dictionaries that may be used by accounting professionals and accounting systems end users to quickly construct journal transaction entries that contain valid transactional analysis.
•Accounts: Design the chart of accounts. This should contain all of your revenue and expense accounts that you will be loading terms and keywords against.
•Categories: Design custom analysis fields that pertain to your particular accounting product and would be necessary for journal line construction or filtering. Common examples would be business units, departments, or even market segments.
•Terms: Design search keywords and phrases for search on the Expense Dictionary Module. This should contain a complete list of the expenses your business deals with and the associated account, category, and notes to users who will reference it when creating journal transactions.
Navigating The Editor: Once you have clicked the editor and begun editing cells, you can navigate the editor with Excel-like functionality. The Tab button navigates to the right cell. If no cell is to the right, it proceeds to the first cell of the next row. Shift-Tab navigates to the left cell. If no cell exists, it navigates to the last cell of the previous row. The Up Arrow navigates to the cell directly above in the previous row, and the Down Arrow navigates to the cell directly below in the next row.
Changing Pages: Rending large amounts of data in HTML requires vast amounts of computer memory. To make the workload easier on your browser, we have introduced paging. 100 rows of data will be displayed per page. The page controls appear at the bottom of the editor. Changing the sort order of a column will return you back to page 1.
Sort and Filter: Columns can be sorted by clicking on the sort arrow next to the column name. Below the column name, text can be entered to filter the results that are displayed. Filtering occurs as you type, so it is not required to press enter to perform a filter. Emptying the text in the filter will stop that column from being filtered.
Add Row: A Blue + appears in the top left column of each table that supports adding new rows. Clicking the button will add a new row to the top row of the editor. Additionally, each designer supports adding new rows by navigating to the last row on a page and pressing the Down Arrow. This will create a new row at the bottom of the page. Once an empty row is created, you must specify a unique required name. Upon providing a valid name, the new item will be created in the database. Pressing Escape will cancel adding the new row.
Delete Row: A Red X appears next to every single row in the editor. Clicking the X will prompt you to confirm removing the row from the editor. Upon confirmation the respective item will be removed from the database.
Edit Row: Click on the cell you want to edit and the appropriate cell editor will appear. After a cell has been edited, validation is performed. If the cell contains any errors, an error message will be rendered in the toolbar and you must provide a valid value or cancel before proceeding. If validation succeeds and the value has changed, the respective item will be updated in the database.
•Account Name: a name that describes the account (must be unique within the dictionary).
•Account Code: the actual account code (also called charge code or account number) used in your accounting system. This is an optional value but is essential to optimal usage of the product.
•Description: a description of the account for reference purposes only.
•Category Name: a unique name for the category.
•<Custom Category> Name: a unique name (within the category) that describes the custom item.
•<Custom Category> Code: a code used in your accounting system. Optional, but essential for optimum usage of the application.
•Term Name: a keyword, name, or phrase for an expense item.
•Expense Account: choose from the drop down list of account codes/names to provide the account the expense item is be charged against.
•Notes: any notes to the user of the system as to how to create transactions
•Search Field: The field that will be searched in a category item to determine if it is a candidate for the mass operation. You may search on the category item Name or Code.
•Search Value: The value to search for. SQL wildcards may be used for finding a match.
•Assigned: A checkbox indicating whether the search term will be added or removed from a custom category element.
•Go: Process the mass operation.
Copyright © 2023 pasUNITY, Inc.
Send comments on this topic.