| | What is the Equipment Cost Account Table account retrieval or hierarchy? |
| Cause | Go to the EQ settings/GL Entry Settings to determine the hierarchy for the Cost Debit accounts. You'll usually find a default acct setup,however if you are using account tables, you'll have additional flexibility for the cost acct retrieval. |
| Resolution | |
To set up the Equipment Cost Account Tables: - From the File menu, select Company Settings, EQ Settings, GL Entry Settings.
- Select the Use account table check box for the credit and/or debit accounts.
- From the Setup menu, select Account Tables and then the cost or debit account desired.
The Equipment Cost Account Tables account retrieval | Search Order | Available columns that can be setup in EQ Settings | Account # | Comments | | c | Equipment Type | Equipment | Code (Revenue or Cost) | You can enters the GL account number here to determine how it prefills. | | | 1 | See the note below | | | | If a cost account is retrieved in Job Cost (JC), then the account retrieval is finished before reaching this table. If the cost account is not found, then this table is accessed and starts at Search Order #2. | | 2 | X | X | X | | If the account table is set up with all 3 available columns, the system uses the Equipment Type, the Equipment and the Code to determine the account number. | | 3 | | X | X | | If the account table is set up with the Equipment and Code columns, the system uses these to determine the account number. | | 4 | X | | X | | If the account table is set up with the Equipment Type and Code columns, the system uses these to determine the account number. | | 5 | X | X | | | If the account table is set up with the Equipment Type and Equipment ID columns, the system uses these to determine the account number. | | 6 | | X | | | If the account table is set up with only the Equipment column, the system uses it to determine the account number. | | 7 | X | | | | If the account table is set up with only the Equipment Type column, the system uses it to determine the account number. | | 8 | | | X | | If the account table is setup with only the Code, the system uses it to determine the account number. | | 9 | | | | | If the account number is not found in the previous 8 steps, the Default Account set up in EQ Settings is used. | Note: If you are retrieving a revenue debit or cost debit account when the Job Cost information is entered and Use JC Cost account is selected in PR Settings, the JC cost account is retrieved first. The credit accounts are not affected by this step. | |
|