COLLAPSEOPENS

Finds currently owned tax lots with matching transaction numbers, security ID, purchase dates, and broker codes, and adds them back together.

Note: You can run this for a entire account or for selected securities.

Tip: Can be used when you have to reverse a sale, and want the record in EDPORT to be as clear as possible.

1. At the Portvue prompt, type COLLAPSEOPENS

The following prompt will appear:

Select specific securities to collapse ?

2. To collapse all open multiple tax lots, answer NO. To collapse specific tax lots, based on the security, answer YES

The following prompt will appear:

Produce report of collapseable open tax lots ?

3. For a report of the tax lots that are being collapsed, answer YES. Otherwise, answer NO

The following prompt will appear:

Post results of COLLAPSEOPENS to EDPORT ?

4. To run this function and post the transactions, answer YES. Otherwise, answer NO. The system will return to the Portvue prompt
5. Once the functions collapses the open tax lots, the report will be created and the system will return to the Portvue prompt.  If the system can not find any tax lots that meet the specified criteria, the following prompt will appear and the system will return to the Portvue prompt: 

No open tax lots are collapseable for COLLAP

Note: The most common situation where you would use this involves reversing a sale or pay down. For example, a pay down was made, which splits an MBS holding across two lines in EDPORT: one line for the remaining holding, and one line for the paid- down piece. Then you discover that the pay down was calculated using the wrong factor. Running DELBATCH will reverse the pay down, but you are still left with two lines in EDPORT. Run COLLAPSEOPENS, and the two lines will be summed, bringing you back to the way things were before the bad pay down was posted.