Knowledge base

List of Same-Day Delivery and Pick Up

define Ascii Date from_date = parameter/cls/line=11/prompt=”Enter Beginning Date> “ define Ascii Date to_date = parameter/line=12/prompt=”Enter Ending Date   > “ WHERE       cr_main:cr_contract_closed <> “Y” and       cr_main:cr_trans_type one of “R”,”C” and                   (cr_main:cr_pickup = “Y” and            cr_fixat:cr_in_due_date >= from_date and            cr_fixat:cr_in_due_date <= to_date )  and   (cr_main:cr_delivery = “Y”        and cr_main:cr_out_date >= […]

May 21, 2020

Back Posted Tickets

Report Output Example: ********************************************************************************************************* define date indt = parameter/prompt=”Enter Date Back Posted To (Last Day of Month)” define date fom = indt – day(indt) + 1 define date  eom = dateadd(fom,1) – 1 define file csmain = access cs_main, set cs_main:cs_key = cr_main:cs_key, generic where cr_log:cr_trans_stat = “BP” and cr_log:cr_log_date= eom list/nobanner/title = “Back Posting […]

Damage Waiver Report – breaks out exempt/non-exempt rental

Report Output Example: ********************************************************************************************************* define file rcmain = access rc_main, set rc_main:rc_inv_no = cr_fixat:rc_inv_no, exact; number dwrent = if rcmain:rc_waiver=”Y” then cr_fixat:cr_extended_amt_net else 0; number nodwrent = if rcmain:rc_waiver=”N” then cr_fixat:cr_extended_amt_net else 0; date begdate = parameter/prompt=”Enter Beginning Date to Report” date enddate = parameter/prompt=”Enter Ending Date to Report” where cr_main:cr_trans_type=”C” and cr_main:cr_contract_closed=”Y” and cr_main:cr_in_due_date>=begdate […]

Missed Rental with Date and Time Info

define file misdesc =  access cr_missc, set cr_missed_rental_code= cr_miss:cr_missed_rental_code, generic define file misname = access cr_missn, set cr_missn:cr_missed_rental_no=cr_miss:cr_missed_rental_no, set cr_missn:cr_nseq = cr_miss:cr_nseq, one to one, generic define date stdt = parameter/prompt = “Enter Starting Date” define date endt = parameter/prompt = “Enter Ending Date”   where cr_miss:cr_missed_date >= stdt and cr_miss:cr_missed_date <= endt list/nobanner/title = […]

DHE Tax Collected on Rental- EC1 (Texas)

Report Output Example: ****************************************************************************************************************************** define date indt = parameter prompt “Enter the Date to Begin Reporting” ; date endd = parameter prompt “Enter Ending Date to Report” ; define file crfialle1=access cr_fiall, set cr_Fiall:cr_transaction = cr_main:cr_transaction, set cr_ftrans_type = “E1”, one to one, generic –file alparam = access al_param, set al_param:al_location = cr_main:al_location, generic define […]

DHE Tax Collected on Rental -EC2 (Texas)

Report Output Example: ********************************************************************************************************** define date indt = parameter prompt “Enter the Date to Begin Reporting” ; date endd = parameter prompt “Enter Ending Date to Report” ; file alparam = access al_param, set al_param:al_location = cr_main:al_location, generic where ( cr_main:cr_in_due_date >= indt ) and ( cr_main:cr_in_due_date <= endd ) and ( cr_main:cr_contract_closed = “Y” […]

Fleet Status by Group / Location

/* This report summarizes Individual Rental Fleet by group by status (Out on rent, In and Available, In but Down for Maintenance) */ define string rptloc = parameter/prompt=”Enter Location or ALL ” default “ALL”; string stat[ 3 ] = if fa_main:cr_contract_on_rent>0 then “OUT” else”IN”; string state[ 20 ] = if stat=”IN” and fa_main:fa_status=”DM” then “IN […]

Credit Invoices and Work Orders by Clerk

Report Output Example: ********************************************************************************************************* /*Lists credit invoices and credit work orders by clerk and date range. */ define date begdate=parameter/prompt=”Enter Beginning Date to Report ” define date enddate=parameter/prompt=”Enter Ending Date to Report ” define string ttype[1] = if cr_totls:wo_grand_total<0 then “W” else “C” define number ticketno = if cr_totls:wo_grand_total<0 then wo_main:cr_contract else cr_main:cr_contract define string […]

Open Tickets with Job Address

–Open Tickets with Job Address 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 […]

Fixed Asset Contract Earnings Report

Fixed Asset Contract Earnings Report by the billed date range /* 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, set cs_main:cs_key = crmain:cs_key, exact define file famain = access fa_main, set […]