DOWNLOAD Sharp POS UTILITY Service Manual ↓ Size: 1.94 MB | Pages: 42 in PDF or view online for FREE

8

These options control what data is extracted from the ECR.

There are three choices for calling sales back into a file.  The file used has  a
default name supplied by 

which is made up of the date, ECR Number

and either an 'X' or a 'Z'.  The file is a comma delimited text file and has an
extension of 'CSV'.   This file will be placed into the directory where the current
database is.  This can be accessed using a text editor, spreadsheet or database.
Whilst in 

 this file can be opened with a text editor from the File Menu.

Each line of the file has the same number of fields.  This has been done to simplify
Importing and manipulation of the data to other programs.  Because of this feature,
some lines will have blank fields.  Appended to the start of each line is the system
date when the sales were called, followed by a number representing the Type of
Sales.  A list of these types can also be found in a text file called
'SalesRecordTypes.txt' supplied with 

.   The fields in the Sales File are;

Date (DD/MM/YYYY)
Type
Clerk/Cashier Number
Code (PLU, EAN, Dept, Transaction, Hour)
Description
Qty 1
Dlrs 1
Qty 2
Dlrs 2
Qty 3
Dlrs 3

N.B. The quantity shown for PLU, EAN and Department sales will include the
decimal places set with the SRV 906 Job.  If 3 decimal places are set, a sale of
1 item will show as 1000!  The 3 Qty and Dlrs (Dollars) fields are for sales up to
3 price levels.  If the Type of sale only supports one price level, this will be
shown under Qty 1 and Dlrs 1.  The ER-A750, ER-A770 and UP-3300 handle
sales in a different way from other ECR's.  For these ECR's the column between
the type and Qty1 will have the price level of the sold item.  In this case only
Qty1 and Dlr1 will be used and there will be no description for the sold PLU.
Other ECR's will have a '0' in this column and the sales at different levels will be
in the Qty1 and Dlr1 to Qty3 and Qty3.

The Types are;

(1) PLUs & EANs

(2) Departments

(3) Transactions & Finalising Keys

See list below for transaction types.

9

(4) Hourly Sales

The number appearing in field three of the hourly sales records relates to the
'Memory Type'.  This is the number of periods since Midnight.  This period is 15
Minutes for a 12 Hour System and 30 Minutes for a 24 Hour System.  e.g. 11 on
a 12 Hour System would be the period from 2:30am to 2:45am.

(5) Clerks

Sales are by Clerk number and transaction number.  See list below for
transaction types.

(6) Cashiers

Sales are by Cashier number and transaction number.  See list below for
transaction types.

The following numbers, relating to the type of transaction, appear in field four of
Type 3 and Type 5 Sales.  The list shown is not a complete list of all the
transaction types.

1001 = %1
1002 = %2
1003 = %3
1004 = %4
1201 = (-)1
1202 = (-)2
1203 = (-)3
1204 = (-)4
2001 = TAXABLE SUB-TOTAL 1
3001 = NET 1
3002 = NET 2
3100 = ORDER TOTAL
3200 = PAID TOTAL
3600 = NON-COMMISSION SALE
4000 = REFUND
4001 = RETURN
4100 = VOID
4101 = VOID 2
4200 = VOID MODE
4300 = MANAGER VOID
4400 = SUB-TOTAL VOID
5000 = CUSTOMERS
5100 = NO SALE
6000 = PREVIOUS BALANCE
6001 = PREVIOUS BALANCE 2 (DRIVE THRU)
6100 = NEW BALANCE
6101 = NEW BALANCE 2 (DRIVE THRU)
7001 = CASH 1
7002 = CASH 2
7100 = CASH IN DRAWER
7200 = CASH/CHIT IN DRAWER
8001 = CHEQUE 1

10

8002 = CHEQUE 2
8003 = CHEQUE 3
8004 = CHEQUE 4
8100 = CHITS IN DRAWER
9001 = CREDIT 1
9002 = CREDIT 2
9003 = CREDIT 3
9004 = CREDIT 4
9005 = CREDIT 5
9006 = CREDIT 6
9007 = CREDIT 7
9008 = CREDIT 8
A101 = CHARGE
D001 = RECEIVED ON ACCOUNT 1
D002 = RECEIVED ON ACCOUNT 2
D101 = PAID OUT 1
D102 = PAID OUT 2

•

This selection calls sales but does not clear any totals in the ECR.  NB. The
Term File sales are not collected by 

.  You are prompted for a

filename to save the sales to.  The default filename offered is
YYYYMMDD[ECR#]X.CSV.  If the file exists, you be asked to confirm
overwriting the existing one.  If Term Files exist in the register, then 

will perform an X2, otherwise an X1.

•

This option calls sales and then CLEARS the totals in the ECR.  NB. The Term
File sales are not collected OR cleared by 

.  You are prompted for a

filename to save the sales to.  The default filename offered is
YYYYMMDD[ECR#]Z.CSV.  If the file exists, you be asked to confirm overwriting
the existing one.  On ECR's which support GLU's (Guest Look Ups), if there are
open GLU's, then depending on the SRV setting of Job 929 Clerk Sales cannot
be cleared.  To be able to Clear Clerk Sales while there are open GLU's, Job
929-B must be set to a 1 or 3.  On ECR's that won't allow 

 to clear the

Clerk Sales, an error message will be displayed, giving you the choice of
Finalising the open GLU's and Retrying, or Cancelling the clearing of Clerk
sales.  If Term Files exist in the register, then 

 will perform a Z2,

otherwise a Z1.

•

This is the default option here.

One of the most useful features of 

 is its ability to Retrieve Data from the

ECR and store it in the database for editing and resending.  There are four possible
options here.  All the RAM Data can be retrieved for sending to another ECR, or for
saving the ECR configuration.  FDS Data can be uploaded on its own, but as this is
normally handled automatically by 

,

the only time you would do this if you

know the ECR File Structure has been changed.  Register Data can either include
or exclude the PLU/EAN and Department Data.  The Register Data contains, Direct
Keys, Free Keys, Function Text, FDS Data and ECR Logo.  Data for ALL the

11

configured registers is held in the 

 Database.  See Managing Databases

for information on keeping multiple copies of the Database.

•

Ticks all the CheckBoxes on the ECR Files tab, as well as PLU's, EAN's and
Departments on the Products tab, for retrieval from the ECR.

•

Ticks all the CheckBoxes on the ECR Files tab, but nothing on the Products
tab, for retrieval from the ECR.

•

This is the default option here.

You can retrieve the following files from the ECR, as well as those described above.

•

Get FDS data from the ECR.  This is not normally needed, as the FDS data is
updated as required by 

.  The obvious time to use this is if you have

changed the File Structure of the ECR.  Use this option if you change the file
structure of an ECR, otherwise you will experience problems sending
PLU/EAN/Department Data.

•

This data is not editable, but can be saved in the current database with other files
for the ECR.