Knowledge base

— UPDATED 12/6/16 to add initial purchase and last rental define number cutoffmos = parameter prompt “Enter number months not rented” valid if cutoffmos > 0 define date cutoff = date(str(dateadd(todaysdate,-1*cutoffmos,0),”MM/01/YYYY”)) define file firstpurch = access fa_purch, set rc_inv_no=fa_main:rc_inv_no, fa_ref_no=fa_main:fa_ref_no,    one to one, using first index, generic define file lastrent = access fa_hist, set […]

May 21, 2020

Report Output Example: ************************************************************** where cr_fixat:cr_trans_status = “P” list /nobanner/title= “OFF RENT, NOT CHECKED IN” cr_main:cr_contract cr_fixat:rc_inv_no

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

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