Knowledge base

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

May 21, 2020

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

Report Output Example: *************************************************************************************************** define number ticket_num = switch(cr_main:cr_trans_type) case “C” : cr_main:cr_contract case “R” : cr_main:cr_reservation default  : cr_main:cr_transaction; where cr_main:cr_contract_closed = “N” and cr_main:al_location <> fa_main:al_location and fa_main:fa_type = “I” list/duplicates/title=”Equipment On-Rent at a Store Other than its ‘Current’ Location”/domain=”cr_fixat” cr_main:cr_trans_type ticket_num/nototal cr_fixat:rc_inv_no cr_fixat:fa_ref_no fa_main:fa_name fa_main:al_location/heading=”FA-CURRENT-LOCATION” cr_main:al_location/heading=”TICKET-LOCATION” sorted by cr_fixat:rc_inv_no cr_fixat:fa_ref_no

Report Output Example: *********************************************************************************************************** /*The following report will list the maintenance history for a single Fixed Asset*/ define string famntnote = parameter prompt “Enter FA Key (8-digits, no dashes) ” ; where ( wo_main:fa_key = famntnote ) list/domain=”wo_main”/nobanner/title=”EQUIPMENT MAINTENCE HISTORY” fa_main:fa_key/noduplicates fa_name fa_serial_no wo_main:cr_contract/heading=”MAINT-TICKET” wo_main:cr_comp_date/mask=”MM/DD/YY”/heading=”DATE” wo_type:work_type/dup fa_wktyc:work_type_description/dup sorted by wo_main:cr_comp_date cr_contract