Description

At various times without warning you get and
error something like “/usr/cqcs/cs xxxx Memory Fault – Core Dump” where
xxxx is a different number each time (e.g. 2403 2592)

Solution

There is a memory corruption on the server.
Cold boot the server and try again. If the error continues contact the
ALERT Help Desk.

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 standard cr_trnfr.eq to give this detail.  All you need to do is save it in your custom directory as cr_trnfr

— cr_trnfr.eq – Monies Collected at Other Loc – Detailed

define string Loc[3] = parameter/cls/line = 10/prompt = “Enter Store Location or #A for all locations “/uppercase

define Ascii Date ll_date = parameter/cls/line = 10/prompt = “Please Enter Reporting Date :”

define STD_DATE l_date = ll_date

define file cust_name = access cs_main, set cs_key=cr_main:cs_key

define file parm2=access al_param, set al_param:al_location = al_line:al_location, exact

define std_amt owed=if cr_finpy:al_location<>al_line:al_location then cr_finpy:cr_paymt_amount

else 0

where (cr_finpy:cr_pay_type=”CA” or cr_finpy:cr_pay_type=”CK” or
cr_finpy:cr_pay_type=”CC”) and cr_finpy:cr_fdate=l_date and
owed<>0

list/domain=”cr_finpy”/title=”MONIES COLLECTED AT DIFFERENT STORES – DETAIL”/nobanner

parm2:al_loc_desc[1,15]/heading=”DUE FROM:”/nodup

al_param:al_loc_desc[1,15]/heading=”DUE TO:”/duplicates

cr_main:cr_trans_type cr_contract cr_reservation

cust_name:cs_name[1,15]

owed

cr_finpy:cr_pay_type

sorted by cr_main:al_location parm2:al_location/total cr_finpy:cr_transaction

top of page

l_date/mask=”mm/dd/yy”/heading=”Report Date”/newline

Description

Sometimes I want to just print what is on the screen. How do I do that?

Solution

Bring up the desired screen image. Hold down the Alt key and press the
PrtSC (or PrintScreen) key Open Miscrosoft Word or Wordpad Paste the
image into Word/Wordpad by clicking on Edit and then Paste or by
holding down the Ctrl key and pressing v You can now print this screen
image to any printer that is available to your PC workstation.

Description

Connection to the server goes down while they
are working on
a ticket. When the connection cames back and they try to retrieve the
ticket out of Stranded they get an error “Record In Use” (as seen at
Johnson’s Handy Rent-All)

Solution

The original user session is still running
and is holding the records open. Find the session with who -u or ps -ef
| grep csrun. Kill the session with kill -9 process_id_number (where
process_id_number is the process ID number of the stranded process).

Description

We would like to clean up the Sales item data base change. What problems will we encounter? I know we can delete a sales item but how does this effect Life to Date $ and or turns?

Solution

When you discontinue selling an item there are several steps you can take to stop it from being sold any more. They include: In the Sales Inquiry/Update screen change field 7 “For Sale” to N. This will not let anyone sell it again. However it will still show up on the Sales Selection screen at the counter and will show on all reports. In the Sales Inquiry/Update screen go to F4 Common Name. Delete all of the entries except sequence #0. Using F6 Change insert a couple periods or tildes (~) in front of the name (e.g. ‘Air Filter’ becomes ‘~~~Air Filter). This will move the entry to the end of the alphabetic search list so it is not easy to find to sell. However it can still be sold (unless you do step #1 above as well) and it will still show on all reports. You can delete Sales items from the system completely. If they have EVER been sold you will have to use the option “Delete Sales Items – No Check”. However if you do delete them the following will occur: All Sales History and Earnings reports will no longer include this item even when run for a date that the item was sold. This will make it impossible to reconcile your Sales Reports to your Counter Financial Reports If an old contract that contained this item is pulled up and/or printed there will be a sale shown with no description. In addition if the number of a deleted Sales item is reused for a new item when old contracts containing the deleted item are pulled up and/or printed they will show the New item’s description. If you delete an item and then re-add it (under either a new or the original number) there is no way to re-enter the earnings history so be very careful if choosing to delete items. Instead you can just renumber a Sales item (i.e. change its Manufacturers Catalogue Number) very easily. On the Sales File Maintenance menu select the option “Global Manufacturer # Change”. Put in the current Manufacturers Catalogue Number and the desired new number and then press F8 Run. This will change the Sales item as well as all tickets (old and current) that it has been on.

If your workstation (usually on a laptop) is setup to go into
“Sleep” or “Hibernate” mode after a period of time it can cause
problems with Alert on that workstation.

When your computer goes to Sleep or into Hibernate mode the
connection to the server is shut down.  The server will see this as a
log out of the workstation and will terminate the Alert session on the
server.  When you “wake up” your workstation there will be nothing on
the server for your Alert session to connect to and it will appear to
be dead.

The solutions are:
1) Shut off the hibernate and sleep modes on
your computer so that the connection isn’t lost (or increase the time
required before these start so that they don’t occur while you are
running Alert
2) If your computer goes to sleep or hibernates when
you bring it back up kill the previous Alert session through Task
Manager and then log back into Alert.

/*All bids, reservations, contracts  and work orders started from “scratch” during the time frame, even if there was no reservation deposit paid.*/

define date start = parameter/prompt = “Enter Start date for Fiscal Year”

define date enddt = parameter/prompt = “Enter End Date for Fiscal Year” default start +364

where cr_log:cr_ticket_prev_status = “NEW” and cr_log:cr_log_date >=start and cr_log:cr_log_date <= enddt

sum/nobanner/noreporttotals

cr_log:units/heading = “Number of Quotes Issued”

by start/heading=”FROM”/width=8 enddt/heading=”TO”/width=8/newpage

/*Any order type that ended up being a contract and was closed in the date range and generated revenue. */ 

/*Plus bids and reservations opened in the date range, even with an event date outside the date range if a reservation deposit was paid in the date range. */

define date start = parameter/prompt = “Enter Start date for Fiscal Year”

define date enddt = parameter/prompt = “Enter End Date for Fiscal Year” default start +364

define file crmain = access cr_main, set cr_transaction=cr_log:cr_transaction, generic

define file crfinpy = access cr_finpy, set cr_transaction=cr_log:cr_transaction, generic

define file csmain = access cs_main, set cs_key=crmain:cs_key, generic

define file womain = access wo_main, set cr_transaction=cr_log:cr_transaction, generic

define file wofinpy = access cr_finpy, set cr_transaction=cr_log:cr_transaction, generic

define file wsmain = access cs_main, set cs_key=womain:cs_key, generic

define file crtotls = access cr_totls, set cr_transaction=cr_log:cr_transaction, generic

define number RENTALS = if cr_log:cr_log_date>=start and cr_log:cr_log_date<=enddt

and cr_log:cr_ticket_prev_status=”NEW” and crtotls:cr_ticket_total>0

and crmain:cr_trans_type one of “R”,”C”

and ((crmain:cr_contract_closed=”Y” and cr_trans_type=”C” and cr_in_due_date<=enddt)

or(csmain:cs_type_code<>“AR” and crmain:cr_in_due_date>=enddt

and crfinpy:cr_paymt_amount>0 and crfinpy:cr_fdate<=enddt)

or (csmain:cs_type_code=”AR” and crmain:cr_in_due_date>=enddt)) then 1 else 0

define number WORKORDERS = if cr_log:cr_log_date>=start and cr_log:cr_log_date<=enddt

and cr_log:cr_ticket_prev_status=”NEW” and crtotls:wo_grand_total>0

and womain:fa_key=”” then 1 else 0

sum/nobanner/nototals/domain=”cr_log”/title=”Number of Quotes Won”

RENTALS

WORKORDERS

by start/heading=”FROM”/width=8 enddt/heading=”TO”/width=8/newpage

/* This report will count the number of invoiced customers, defined as any ticket posted to AR or FC.*/

define date start = parameter/prompt = “Enter Start date for Fiscal Year”

define date enddt = parameter/prompt = “Enter End Date for Fiscal Year” default start +364

define file crmain = access cr_main, set cs_key=cs_main:cs_key, generic

define file crfinpy = access cr_finpy, set cr_transaction=crmain:cr_transaction, generic

define file womain = access wo_main, set cs_key=cs_main:cs_key, generic

define file wofinpy = access cr_finpy, set cr_transaction=crmain:cr_transaction, generic

where (crfinpy:cr_pay_type one of “AR”,”FC” and cr_fdate>=start and cr_fdate<=enddt) or

(wofinpy:cr_pay_type one of “AR”,”FC” and cr_fdate>=start and cr_fdate<=enddt)

sum/nobanner/nototals/domain=”cs_main”

cs_main:units/heading = “Number of Invoiced Customers”

by start/heading=”FROM”/width=8 enddt/heading=”TO”/width=8/newpage

/*Completed transactions during the time period with a value > $0.00 (regardless of when they were originally started). */

define date start = parameter/prompt = “Enter Start date for Fiscal Year”

define date enddt = parameter/prompt = “Enter End Date for Fiscal Year” default start +364

define file crmain = access cr_main, set cr_contract=cs_inv:cs_invoice, generic

define file crtot = access cr_totls, set cr_transaction=crmain:cr_transaction, generic

define number RENTALS = if cs_inv:cs_icreate_date>=start and cs_inv:cs_icreate_date<=enddt and cr_trans_type="C" and
cs_iamount>0 and crtot:cr_rental > 0 then 1 else 0

define number RETAIL = if cs_inv:cs_icreate_date>=start and cs_inv:cs_icreate_date<=enddt and cr_trans_type="C" and
cs_iamount>0 and crtot:cr_rental = 0 then 1 else 0

define number WORKORDERS = if cs_inv:cs_icreate_date>=start and cs_inv:cs_icreate_date<=enddt and cr_trans_type="W" and
cs_iamount>0 then 1 else 0

sum/nobanner/nototals/domain=”cs_inv”/title=”Number of Transactions Completed”

RENTALS

RETAIL

WORKORDERS

by start/heading=”FROM”/mask=”mm/dd/yy” enddt/heading=”TO”/mask=”mm/dd/yy”/newpage