Knowledge base

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

May 21, 2020

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

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

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

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

–Tickets by Customer Business Type 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 date begindt = parameter/prompt=”Enter Beginning Date “; define date enddt = parameter/prompt=”Enter End Date”; define file famain= access fa_main, set fa_main:rc_inv_no = cr_fixat:rc_inv_no, set fa_main:fa_ref_no = cr_fixat:fa_ref_no, generic   where    cr_main:cr_contract_closed = “N” and    cr_main:cr_out_date >=begindt and    cr_main:cr_out_date<= enddt    and famain:fa_status =  “IA”   list /domain=”cr_fixat”/nobanner/title = “Inactive Items on […]

define   number key2 = parameter prompt “Enter Customer Key to Report” ;     where   ( cr_main:cr_trans_type <> “D” )   and ( cr_contract_closed = “N” )   and ( cs_key = key2 )   list/domain=”cr_sales”/nobanner/title=”Sales Items on Open Tickets by Customer”   cr_main:cr_transaction/heading =”BID”   cr_main:cr_contract   cr_main:al_location   cr_sales:sl_mfg_cat_no/heading=”MFG-CAT NO”   […]

Report Output Example: ********************************************************************************************************* /*========DOCUMENTATION=============* Name: CR_OPENC Overview: Reports Open Contract Domain File: Ext Files: CHANGE HISTORY Author Date Comment ——————- ——– ————————————– Jean-Pierre Chastagnol 29 Nov 93 Ian Dudley 03/10/05 STR 40215 suppress display only notes Susan Russo 02/15/08 Added Ticket total NC1 08/31/12 Custom to pull by job # *==============END OF DOCUMENTATION============*/ define […]

Report Output Example: ****************************************************************************************************************** /*The following report shows counter ticket activitiy in cronological order over a given date range for a given employee:*/ define date begindt=parameter/prompt=”Enter Beginning Date to Report ” define date enddt = parameter/prompt=”Enter Ending Date to Report ” define string inits[3]=parameter/prompt=”Enter Employee Initials to Report (#A = All)”/uppercase define number tckt = […]