| LeasePak 6.2a Reference Guide | Print Version| Help| Search| DocSuite | Document Top |  |
| Cost Per Use | |||
| Asset vs. Lease U0212 U08 U0231 U0233 Pricing Credits U0131 U0132 Reversals Lpautil 224 U0448 R0925 | |||
| LeasePak 6.2a Reference Guide | Print Version| Help| Search| DocSuite | Document Top | |
| Cost Per Use | |||
| Asset vs. Lease U0212 U08 U0231 U0233 Pricing Credits U0131 U0132 Reversals Lpautil 224 U0448 R0925 | |||
Describes Cost Per Use meters, a feature that allows the user to attach a meter definition to either a pending/booked asset or an application/lease, then enter meter readings and assess cost per use charges. Requires the optional Cost Per Use module.
When you attach one or more meters (up to 4) to an individual pending or booked asset at the asset level, LeasePak tracks meter readings and assessed charges for the individual asset, using an asset-level general ledger assessment account.
When you attach one or more meters (up to 4) to an entire application or lease at the lease level, you can still associate meters with particular assets on the application/lease (up to 4 per asset), but LeasePak tracks meter readings and assessed charges for the whole lease, using a lease-level general ledger assessment account.
Do not use both asset- and lease-level meters on the
same application or lease. This will result in unexpected and erroneous LeasePak behavior.
Before attaching meters to an asset or application/lease, you must first specify the assessment(s) to use for meter charges.
For asset-level meters, use the field Cost Per Use Assmt Code in Portfolio [U0212]: Miscellaneous Customizations to specify an asset-level assessment. The following choices are available:
For lease-level meters, use the field Lease Cost Per Use Assmt Code in Portfolio [U0212]: Miscellaneous Customizations to specify a lease-level assessment. The following choices are available:
You can use Sales Tax on Assessments with any of these assessments. If your LeasePak license includes the Name Assessments module, you can change the names of these assessments through Assessment Customizations, and you can modify the names used for the accounting transactions through Office G/L Change.
For asset-level meters on pending assets, use Asset Meter Maintenance from the Application Tracking [U08] menu. This starts the Asset Meter Maintenance [U0231] update for pending assets.
For lease-level meters on applications, use Application Meter Maintenance from the Application Tracking [U08] menu. This starts the Lease Meter Maintenance [U0233] update for applications.
For booked assets and leases, you can access the appropriate meter maintenance updates from the LeasePak main menu.
To add, change, or delete asset-level meter definitions, use Asset Meter Maintenance [U0231], either through Application Tracking [U08] (for pending assets), or directly from the LeasePak main menu (for booked assets in inventory or attached to a lease).
To add, change, or delete lease-level meter definitions, use Lease Meter Maintenance [U0233], either through Application Tracking [U08] (for applications), or directly from the LeasePak main menu (for booked leases).
The Cost Per Use module employs a tier-based pricing system. The following are setup and assessment examples of 4-tier pricing.
Setup
Base Allowance = 3,000
| Tier | Start Range | End Range | Cost Per Use |
|---|---|---|---|
| 1 | 3,001 | 8,000 | $0.00090 |
| 2 | 8,001 | 12,000 | $0.00080 |
| 3 | 12,001 | 20,000 | $0.00070 |
| 4 | 20,001 | -1 | $0.00060 |
Assessment
Previous Meter Reading: 112,000
New Meter Reading: 136,000
Difference: 24,000
| Number of Uses | Cost Per Use | Assessment | |
|---|---|---|---|
| 0 - 3,000 | $0.00000 | $0.00 | |
| 3,001 - 8,000 | $0.00090 | $4.50 | |
| 8,001 - 12,000 | $0.00080 | $3.20 | |
| 12,001 - 20,000 | $0.00070 | $5.60 | |
| 20,001 + | $0.00060 | $2.40 | |
| Totals | 24,000 | N/A | $15.70 |
Using the same setup as assessments, service credits are divided appropriately among the tiers and converted to corresponding credit amounts. In the event that there are more credits than uses during a cycle (month or time between meter readings), the excess service credits will roll over and become available for the next cycle, unless the number of uses during a cycle are less than the Base Allowance. In that case, all uses are charged at the base ($0.00000 per use) rate and no service credits roll over for the next cycle.
Example 1: (based on the tiers described in the previous section)
number of uses > the Base Allowance
number of service credits < number of uses.
Previous Meter Reading: 112,000
New Meter Reading: 136,000
Difference: 24,000
Service Credits Available: 8,000
| Number of Uses | Service Credits | Cost Per Use | Assessment | Credit Amount | |
|---|---|---|---|---|---|
| Base | 3,000 | N/A | $0.00000 | $0.00 | $0.00 |
| 1 | 5,000 | 5,000 | $0.00090 | $4.50 | $4.50 |
| 2 | 4,000 | 3,000 | $0.00080 | $3.20 | $2.40 |
| 3 | 8,000 | 0 | $0.00070 | $5.60 | $0.00 |
| 4 | 4,000 | 0 | $0.00060 | $2.40 | $0.00 |
| Totals | 24,000 | 8,000 | N/A | $15.70 | $6.90 |
Assessment - Credit Amount = $8.80
Example 2: (based on the tiers described in the previous section)
number of uses > the Base Allowance
number of service credits > number of uses over the Base Allowance.
Previous Meter Reading: 112,000
New Meter Reading: 136,000
Difference: 24,000
Service Credits Available: 23,000
| Number of Uses | Service Credits | Cost Per Use | Assessment | Credit Amount | |
|---|---|---|---|---|---|
| Base | 3,000 | N/A | $0.00000 | $0.00 | $0.00 |
| 1 | 5,000 | 5,000 | $0.00090 | $4.50 | $4.50 |
| 2 | 4,000 | 3,000 | $0.00080 | $3.20 | $3.20 |
| 3 | 8,000 | 8,000 | $0.00070 | $5.60 | $5.60 |
| 4 | 4,000 | 4,000 | $0.00060 | $2.40 | $2.40 |
| Totals | 24,000 | 20,000 | N/A | $15.70 | $15.70 |
Assessment - Credit Amount = $0.00
Service credits rolled over to the next cycle: 3,000
Example 3: (based on the tiers described in the previous section)
number of uses < the Base Allowance
Previous Meter Reading: 112,000
New Meter Reading: 114,500
Difference: 2,500
Service Credits Available: 8,000
| Number of Uses | Service Credits | Cost Per Use | Assessment | Credit Amount | |
|---|---|---|---|---|---|
| Base | 3,000 | 8,000 | $0.00000 | $0.00 | $0.00 |
| Totals | 2,500 | 8,000 | N/A | $0.00 | $0.00 |
Assessment - Credit Amount = $0.00
Service credits rolled over to the next cycle: 0
To enter meter readings and assess charges to either asset- or lease-level meters interactively, use Assess Meter Charge [U0131].
You can also assess readings and charges in batch mode using LeasePak Utility 224: Cost Per Use Import File, described later in this document.
LeasePak will place the meter charge assessment on the next invoice to be accrued for an asset tied to a lease. For users without the Off-Lease Billing module, if the lease has stopped accruing, LeasePak will place the assessment on the most recent invoice; in this case, multiple assessments may be placed on the same invoice over time.
For users with the Off-Lease Billing module, LeasePak will only place multiple assessments on the same invoice if accruals are stopped due to the lease being in a non-accrual hold status.
The following is an example of how meter assessments appear on the invoice scratch file:
<inv #1> 213 <due #1>890506 <cm #101>N <asm #101>FED HIWAY USE TX FEE <asm type #101>FHUT <asm amt #101>0000000850 (METER TRANSACTION BEG) <meter unit> 81 <meter id> BW <meter desc>Black and White <meter prv read>0000000000120000 <meter new read>0000000000137000 <meter usage beg>890316 <meter usage end>890416 <meter base allow>0000004000 <meter prv credit>0000000000 <meter new credit>0000003000 <meter apl credit>0000003000 <meter charge>0000000760 <meter item tier#01>00004000 <meter rate tier#01>00000090 <meter item tier#02>00004000 <meter rate tier#02>00000080 <meter item tier#03>00005000 <meter rate tier#03>00000070 (METER TRANSACTION END) (METER TRANSACTION BEG) <meter unit> 81 <meter id> BW <meter desc>Black and White <meter prv read>0000000000137000 <meter new read>0000000000142000 <meter usage beg>890416 <meter usage end>890516 <meter base allow>0000004000 <meter prv credit>0000000000 <meter new credit>0000000000 <meter apl credit>0000000000 <meter charge>0000000090 <meter item tier#01>00001000 <meter rate tier#01>00000090 (METER TRANSACTION END)
You must use one of the Cost Per Use updates to either assess or reverse meter charges. Once you specify an assessment to use with Cost Per Use, you cannot assess or waive charges for that assessment through other LeasePak assessment/waiver updates, such as Assessment [U0105] or Batch Assessments [U0418].
To reverse meter assessments on either asset- or lease-level meters interactively, use Reverse Meter Charge [U0132].
You can also reverse readings and assessments in batch mode using LeasePak Utility 224: Cost Per Use Import File, described later in this document.
These are examples of different procedures you can use when reversing and reassessing multiple meter charges. Each example uses the following set of assessments:
| Invoice Date | Period Start | Period End | Meter Reading |
|---|---|---|---|
| 04/15/2010 | 03/15/2010 | 04/15/2010 | 1,000,080 |
| 05/15/2010 | 04/15/2010 | 05/15/2010 | 1,001,111 |
| 06/15/2010 | 05/15/2010 | 06/15/2010 | 1,002,002 |
Example 1: combine all charges into one period.
Example 2: re-assess charges on the original invoices.
Example 3: re-assess charges individually on the next invoice.
For best results, NetSol recommends using the procedures described in Example 2 or 3. For more information about reversal procedures, contact your NetSol representative.
Processing of meter assessments in a batch requires an input file containing all the assessment entries in a pre-defined format. This file is processed by End of Period when it runs. The End of Period process will process each of the particular records and either assess or reverse new cost per use meter reads. It will also generate an audit and exception report.
The users need to manually create the input file and place it in the data directory of the environment in which the End of Period process is to run. The name of the file must conform to the convention - pn_btchcpu.dat. Where, 'n' in the file name is the portfolio number.
When using Batch Meter Charge [U0133], LeasePak displays a dialog requiring the user to select the portfolio for which to process the assessments.
After you have selected your required portfolio and clicked OK, LeasePak will search for the batch file at the previously mentioned location. If LeasePak is successful in finding the file and reading its content, it will load the assessments into its database and will make them available for the next scheduled End of Period process. You will see the following dialog if the assessment file was successfully found and loaded.
However, if LeasePak was unable to find the file at the correct location for some reason, you will receive the following message:
It is also important to know that LeasePak deletes the batch input file after processing it. Therefore, take a backup copy of the file at a different location if you may have any future need for it.
This section provides detail about the format of the batch input file for meter assessments.
Each line of the Cost per Use input file will contain the following mandatory elements:
Example 1:
422000, 09/15/06, 125,BW01,12500,-20,BW02,7500,-15,CL01,5000,-5,CLO2,3500,0
Directs the Cost per Use End of Period module to charge an assessment for lease number 422000 with meter end period date of 9/15/06 for asset 125 for meter BW01 with a reading of 12500 and service credit 20, meter BW02 with a reading of 7500 and service credit of 15, meter CL01 with a reading of 5000 and service credit of 5, meter CL02 with a reading of 3500 and no service credit.
Example 2:
427909, 09/15/06, 89,BW01, 750109,-50
Directs the Cost per Use End of Period module to charge an assessment for Lease 427909 with meter end date of 09/15/06 for asset 89 meter BW01 with a reading of 750109 and service credit of 50.
Example 3:
427909, 09/15/06, 89,BW01, -750109,50
Directs the Cost per Use End of Period module to reverse the latest assessment for Lease 427909 asset 89 meter BW01.
The LeasePak utilities are options of the
program $uexe/lpautil.exe. You must have direct access to the LeasePak server, either as the LeasePak administrative
user (lpadmin) or as the NetSol release administrator (msiadmin), in order to run this program. Many of
the utilities can severely corrupt LeasePak and its databases; consult your NetSol representative before running any of
them.
Terminal emulation: you must use one of the supported terminal types. Refer to System Requirements in the System Administration Guide for more information.
Use this utility to load meter charge assessment and reversal information into the RBM table for processing by the End of Period (Sequential Updates, Daily) module Batch Meter [U0448] (described later in this document).
To use the utility, create a batch input file named p*_btchcpu.dat
(where * is the portfolio number) and place it in the data
directory of your LeasePak environment.
Each line of the batch input file must contain the following three elements separated by commas:
For assessment transactions (type 'A'), you may also include the following:
These additional elements are also separated by commas. You can specify them in any order as long as you place them after the required elements.
Example 1
A,U12245,M0001,V12500,E040115
This line assesses Asset 12245, Meter 0001 with a meter reading of 12,500 and a meter period end date of 01/15/04.
Example 2
A,SSER#124912-23133,M0002,V550000,C2300
This line assesses an asset with serial number SER#124912-23133, Meter 0002 with a meter reading of 550,000 and 2,300 service credits.
Example 3
R,SSER#124912-23133,M0002
This line reverses the most recent meter charge made to the asset with serial number SER#124912-23133.
Once the batch input file is successfully loaded, the Batch Meter module (if set to run) will process it during the next End of Period.
This End of Period (Sequential Updates) module assesses and reverses meter charges loaded into the RBM table through LeasePak Utility 224: Cost Per Use Import File. The update produces two reports, Batch Meter Exception [U0448A] and Batch Meter Audit [U0448B]. If you wish to use this module, you must first turn it on in Portfolio [U0212]:End of Period Customizations, Modules and Reports.
Use the Meter Transaction Journal [R0925] to report on meter assessments and reversals. This is an interactive report--it does not have an End of Period counterpart.
LeasePak 6.2a Documentation Suite
©
2010 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.