Knowledge base

Report Output Example: ************************************************************************************************************************* /*NOTE: This report compares the Credit Limit to the CURRENT Balance. If you prefer to compare against the ACCRUED balance, change the last field in the WHERE clause to ‘cs_bal:cs_accr_balance’*/ where cs_main:cs_credit_limit>0 and cs_main:cs_credit_limit<cs_bal:cs_curr_balance list/nobanner/domain=”cs_main”/title=”CUSTOMERS OVER THEIR CREDIT LIMITS” cs_main:cs_key cs_name cs_credit_limit cs_bal:cs_curr_balance cs_accr_balance cs_main:cs_contact cs_phone_1/heading=”PHONE” sorted by cs_main:cs_name

May 21, 2020

Report Output Example: ********************************************************************************************************** /* Report lists all customers who have LTD $ great than a given input who have had a last contract date between given input dates */ define number ltdsales = parameter prompt “Enter lowest LTD $” ; date STDT = parameter prompt “Enter starting last contract date” ; date EDDT = […]

Report Output Example: ********************************************************************************************************** where cs_main:cs_contact_method one of “F”,”X” and cs_phone_2<1 or cs_main:cs_contact_method one of “E”,”Z” and cs_email_address=”” or cs_main:cs_ap_contact_method one of “F”,”X” and cs_ap_fax<1 or cs_main:cs_ap_contact_method one of “E”,”Z” and cs_ap_email=”” list/nobanner/domain=”cs_main”/title=”CUSTOMER ACCOUNTS WITH CONTACT METHOD ISSUES” cs_key cs_name cs_contact_method/heading=”ACCOUNT-CONTACT-METHOD” cs_main:cs_phone_2/heading=”ACCOUNT-FAX-NUMBER” cs_email_address/heading=”ACCOUNT-EMAIL-ADDRESS” cs_main:cs_ap_contact_method/heading=”AP-CONTACT-METHOD” cs_ap_fax/heading=”AP-FAX-NUMBER” cs_main:cs_ap_email/heading=”AP-EMAIL-ADDRESS” sorted by cs_name

Report Output Example: *************************************************************************************************** /*The following report lists Credit Memos Posted to the system over a selected date range: */ define date beg=parameter/prompt=”Beginning Date” define date end_date=parameter/prompt=”Ending Date” where cs_pymt:cs_ppost_date>=beg and cs_pymt:cs_ppost_date<=end_date and cs_pymt:cs_pmt_type =”CM” list/domain=”cs_pymt”/title=”CREDIT MEMOS POSTED”/nobanner cs_main:cs_key/duplicates cs_main:cs_name/duplicates cs_pymt:cs_check/heading=”CREDIT-MEMO” cs_pymt:cs_payment_date cs_pymt:cs_pamount/heading=”CREDIT-AMOUNT” cs_pymt:cs_ppost_date/heading=”POSTING-DATE” cs_pymt:gl_acct sorted by cs_payment_date/newlines cs_check top of page beg/heading=”START DATE “/newline […]

Report Output Example: ****************************************************************************************************************** where cs_main:cs_credit_limit<cs_bal:cs_accr_balance and cs_main:cs_type_code[1]=”A” list/domain=”cs_main”/nobanner/title=”AR CUSTOMERS WITH ACCRUED BALANCES OVER THEIR CREDIT LIMIT” cs_main:cs_key cs_name cs_credit_limit cs_bal:cs_curr_balance cs_accr_balance cs_main:cs_contact cs_phone_1 sorted by cs_main:cs_name

/*============================= DOCUMENTATION ========================================== # Name: RC_RATEB # # # ALERT Easy*Pro ™ # Copyright by Interactive Management Systems, Inc # Use of this software is by license only, see license agreement for # conditions of useage. # Overview: Display Rental Rates based on rate field selection. # # # Domain File: RC_NAME # Ext Files: […]

find rc_main not with rc_main:fr_group = fr_group:fr_group list/title = “Rental Classes With Deleted Groups”/nobanner rc_main:rc_inv_no/heading = “RC#” rc_name_t:rc_name rc_main:fr_group

　 find rc_main with rc_main:rc_kit = “Y” and not with any rc_reltd:rc_kit_related = “K” list/nobanner/domain = “rc_main”/title = ” Rental Class Kits with no Parts” rc_main:rc_inv_no/heading = “Rental Class” rc_name_t:rc_name/nohead

Report Output Example: *********************************************************************************** –enter date range for the most recent year to report, will go back 5 years from there. –Date Range Can NOT span years – so starting and ending date must have same year. define std_date st_date = parameter/prompt=”Enter the Starting Date”/cls define std_date e_date = parameter/prompt=”Enter the Ending Date” define std_date […]

/*This report can be saved in custom as cr_rchis to get substitute names on your rental class contract history report from Alert/* /* CR_RCHIS – FIXED ASSEST CONTRACT HISTORY RECORD Overview: Display Rental equipment associated with an open ticket */ define file crmain= access cr_main, set cr_main:cr_transaction = cr_fixat:cr_transaction, generic define file csmain= access cs_main, […]