TRAINING MANUAL MODEL POS UTILITY
Contents Page No Description 2. 2. 3. 4. 4. 5,6 7. 7. 8.-12 13. 13. 14. 15. 16. 18. 19,20 21, 22, 23, 23,24,25 26,27 28, 29, 30, 31, 32.
Managing Databases There is only one database name supported by POSUtility, this is 'POSUtility.mdb'. This file must exist in the program directory (where POSUtility was installed), for POSUtility to start. If you wish to access multiple databases, use the Create Customer Database under the File Menu. This allows you to organise Folders under a starting path of \CUSTOMERS. This option creates the Folder and copies an empty 'POSUtility.mdb' to it.
ER-A750 and UP-3300 • If an ER-A750 or UP-3300, passes a Communications Test, but then fails doing other operations, or appears to stop for an extended length of time, check that a printer is configured but NOT physically attached to the ECR. The most common cause of this effect is the ECR trying to print to a Journal Printer without one being present.
If set to 'y' then the Reading (X) and Clearing (Z) options will access the Term Files. i.e. the readings will now be X2/Z2. The default is to do X1/Z1's. Obviously the Term Files must be configured in the ECR! ReportPrintControl = ? With this set, printing during a Z Read can be controlled. The default is Not to print. The options for ? here are; 0 = print on Receipt and Journal 1 = print on Receipt only 2 = print on Journal only 3 = no printing If the 'POSUtility.
• Delete Departments & Products from database Current ECR • The Register to be deleted. This is selected using the control on the form. Delete • Deletes the selected Register or Data Files. The data files are both the PLU/EAN Data and the Department Data. Cancel • Cancel this operation and exit the Delete Data form. Edit Register Logo This form displays the ECR Logo information. This can be up to 6 lines, the actual number of characters being determined by the ECR/Printer Type.
Current ECR • Information displayed is for this Register and Type Logo Lines • The six lines of the ECR Logo. Add • If the Logo hasn't been retrieved from the ECR, you can Add it for the current ECR. This option isn't available if there is already data. Edit • Edit the currently displayed Logo text.
• UP-3300 (PRS Scanning) POSUtility POSUtility was developed with the sole purpose of allowing users to easily duplicate and change SHARP ECR configurations. This means that Data from a current ECR needs to be RETRIEVED to the POSUtility Database before it can be edited and resent. This may be as simple as doing a Master Reset on the ECR and then retrieving all the data, or retrieving all the data from an ECR which is programmed the way you like.
Retrieve from Register options. These options control what data is extracted from the ECR. Calling Sales Options There are three choices for calling sales back into a file. The file used has a default name supplied by POSUtility 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.
(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.
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 X Read & Save to File • This selection calls sales but does not clear any totals in the ECR. NB. The Term File sales are not collected by POSUtility. You are prompted for a filename to save the sales to.
configured registers is held in the POSUtility Database. See Managing Databases for information on keeping multiple copies of the Database. Include Plu's & Dept's • 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. Exclude Plu's & Dept's • Ticks all the CheckBoxes on the ECR Files tab, but nothing on the Products tab, for retrieval from the ECR. Don't get register data • This is the default option here.
Direct Keys Auto Keys Touch Screen • This option is only applicable to the UP-3300. ECR RAM Image • Get ALL RAM data from the ECR. Please note this data is NOT EDITABLE! This option gets a complete memory image from the ECR. This image is unique to the Firmware (EPROM) Version installed in the ECR where the data was retreived from. Sending it to an ECR with a different version can cause the ECR to lock up. All RAM data is used to create a register identical to the source ECR including any sales.
About SharpLink... Copy Register Data This option allows copying various data files from one register to one or more of the same type. Source ECR This is the ECR that will have its selected data duplicated. If there is no data in the database for this ECR, the selection Checkbox will be greyed out.
Things to Copy If the checkboxes are greyed out, there is no data for this selection in the database (hasn't been retrieved), or the selected register doesn't support the selection. As some data can be copied across models (Condiments and PLU Menus), the list of Destination ECR's will change depending on the selections you make. Destination ECR(s) If there are any other ECR's in the database of the same type, then they will be displayed here. You can tick one or more of these.
Convert • Make the Change Current ECR Type • Will only display ECR's which are capable of being upgraded to SmartCard operation. Register • The ECR to be converted. Exit • Close the Change Type form. Register Communication Settings This is where you configure the settings for On-Line Communications. Each ECR has separate settings in the database. This form is used for a number of tasks; Sending, Retrieving and Exporting Data.
Baud Rate • The Baud Rate for ECR Communications is selected here. The range available is from 1200 to 38400 baud. The standard setting for Sharp ECR's is 9600. This corresponds to a 5 setting with the 6112 PGM2 Job. The ER-A750, ER-A770, UP600/700 and UP-3300 can communicate at up to 38400 baud. A setting of 19200 gives good results providing the cabling is not of excessive length and in a noisy (electrically), environment. Register Type • Select the type of the ECR.
Delete Register • Delete the currently selected register. Cancel • Cancel the form (exit). Add New Register • Add a new register to the database. Change Details • Change the details of the selected ECR. The Number and Type can't be changed. Firmware Version • Display the Firmware Version Information for the selected ECR if the firmware supports this feature.
Modem Setup Utility This Utility allows you to configure different modems to suit communicating with Sharp ECR's. Each setup can be stored in the database. After the Preamble, each String (1 to 3) and the Postamble there is a Carriage Return (except in the case of the Netcomm Factory Reset). NB The AT is added by the utility when sending to the modem, so please don't add it to any strings you enter.
Modem.
Auto Keys This form allows you to edit the Auto Sequencing Key information. There are 25 key sequences per Auto Key (the buttons labeled 1 to 25 on the form). The Auto keys must exist in the ECR before you can edit them on this form. To edit a sequence, use either; • The number keys 0 to 9, Z = 00, decimal point, X = multiply, S = SUBTOTAL, T = TL/CASH and I = INHIBIT. • Clicking on a sequence button will display a Free Key Function form for you to select available keys from.
Firmware Version Info Display firmware version information obtained from the selected register. This information is embedded in the firmware by the software developer. This is not supported in the standard Sharp ECR.
Modem Status This form is displayed while the modem is being dialed, providing some feedback from the process. Selecting Hangup will stop the dialing and disconnect the modem. Edit Products This Form allows Editing of the Product (PLU and EAN) Data. This data is global, which means it is common to all ECR's configured in POSUtility. This data can be entered here, or retrieved from an ECR. Obviously, if you retrieve the data from an ECR it will overwrite the data currently held in the database.
Cancel of the ESC buttons will cancel the Editing. Delete Print Cancel Close • Delete the selected Product. You will be asked to confirm the deletion. • A simple report can be sent to the printer. Note that if the extended Product Form is displayed, then each PLU will take up 7 lines on the paper - you could use a lot of paper if there are a lot of PLU's. • Cancel the current operation. Pressing the ESC button has the same effect. • Exit the Product Form.
Data grid (List) • This displays a list of Products from the database. These can be sorted by clicking on the Column Headings. The Column Heading Text will change to Blue to show the sort order. The Modified column identifies records which are new, or have been modified. This is used for the Send PLU Options. Key Colour • The Key Colour can be selected for ECR's which support this feature e.g. The UP3300. Condiment Programming • Settings for the PLU related to its use as a Condiment can be selected here.
Edit Departments This Form allows editing of the Department Data. This data is global, which means it is common to all ECR's configured in POSUtility. The data can be retrieved from an ECR or entered using this form. Obviously, if you retrieve the data from an ECR it will overwrite the data currently held in the database.
• Exit the Department form. Data Fields: Code • The Department Number between 1 and 99. This field cannot be blank or contain a duplicate. Description • The Department Description. If you leave it blank, you will be asked to confirm this. If you wish to use expanded characters (Double Size), do a 'SHIFT+^' before the character you want expanded. Note that this character takes up two places. Group • The Department Group. Valid Groups are between 1 and 17.
Tools Options available here are all destructive except the Compact Database. Please be careful. Compact Database • POSUtility being an ECR Maintenance Tool will create waste space in the Access Database which it uses. This is created by deleting data from it. To reclaim this space this option can be run. The active database is backed up before the compaction takes place. If the result is successful you will be notified. If it fails for some reason, then the backup will be restored.
TCP/IP Configuration File This menu allows viewing of the Log and Sales Files, Open a different Database and Exiting from the program. Open Log & Sales Files • Selecting this option will display the Open File Dialog. The two choices of file types available are 'TXT' and 'CSV'. The POSUtilityLog.txt is the Log File for the program and is also the default filename displayed. To view Sales Files, select 'CSV' as the file type. These files are by default opened with Notepad.
not supported in the export format. The format of the file to import is the same as the export file including the first record containing field names. Departments Export/Import • The Department Data export/import is similar to the Products. Exit • Close all files (except files opened through the above method) and exit the program. Edit Databases and Configuration Options. These buttons control access to the different areas of the POSUtility Database.
Progress The Progress Bar is displayed whenever ECR Communications is in progress. This gives you some indication of how long a Job will take. Also displayed, depending on what is being done, is a number of information messages. These will show the Product and Department Codes and Descriptions, what Sales are being read etc. Preceding the start of each Communications Session, POSUtility performs a 'Comms Test' (Shown as 'Comms Test' on the Main Form).
Edit Direct Keys Direct Keys refer to buttons which have a Department Number or PLU Number associated with them. These keys can also be referred to as 'Fast Keys' or 'Presets'. This screen shows the information that you would get from a PGM2 2119 Report. The actual Direct Keys are defined in Edit Free Keys. Editing of Direct Keys is not allowed on some ECR Types. The number of levels varies depending on ECR Type. POSUtility only allows editing of levels 1 to 3 eventhough some ECR's can have up to 10 levels.
Clicking the mouse in the Type Cell, will drop-down a selection list for the Level. On Level one, the available Types are; • PLU • Inhibited • Department On Level 2 and 3, the available Types are; • PLU • Inhibited N.B. The Key Type can also be changed by selecting the first letter of the type while in the cell. e.g. I = Inhibit, P = PLU, D = Department. If Inhibit is selected then the Value is set to 0.. The desired Department or PLU Number is entered in the Value Cell.
Close• Close the Direct Key form Edit Function Text This Form allows editing of the Function Text or 'Text Programming for Misc Keys'. Editing of 'Message Text' cannot be done by this version of POSUtility. Editing of Function Text is not available for all ECR Types. There are two columns on this form; ECR Original and Function Text. The ECR Original is as it has been retrieved from the ECR and cannot be changed. This is for your reference if you want to return some text to what is was before.
Current ECR • Information displayed is for this Register and Type. Close • Close the Function Text form. Edit Free Keys Free Keys refer to all the available types of keys that the ECR supports except the Receipt and Journal Feed keys. The information displayed here is a combination of the SRV 950 and 951 Reports. Similarly, the programming functions of the SRV 950 and 951 Jobs can be performed on this form. Note editing of Free Keys is not available for all ECR Types. N.B.
About POSUtility This form displays general information about POSUtility , where you can obtain support and other software for SHARP Cash Registers. System Info... • Show System Information for your computer. Ok • Close the About form. Send to Register options. These options control what data is sent to the ECR. You may select any number of these options for sending to the ECR with one exception -- Sending ALL RAM Data can only be done on its own.
exceeds the number the ECR is able to accept, then you will receive a notification message. Using this option sets the 'Modified Flag' on the PLU/EAN Record OFF. MODIFIED only • Modified PLU's and EAN's are those which have been edited since the last time they were retrieved from the ECR or sent to the ECR. MODIFIED only & clear Flag • Modified PLU's and EAN's are those which have been edited since the last time they were retrieved from the ECR or sent to the ECR.
sent back using this option. TCP/IP Config • This option is only supported by the Starrtec Services TCP/IP Interface for Sharp ECR's. With this interface fitted, programming for the 7000 Jobs can be sent to the ECR. Comms Test • This is a Communications Test to see if there is a valid ECR connected to the computer and if it is available for Comms. This test is performed before EVERY Comms Session. If no SEND or RETRIEVE options are selected, the test will be performed on its own.
Condiment Tables You cannot create Condiment Tables from scratch in POSUtility. You must create at least one table in the ECR, then retrieve the data (including PLU's) which will include the table you just created. You may then edit this table and create or delete as required. The PLU's you use in the Condiment Table must exist in the ECR and POSUtility. To add to either Grid, press the INS(ert) key or using the mouse DoubleClick. If you are adding PLU's, a list of available PLU's will be displayed.
Add PLU's and/or Menus This form is used by both the Condiment Table and PLU Menu Preset options for selecting the PLU or Menu to add. If this form has been activated by the adding to the Condiment Table, only PLU's will be able to be selected. If it was activated to add to the PLU Menus, you have the choice of adding PLU's or Menus. Sorting of the displayed data is done by clicking on the column headings. To add the selected data, DoubleClick using the mouse. The last item you added is displayed.
headings. To add the currently highlighted PLU or Menu, DoubleClick on the row with the mouse. To delete from either Grid, press the DEL(ete) key. You will be asked to confirm the deletion. The edit button allows you to edit the Menu Description.
POS Utility Cable PC to POS POS 9 way D type Female PC 9 way D type Female Function Pin No. Pin No.
