Knowledge base

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

May 21, 2020

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

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

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