The U0212 Portfolio update is used to establish or change operational parameters, which define and control functions of LeasePak.
Options to add or delete portfolios require the Multi Portfolio Processing module. With multiple portfolios, settings can be customized for leases booked under the various portfolios. Otherwise, the user has the option to change Portfolio 1 only, which will affect all leases in the system.
Each parameter controls a specific function or, in some cases, several functions of LeasePak. Methods of accounting, yield calculation, file clean-ups, and End of Period execution are a few examples of areas which may be affected by changes to portfolio parameters. Careful analysis should be performed when changing parameters, both at initial set-up and subsequently. Read the detailed descriptions of parameters in the different customizations documents to understand consequences of a change to a parameter.
NetSol advises not to change or flip the portfolio switches once they are initially set. However, if a change is required and it has potentially harmful effects (for example, the General Ledger may go out of balance, or existing data may be inconsistent with new parameter settings), a warning message appears. The change is not prevented, however. Therefore, when changing parameters, special attention should always be paid to any messages displayed on the screen.
In determining whether a given change may have adverse effects, LeasePak may have to examine a large number of records, possibly equal to the number of leases in the portfolio. Therefore certain edit checks may require a long processing time.
A permanent record of changes made to any portfolio is stored in the file DATA:LPU0212.HIS. This file contains information on the run date and time of a change, the username of the operator who made the change, the type of change (add, change, or delete portfolio), the field(s) changed, the internal field name(s) of the field(s) changed, and the old and new value(s) of the field(s) changed. This file may be read by users with access to a server account (for example, $NSTADMIN). It should never be deleted, except under the direction of NetSol personnel.
Requires Multi Portfolio Processing module.
Requires Multi Portfolio Processing module. Otherwise, this and the next two screens (Add Portfolio and Change/Delete Portfolio) do not appear.
Option descriptions:
Always use a default portfolio number to copy initial settings from (see Default Port below), then change as needed for the new portfolio. Do not attempt to add a portfolio from scratch. Contact your NetSol representative for more information.
Requires Multi Portfolio Processing module. This screen appears if you select Add from the previous menu.
Enter the number of the portfolio to add. Use to see a list of existing numbers. If you are restricted through U0706 Security to a single portfolio, you may be unable to perform this task.
Always use a default portfolio number to copy initial settings from, then change as needed for the new portfolio. Do not attempt to add a portfolio from scratch. Contact your NetSol representative for more information.
This field appears after you enter a new portfolio number and click OK or press Enter. Type or use to select default portfolio, if applicable. This portfolio must already exist. If a default portfolio is entered, all parameters for that portfolio are assigned to the portfolio being added. If a default portfolio is not entered, all required parameters for the new portfolio must be entered during this session or the new portfolio will not be added.
Requires Multi Portfolio Processing module. This screen appears if you select Change or Delete from the previous menu.
Type or use to select the portfolio to change or delete. If you are restricted through U0706 Security to a single portfolio, you will only have access to that portfolio.
This screen is used to select the category of customization parameters to be added or changed.
If adding a new portfolio without specifying a default portfolio, each category on this menu must be entered and completely processed to add the new portfolio. Only for User Defined Fields/Tables and PAP/ACH Control File is entry optional. If one or more category is not entered or completely processed before leaving this update, the portfolio is not added and all information is deleted. No portfolio with missing information is stored.
If adding a new portfolio using a default portfolio, at least one category on this menu must be entered and completely processed in order to add the new portfolio. A specific parameter change is not required, so to add a portfolio exactly identical to the default portfolio, select a category and press RETURN on each screen until the above menu is redisplayed.
For default portfolio User Defined Fields/Tables to be cloned, the user must go through each of the User Defined Fields/Tables screens.
Options descriptions:
Users who wish to store information not provided in LeasePak may create fields or tables for entry of such customized data. Fields and tables may be defined for:
For each of the items listed above, 36 fields and one table may be defined. Fields are 36 characters in length. The table contains 12 columns and 36 rows. Each of the 432 table elements is 12 characters in length.
The difference between fields and the table is that the fields may contain only one value, while the table may be used to store a list of related items. For instance, the user may define a field for lease applications to store the vendor program from which the application originates. Since each application can originate from only one vendor program, only one value needs to be stored. If the lease application covers multiple assets to be leased, a table may be used to store a list of these assets and their features.
Starting this customization launches a new menu showing the accessible user defined field/table options.
Following is a list of updates in which user-specified information may be entered or changed if their corresponding fields and/or tables are defined:
OPTION | UPDATE | FOR |
ADD | Lease Application [U0801] | Lease Applications |
CHANGE | Lease Application [U0801] | Lease Applications |
ADD ASSET | New Leases [U0101] | Assets |
BOOK LEASE | New Leases [U0101] | Leases |
CHANGE | Master Financial [U0202] | Leases |
CHANGE | Asset [U0210] | Assets |
ADD | Customer [U0205] | Customers |
CHANGE | Customer [U0205] | Customers |
ADD | Lessee [U0203] | Lessees |
CHANGE | Lessee [U0203] | Lessees |
ADD | Vendor [U0201] | Vendors |
CHANGE | Vendor [U0201] | Vendors |
Also, user defined information entered for a lease application may be viewed on the Lease Application Inquiry report [R0502], and user defined information entered for a lease and/or assets may be viewed through R0905 Lease Inquiry. As an alternative, reports may be customized through any SQL query tool, such as Sybase stored procedures or Microsoft Access.
Data entered in user defined fields and tables is not used in any LeasePak calculations such as payment schedules, General Ledger accounting, taxes, depreciation, vendor participation, and yield.