Knowledge base

Average Ticket Total for each AR customer in the last 12 months

Report Output Example: ******************************************************************************************************************************************** /*The following report shows the Number of TIckets and the Average Ticket Total for each AR customer who has does business with you in the last year:*/ where cs_inv:cs_icreate_date>=todaysdate-365 and cs_main:cs_type_code= “AR” and cs_ytd_sales> 0 sum/domain=”cs_inv”/nobanner/title= “AVE TICKET TOTAL FOR AR CUSTOMERS IN LAST 12 MONTHS” cs_inv:cs_iamount/heading=”TOTAL SALES” cs_iamount/average/heading=”AVERAGE SALE” cs_inv:units/heading=”NUMBER […]

May 21, 2020

Average Ticket Revenue By Date By Location

Report Output Example: ********************************************************************************* /*The following report shows the average revenue generated by ticket by date by location:*/ define date begindt=parameter/prompt=”Enter beginning date : ” define date enddt = parameter/prompt=”Enter ending date : ” where cr_main:cr_in_due_date>=begindt and cr_in_due_date<=enddt sum/nobanner/title=”AVERAGE TICKET REVENUE BY DATE BY LOCATION”/domain=”cr_totls” cr_totls:units/heading=”#Tickets” cr_ticket_total/average/heading=”Average Ticket Total”/nototal across cr_main:al_location by cr_main:cr_in_due_date/heading=”Date”/mask=”mm-dd-yy”

Purchase Order List Report (Summary) by Location

define std_date open_beg_date = parameter/prompt=”Beginning for Open Date” define std_date open_end_date = parameter/prompt=”Ending for Open Date” define std_date req_beg_date = parameter/prompt=”Beginning for Req Date” define std_date req_end_date = parameter/prompt=”Ending for Req Date” define string l_vendor[6] = parameter/prompt=”Vendor or #A for all” define string l_status[2] = parameter/prompt=”Status (Req/OpenPO/Closed or #A for all)” define string sort_by[1] = […]

Purchase Order List Report (Detail) by Location

define file slpodet = access sl_podet,                       set sl_po_req_no = sl_pohdr:sl_po_req_no, one to many, generic  — STR 13066 define file slnamet = access sl_name_t, set sl_mfg_cat_no =                       slpodet:sl_mfg_cat_no, one to one, generic define std_date open_beg_date = parameter/prompt=”Beginning for Open Date” define std_date open_end_date = parameter/prompt=”Ending for Open Date” define std_date req_beg_date = parameter/prompt=”Beginning for […]

Work Orders and Estimates by Serial Number

  define string serial = parameter/prompt = “Enter All or Part of Serial Number to Look Up” /uppercase where         wo_main:wo_ser_number contains serial list/nobanner/noreporttotals/domain=”wo_main”/pagelength=60/title=”Work Orders and Estimates by Serial #”   wo_main:cr_estimate/mask=”ZZZZZZZ9″/heading=”EST#”   wo_main:cr_contract/heading = “WO#”   wo_main:cs_key/mask=”ZZZZZ9″/heading=” CUST#”   cs_main:cs_name/duplicates/heading=” NAME”   wo_main:cr_open_date/width=8/heading=” ORD”     wo_main:rc_inv_no+”-“+fa_ref_no/heading=”    ITEM”   wo_main:wo_item_descr/heading=” DESC”   wo_main:wo_brand_model/heading=” […]

Total (#/$) Parts Used on Customer WO by Location and Date

define date begin_dt=parameter/prompt=”Beginning Sales Date: “ define date end_dt=parameter/prompt=” Ending Sales Date: “ define file alparam = access al_param, set al_location= wo_main:al_location , generic define string loc = parameter/prompt = “Enter Location” /uppercase where wo_main:al_location = loc and wo_main:cr_comp_date>=begin_dt and wo_main:cr_comp_date<=end_dt and cr_contract_closed= “Y” and wo_main:cs_key <> alparam:al_def_wo_cust sum/domain = “wo_parts”/nobanner/title=”Total of Parts Used on […]

Distributed Kits

Report Output Example: ******************************************************************************************************************************* –Finds Kits with earnings NOT posted to the Kit Header. define string loc[3]=parameter/prompt=”Enter the Location ID to check “/uppercase define file relrate = access rc_rate, set rc_inv_no=rc_reltd:rel_rc_inv_no, al_location=loc, rc_rate_type=”R”,   rc_rate_seq=0, generic define file relrcname = access rc_name_t, set rc_inv_no=rc_reltd:rel_rc_inv_no, generic where rc_main:rc_kit=”Y” and rc_assign_earning_to_header<>”Y” and rc_reltd:rel_rc_inv_no<>”” and rc_kit_related=”K” list/nobanner/domain=”rc_reltd”/title=”KITS THAT WANT TO […]

Kits Which WIll Fail to Distribute Earnings

–Each of the kit parts needs to have a Daily Rate  –or Post earnings to kit header. define string loc[3]=parameter/prompt=”Enter the Location ID to check “/uppercase define file relrate = access rc_rate, set rc_inv_no=rc_reltd:rel_rc_inv_no, al_location=loc, rc_rate_type=”R”,    rc_rate_seq=0, generic define file relrcname = access rc_name_t, set rc_inv_no=rc_reltd:rel_rc_inv_no, generic where rc_main:rc_kit=”Y” and rc_assign_earning_to_header<>”Y”    and rc_reltd:rel_rc_inv_no<>”” and […]

Print RC Rate Increase Screen

 /*This report will allow you to print any saved rates in the rate increase work screen before committing them*/ list/nobanner/title = “Proposed New Rates” rc_rttmp:fr_group /heading = “GR” rc_inv_no /heading = “RC” rc_name_t:rc_name rc_rttmp:al_location /heading = “LOC” rc_rent_term /heading = “MIN-RENT-TERM” rc_min_rent /heading = “MIN-RENT-AMOUNT” rc_hour_1 /heading = “1HR” rc_hour_4  /heading = “4HR” rc_hour_8  /heading […]

Individual Valuation Report with Purch info

FIXED ASSEST VALUATION LIST FOR INDIVIDUAL Items with Purchase Date Overview: Selects equipment based on these selection criteria: equipment name, equipment type=”I”, status, =============================================================================*/ define file alparam = access al_param, set al_param:al_location = fa_main:al_location, generic –define file fapurch = access fa_purch, set fa_purch:fa_key = fa_main:fa_key, one to many, generic define string num[4]=parameter/cls/prompt=”Enter the equipment number, […]