Knowledge base

*/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 […]

May 21, 2020

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 —————————– ——– ————————————- […]

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 <= […]

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 […]

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 […]

define date begindt = parameter/prompt=”Enter Beginning Date to Include “ define date enddt = parameter/prompt=”Enter Ending Date to Include “ where fa_maint:fa_mdate>=begindt and fa_mdate<=enddt list/nobanner/domain=”fa_maint”/title=”INTERNAL MAINTENANCE COSTS” fa_main:fa_key fa_name fa_maint:fa_mdate/heading=”DATE”/mask=”MM/DD/YY” fa_maint:fa_maint_ticket fa_maint_type_code fa_maint_cost fs_vendor sorted by fa_maint:fa_key/total fa_mdate

define ascii date from_date = parameter/cls prompt ” Enter Beginning Date ” ; ascii date to_date = parameter/line=3 prompt ” Enter Ending Date ” ; string Loc[ 3 ] = parameter/line=5/uppercase prompt ” Enter Store Location or #A for all locations ” ; where cr_fiall:cr_fdate >= from_date and cr_fiall:cr_fdate <= to_date and (trun(cr_fiall:al_location)= trun(Loc) or […]

From Glenn at Durant’s Tents and Events This report summarizes all FIXED assets that do not have a purchase record. find fa_main not with fa_main:fa_key=fa_purch:fa_key and not with fa_main:fa_status = “SO” list/domain=”fa_main”/nobanner/title=”Fixed Assets Without Purchase Records” fa_main:fa_key fa_name fa_type fa_status al_location

define date stdt = parameter prompt “Enter a starting date” define date enddt = parameter prompt “Enter an ending date” define string rc[4] = cr_sales:sl_mfg_cat_no[4,7] define string fa[4] = cr_sales:sl_mfg_cat_no[8,11] define file crmain = access cr_main, set cr_main:cr_transaction = cr_sales:cr_transaction, many to one, exact define file famain = access fa_main, set fa_main:rc_inv_no = rc, fa_main:fa_ref_no […]

In Alert v9.0 and below, it isn’t possible to positively identify Fixed Assets that were exchanged off of ticket.  However, the following report will find all the individual Fixed Assets that charged nothing yet were not in a kit..  Most of these should be items that were removed from the ticket throught Exchanges. define date […]