Serial Lease Info Upload is a new program in Rev 15 that allows you to upload fields from the Leasing screen in Machine Placement from an ASCII tab delimited file. It can be found in 17 System Manager> 1 System Manager Submenu> 3 Serial> 23 Serial Lease Info Upload. These are fields 63 through 78 in Machine Placement screen. The fields are: Lease Company Name, Lease Account Number, Lease P.O. Number, Start Date, Expiration Date, Billing Period, Lease $ Per Period, Total Lease $, User Defined Numeric 1, User Defined Numeric 2, User Defined Alphanumeric 1, User Defined Alphanumeric 2, and Fixed Asset Number. The 3 spare fields are not used. See the screen sample below of Machine Placement. The program allows you to blank out all of the leasing fields and / or leasing user defined fields in all serial records before loading the new information. There are two questions that are asked. These are: “Do You Wish To Blank Out The Leasing Fields And FA # In All Serial Records Prior To Loading File (Y'es, N'o, E'nd)” and “Do You Wish To Blank Out The Leasing User Defined Fields In All Serial Records Prior To Loading File (Y'es, N'o)”. If the operator answers Y for yes to the first question, fields 63 through 70 and field 78 in Machine Placement will be blanked out or set to 0 prior to loading the information in the ASCII file. If the operator answers Y for yes to the second question, fields 74 through 77 will be blanked out or set to 0 prior to loading the information in the ASCII file. This will update both machines that are placed at a customer site and machines that are in stock.
Location: 17 System Manager> 1 System Manager Submenu> 3 Serial> 23 Serial Lease Info Upload
Filename: LMSY323
The ASCII file should be called LEASEUP.TXT. On SuperDOS systems, the file should be FTP’ed to your data directory (usually 5:15). On Windows and Unix, the file should be copied into your data directory. The file should contain the following fields in the following format:
|
Item Number |
18 Alphanumeric |
|
Serial Number |
18 Alphanumeric |
|
Lease Company Name |
40 Alphanumeric |
|
Lease Account Number |
15 Alphanumeric |
|
Lease PO Number |
15 Alphanumeric |
|
Start Date |
MM/DD/YY format |
|
Expiration Date |
MM/DD/YY format |
|
Billing Period |
2 digits numeric |
|
Lease $ Per Period |
8 digits with 2 decimal positions and decimal point. ex. 123456.78 |
|
Total Lease $ |
8 digits with 2 decimal positions and decimal point. ex. 123456.78 |
|
User Defined Numeric 1 |
9 digits numeric |
|
User Defined Numeric 2 |
9 digits numeric |
|
User Defined Alphanumeric 1 |
20 Alphanumeric |
|
User Defined Alphanumeric 2 |
20 Alphanumeric |
|
Fixed Asset Number |
8 digits numeric |
The program will check to make sure that the item and serial number exist in the serial file. If it does not, the item and serial number will print on the exception report and the record will be skipped.
The program will also check to make sure that the numeric fields do not contain any non-numeric characters. The date fields will be validated and the program will also check to make sure that the start date is prior to the expiration date. The two dollar amount fields will be checked to make sure that the decimal point is included. If the record fails any of these checks, the serial record will be updated with the valid fields and the invalid field will print on the exception report along with the item and serial number. The invalid field in the serial data record will remain what it was prior to the program running.
If errors are encountered, a message will display on the screen warning the operator that errors occurred. The exception report should be checked and any corrections to the data file should be made through Machine Placement program. Or, the ASCII text file can be corrected and this program ran a second time.
If a field is left blank in the ASCII text file, it will clear out whatever was in the field in the Serial file prior to the program running.
Information that is updated is on the third screen in Machine Placement:
Input screen:
Exception report sample:
