Knowledge base

The following report is a customized version of cr_openr.eq that includes a display of the Estimated Ticket Total Dollar Value (which can be useful in doing financial projections): /*=============================DOCUMENTATION================================*\ Name: CR_OPENR Overview: Reports Open Reservations An open reservation is defined as A transaction with – A non zero reservation number – A status of “R” […]

May 21, 2020

This report shows the number of tickets closed and the dollar value by day of week: 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_curr_status=”CLOSED” and cr_ticket_prev_status<>”CLOSED” and cr_main:cr_contract_closed=”Y” and cr_in_due_date>=begindt and cr_in_due_date<=enddt and cr_log:cr_trans_stat […]

define number offrt=parameter/prompt=”Enter Off-Rent Number to Report “ where cr_fixat:cr_off_rent_no=offrt list/domain=”cr_fixat”/nobanner cr_main:cr_contract cs_main:cs_name/heading=”CUSTOMER NAME” cr_fixat:fa_key/heading=”ASSET#” fa_main:fa_name cr_fixat:cr_actual_in_date/heading=”OFFRENT-DATE”/mask=”mm/dd/yy” cr_fixat:cr_actual_in_time/heading=”OFFRENT-TIME” top of page offrt/heading=”REPORT FOR OFF-RENT NUMBER”/nocommas

define std_date committed_date = parameter prompt “Enter a date ” default dateadd(12.01.0001,0,year(todaysdate) -1) define file commitments = access cr_avail, set cr_avail:rc_inv_no=fa_main:rc_inv_no, set cr_avail:fa_ref_no=fa_main:fa_ref_no, set cr_avail:cr_avail_date=committed_date, using first index, one to many, generic define file fablkst = access fa_blkst, set fa_blkst:rc_inv_no=fa_main:rc_inv_no, set fa_blkst:fa_ref_no=fa_main:fa_ref_no, using first index, one to one, generic where fa_main:fa_status one of “CU” list/domain=”fa_main” […]

The following report shows the contracts that generated postings at the counter to a given GL account over a specifid date range: define string glacct[6] = parameter/prompt = “Enter GL Account, #A for ALL “/uppercase define std_date begdate=parameter/prompt=”Enter Beginning Date to Report “ define std_date enddate=parameter/prompt=”Enter Ending Date to Report “ define number ticketno= if cr_main:cr_trans_type=”R” […]

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

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

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

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

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