Knowledge base

— list version (for items like a NOTE where it could be anything)   define string which_rc = parameter/uppercase prompt “Enter an RC #” define date begdate = parameter/prompt=”Enter beginning date “ define date enddate = parameter/prompt=”Enter ending date “ define file crfrlck = access cr_frlck, set cr_transaction=cr_fixat:cr_transaction,    cr_item=cr_fixat:fa_key,    cr_item_id=cr_fixat:cr_item_id, generic   where […]

May 21, 2020

Report Output Example: ********************************************************************************************************* define file name= access rc_name, set rc_name:rc_inv_no =   cr_fixat:rc_inv_no, generic   define file crtotls = access cr_totls, set cr_totls:cr_transaction = cr_main:cr_transaction, 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 = […]

— sum version    (for items like a MISC INFLATABLE where it is — more than likely one of a handful) define string which_rc = parameter/uppercase prompt “Enter an RC #” define date begdate = parameter/prompt=”Enter beginning date “ define date enddate = parameter/prompt=”Enter ending date “ define file crfrlck = access cr_frlck, set cr_transaction=cr_fixat:cr_transaction, […]

Report Output Example: ****************************************************************************************************************************************************************************** /* List of web request that have been converted to tickets with ticket totals by date */ define file crmain1 = access cr_main, set cr_transaction = cr_web:cr_transaction, one to one file crtotls1= access cr_totls, set cr_transaction= cr_web:cr_transaction, one to one std_date begdate=parameter/prompt=”Enter Beginning Date to Report ” std_date enddate=parameter/prompt=”Enter Ending Date […]

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 define file name= access rc_name, set rc_name:rc_inv_no =   cr_fixat:rc_inv_no, generic define file crtotls = access cr_totls, set cr_totls:cr_transaction = cr_main:cr_transaction, generic define file slname= access sl_name, set sl_name:sl_mfg_cat_no = cr_sales:sl_mfg_cat_no, generic define string Loc[3] = parameter/cls/line = […]

Report Output Example: ****************************************************************************************************************** /* Report lists all rental equipment current out that have been called offrent */ define string runloc[3] = parameter/prompt=”Enter Location to Report or ALL for all locations”/uppercase default “ALL”; where cr_fixat:cr_off_rent_no>0 and cr_trans_status=”P” and (cr_main:al_location=runloc or runloc=”ALL”) list/nobanner/domain=”cr_fixat”/title=”OFF-RENT RENTAL EQUIPMENT” cr_main:cr_contract cs_main:cs_name[1,25] cr_main:cr_job_address_1/heading=”JOB ADDRESS” cr_job_city/heading=”CITY” cr_fixat:fa_key/heading=”ITEM” fa_main:fa_name[1,30]/heading=”DESCRIPTION” cr_fixat:cr_off_rent_no/heading=”OFF-RENT#”/nocommas cr_fixat:cr_actual_in_date/mask=”mm/dd/yy”/heading=”OFF-RENT-DATE” sorted by […]

/* Report lists all Off-Rent requests by off-rent number range */ define number lownum = parameter/prompt=”Enter Lowest Off-Rent Number to report” default 1; define number highnum = parameter/prompt=”Enter Highest Off-Rent Number to report” default 999999; where cr_fixat:cr_off_rent_no>=lownum and cr_off_rent_no<=highnum list/nobanner/domain=”cr_fixat”/title=”OFF-RENT REQUESTS” cr_fixat:cr_off_rent_no/heading=”OFF-RENT#”/nocommas/noduplicates cr_main:cr_contract cs_main:cs_name[1,25] cr_main:cr_job_address_1/heading=”JOB ADDRESS” cr_job_city/heading=”CITY” cr_main:cr_contract_closed/heading=”CLOSED?” cr_fixat:fa_key/heading=”ITEM” fa_main:fa_name[1,30]/heading=”DESCRIPTION” cr_fixat:cr_actual_in_date/mask=”mm/dd/yy”/heading=”OFF-RENT-DATE” sorted by cr_fixat:cr_off_rent_no cr_actual_in_date […]

/* Displays tickets in Stranded Ticket list along with info from their     Saved copies (if any) by clerk  */ define file crmain = access cr_main, set cr_transaction=wk_mnshd:cr_transaction, generic define file wktotls = access wk_totls, set cr_transaction=wk_mnshd:cr_transaction, generic define file crtotls = access cr_totls, set cr_transaction=wk_mnshd:cr_transaction, generic define file wkcsmain = access cs_main, set cs_key=wk_mnshd:cs_key, […]

/* The following report will list all tickets at a given venue number for a date range */ Define number venno = parameter/prompt=”Enter Venue Number to Report “ define date begdate = parameter/prompt=”Enter Beginning Event Date to Report “ define date enddate = parameter/prompt=”Enter Ending Event Date to Report “ define string compltd = parameter/prompt=” […]

Rental Class History report (cr_rchis) with substitute names listed and the extended amount. define file crmain= access cr_main,                     set cr_main:cr_transaction = cr_fixat:cr_transaction,                     generic define file csmain= access cs_main, set cs_main:cs_key = crmain:cs_key, exact define file famain = access fa_main, set fa_main:rc_inv_no = cr_fixat:rc_inv_no,                                          fa_main:fa_ref_no = cr_fixat:fa_ref_no,                                          exact   Define string num[4]=parameter/cls/prompt=”Enter the equipment […]