Rev 14 Documentation
INITIAL SETUP
Wells Fargo contracts should be set up in the Contracts module. Note: Billing method 4 contracts are not useable. They should not contain any accessories. The contracts are billed through the Contract Billing program like any normal contract. These invoices are sent to Wells Fargo via the Wells Fargo Download program.
Every Wells Fargo contract will need to have the Wells Fargo Account Number stored in the PO Reference field in the Contract Header or every machine that is on a Wells Fargo contract will need to have the Wells Fargo Account Number stored in the User Defined-20 field in the Serial File. If there are more than one machine on a contract or a group of contracts with the same Group Bill Number that have more than one Wells Fargo Account Number, you will need to use the User Defined-20 field in the Serial File for each machine. If there are no more than one machine per contract or group of contracts with the same Group Bill Number that have more than one Wells Fargo Account Number, you can use the PO Reference field in the Contract Header. The PO Reference field in the Contract Header can be modified in Contract Changes (CN.1.6). The PO Reference is field number 23. The User Defined-20 field in the Serial File can be found in Machine Placement on the Leasing Information screen. The User Defined-20 field that is used is field number 76. The Wells Fargo Account Number is set up in the following format: ###-#######-###. This number should be entered completely, including the dashes (-).
RUNNING THE WF PROGRAM
When they are ready to send this information to Wells Fargo, they will need to run the WF program that was set up on the Billing custom menu. No one should be billing contracts for Wells Fargo during this time. They will log into the LMS main menu, choose #3 for Billing, #5 for Custom, #? for Wells Fargo Download and it will display the following:
7/18/01 Wells Fargo Download 8:40
Beginning Transaction Date Or A'll:
Ending Transaction Date:
M'eter Format Or B'ase Format:
Use C'ontract Header Or S'erial File For Wells Fargo Account No.:
Notes: ^ = Go Back 1 Space / = Cancel
Enter the date range to be downloaded at the Beginning and Ending Date range prompts. The program uses the transaction date on the invoices to determine if contract invoice was within range of dates entered. The files that are created are in two formats. The question “M’eter Format Or B’ase Format” determines which file is created. The download needs to be ran twice, once for Meter Format and once for Base Format. For the base information the file created is NWF.BSE. For the meter information the file created is NWF.MTR. These files are the ones that will need to be transferred to Wells Fargo. These files will be overwritten with new information every time you run the Wells Fargo Download program. At the “Use C'ontract Header Or S'erial File For Wells Fargo Account No.” prompt, enter C to have the Wells Fargo Account Number to be used from the Contract Header PO Reference Field. Enter S to have the Wells Fargo Account Number to be used from the User Defined-20 in the Serial File (field number 76 in Machine Placement).
DATA FILE LAYOUTS
NWF.BSE will have the following information. Each individual invoice will show on one line with a full length of 109.
PO Reference Field 1 – 20 Alphanumeric
This is Wells Fargo’s contract number.
It is taken from the PO Reference field
in the Contract Header File.
Invoice Number 21 – 28 Numeric
Dealer’s invoice number
Contract Number 29-- 36 Numeric
Contract Number from CNHDR
Group Bill Number 37-- 44 Numeric
Group Bill Number from CNHDR
Batch Bill Y/N 45-- 45 Alphanumeric
If Contract is Batch Billed then Y for yes
Amount 46 – 56 Numeric
Contract Base Billing amount – two decimal positions, but no decimal point. Ex.10040 is $100.40
Item Number 57-- 74 Alphanumeric
This is the item number of the machine on the contract.
Serial Number 75 – 92 Alphanumeric
This is the serial number of the machine on the contract.
Bill In Arrears Y/N 93-- 93 Alphanumeric
If Contract is Billed In Arrears then Y for
yes
Beg. Coverage Date 94 – 101 Date Format
This is the beginning Billing Period Date
on the invoice. It needs to be set up
on the contract as the first day of the
month. The format is with slashes – ex.
6/5/01
Ending Coverage Date 102 – 109 Date Format
This is the ending Billing Period Date on
the invoice plus one day. The format is
with slashes – ex. 6/5/01
NWF.MTR will have the following information. Each individual machine will show on one line with a full length of 224.
PO Reference Field 1 - 20 Alphanumeric
This is Wells Fargo’s contract number.
It is taken from the PO Reference field
in the Contract Header File.
Invoice Number 21 – 28 Numeric Dealer’s invoice number
Contract Number 29 - 36 Numeric
Contract Number from CNHDR
Group Bill Number 37 - 44 Numeric
Group Bill Number from CNHDR
Batch Bill Y/N 45 – 45 Alphanumeric
If Contract is Batch Billed then Y for yes
Total Dollars Due 46 – 56 Numeric
This is the Total Meter Dollars Due – two decimal positions, but no decimal point. Ex. 10040 is $100.40
Model Number 57 – 74 Alphanumeric
This is the Item Number of the machine
on the contract.
Serial Number 75 - 92 Alphanumeric
This is the Serial Number of the machine
on the contract.
Customer Number 93 –100 Numeric
Sold-to customer no. on the invoice
Customer Name 101 –125 Alphanumeric
This is the is the ship-to customers name
from the invoice
DATA FILE LAYOUTS (CONT’D)
Machine Description 126 - 157 Alphanumeric
Description from Item File
Ending Meter Rdg Date 158 - 165 Date Format
Date of ending meter reading. The
format is with slashes. (6/5/01)
Ending Meter Reading 166 – 173 Numeric Ending Meter Reading
Beg. Meter Rdg Date 174 – 181 Date Format
Date of beginning meter reading. The
format is with slashes. (6/5/01)
Beg. Meter Reading 182 – 189 Numeric Beginning Meter Reading
Total # Clicks 190 – 197 Numeric
Total no. of copies being billed.
Allowance 198 – 205 Numeric
Total number of copies included.
# Billable Copies 206 – 213 Numeric
Net Billable Copies on the invoice
Overage Rate 214 – 224 Numeric
This is the overage rate – has 6 Decimal
positions and prints with decimal point.
Ex. 0000.000120
FILE LOCATION OF NWF.BSE/NWF.MTR
For SuperDOS, the NWF.BSE and NWF.MTR files will be created/written to the first drive and user group of the search list and will most likely be 5:15 or 6:15. To verify this, log into Billing and enter in two colons (:: ) to be at the > prompt. Enter in MMI SE and return to show the search. To verify there is information in these files, enter in at the > prompt, TYPE/M NWF.BSE or TYPE/M NWF.MTR.
On Unix and NT, the NWF.BSE and NWF.MTR files will be created/written to the first directory of their environment. This will usually be the \lms\data\amsrc directory on Unix or \lms\data\amsrc on NT. To verify this, log into Billing and enter in two colons (:: ) to be at the * prompt. Enter in RUN”PATH and return, at filename enter in ? and return to display the first directory. Or at filename, enter in NWF.BSE or NWF.MTR to display the directory the programs will be located on. Return at the filename prompt to return to the * prompt. To verify there is information in these files, enter at the * prompt, !TYPE NWF.BSE or !TYPE NWF.MTR. To log off at the * prompt, enter: BYE and return.
The files will need to be on the C drive of a PC that has email capabilities. They will need to be emailed to Wells Fargo. The following instructions are to transfer the files to a PC for each LMS Operation System.
There are a couple of different processes the customer can use, depending on what they have and what they are comfortable with. If they have questions on using PC Connect or FTP/Tiny Term to transfer the programs, they will need instructions from hardware support. If PC Connect, FTP or Tiny Term are not an option the files will need to be
transferred to a diskette from SuperDOS and then taken to a PC with email capabilities. Insert a diskette into the diskette drive on the main SuperDOS server. At the main server, on the main task 1, log into your BEGIN password. At the > prompt, enter in PCXFER/S 5:15:NWF.* A:\. This will copy all NWF files from SuperDOS drive 5, user group 15 to a DOS floppy diskette in drive A. They are then able to take this
diskette to the PC with email capabilities and copy it on with Windows Explorer or through MSDOS.
The only way to transfer the program is through File Transfer Protocol (FTP).
You will need to know what your IP address. Depending on how you are set up, there are a couple ways to find the IP address. If you are running Tiny Term, the Comms will show you the IP Address under the Network Node. If you are running UGI, open the session, click on Preferences, click on Comms, the TCP heading will display the IP address. Otherwise, log into the root login and at the # enter in netconfig and return. This will bring up a gui screen that you can tab to move around. Under the Network Card section, highlight the SCO TCP/IP. Then tab to the VIEW PROTOCOL CONFIGURATION and return. This will show information including the IP address. Click on OK, tab to HARDWARE and choose Exit to get back to the # prompt. At the # prompt, enter exit to log off.
For the first time, you will want to create a special directory to hold the files. This should be done on the PC that you would like to email the files from. You can go into Windows Explorer and under the C drive, create a folder called WELLSFARGO (or whatever you would like) or at the MS DOS prompt, under the C drive, create the directory by doing md WELLSFARGO.
At the same PC that you would like to email the files from, log into the MS DOS prompt, and go to the root of the C drive (C:\>). Enter in cd WELLSFARGO (or the directory name you are using). At the prompt, enter in ftp IP address#. You should connect correctly and will display the User logon. Enter in root and return. It will then display the Password logon for root, enter this password in. When you have connected correctly it will display an ftp> prompt. At this prompt, enter in cd /lms/data/amsrc and return. This directory is where the files are located from the above instructions. If your system set up is different from our standard, the directory name may be different. Please contact LMS Support if you have any questions. The valid directory should be displayed and you will be back at an ftp> prompt. At this prompt, enter in mget NWF.* and return. The
program will display that it transferred properly the two files of NWF.BSE and NWF.MTR and return to the ftp> prompt. At this prompt, enter quit and return. This will return you to the prompt. These files are now located on the C drive, in the WELLSFARGO directory and are then ready to be emailed to Wells Fargo.
NT
For the first time, you will want to create a special directory to hold the files. This should be done on the PC that you would like to email the files from. You can go into Windows Explorer and under the C drive, create a folder called WELLSFARGO (or whatever you would like) or at the MS DOS prompt, under the C drive, create the directory by doing md WELLSFARGO.
In Windows Explorer you can click and drag the files of NWF.BSE and NWF.MTR from the drive and directory these files were located, D:\LMS\DATA\AMSRC, to the WELLSFARGO folder. The LMS\DATA\AMSRC directory is where the files should be located. If your system set up is different from our standard, the directory name may be different. Please contact LMS Support if you have any questions. Once the files have been moved, they are ready to be emailed to Wells Fargo.