Knowledge base

"Monies Collected at Different Stores" with detailed breakdown

Report Output Example: ************************************************************************************************ The “MONIES COLLECTED AT DIFFERENT STORES” report that runs with the Daily Transactions Listing report for multi-store operations doesn’t provide a detailed breakdown of the method of payment for each amount, making it hard to balance the cash drawer if there is a lot of interstore payments due.  The following report replaces the […]

May 21, 2020

Counter General Ledger Postings by Date & GL Account

Report Output Example: *********************************************************************************************************************************** define std_date begindt = parameter/prompt=”Enter Beginning Date to Report ” define std_date enddt = parameter/prompt=”Enter Ending Date to Report ” define string glacct = parameter/prompt=”Enter GL Account to Report ” default “#A” define file csmain_cr = access cs_main, set cs_key=cr_main:cs_key, generic define file csmain_wo = access cs_main, set cs_key=wo_main:cs_key, generic where […]

Report of tickets reverted back to Bids

/* The following report lists tickets that have been saved as Reservations or Contracts but have been switched back to Bids and saved */ define date begdate = parameter/prompt=”Enter beginning date to report “ define date enddate = parameter/prompt=”Enter ending date to report “ define string loc[3] = parameter/prompt=”Enter Store to report or ALL for […]

Clerk Activity Report (sum version)

—  this is a sum version of the clerk activity report define string location = parameter/cls/line=9/prompt=”Enter store location “/uppercase default “#A” define string clerk = parameter/cls/line=9/prompt=”Enter clerk “/uppercase default “#A” define date begin_date[8]=parameter/prompt=”Enter begin date ” default date(str(todaysdate,”MM/01/YY”)) define date end_date[8]=parameter/prompt=”Enter end date ” default todaysdate define file crmain = access cr_main, set cr_main:cr_transaction = […]

Cash Register Payment List that also breaks down the Credit Card…

Report Output Example: ********************************************************************************************************* /*=============================DOCUMENTATION================================* Name: CR_DLYPY Overview:  Daily received on account *=========================END OF DOCUMENTATION=============================*/ define ascii date bb=parameter/prompt=”Enter the starting date of counter payments to dump:” define ascii date end_date=parameter/prompt=”Enter the ending date of counter payments to dump:” define std_date business_date=bb define std_date to_date=end_date define string inccash[1]=parameter/prompt=”Include cash payments?” default “Y” define string inccheck[1]=parameter/prompt=”Include […]

Open Reservations Report with Ticket Total $$ Listed

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

Number of Contracts and Dollars by Day of Week

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

Look-up Ticket by Off-Rent Number

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

Items Available on Given Date

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

GL Accounts Posted to by Date

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