Knowledge base

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

May 21, 2020

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

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

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

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

find rc_main not with rc_main:rc_inv_no = fa_main:rc_inv_no list/domain=”rc_main”/title = “Rental Classes with no Fixed Asset Record”/nobanner   rc_main:rc_inv_no   rc_name_t:rc_name

where   ( rc_main:rc_sme_tax = “N” )   and ( fa_main:fa_status <> “SO” )   list/domain=”fa_main”/nobanner/Title=”Items Which Do NOT Charge ADDL/SME tax”   fa_main:fr_group/noduplicates   fr_group:fr_group_desc   fa_main:fa_key   fa_main:fa_name   fa_main:fa_type   fa_main:fa_status   fa_main:al_location   fa_main:fa_serial_no   rc_main:rc_sme_tax/duplicates    

where   ( rc_main:rc_sme_tax = “Y” )   and ( fa_main:fa_status <> “SO” )   list/domain=”fa_main”/nobanner/Title=”Items Which Do Charge ADDL/SME tax”   fa_main:fr_group/noduplicates   fr_group:fr_group_desc   fa_main:fa_key   fa_main:fa_name   fa_main:fa_type   fa_main:fa_status   fa_main:al_location   fa_main:fa_serial_no   rc_main:rc_sme_tax/duplicates   sorted by   fa_main:fr_group

Kits a Rental Class is On define   string RC = parameter /prompt =”Rental Class”/uppercase ;   where   rc_reltd:rel_rc_inv_no = RC     and rc_reltd:rc_kit_related =”K” list/title= “Kits a Rental Class is On” /domain=”rc_reltd”/nobanner rc_name:rc_inv_no/heading=”KIT RC” rc_name fr_group sorted by rc_name:rc_inv_no top of page RC/heading=”For Rental Class”

This report shows Will Call Tickets for a given date range: define file name= access rc_name, set rc_name:rc_inv_no =             cr_fixat:rc_inv_no, generic define file slname= access sl_name, set sl_name:sl_mfg_cat_no =             cr_sales:sl_mfg_cat_no, generic define file param = access al_param, set     al_location = cr_main:al_location define file cust = access cs_main, set     cs_key = cr_main:cs_key […]