Banner JVUPLOAD

Table of Contents
Home

Banner JVUPLOAD - uploading journal vouchers

The following steps define the process of uploading JV entries:
 

Departments:

  1. Copy the JVUPLOAD_TEMPLATE.xls spreadsheet to your local C drive or a shared network drive.
  2. If you are running OFFICE 2007 you must enable the macros to complete the upload process.
  3. Enter your monthly journal voucher details.
  4. DO NOT used the CREATE FILE button - this is reserved for the Budget Analyst to finalize the JV upload process.
  5. Save it to a location on your local hard drive as a regular EXCEL spreadsheet until you are ready to sent it to Financial Services.
  6. When you have completed your entries for the month, email the spreadsheet to the appropriate Budget Analyst in Financial Service.

Financial Services:

  1. When you receive a JVUPLOAD spreadsheet from the departments, save it to a shared network drive.
  2. Edit the data in the spreadsheet as you normally would
  3. If you are running OFFICE 2007 you must enable the macros to complete the upload process.
  4. When completed use the SEND button on the spreadsheet to create the upload file.
  5. Run JVUPLOADCPY to combine all of the JVUPLOAD files into one file for posting to Banner.
  6. Request the AppWorx Chain - FNS_JVUPLOAD.
  7. Check for e-mail, in ACCOUNTSPAYABLE@MISSOURISTATE.EDU, for output error reports.
  8. Go to FGAJVCM to correct any errors.
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.