...
- Source Code: this should always be JE
- GL Account Number: the full account number is needed for processing transactions
- Charge/Credit: either a charge or credit must be entered per line
- Description: description of the transaction; must not be over 80 characters in length
- Reference No: This can be anything. The only caveat is that each line must contain the same value.
- Date: date of the transaction
If you have a report that contains all of this data in an excel format, we’ll happily accept it. We can also work with delimited files, csv files or other types of files that can be easily imported into Excel.
...
- Import or open (depending on how the data is received) the data into Excel and verify the data is setup like below. Add/Remove columns as necessary, format the Debit and Credit fields to be two decimal places, make sure the Reference No and Date columns are the same.
- Once the data has been verified, it needs to be saved as a .csv file.
- The next step is to upload the file you just saved into Colleague. This can be accomplished using the FLUL screen. The Target Directory will be GL.INTERFACES. The Target File Name can be anything, however, to keep a clean environment, using the same file name over and over again is recommended. MJE is a simple name that is currently being used. When the screen asks if you would like to replace this file, click on Yes. You'll then be prompted to Select File. Browse to the file you saved and click on Open. You should receive a message stating "File upload complete". If it says "Upload cancelled", check to make sure you don't have the file open within Excel. If so, close the Excel window and try again.
- The data has one more step before importing using GLIM. XGLI needs to be run to format the data and copy it to the GENERAL_IMPORT file. The XGLI requires a Transaction Date (depending on requirements, it would typically be the last day of the month the transaction occurred in) and to choose a file name. To choose the file name, click on the drop down error and choose the file, which in the case of this documentation, would be MJE. Click on Save All twice to process the file.
- Open GLIM and "GENERAL.IMPORT" when it asks for the GL Interface Def Lookup. Choose "Report Only" for the Import Mode and enter "Y" for the OK to proceed box. Set the Output Device to Hold (H) on the following two screens. You first want to run GLIM in Report Only mode to verify the file your processing is correct. Once the process runs error free, then choose "Update from Report" to import the data. Inversely, you can choose "Immediate Update Mode" which will run the report process and if there are no errors, will immediately run the update process.
A successful report will look similar to the following:
An error report will be similar to below:
- At this point, the data has been imported into Colleague and will post over night.
...