Knowledge base

Rental Classes with no Fixed Asset Record

find rc_main not with rc_main:rc_inv_no = fa_main:rc_inv_no list/domain=”rc_main”/title = “Rental Classes with no Fixed Asset Record”/nobanner   rc_main:rc_inv_no   rc_name_t:rc_name

May 21, 2020

Items which do NOT charge ADDL/SME tax

where   ( rc_main:rc_sme_tax = “N” )   and ( fa_main:fa_status <> “SO” )   list/domain=”fa_main”/nobanner/Title=”Items Which Do NOT Charge ADDL/SME tax”   fa_main:fr_group/noduplicates   fr_group:fr_group_desc   fa_main:fa_key   fa_main:fa_name   fa_main:fa_type   fa_main:fa_status   fa_main:al_location   fa_main:fa_serial_no   rc_main:rc_sme_tax/duplicates    

Items which Charge ADDL/SME tax

where   ( rc_main:rc_sme_tax = “Y” )   and ( fa_main:fa_status <> “SO” )   list/domain=”fa_main”/nobanner/Title=”Items Which Do Charge ADDL/SME tax”   fa_main:fr_group/noduplicates   fr_group:fr_group_desc   fa_main:fa_key   fa_main:fa_name   fa_main:fa_type   fa_main:fa_status   fa_main:al_location   fa_main:fa_serial_no   rc_main:rc_sme_tax/duplicates   sorted by   fa_main:fr_group

Kits a Rental Class is On

Kits a Rental Class is On define   string RC = parameter /prompt =”Rental Class”/uppercase ;   where   rc_reltd:rel_rc_inv_no = RC     and rc_reltd:rc_kit_related =”K” list/title= “Kits a Rental Class is On” /domain=”rc_reltd”/nobanner rc_name:rc_inv_no/heading=”KIT RC” rc_name fr_group sorted by rc_name:rc_inv_no top of page RC/heading=”For Rental Class”

Will Call List

This report shows Will Call Tickets for a given date range: define file name= access rc_name, set rc_name:rc_inv_no =             cr_fixat:rc_inv_no, generic define file slname= access sl_name, set sl_name:sl_mfg_cat_no =             cr_sales:sl_mfg_cat_no, generic 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 […]

Tickets Opened by Hour By Day of Week

Want to know what times of day you write the most contracts?  What days you write the most contracts?  Run this report: define date begindt=parameter/prompt=”Enter Beginning Date to Report “ define date enddt = parameter/prompt=”Enter Ending Date to Report “ define file crtot = access cr_totls, set cr_transaction=cr_log:cr_transaction, approximate where cr_log:cr_ticket_prev_status=”NEW”    and cr_main:cr_open_date>=begindt   […]

Tickets Opened By Clerk – Summary

Summary of all tickets started by clerk by current ticket status with ticket total dollars: define date begindt=parameter/prompt=”Enter Beginning Date to Report “ define date enddt = parameter/prompt=”Enter Ending Date to Report “ define file crtot = access cr_totls, set cr_transaction=cr_log:cr_transaction, approximate where cr_log:cr_ticket_prev_status=”NEW” and cr_main:cr_open_date>=begindt and cr_open_date<=enddt and cr_log:cr_trans_stat not one of “RB”,”AB” and […]

Tickets Opened by Clerk – Detailed

List of all tickets started by clerk with current ticket status and ticket total dollars: 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 “/uppercase define number tckt = if cr_main:cr_trans_type=”C” then cr_contract    else if cr_main:cr_trans_type=”R” then cr_reservation    else cr_transaction […]

Prior Year Contracts Report

To get a list of contracts closed over a period of time in descending order of total contract amount, run the following: define date begindt=parameter/prompt=”Enter the Beginning Date to Report ” default todaysdate – 365 define date enddate=parameter/prompt=”Enter the Ending Date to Report ” default todaysdate – 334 define number tvalue = parameter/prompt=”Enter Minumum Ticket […]

Price Changes Made to Rental and Sales Items by Date Range

define   date edate1 = parameter prompt “Enter Start Date” ;   date edate2 = parameter prompt “Enter End Date” ;   file csmain = access cs_main, set cs_main:cs_key = cr_main:cs_key; where ( cr_excpt:cr_ex_date >= edate1 and cr_ex_date <= edate2 )   and ( cr_exception_code one of “SLSPRCTYCH”, “RNTLRTTYCH”, “FNLADJSLS”, “FNLADJRNT”, “GLBLTCKDSC” ) list/duplicates/domain=”cr_excpt”/nobanner   […]