Banner JVUPLOAD - uploading journal vouchers
The following steps define the process of uploading JV entries:
Departments:
- Copy the JVUPLOAD_TEMPLATE.xls spreadsheet to your local C drive or a shared network drive.
- If you are running OFFICE 2007 you must enable the macros to complete the upload process.
- Enter your monthly journal voucher details.
- DO NOT used the CREATE FILE button - this is reserved for the Budget Analyst to finalize the JV upload process.
- 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.
- When you have completed your entries for the month, email the spreadsheet to the appropriate Budget Analyst in Financial Service.
Financial Services:
- When you receive a JVUPLOAD spreadsheet from the departments, save it to a shared network drive.
- Edit the data in the spreadsheet as you normally would
- If you are running OFFICE 2007 you must enable the macros to complete the upload process.
- When completed use the SEND button on the spreadsheet to create the upload file.
- Run JVUPLOADCPY to combine all of the JVUPLOAD files into one file for posting to Banner.
- Request the AppWorx Chain - FNS_JVUPLOAD.
- Check for e-mail, in ACCOUNTSPAYABLE@MISSOURISTATE.EDU, for output error reports.
- Go to FGAJVCM to correct any errors.