Knowledge base

list/nobanner/title = “Replacement Cost/Selling Price for Rental Items” fa_main:fr_group fa_key fa_name fa_status fa_type al_location fa_replace_cost fa_selling_price sorted by fa_status/newlines fa_main:fr_group fa_name

May 21, 2020

Report Output Example: ****************************************************************** find fa_main not with fa_main:fr_group = fr_group:fr_group list/title = “Fixed Assets With Deleted Groups”/nobanner fa_main:rc_inv_no/heading = “RC#” fa_ref_no/heading = “FA#” fa_name:fa_name fa_main:fr_group

/*    – FIXED ASSEST COUNT SHEET Overview: Selects equipment based on these selection criteria: equipment name, equipment type, status, Change History: Author            Date                Comment Jessica Flint     Sept. 15, 1993 NC1 converted fa_slist into count sheet                                                           */ define string grvar[2]=parameter/cls/line=10/prompt=”Enter the group number, #A for All “/uppercase default “#A” define string rcvar[4]=parameter/cls/line=10/prompt=”Enter the rental class […]

define file fawrkty = access fa_wrkty, set fa_wrkty:form_no = fa_frmcd:form_no, one to many, generic; file fawrkpa = access fa_wrkpa, set fa_wrkpa:form_no = fa_frmcd:form_no, set fa_wrkpa:work_type = fawrkty:work_type, one to many, generic; file fawktyc = access fa_wktyc, set work_type = fawrkty:work_type, generic file famchcd = access fa_mchcd, set mechanic_code=fawrkty:mechanic_code, generic file slnamet = access sl_name_t, set […]

list/domain=”cs_job”/nobanner/title=”JOB / PO ADDRESSES, ZIP CODES AND TAX CODES” cs_job:cs_key cs_main:cs_name cs_job:cs_project_po cs_job_name cs_job_address_1/heading=”JOB-ADDRESS” cs_job:cs_job_city cs_job_state cs_job_zip st_tax_area sorted by cs_main:cs_name/newlines cs_job:cs_project_po

Report Output Example: ************************************************************************************************* /*This report will list all customers who currently have unapplied payments. It does not include customers with unapplied credit invoices:*/ where cs_pymt:cs_pallocated < cs_pamount list/domain=”cs_pymt”/nobanner/title=”UNAPPLIED PAYMENTS ON ACCOUNTS” cs_main:cs_key cs_name cs_pymt:cs_check cs_payment_date cs_pmt_type cs_pamount/heading=”PAYMENT-AMOUNT” cs_pallocated/heading=”AMOUNT-APPLIED” sorted by cs_pymt:cs_key cs_check

Report Output Example: ******************************************************************************************************* where cs_main:cs_status=”O” and (cs_main:cs_discount<>0 or cs_sales_discount<>0) list/nobanner/title=”DISCOUNTED CUSTOMERS” cs_main:cs_key cs_name cs_setup_date cs_type_code cs_discount/heading=”RENTAL-DISCOUNT” cs_sales_discount/heading=”SALES-DISCOUNT” cs_ytd_sales cs_ltd_sales cs_bal:cs_curr_balance sorted by cs_main:cs_name

Report Output Example: *********************************************************************************************************** define number zipbegin = parameter/prompt=”Enter Beginning Zip Code to Include ” define number zipend = parameter/prompt=”Enter Ending Zip Code to Include” define string custtype=parameter/prompt=”Enter Customer Type to Include (#A = All) “/uppercase default “#A” define string z5 = cs_main:al_zipcode[1,5] define file zip5 = access al_zipcd, set al_zip5 = z5, generic where […]

Report Output Example: ******************************************************************************************************************************************************************************* /*The following report lists all customers that show a credit balance on the main customer screen in Alert. If your end of day is not running, this report may not be correct for all customers: */ where cs_bal:cs_curr_balance < 0.00 list/domain=”cs_bal”/nobanner/title=”CUSTOMERS WITH CREDIT BALANCES” cs_bal:cs_key cs_main:cs_name cs_bal:cs_curr_balance cs_accr_balance cs_last_pmt_amt cs_last_pmt_date cs_last_pmt_check […]

Report Output Example: ******************************************************************************************************************************************************************************** /*The following report will list all customers who have done less than $100 in business (due to finance charges etc) this calendar year, and whose last closed contract is dated during the last calendar year. It gives customer names and contact information for the purposes of mailers or similar marketing.*/ where […]