GL Interface Dictionaries
- 200 - Credit G/L Charge Account Number
- 201 - Debit G/L Charge Account Number
- 202 - Credit G/L Payment/Adjustment Account Number
- 203 - Debit G/L Payment/Adjustment Account Number
Note: You must set up a default account for each of the above.
These dictionaries can be populated using a tab delimited text file via Dictionary Import. The dictionary code is limited to 20 characters maximum.
Import File Format
The format for the dictionary import files are the following:
|
Column |
Description |
|
1 |
Is equal to “GL” without the quotes. This identifies which dictionary file the import should be associated with. |
|
TAB between each column |
|
|
2 |
Holds the Data Element of the dictionary i.e. “200”, “201”, “202”, or “203” 200 - Credit G/L Charge Account Number 202 - Credit G/L Payment/Adjustment Account Number 201 - Debit G/L Charge Account Number 203 - Debit G/L Payment/Adjustment Account Number |
|
3 |
Holds the Dictionary Code |
|
4 |
Holds the Dictionary Value |
|
Must have four TAB’s at the end followed by a Line Feed. |
|
Example of the text file for the "200 - Credit G/L Charge Account Number" import file
The non-printing characters were left in for clarity. The fourth column could hold the description of the account number, but for this client, they just used the account number for both. That same statement holds true for each of the four import files.
Example of the text file for the "201 - Debit G/L Charge Account Number" import file
Example of the text file for the "202 - Credit G/L Payment/Adjustment Account Number" import file
Example of the text file for the "203 - Debit G/L Payment/Adjustment Account Number" import file
Once you have all of the import files set up and ready to be imported, you will need to navigate to the Dictionary Import form: myAvatar PM\RADplus Utilities\Dictionary and Table Maintenance\Dictionary Import.
Each time you import a file, you will need to perform the following steps:
- Grab the Import File by clicking the Select File button and navigating to the dictionary file you are importing.
- Scan the Import File by selecting the Scan Import File button to find out any errors or warnings from the file.
- Review the Scan Results and then correct any errors listed in the report. Correct any errors in the file and reload the corrected file again.
- Once the scan is clean, begin the import by selecting the Begin Import button.
- You will receive a pop up box with “Dictionary Import Complete” once the file has finished loading.
You will need to do these steps for each of the four files listed above.
