Knowledge base

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

May 21, 2020

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

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

Report Output Example: ************************************************************************************************************ define number contno = parameter/prompt=”Enter Contract Number” define file slnamet = access sl_name_t, set sl_mfg_cat_no=cr_cogs:sl_mfg_cat_no, generic where cr_main:cr_contract=contno list/nobanner/domain=”cr_main”/title=”COST OF GOODS SOLD BY TICKET” cr_main:cr_contract cs_main:cs_name/heading=”CUSTOMER NAME” cr_cogs:sl_mfg_cat_no slnamet:sl_name cr_cogs:cr_sl_quantity/heading=”QUANTITY”/nototal cr_sl_price/heading=”UNIT-PRICE”/nototal cr_cogs:sl_stand_item_cost/heading=”UNIT-COST”/nototal cr_sl_ext_amt_net/heading=”EXTENDED-PRICE” (cr_cogs:cr_sl_quantity * sl_stand_item_cost)/heading=”EXTENDED-COST” (cr_sl_ext_amt_net – (cr_cogs:cr_sl_quantity * sl_stand_item_cost))/heading=”PROFIT” sorted by cr_transaction sl_mfg_cat_no

/*==================DOCUMENTATION========================*\ Name: Resale_P – This is a SUM REPORT by resale item. This report will give you a total sum reserved for sell – between the dates selected. – This report displays CURRENT QTY ON HAND, SELL QTY, CATEGORY, and RESALE ITEM NAME – This report will show you the customer name on the reservation. […]

/*====================DOCUMENTATION=======================*\ Name: Resale_L – This is a LIST REPORT by resale item. This report will give you all the reservation numbers – that have the resale item going out depending on the date range you have selected. – This report will give you the CURRENT QTY ON HAND, not qty on hand after the reservations. […]

Below is a report to compare customer discount with the ticket discount to see if the sales staff is providing additional discounting.     define   string nmj = parameter prompt “Enter Location” ;   date blfgk = parameter prompt “Enter Start Date” ;   date gklss = parameter prompt “Enter End Date” ;   where […]

Use the following report to get a list of billings for a given contract number: define number origtckt = parameter/prompt=”Enter Original Contract Number “ file crmain9 = access cr_main, set cr_transaction=cr_log:new_cr_transaction, exact file crtotls = access cr_totls, set cr_transaction=cr_log:new_cr_transaction, exact file csmain = access cs_main, set cs_key=cr_main:cs_key, generic where cr_main:cr_contract=origtckt and cr_log:cr_trans_stat one of “RB”,”AB” […]