Knowledge base

Equipment Currently Off-Rent by Location

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

May 21, 2020

Off-Rent History Report

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

Stranded Ticket Report

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

Tickets at one Venue

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

RC History Report with Ext AMT and Equipment substitute names

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

Open Reservations and Contracts by Customer with Amounts

define   number key2 = parameter prompt “Enter Customer Key to Report” ;     where   ( cr_main:cr_trans_type one of “C”, “R” )   and ( cr_contract_closed = “N” )   and ( cs_key = key2 )   list/domain=”cr_main”/nobanner/title=”Open Reservations and Contracts by Customer”   cr_main:cr_reservation   cr_main:cr_contract   cr_main:al_location     cr_main:cr_open_date   cr_main:cr_out_date […]

Contract Detail by Date Range and Customer

Report Output Example: ********************************************************************************************************** define date indt = parameter prompt “Enter Beginning Date to Report” ; date edt = parameter prompt “Enter Ending Date to Report” ; number key2 = parameter prompt “Enter Customer Key” ; file sale = access sl_name_t, set sl_name_t:sl_mfg_cat_no=cr_sales:sl_mfg_cat_no where ( cr_main:cr_in_due_date >= indt ) and ( cr_main:cr_in_due_date <= edt ) […]

Annual Events by Year

Report Output Example: ************************************************************************************************** –define number MonthPar = parameter/prompt=”Enter Month (1-12): ” define number YearPar = parameter/prompt=”Enter Year (YYYY): ” define string Loc[3]= parameter/prompt=”Enter store location or #A for all stores: “/uppercase define file wkdeflt = access wk_deflt, set wk_def_set = “1”, generic where cr_main:cr_annual_event = “Y” and (trun(loc) = “#A” or trun(cr_main:al_location) = trun(loc)) […]

Tickets with Refunds Due to Cash Customers

where cs_main:cs_type_code=”CA” list/domain=”cr_main”/nodetail/noblanklines/noreporttotals/title =”Refund Due Report”   cr_main:cr_transaction/heading =”BID” /name = “c1”   cr_main:cr_contract /name = “c2”   cs_main:cs_name /name = “C3”   cr_main:cr_job_name /name = “C5”   cr_main:cr_open_date /name =”C6″   cr_main:cr_in_due_date /name = “C7”   cr_totls:cr_ticket_total/heading = “PAYMENT-AMOUNT” /name = “C8”   cr_finpy:cr_paymt_amount/heading=”TICKET-AMOUNT” /name = “C9”  cr_totls:cr_ticket_total/HEADING =”REFUND-AMOUNT”/name =”C10″   sorted by   […]

Credit Tickets by Date Range

Report Output Example: *********************************************************************************************************** define date begin = parameter/prompt = “Enter Beginning Date” define date enddt = parameter/prompt = “Enter Ending Date” where cr_main:cr_open_date>=begin and cr_in_due_date<=enddt and cr_totls:cr_ticket_total<0 and cr_main:cr_trans_type <> “D” list/domain=”cr_main”/nobanner/title=”Credit Tickets for Date Range” cs_main:cs_key/heading = “Key” /dup cs_main:cs_name/heading=”Name”/name=”c3″/dup if cr_main:cr_trans_type =”Q” then {“B-“+str(cr_main:cr_transaction)/heading=”CONT -RES -BID “/width = 4} else if cr_main:cr_trans_type […]