Knowledge base

Credit Memos Posted

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

May 21, 2020

AR Customers with Accrued Balances Over Their Credit Limits

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

Rate Book #2 Without Common Names

/*============================= 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: […]

Rental Classes wtih Deleted Groups

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

Rental Class Kits with no Parts

　 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

FA Earnings by Group 5 Year Comparison

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

Rental Class Contract Earnings Report with Substitue Names

/*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, […]

Active Kits with Inactive Parts

Report Output Example: ********************************************************************************************************* define file rcmain = access rc_main, set rc_inv_no=rc_reltd:rel_rc_inv_no, generic define file rcname = access rc_name_t, set rc_name_t:rc_inv_no = rc_reltd:rc_inv_no, generic define file rcname2 = access rc_name_t, set rc_inv_no=rc_reltd:rel_rc_inv_no, generic define file famain = access fa_main, set fa_main:rc_inv_no=rc_reltd:rel_rc_inv_no, generic define file sls = access sl_main, set sl_main:sl_mfg_cat_no=rc_reltd:sl_mfg_cat_no, generic define file slsname =access […]

Rental Classes marked as kits and their kit parts

define file rcnamet=access rc_name_t, set rc_inv_no=rc_reltd:rel_rc_inv_no, generic where ( rc_main:rc_kit = “Y” ) list/domain=”rc_main”/nobanner rc_main:rc_inv_no/heading=”KIT-NO” rc_name_t:rc_name/heading=”KIT NAME” rc_reltd:rel_rc_inv_no/heading=”PART#” rcnamet:rc_name/heading=”COMPONENT NAME” /dup rc_reltd:rc_quantity rc_reltd:rc_kit_related sorted by rc_main:rc_inv_no/newline rc_reltd:rc_seq

Active Rental Classes with Turn Around Time

Report Output Example: ************************************************************************ where rc_main:rc_turn_around_hours>0 and rc_rental_class_active = “Y” list /nobanner/title= “Active Rental Classes wtih Turn Around Time” rc_inv_no/heading = “RC” rc_name_t:rc_name/nohead rc_main:rc_turn_around_hours