Finance
Accounts Receivable Reconciliation
Procedures
Run TGRAPPL. Leave parameters as defaulted.
Check the log file for TGRAPPL process to make sure there are no error messages.
Finance
Accounts Receivable Reconciliation
Run TGRFEED with the following parameters: NOTE: Update date as necessary. o Click the SAVE Icon when in the Job Submission block. o Select Options, Review Output. o Double click on File Name to review file/feed. o Double click on the “.lis” file. o Select Options, Show Document. (May need to select Run to continue.) NOTE: You may also just click the Save icon to cut out a step.Finance
Accounts Receivable Reconciliation
o Select Save File when window pops up. o The file will be saved to a temp folder on your C drive. o Open with notepad and save to the N drive for future reference (Banner TGRFEED folder created for this purpose under “Shared”). o Exit from TGRFEED. Run TGRCSHR process to change finalized to reported using the following parameters:Finance
Accounts Receivable Reconciliation
Run FURFEED process in audit mode to obtain document number(s) for GURDETL information. NOTE: If you wish to only feed accounts receivable, use ACTRECV in place of ALL in the parameters. o Click the SAVE Icon when in the Job Submission block. o Select Options, Review Output. o Note document numbers for use in running GURDETL. o Exit FURFEED.Finance
Accounts Receivable Reconciliation
Run
GURDETL
for each document number. NOTE: Data in GURDETL table will be lost if not obtained at this point. o Click the SAVE Icon when in the Job Submission block. o Select Options, Review Output. o Double click on File Name to review file/feed. o Double click on the “.lis” file. o Select Options, Show Document. (May need to select Run to continue.) o Select Save File when window pops up. o The file will be saved to a temp folder on your C drive. o Open with notepad and save to the N drive for future reference (Banner GURDETL folder created for this purpose under “Shared”). o Exit from GURDETL after all document information has been saved. Run FURFEED process in update mode. NOTE: : If you wish to only feed accounts receivable, use ACTRECV in place of ALL in the parameters.Finance
Accounts Receivable Reconciliation
o Select Options, Review Output. o Double click on File Name to review file/feed. o Double click on the “.lis” file. o Select Options, Show Document. (May need to select Run to continue.) o Select Save File when window pops up. o The file will be saved to a temp folder on your C drive. o Open with notepad and save to the N drive for future reference (Banner FURFEED folder created for this purpose under “Shared”). o Exit from FURFEED. Run FGRTRNI. o No parameters are necessary. o Click the SAVE Icon when in the Job Submission block. o Select Options, Review Output. o Double click on File Name to review file. o Double click on the “.log” file. o Verify that the process ran successfully. o Exit from FGRTRNI. Run FGRTRNR. o No parameters are necessary. o Click the SAVE Icon when in the Job Submission block. o Select Options, Review Output. o Double click on File Name to review file. o Double click on the “.lis” file. o Verify that there are no errors. If there are errors, those feeds must be corrected to have the data process correctly. The following report example has no errors. No record count noted indicates there are no errors.Finance
Accounts Receivable Reconciliation
o Exit from FGRTRNR. Run FGRACTG. o No parameters are necessary. o Click the SAVE Icon when in the Job Submission block. o Select Options, Review Output. o Double click on File Name to review file. o Double click on the “.lis” file. Run TGRRCON with the following parameters:Finance
Accounts Receivable Reconciliation
o Click the SAVE Icon when in the Job Submission block. o Select Options, Review Output. o Double click on File Name to review file/feed. o Double click on the “.lis” file. o Select Options, Show Document. (May need to select Run to continue.) o Select Save File when window pops up. o The file will be saved to a temp folder on your C drive. o Open with notepad and save to the N drive for future reference (Banner TGRRCON folder created for this purpose under “Shared”). o Exit from TGRRCON.NOTE: Difference column should typically show zero across the board; however, due to manual postings that have not been corrected as of this document creation date, differences are noted. Correcting entries will be made to rectify the out of balance condition. If the difference is anything other than zero, variance must be located and corrected immediately.