Using Queries
The Query field in the toolbar lists all of these possible queries:
| Query Command | Description |
|---|---|
| GET ALL CODES | Returns all codes from the COA |
| GET ASSET CODES | Returns all codes with type Asset |
| GET LIABILITY CODES | Returns all codes with type Liability |
| GET REVENUE CODES | Returns all codes with type Revenue |
| GET EXPENSE CODES | Returns all codes with type Expense |
| GET EQUITY CODES | Returns all codes with type Owner's Equity |
| GET CODES STARTING WITH | Returns all codes staring with a given pattern Example: GET CODES STARTING WITH 1005* |
| GET CODES ENDING WITH | Returns all codes ending with a given pattern Example: GET CODES ENDING WITH *100 |
| GET DESCRIPTION STARTING WITH | Returns all codes whose associated description start with the given pattern Example: GET DESCRIPTION STARTING WITH Cash |
| GET DESCRIPTION ENDING WITH | Returns all codes whose associated description end with the given pattern Example: GET DESCRIPTION ENDING WITH "Discount" |
| GET DESCRIPTION CONTAINS | Returns all codes whose associated description contains a given pattern Example: GET DESCRIPTION CONTAINS Inventory |
| GET UNITCODE {1..4} FOR |
GET UNITCODE {1..4} FOR Returns unit codes for the given account. Example: GETUNIT CODE 1 FOR 102000 (Returns all the unit codes 1 for account code 102000) GET UNIT CODE 4 FOR 504000 (Returns all the unit codes 4 for account code 504000). |
| GET CURRENT ASSESTS | Returns all codes with Account Class 'Current Assets' |
| GET NONCURRENT ASSETS | Returns all codes with Account Class 'Noncurrent Assets' |
| GET CURRENT LIABILITIES | Returns all codes with Account Class 'Current Liabilities' |
| GET NONCURRENTLIABILITIES | Returns all codes with Account Class 'Noncurrent Liabilities' |
| GET EQUITY(AC) | Returns all codes with Account Class 'Equity' |
| GET REVENUE | Returns all codes with Account Class 'Revenue' |
| GET COST OF SALES | Returns all codes with Account Class 'Cost of Sales' |
| GET OPERATING EXPENSE | Returns all codes with Account Class 'Operating Expense' |
| GET DEPRECIATION ANDAMORTIZATION EXPENSE | Returns all codes with Account Class 'Depreciation and Amortization Expense' |
| GET INTEREST INCOME EX-PENSE | Returns all codes with Account Class 'Interest Income Expense' |
| GET NON-OPERATING INCOMEEXPENSE | Returns all codes with Account Class 'Non Operating IncomeExpense' |
| GET TAX EXPENSE | Returns all codes with Account Class 'Tax Expense' |
Click the ! Go button to execute your chosen query.