LeasePak Utilities

115 Batch Sale of Asset Reversal

The utility provides an option to preload a batch file to process batch sale of asset transactions. Utility also checks for the existing records before preloading batch file and, provides an option to delete the existing records if the records are not required. The utility will preload a batch file into LeasePak RBB table. If records are not loaded properly, then the utility will generate a preload exceptions report of records not loaded. The utility will process these records from LeasePak RBB table and creates exception and audit report once processing of records completes.

Input File:

Users must first create an input file, named btchsoar.dat and place it in the $udata directory before running the utility. The input file must contain one record for each sold asset to be reversed. Each record must contain an asset that exists in the LeasePak database and has been sold through sale of Asset in Inventory.

A record must contain the following mandatory element:

Name	Prefix	Description
U	Asset	Asset number that has been sold through sale of asset in inventory.

Below is an example of a possible batch input file:
U78
U36
This file consists of two records for assets needing their sales reversed. The first is for asset 78 and the second is for asset 36.

For Vertex O users only: If asset is a Vertex O asset when processing batch sale of asset reversal, LeasePak does not support the state, county, and city fields. Vertex O uses address with TAIDs that will default to asset's equipment.

User Interface:

Users will run this utility from command line same as other Leasepak Utilities.

This utility preloads a sale of asset reversal batch file from the $udata directory into the LeasePak RBB table and processes the records from the LeasePak RBB table.

Do you wish to continue (Y/N)?

Enter Y to proceed. The program will display:

Client Password?

Enter the correct LeasePak client string password to proceed. The program will display:

Do you wish to preload a batch file [Y/N], <RETURN> to exit?

Enter Y to proceed. The utility will check that the batch file btchsoar.dat exists or file does not exist. Utility will also check if any header record exists in RBA table. If the header record still exists, it means the preload ended abnormally. The programs will display:

E R R O R � read carefully:

The prior input file was in the middle of being preloaded when an error occurred. The input file must be manually modified to remove entries that have already been preloaded. Failure to do so will cause those records to be processed twice. Do not continue here until you have modified the input file. Do you want to continue [Y/N]?  

Enter Y to proceed. The program will display:

Records already exist. Do you want to delete these records before loading more [Y/N], <RETURN> to exit:

Enter Y to proceed. The system will delete all the records from RBB tables. The program will display:

Loading batch sale of asset reversal file (path and name of file)

One moment please . . . 

While running this preload process, the utility will first write a header record if header record doesn�t exist. System will delete the header record once preload completes successfully. A header record will have blanks in all fields except the run date and run time. The preload process will continue running. The utility will read in the batch file, do the preliminary edit checks, and load data into the leasePak table RBB. If exception encountered, then it will write the exception to the preload exception report about the record skipped and not written to the RBB table. The utility will continue processing with next records found until all records have been processed. The utility will overwrite the exception report, if the exception report already exists. After processing batch file, the utility will delete the batch file; delete the header record, and display:

Completed.
Do you wish to process loaded records [Y/N], <RETURN> to exit? 

Enter Y to proceed. The program will display:

Processing batch sale of asset reversals, one moment please . . .  

Once process is done program will display:

Completed.

While processing, the utility will process all the records found in LeasePak RBB table and also deletes the records once processing is done, whether successful or with exceptions. The utility will read the records in order of the rbb_idx0 index. The utility will process each record through U0103 Sale of Asset in Inventory. Any edit checks that would have been done through the U0103 when data is entered manually will be done by the utility and will write the exceptions to the Sale of Asset Reversal Exception Report. If an exception occurs, the system will write the exception, will not perform sale of asset reversal for that record, deletes the record, and moves to the next record.

When the utility processes each record in the batch file, the following is one of the things that will be checked before writing data to the RBB table:

• The asset number is present and exists in the LeasePak database.

The values of the columns in the RBB table will be determined as follows:

Column	Value
por_s	The portfolio in which the asset resides.
com_s	The company in which the asset resides.
reg_s	The region in which the asset resides.
off_s	The office in which the asset resides.
unit_s	Asset number
Timestamp	Timestamp
d_run_s	Date preload is run
t_run_s	Time preload is run

Below is an example of how the batch file will look in the RBB table:

por_s	com_s	reg_s	off_s	unit_s	timestamp	d_run_s	t_run_s
2	1	1	1	78	0x00000000000d7b1c	Feb 4 2010	102631
2	1	1	1	36	0x00000000000d548b	Feb 4 2010	102631

Output Reports:

LeasePak will generate the Preload Exception Report when the batch input file processing ends abnormally. On failure, LeasePak will create the Exception Report and it will generate the Audit Report in case of successful completion.

Preload Exception Report:

The utility will create a preload exception report in the directory from which the utility is run when the preload option is selected. The utility will name the preload exception report plsoarexcpt.rpt. If file already exist with same name then, LeasePak will overwrite the existing file and replace it with the new report when processing preload process. The report will contain records from the batch file that have exceptions, exactly the way they appeared in the batch file along with an error message.
The report will include the following information in the header:

• Run date: Current date when running preload process.
• Run time: Will show the time when started loading batch file for processing.
• User ID: Valid LeasePak user Id.
• LeasePak version: Version of LeasePak in which the utility is running.
• Title: BATCH SALE OF ASSET REVERSAL PRELOAD EXCEPTIONS:

The report detail will have the following column headings:

• Batch Record: The batch record will contain the actual record text of the record rejected.
• *Message: The message will contain an error message preceded by and (*) asterisk.

Following is the sample of Sale of Asset Reversal Exception Report:

Exception Report:

The utility will create the sale of asset reversal exceptions report in the directory from which the utility is run when the �process loaded records� option is selected. The utility will name the exceptions report btchsoar_excpt.rpt. If a file with the same name exists, the program will overwrite the file and replace it with new report.
The report will include the following information in the header:

• Run date: Day of running utility.
• Run time: Utility start time.
• User ID: LeasePak user Id.
• LeasePak version: LeasePak current version.
• Title: BATCH SALE OF ASSET REVERSAL EXCEPTIONS: of the report presenting exceptions report.

The report detail will have the following column headings:

• PCRO: A valid portfolio, company, region and office number.
• Asset
• Message: Message will display the error message.

Following is the sample of Batch Sale of Asset Reversal Exception Report:

Audit Report:

The utility generates a sale of asset reversal audit report in the directory from which the utility is run when the �process loaded records� option is selected. The utility will name the audit report btchsoar_audit.rpt. If a file with the same name already exists, the utility will overwrite the file and replace it with the new report content. The audit report will lists all successful records when trying to process preloaded records.
The report will include the following in the header:

• Run date: Day of running utility.
• Run time: Utility start time.
• User ID: LeasePak user Id
• LeasePak version:LeasePak current version
• Title: BATCH SALE OF ASSET REVERSAL AUDIT:



The report detail will have the following column headings:

• PCRO: A valid portfolio, company, region and office number.
• Asset:
• Amount Reversed:

Following is the sample of Batch Sale of Asset Reversal Audit report: