Knowledge base

Equipment Setup for EC1/EC2 Charge

Report Output Example: *************************************************************************************************** where  ( fa_main:fa_status <> “SO” ) list/domain=”fa_main”/nobanner/Title=”Equipment Setup for EC1/EC2″ fa_main:fr_group/noduplicates fr_group:fr_group_desc fa_main:fa_key fa_main:fa_name fa_main:fa_type fa_main:fa_status fa_main:al_location fa_main:fa_serial_no fa_main:fa_ec1 fa_main:fa_ec2 sorted by   fa_main:fr_group

May 21, 2020

Items which do NOT charge Env2 (EC2)

where   ( fa_main:fa_ec2 = “Y” )   and ( fa_status <> “SO” )   list/domain=”fa_main”/nobanner/Title=”Items Which Do Charge Env2″   fa_main:fr_group/noduplicates   fr_group:fr_group_desc   fa_main:fa_key   fa_main:fa_name   fa_main:fa_type   fa_main:fa_status   fa_main:al_location   fa_main:fa_serial_no   fa_main:fa_ec2

Items which do NOT charge Env1 (EC1)

where   ( fa_main:fa_ec1 = “N” )  and ( fa_status <> “SO” )   list/domain=”fa_main”/nobanner/Title=”Items Which Do NOT Charge Env1 “   fa_main:fr_group/noduplicates   fr_group:fr_group_desc   fa_main:fa_key   fa_main:fa_name   fa_main:fa_type   fa_main:fa_status   fa_main:al_location   fa_main:fa_serial_no   fa_main:fa_ec1   sorted by   fa_main:fr_group

A Bulk Utilization Report

Report Output Example: ********************************************************************************************************* /* bulkutillist28d  Trial List report to show bulk utilization historical by out date by Tim M 2/3/05, 2/25/05- fixed auditing lines and added selection for group selection, 4/2/05- changed 14 day to 28 day and added a remark line to show how to change to run future vs past reports. 4/16/2006- […]

List Items Currently Down for Maintenance

–This report gives a list of the items that have a status of “down for maintenace” define file womain = access wo_main,set cr_transaction=fa_main:fa_work_order_transaction, generic where fa_main:fa_status= “DM” list/domain=”FA_MAIN” /nobanner/title = “Equipment Down for Maintenance” fa_main:al_location/heading=”Loc”/noduplicates rc_inv_no/heading = “Rental-Class” fa_ref_no/heading = “Fixed-Asset” fa_name/heading = “Name” womain:cr_contract/heading=”Work-Order#” sorted by fa_main:al_location/newlines=2 fa_key

On Yard Report – Individual

*/This report will show individual Fixed Assets and if they should be on yard, or are on a WO, or are currently on a contract (not a reservation or bid)/* where   ( fa_main:fa_status <> “SO”  and fa_main:fa_type= “I”) list/domain=”fa_main”/nobanner/title = “On Yard Report – Individual Items On Contract, On Work Order or On Yard”   fa_main:fr_group […]

Fixed Assets Purchased or Sold in Date Range

Report that shows all fixed assets that have been purchased or sold within a specific date range by location, rental class, and equipment group. /*============================= DOCUMENTATION ====================================*\ Name: fa_purch_sold.eq Overview: Fixed Asset Purchase Report — Selects equipment based on these selection criteria: equipment name, equipment type, status CHANGE HISTORY Author Date Comment —————————– ——– ————————————- […]

Equipment On-Rent on a Given Date

Report Output Example: *********************************************************************************************************** define date STDDATE = parameter prompt “Enter Date to Report On ” ; string addr = if cr_main:cr_job_address_1>”” and cr_job_address_1<>”SAME” then cr_job_address_1 else cs_main:cs_address_1 string city = if cr_main:cr_job_city>”” then cr_job_city else cs_main:cs_city string state = if cr_main:cr_job_state>”” then cr_job_state else cs_main:al_st_code where ( cr_fixat:cr_actual_in_date >= STDDATE ) and ( cr_out_date <= […]

Percentage Time Utilization LTD & YTD

If you would like to know the percentage of time Individual Rental equipment has been on-rent (both this year and since you purchased it), run the following report (NOTE:You must have run the “Update Rent Utilization” (on the Fixed Asset ‘Action’ pull-dwon menu) for all months since the purchase of the equipment for this report to […]

Percentage of Rental Fleet by Current Status / Location

The following report will show the value of your rental fleet that is Out on Rent, In (but in maintenance) and In (available for rent) define string stat[ 3 ] = if fa_main:cr_contract_on_rent>0 then “OUT” else”IN”; define string state[ 20 ] = if stat=”IN” and fa_main:fa_status=”DM” then “IN – MAINTENANCE” else if stat=”IN” and fa_main:fa_status=”CU” then “IN – AVAILABLE” else “OUT ON RENT”; define string tot_by = parameter/prompt =”TOTAL BY?” valid “FLEET”,”GROUP” default “GROUP”; define string […]