Using FWPJVLD
1. Prepare your data file.
a. The file must be saved as a CSV File - NOT an Excel Workbook (.xlsx or .xls)
* TIP: To turn an Excel workbook (.xlsx) into a CSV file, go to "File", Select "Save As" then click "Browse". When you choose the location and enter a file name, use the drop-down laveled "Save as type:" to select "CSV (Comma delimited)(*.csv)"
b.The file must contain the following columns:
| Column Name |
Required? |
Description |
| DOC CODE |
Yes |
Banner document number that has not been used by a previous document. |
| REC TYPE |
Yes |
1 for Banner document Header record, 2 for detail record |
| SEQ NUM |
Yes |
Detail record sequence |
| RULE CODE |
Yes |
Banner document Rule Code (FTVRUCL) - user running FWPJVLD must have Banner Finance access needed to create documents with this Rule Code |
| TRANS DATE |
Yes |
Transaction date to be entered in Banner for this document. FOAPAL information checked using this for "as-of" date |
| CHART |
Yes |
Banner Chart of Accounts Code (FTVCOAS) |
| INDEX |
No* |
Banner Index (FTVACCI) - Either Index or Fund, Orgn, Acct, Prog required |
| FUND |
No* |
Banner Fund (FTVFUND) - Either Index or Fund, Orgn, Acct, Prog required |
| ORGN |
No* |
Banner Orgn (FTVORGN) - Either Index or Fund, Orgn, Acct, Prog required |
| ACCT |
No* |
Banner Acct (FTVACCT) - Either Index or Fund, Orgn, Acct, Prog required |
| PROG |
No* |
Banner Prog (FTVPROG) - Either Index or Fund, Orgn, Acct, Prog required |
| ACTV |
No |
Banner Actv (FTVACTV) |
| LOCN |
No |
Banner Locn (FTVLOCN) |
| DR/CR |
Yes |
Debit/Credit indicator. Valid values are D C + - |
| AMOUNT |
Yes |
Dollar amount |
| TRANSACTION DESCRIPTION |
Yes |
Description posted to the Banner document for this line |
| DOC REF |
No |
Banner Document Reference number |
| BANK |
No |
Banner Bank code (GXVBANK) |
c. The file must have ALL of these rows:
* The first row in the file must be column headers, as shown in the table above. FWPJVLD will not be able to read your file without the column headers.
* Exactly one (1) record with a REC TYPE of 1 (This creates the journal header in Banner). FWPJVLD can only load one journal document per file.
* One or more records with REC TYPE 2 (These are the journal detail entries). You can have as many detail entries as you need. Banner will reject a journal without detail entries.
2. Upload the CSV file.
a. Log into Vandalweb and navigate to "Employees" -> "UI Administrative Tasks" -> "Upload File (GWAUPLD)"
b. If you have uploaded a previous file, it will prompt you with "Old file exists - Delete old file?" Click "Delete File"
c. Click "Choose File" and select the file that meets the requirements above
d. Click "Submit File"
3. Run FWPJVLD.
a. Log into Banner and go to FWPJVLD
b. Parameters:
| Parameter Number |
Parameter Name |
Description |
| 01 |
Input Filename |
Name of the file - this will be your username in all capital letters with _BannerFile - example: the file name for Joe Vandal (username JOEVANDAL) would be JOEVANDAL_BannerFile |
| 02 |
Test or Update |
T to run a test, U to load the file to Banner |
| 03 |
Date Format |
Format of the date in the TRANS DATE column. Examples: DD-MON-RRRR for 12-APR-2021, MM/DD/RR for 04/12/21 |
Frequently Asked Questions
I have an Excel file - how do I turn this into a CSV file?
- Go to "File", Select "Save As" then click "Browse". When you choose the location and enter a file name, use the drop-down laveled "Save as type:" to select "CSV (Comma delimited)(*.csv)"
The program gives me an error saying there is no document header, but my CSV file has a header!
- The file must have both a CSV header (column names) and a Banner Document Header (REC TYPE = 1). Please be sure it has both of these.