Warning
WARNING: The TrackAbout MetaWiki has been deprecated and is no longer being updated.

Please visit our new TrackAbout Knowledge Base at https://supportkb.trackabout.com for the most-up-to-date documentation on TrackAbout and TrackAbout Mobile.

Difference between revisions of "Customer Reports"

From TrackAbout MetaWiki
Jump to navigation Jump to search
Line 12: Line 12:
 
===[[Rental Balance]]===
 
===[[Rental Balance]]===
 
This report displays the current rental balance of the selected customer and all departments that bill with this customer. The balances are calculated since the end date of the last Billing Period. Balances can be viewed by asset type or by rental class. Only enabled for rental customers.
 
This report displays the current rental balance of the selected customer and all departments that bill with this customer. The balances are calculated since the end date of the last Billing Period. Balances can be viewed by asset type or by rental class. Only enabled for rental customers.
 +
 +
==== Exchange Type====
 +
If exchange type is enable, the rental balance page allows to edit exchange balances
 +
 +
==== Lease value ====
 +
The rental balance page can display "Leased as of Now" and "Rental Balance" with '''decimal values'''.
 +
 +
If a rental billing period is open AND that the system configuration allows [[Asset_Agreements#Asset_Agreement_Configurations|prorating of asset agreements]], the customer rental balance page can display "Leased as of Now" and "Rental Balance" with decimal values.
 +
 +
Example:
 +
On May 5, the March billing period is still open and April rental has not yet been started.
 +
Lets assume we have a customer ABC with an asset agreement of 22 asset for type "CO2-244" and an asset balance of 11 for that same type.
 +
 +
The Rental balance page will show:
 +
*"Current Balance" = 11
 +
*"Leased as of Now" = 10.3
 +
*"Rental Balance" = 0.67
 +
 +
If now we close the March billing period, these number will change to:
 +
*"Current Balance" = 11
 +
*"Leased as of Now" = 0
 +
*"Rental Balance" = 11
 +
 +
Lets explain the decimal values found before closing the billing period. March had 30 days, April 31, and as off today May 5th, 5 days, or a total of 66 days.
 +
Since prorating of asset agreements is enabled in the system and that the March period is open (March has 31 days), the asset leased as of now is:
 +
 +
*31/66 days X 22 asset agreements = '''10.33'''
 +
*Asset balance being 11, the rental balance as of now is: 11 - 10.33 = '''0.67'''
  
 
===[[Asset Search]]===
 
===[[Asset Search]]===

Revision as of 13:03, 7 May 2015

The customer reports page provides access to useful breakdowns and summary of a client's asset activity.

Asset Balance Report

This report calculates the complete balance of the selected customer and any departments.

By default, this report shows the current, up-to-the-minute balance, but it can calculate the balance at any point in time in the past as well. It does not automatically show what part of the balance is made up of unique, barcoded assets and what part is Not-Scanned assets, but this setting can be changed.

You can switch to the Asset Details Report for a specific customer by clicking on the Switch to Asset Details Report link next to the customer's name.

Asset List Report

This report displays all the unique scanned assets out to the selected customer as of specific date. This does not include any Not-Scanned assets. It can be accessed by viewing a customer and then clicking "Asset List" in the Customer Reports section.

Rental Balance

This report displays the current rental balance of the selected customer and all departments that bill with this customer. The balances are calculated since the end date of the last Billing Period. Balances can be viewed by asset type or by rental class. Only enabled for rental customers.

Exchange Type

If exchange type is enable, the rental balance page allows to edit exchange balances

Lease value

The rental balance page can display "Leased as of Now" and "Rental Balance" with decimal values.

If a rental billing period is open AND that the system configuration allows prorating of asset agreements, the customer rental balance page can display "Leased as of Now" and "Rental Balance" with decimal values.

Example: On May 5, the March billing period is still open and April rental has not yet been started. Lets assume we have a customer ABC with an asset agreement of 22 asset for type "CO2-244" and an asset balance of 11 for that same type.

The Rental balance page will show:

  • "Current Balance" = 11
  • "Leased as of Now" = 10.3
  • "Rental Balance" = 0.67

If now we close the March billing period, these number will change to:

  • "Current Balance" = 11
  • "Leased as of Now" = 0
  • "Rental Balance" = 11

Lets explain the decimal values found before closing the billing period. March had 30 days, April 31, and as off today May 5th, 5 days, or a total of 66 days. Since prorating of asset agreements is enabled in the system and that the March period is open (March has 31 days), the asset leased as of now is:

  • 31/66 days X 22 asset agreements = 10.33
  • Asset balance being 11, the rental balance as of now is: 11 - 10.33 = 0.67

Asset Search

Pulls assets in the customer's possession based on selected criteria. This can be done through using barcodes, serial numbers, project codes, and asset classifications, as well as other criteria.

Inventory Worksheet

This option automatically produces a printable worksheet of assets with a customer and lists the expected number of assets. It includes a number for assets which were not scanned.

Transfer Activity

This page displays all asset transfer activity for a customer (and optionally its departments, if any exist) over the specified date range.

Unexpected Transfers

This report shows any unusual or suspicious transfer activity for the specified customer and optionally, its departments. This typically indicates theft.

View Balance Changes Details

Displays the types of assets that have been delivered to or returned from the customer. Data can be displayed based on date and asset type selections.

View Balance Changes Summary

This report shows a summary of balance changes for a given customer and asset type. NOTE: This report provides output only for locations indicated as "Branches".

Customer Transaction History

This report outlines all assets that were delivered or returned within a given date range for a given customer. Deliveries and returns are matched up on the same line representing a round trip for the asset.

The following restrictions apply to the parameters supplied for this report: The provided start and end date values must represent valid dates and a valid date range. For example, the end date must come after the start date. The provided date range can cover a maximum or three years. The provided customer Id must exist within the database.