Knowledge base

Maintenance History by Asset for a Date Range

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

May 21, 2020

Internal Repair Costs for Date Range

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

Fixed Assets that do not have a Purchase record

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

Fixed Assets owned by one store, sold by another

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

Exchanged and Other Free Fixed Assets

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

Equipment On-Rent at a Store Other than its ‘Current’…

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

Equipment Maintenance History

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

Detailed Report on One Asset

Report Output Example: ***************************************************************************************************** define file maint_code = access fa_mncod, set fa_mncod:fa_maint_type_code = fa_maint:fa_maint_type_code; string sold_key = parameter prompt “ENTER FIXED ASSET KEY NUMBER (xxxxxxxx) ” ; where ( fa_main:fa_key = sold_key ) list/nototals/duplicates/domain=”fa_main”/nobanner/pagelength=80/title=”DETAILED ASSET REPORT” fa_main:fr_group/heading=”GR” fa_main:fa_key/heading=”ITEM” fa_main:fa_name/noheading fa_main:fs_vendor/heading=”VENDOR” fa_main:fs_manufacturer/heading=”MFG” fa_main:fa_catalog_no/heading=”MFG CAT #” fa_main:fa_model_no/heading=”MODEL” fa_main:fa_serial_no/heading=”SERIAL #”/newline=2 “MTD RENTS” fa_main:fa_mtd_util/noheading/column=15 “EARNINGS”/column=28 fa_main:fa_mtd_earnings/noheading/column=35/newline “YTD RENTS” fa_main:fa_ytd_util/noheading/column=15 […]

CURRENT INDIVIDUAL ASSETS BY LOCATION WITH IN/OUT STATUS

define file crmain=access cr_main, set cr_contract=fa_main:cr_contract_on_rent, generic define file csmain=access cs_main, set cs_key=crmain:cs_key, generic define string stat[3]= if fa_main:cr_contract_on_rent>0 then “OUT” else “IN” where fa_main:fa_type=”I” and fa_status one of “CU”,”DM” list/nobanner/domain=”fa_main”/title=”CURRENT INDIVIDUAL ASSETS BY LOCATION” fa_main:al_location fa_key/heading=”ASSET” fa_name fa_purch:fa_purch_amt/heading=”PURCHASE-PRICE” fa_main:fa_status/heading=”CURRENT-STATUS” stat/heading=”IN-OUT” if stat=”OUT” then { fa_main:cr_contract_on_rent/heading=”CONTRACT” csmain:cs_name/heading=”CUSTOMER NAME” crmain:cr_job_name, cr_job_address, cr_job_city } sorted by fa_main:al_location/newpage/total/heading=”LOCATION” […]

Sales Purchasing Analysis report

–#Sales Purchasing Analysis report that shows  –#on-hand quantities, costs, reorder info –# and monthly sales from this and last year define string num[20]=parameter/cls/line=10/prompt=”Enter the manufacturer number, ALL for all”/uppercase default “ALL” define string categ[3]=parameter/cls/line=10/prompt=”Enter the Sales Item Category or ALL for all”/uppercase default “ALL” define string loc[3]= parameter/cls/line=10/prompt=”Enter Location or #A for All”/uppercase default “100”; […]