The Multi Asset Maintenance is an optional update (part of 2001 JULE Fund and Application Tracking modules). It allows changes to the location, use tax, property tax, UCC/title filing, and many more information to one, some, or all of the assets attached to a particular application/lease.
For application-side asset maintenance, the users will need to have the Application Tracking and 2001 JULE Fund modules and the authority to use the functionality. The user’s authority can be set up in the Application Tracking Setup [U0831]. To change the assets on an application which is not approved yet, use the Application menu option to run the update. Asset(s) can also be deleted using the application-side asset maintenance update.
For lease-side asset maintenance, the users will need to have the 2001 JULE Fund module. To change the assets that are already booked (on a lease), matured, or paidoff but not sold, use the lease-side Multi Asset Maintenance [U0230] update directly from the LeasePak Updates menu. Assets cannot be deleted using the lease-side asset maintenance update.
LeasePak prevents the users to update certain fields depending on the state or status of the asset. See the following table for details.
Status of Asset | Application Asset | Asset in Inventory | Asset on Lease | |
Applicable Update | Application | Application/Lease | Lease | |
Field | Allow update RAQ | Allow update REQ | Allow update REQ | |
1 | Address | Y | Y | Y |
2 | Tax Area ID | Y | Y | Y |
3 | City | Y | Y | Y |
4 | County | Y | Y | Y |
5 | State | Y | Y | Y |
6 | Zip | Y | Y | Y |
7 | Use Tax Code | Y | Y | Y |
8 | Tax Type | Y | Y | Y |
9 | PPT Basis | Y | Y | Y |
10 | Report PPT(Y/N) | Y | Y | Y |
11 | Allow PPT(Y/N) | N | Y | Y |
12 | 8 UCC fields | Y | Y | Y |
13 | Book Accounting Method | Y | N | N |
14 | Book Depreciation Method | Y | N | Y |
15 | AMT Depreciation Method | Y | N | N |
16 | Fed. Depreciation | Y | N | N |
17 | State Depreciation | Y | N | N |
18 | In-Service Date | Y | N | N |
19 | Book Depreciation Date | Y | N | Y |
20 | Class | Y | Y | Y |
21 | Residual Amount | Y | Y | N |
22 | Acquisition Cost | Y | N | N |
23 | Identification | Y | Y | Y |
24 | Acquisition Date | Y | Y | Y |
25 | Supplier | Y | Y | Y |
26 | PPT Exempt Code | Y | Y | Y |
27 | Payment Amount | Y | Y | Y |
28 | Use Tax Exempt Code | Y | Y | Y |
From the LeasePak menu, select Updates, Maintenance, Multi Asset Maintenance. LeasePak displays the lease selection screen:
Type the lease number or click to search, then click
Select to continue.
On entering a paidoff or terminated lease number, the program will display a warning message. The warning message applies to the lease-side U0230 Multi Asset Maintenance update only.
The user must click OK to proceed with the update.
LeasePak displays the Multi Asset Maintenance screen. This screen is used for both application-side and lease-side asset maintenance with a few differences described below:
This screen has two main subsections.
The top half subsection (active by default) is called the Assets grid and lists all assets attached to the application/lease except those which are already sold. Sold assets are not displayed on this screen.
Click in the leftmost column to select the corresponding asset record, click
to cancel the selection, or use Select All/Unselect All toggle button to either select all assets records or clear all selections.
Click any column name in the Assets grid header row to sort the records on that column in ascending or descending order.
The user can also delete one or more assets on an application that is not approved yet using this subsection of the screen. For that, you will need to run this update from the Application menu. Select the assets you want to delete in the Assets grid and click Delete. The program will perform the delete operation in the following ways:
You cannot delete asset(s) that are already booked (on a lease), matured, or paidoff while running the Multi Asset Maintenance [U0230] update directly from the LeasePak Update menu.
The bottom half subsection (inactive by default) is used to view/change the asset fields based on the tab selected in the top half. Asset fields are arranged into five tabs given in the top half of the screen. Follow the document to learn more about the five tabs along with the asset fields arranged in them.
The update allows the user to change more than one asset at a time. Select the assets you want to change from the Assets grid and click Change. It will disable the Assets grid in the top half and enable the asset fields in the bottom half of the screen to view/change their values. By default, the asset fields arranged in the first tab (General 1) are displayed, however you can navigate through the other tabs to view/change the other fields as well.
The asset fields displayed in the bottom half of the screen can have two different states (locked or unlocked) and therefore can be updated in the following two ways:
Single Value Field - If the field have same value for all of the assets selected in the Assets grid, it is called single value field. Single value fields are active by default and displayed with an unlocked padlock toggle button. You can directly enter a new value to a single value field or leave it blank.
Multiple Value Field - If the field does not have same value for all of the assets selected in the Assets grid, it is called multiple value field. Multiple value fields are inactive by default and displayed with a locked padlock toggle button. To update a multiple value field, you need to click on the locked padlock toggle button to make it enable first. It will change the button into an unlocked position and make the field active. You can now enter a new value to an active field. If you do not want to make any change in the field value, simply click to change the unlocked padlock toggle button into a locked position. The program will consider the field unchanged on save.
You cannot set multiple assets' field value to blank, space (' '), or zero (0).
Moving the pointer over a locked padlock toggle button will display the following text as tool tip:
Multiple values currently exist. Click to change
After making the required changes to the asset fields, click Save. It will save the new values entered to the asset fields, except those with a locked padlock toggle button, to all of the asset records selected in the top half of the screen.
If you leave a field blank with an unlocked padlock toggle button and save it, the program will change the data in that field for selected asset records to blank only if the blanks are allowed for the field.
If you enter zero value in a numeric field with an unlocked padlock toggle button and save it, the program will change the data in that field for selected asset records to zero.
Changes made to the asset fields will affect all assets selected (checked) in the Assets grid.
The program will enforce all edit checks for valid values in any asset field being updated, as currently represented in the U0210 Asset and U0120 Change Asset updates.
Clicking Cancel will prompt the following message.
Click No in the message box to go back to the main U0230 Multi Asset Maintenance screen where you can save the changes to the asset records permanently. Or click Yes in the message box to discard the changes and return to the prior screen where a new lease number may be entered.
Running Location Search without first specifying any criteria (such as a state or province) accesses all location records (50,000+ if Vertex locations are loaded) in the LeasePak database and can take up to 15 minutes to complete.
For Vertex O users only: The search button will only appear if asset is a Vertex-O asset. Users can still enter the address directly by the non-Vertex method. If fields are disabled click on the Class lock button to unlock and enter address information.
If the Multiple Banks module is purchased and the asset is an insurance asset, LeasePak will use the Acquisition Cost to hold the insurance premium.
ACQUIS COST * (RESIDUAL % / 100)
LeasePak allows operating type assets to be booked with a RESIDUAL that exceeds the ACQUISTION COST. For interest bearing loans, the residual field can be used to book a balloon payment.
With the Asset Cost Recalculation switch, Custom General [U0712] - Miscellaneous Customizations, enabled, LeasePak automatically adjusts the residual amount when acquisition cost changes.
LeasePak allows the user to change the asset payment amount in Rebook [U0116] and the percent of schedule used in the tax calculations after the lease has booked.
If you are using the Customer Service module, the asset payment amount will affect what the Lease Summary screen [F5] displays for the asset payment schedule. Refer to the Asset Tab of Customer Service [U1601]: Lease Summary for more information (the asset payment schedule does not appear on any reports and is not stored in LeasePak data).
When a new or cloned asset is being booked and the in-service date crosses a previous tax year boundary, LeasePak will display a warning message to notify the user, this message is informational only: "Warning-Asset In-Service date is prior to a previous tax year. Continue Y/N?"
When Y is selected, the user may continue to add the asset. When N is selected, LeasePak will cancel the add asset update and return to the first screen.
While the Title Filings popup window is opened, you will not be able to access the main U0230 Multi Asset Maintenance screen. The window lists all title filings on record for the assets selected on the main U0230 Multi Asset Maintenance screen. Each asset can have up to five title filings. You can select one or more title filing records on this window and change or delete them. You can also create new title filing records for each of the assets selected on the previous screen, up to the maximum of five title filings per asset. The following describes various functions of the Title Filings update:
Select All – Use Select All/Unselect All toggle button to either select all title filing records in the top half of this window or clear all selections.
Delete – Use Delete button to remove all title filing records selected in the top half of this window. The program will permanently delete the records from the LeasePak database once the Save button is clicked on the main U0230 Multi Asset Maintenance screen.
Change – Select the title filing records in the top half of this window and click Change. The program will make the Title Filings Changes section available for changes in the bottom half of this window as follows.
Similar to the asset fields, the title filing fields can also have single or multiple values for the selected assets. So to update the title filing fields, you need to use the same technique that is discussed for Multi Asset Maintenance above.
After making the desired changes to the title filing fields, click Done button within the Title Filing Changes section of the window. It will apply the new values entered to the fields, except those with a locked padlock toggle button, to all of the title filing records selected in the top half of the window.
Now click Done in the bottom half to close the Title Filings update window. The program will update the LeasePak database with the changes once you click the save button on the main U0230 Multi Asset Maintenance screen.
Add – This button helps you to add a new title filing record to the selected assets. Similar to the function of Change button, when you click Add button, it will make the Title Filing Changes section available with empty fields in the bottom half as follows:
All fields are mandatory except File Number in this screen.
NOTE: There is a read only field "Number of title filing records to be added:" which tells how many title filing records will be added in one attempt. The field is informational only.
Fill up the required fields in the Title Filing Changes section in the bottom half (unless Type is NONE, in which case only Type is required) and click Done. The program will use the entered information to create a new title filing record for each of the asset selected on the main U0230 Multi Asset Maintenance screen, up to a maximum of five title filing records per asset.
If you will attempt to add a title filing record to an asset that already has five records in its title filing list, the program will prevent you from adding a new record with the following error message:
Click Cancel in the Title Filing Changes section. It will ignore any changes made in the section, activate the Title Filings for Selected Assets section in the top along with its Done and Cancel buttons, and hide the Title Filing Changes section.
Once you are out of the Title Filing Changes, click Done to close the Title Filings update window. It will take you to the main U0230 Multi Asset Maintenance window where you can permanently save all changes made to the title filing records to the LeasePak database.
If there are changes to save in the Title Filing update window and you clicks Cancel, the following message displays:
Click No in the message box to discard the changes made to the title filing records and return to the main U0230 Multi Asset Maintenance screen. Or click Yes to carry all the changes to the main U0230 Multi Asset Maintenece screen where you can permanently save all changes made to the title filing records to LeasePak database.
U0230 Multi Asset Maintenance update does not support asset(s) based on Canadian province (state) with Vehicle Tax Table when Use Tax Code is other than Upfront Sales Tax type.
For Vertex O users only: The supported Use Tax Codes for Vertex O assets are ALL, NOEX, NONR, NOPF, NOUT, and NOAP. Changing the asset from one use tax code to other cannot be done on this screen. For assets with NOPF or NOUT codes, LeasePak will override the Vertex-O rules and mark them as exempt with the reason code, and will not charge additional upfront sales tax amounts.
FIN (FINANCE): Enter this method if the asset is to be booked on a lease other than an operating lease. Monthly book depreciation is recorded at the asset level, but no General Ledger updating is performed.
OPER (OPERATING): Monthly book depreciation is recorded at the asset level. In the General Ledger, the inventoried value of the asset is decreased and the depreciation expense is increased by the depreciation amount.
If the Multiple Banks module is purchased and the asset is an insurance asset, LeasePak will automatically default the accounting method to Finance.
The guidelines for various federal depreciation methods discussed above also apply to book depreciation (e.g., ACRS depreciation may not be used for assets with an IN-SERVICE DATE prior to January 1, 1981). DVA1 and/or DVA2 depreciations are to be used when calculating the Diminishing Value of the asset.
With the Asset Cost Recalculation switch, Custom General [U0712] - Miscellaneous Customizations, enabled, LeasePak automatically adjusts this value when acquisition cost changes.
LeasePak prorates book depreciation based on various criteria. See U0443 Depreciation for details on which criteria affect this process.
ACRS depreciation may not be used for assets with an IN-SERVICE DATE prior to January 1, 1981.
ACRS Safe Harbor depreciation may not be used for assets with an IN-SERVICE DATE after December 31, 1983.
MACRS 1/2 Year Convention and MACRS Mid Quarter Convention depreciation methods may not be used for assets with an IN-SERVICE DATE before August 1, 1986.
ADR depreciation may not be used for assets with an IN-SERVICE DATE after December 31, 1980.
If federal depreciation is not to be calculated for the asset and Investment Tax Credit is to be claimed, the bypass depreciation methods must be used. The bypass depreciation methods must be used if the asset is tied to an Interest Bearing Loan DVA1 and/or DVA2 depreciations are to be used when calculating the Diminishing Value of the asset.
The guidelines for various federal depreciation methods above also apply to state depreciation (e.g., ACRS depreciation may not be used for assets with an IN-SERVICE DATE prior to January 1, 1981).
AMT depreciation may not be used for assets with an IN-SERVICE DATE prior to August 1, 1986.
The bypass depreciation methods must be used if the asset is tied to an Interest Bearing Loan.
After making the required changes to the selected assets, when you will click Save in the Multi Asset Maintenence screen, the program will start validating all intended field changes. If all changes are valid, it will produce a validation report that you can check before committing the transaction.
You can review the fields the program will update in the report and click OK to proceed or Cancel to return to the update window.
If the program is unable to validate any field change on any of the assets selected, it will instead produce an exceptions report. It's a standard XML-format report with filename "lpu0230_exceptions.rpt" that you can:
The report will list each failed asset/field update attempted and why it failed, displaying the following columns:
Once all intended field changes are validated succesfully, the program will produce a audit report. It's a standard XML-format report with filename "lpu0230_audit.rpt" that you can:
The report will list all asset/field changes, displaying the following columns:
LeasePak Documentation Suite
©
by NetSol Technologies Inc. All rights reserved.
The information contained in this document is the property of NetSol Technologies Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NetSol Technologies Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NetSol Technologies Inc. is prohibited.
This message should disappear within 5-15 seconds, depending on the size of the document and the speed of your connection to the Documentation Suite.
If you can still see this message after 20 seconds, try clicking the Refresh or Reload button on your Web browser.
If your document still does not load, refer to Document Load Troubleshooting for instructions on how to fix possible problems with either your Documentation Suite installation or Web browser setup.
If you do not have read access to the parent docsuite directory, you will not be able to load the Document Load Troubleshooting document. In this case, contact your network administrator for assistance.