Knowledge base

Find Off-Rent Number by Customer / Date

define number cust=parameter/prompt=”Enter Customer Key Number to Search “ define date begdt=parameter/prompt=”Enter Beginning Off-Rent Date to Search “ define date enddt=parameter/prompt=”Enter Ending Off-Rent Date to Search “ where cr_main:cs_key=cust and cr_fixat:cr_off_rent_no<>0 and cr_fixat:cr_actual_in_date>=begdt and cr_fixat:cr_actual_in_date<=enddt list/domain=”cr_fixat”/nobanner/title=”OFF-RENT NUMBERS BY CUSTOMER” cs_main:cs_name/heading=”CUSTOMER NAME”/noduplicates cr_main:cr_contract cr_fixat:fa_key/heading=”ASSET#” fa_main:fa_name cr_fixat:cr_off_rent_no/heading=”OFFRENT-NUMBER”/nocommas cr_fixat:cr_actual_in_date/heading=”OFFRENT-DATE”/mask=”mm/dd/yy” cr_fixat:cr_actual_in_time/heading=”OFFRENT-TIME” sorted by cr_main:cr_contract/newlines cr_fixat:cr_fseq top of page begdt/heading=”FROM”/newline/mask=”mm/dd/yy” […]

May 21, 2020

Earnings by Business Type for the Last Three Years

Report Output Example: *********************************************************************************************************** /*The following report totals rental earnings and sales earnings for the last three years by business type:*/ define file csbscod = access cs_bscod, set cs_bscod:cs_business_type = cs_main:cs_business_type; where year(cr_main:cr_date_fully_allocated) >= year(todaysdate)-3 sum/title=”Earnings by Business Type for the Last Three Years” /domain=”cr_main” cr_totls:cr_rental/heading=”Rental Earnings” cr_totls:cr_sales_taxable+cr_sales_nontaxable+cr_other_taxable+cr_other_nontaxable /heading=”Sales Earnings” across cr_main:cr_date_fully_allocated/heading=” “/year by cs_main:cs_business_type/heading=”Business […]

Delivery report sorted by Date and Delivery Area

Report Output Example: *********************************************************************************************************** /*From Glenn at Durant’s Tents & Events This report sorts all delivered contracts and reservations by date range and zipcode.*/ /*=============================DOCUMENTATION================================* Name: CR_DLVRY Overview: Domain File: Ext Files: CHANGE HISTORY Author              Date     Comment ——————- ——– ———————————————— Ian Dudley          03/10/05 STR 40215 suppress displayonly notes *=========================END OF DOCUMENTATION=============================*/ define Ascii Date from_date […]

Credit Invoice by Date Range

Report Output Example: ********************************************************************************************************** /* Report to show credit invoices for a given date range – sorted by location and date */ define date date1 = parameter prompt “Enter Starting Date” ; date date2 = parameter prompt “Enter Ending Date” ; string creditloc = parameter prompt “Enter Location (#A for all)” default “#A” ; file […]

Credit Card Audit Report

Report Output Example: ******************************************************************************************************************************************************************************** /*Credit Card Audit Report looks for any credits to tickets via credit card within a date range, then prints all the payments taken on those tickets so that you can ensure that credits are being done to the correct card numbers. */ define date begindt=parameter/prompt=”Enter Beginning Date to Report ” define […]

Contracts Written or Converted by Date Range

Report Output Example: *********************************************************************************************************** define date begindt=parameter/prompt=”Enter Beginning Date to Report” default todaysdate-1; define date enddt=parameter/prompt=”Enter Ending Date to Report” default todaysdate-1; where ( cr_log:cr_ticket_prev_status <> “CONTRACT” ) and ( cr_ticket_curr_status = “CONTRACT” ) and cr_log_entry_date >=begindt and cr_log_entry_date <=enddt list/domain=”cr_fixat”/nobanner/title=”NEW & CONVERTED CONTRACTS” cr_main:cr_contract cr_main:cr_reservation cs_main:cs_name cr_main:cr_job_name cr_main:cr_job_address_1 cr_fixat:fa_key fa_main:fa_name cr_fixat:cr_quantity/nototal sorted by cr_main:cr_contract […]

Open Tickets by Customer

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 rcinvno[4] = pad(cr_fixat:rc_inv_no,” […]

Tickets by Venue

define number venue = parameter /prompt =”Enter Venue Key “; string rcinvno[ 4 ] = pad(cr_fixat:rc_inv_no,” “); string l_padded_key[ 20 ] = pad(rcinvno+cr_fixat:fa_ref_no, ” “); std_trans l_trans = cr_main:cr_transaction; string Loc[ 3 ] = parameter/cls/line=10/uppercase prompt ” Enter Store Location or #A for all locations ” ; ascii date from_date = parameter/cls/line=11 prompt ” Enter […]

Open Tickets Report by Rental Class

/* Overview: Reports Open Bids/Quotes, Reservations, Contracts, or All and allows for a search by Rental Class or All ——————- ——– ————————————————  */ 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 […]

FA Commitment Report with ExtAmt and Equipment Substitute Name

Report Output Example: ********************************************************************************************************** /* FA Commitment Report with ExtAmt and Equipment Substitute Name CR_RCCOM – FIXED ASSEST COMMITMENT REPORT Overview: Display Rental equipment associated with an open ticket with the extended net amount for each item and the substitute name for the equipment if there was a substitute name. */ define file crmain= access […]