Tender buttons on touchscreen not functioning in Store Operations

Tender buttons on touchscreen not functioning in Store Operations I found Article ID : 862004 on customer source. But I am confused after step 9 After I run query for step 4 I found this ID Description ADDITIONAL DETAIL Display Code

1 CASH 1 0 1 2 CHECK 2 1 2 3 MASTER/VISA 3 4 3 4 CASH OVER 1000 1 9 4 15 DISCOVER 3 8 9 6 ON ACOUNT 4 6 6

16 AMEX 3 7 10

11 DEBIT 9 3 11 12 COUPON 1 2 12 What I need to put on step 10 after I found this on step 4 Here is all the step Restore the Tender table to a status where all ID values are sequential, beginning with the value of 1. Follow these steps to perform this task:

1. Open Store Operations Administrator and connect to the database by clicking File and then Connect.

2. Make a backup of the database in Store Operations Administrator by clicking Database and then Backup.

1. Open a new query window by clicking Query and then New.

2. Enter the following and then click Run (green arrow button):

SELECT ID, Description, AdditionalDetailType, DisplayOrder, Code FROM Tender

1. Print the results by clicking File and then Print, or write down the results of this query.

1. Close the first query window and open a new query by clicking Query and then New.

2. Enter the following and then click Run:

DELETE Tender

1. Close the first query window and open a new query by clicking Query and then New.

1. Enter the following and then click Run:

set identity_insert tender ON

Note Leave this query window open because you will run it multiple times

1. Open a new query window, enter the following, and then click Run (green arrow button):

INSERT INTO Tender (ID, Description, AdditionalDetailType, DisplayOrder, Code) VALUES (1, 'A', B, C, 'D')

1. In the above statement, modify the values found after the keyword VALUES. Starting with the first record, use the results printed from Step 5 to enter the appropriate values according to this:

'A': The description of the original tender B: The AdditionalDetailType of the original tender C: The DisplayOrder of the original tender 'D': The Code of the original tender

Do not modify the first value in the parenthesis (1). This value will be incremented by 1 every time the statement is executed. Make sure that the values of the Description and Code are enclosed in single quotation marks marks (as shown in the example).

1. Run this query. You may receive an error that "Identity Insert is set to Off." If you receive this error, run the query in the other window that was done in Step 9. As soon as that has run, run the above statement again.

1. Modify the statement found in Step 10 by changing the 'A', B, C, and 'D' values for the next tender found in Step 4. Increment the first value in the VALUES section by 1. For the second record, this should be 2. Continue executing this statement one time for each of the original tenders, every time incrementing the first value by 1, and modifying the 'A', B, C, and 'D' values accordingly. You may receive an error that "Identity Insert is set to Off." If you receive this error, run the query in the other window that was done in Step 9. As soon as that has executed, run the INSERT statement again.

2. As soon as the INSERT statement has been executed one time for each of the original tenders, Login to Store Operations Manager and view each tender type to make sure all appropriate settings are entered. This task is performed by clicking Database, Tender Types, and clicking Properties for each tender type that applies.

1. You will have to manually update the new credit and debit card tender types to enable the Verify via EDC and Prevent cashier overtendering options. To do this, open a new query window, type the following, and then click Run (green arrow button):

UPDATE Tender SET VerifyViaEDC = 1, PreventOverTendering = 1 WHERE AdditionalDetailType IN (3,9)

1. Login to POS on each register and perform a Z report for this change to take affect by clicking F5 and then Print Z Report.

1. Test the Touchscreen to make sure the Tender buttons are working correctly.

2. Go back to Administrator and open a new query by clicking Query and then New.

1

1. Enter the following and then click Run:

SELECT ID, Description FROM Tender

1. Print the results by clicking File and then Print, or write down the results of this query.

1. Close the first query window and open a new query by clicking Query and then New.

2. Enter the following statements:

UPDATE TenderEntry SET TenderID = X where TenderID = Y UPDATE TenderTotals SET TenderID = X where TenderID = Y UPDATE QuoteTenderEntry SET TenderID = X where TenderID = Y UPDATE Public_TenderEntry SET TenderID = X where TenderID = Y

Note X is the value of the NEW tender ID value printed in Step 19, and Y is the OLD value of the tender ID printed in Step 5.

1. Run these statements and then click Run.

1. Modify the statements for the next tender, and repeat for each of the tenders that were deleted and recreated.

Note This is necessary to maintain historical reporting.

MORE INFORMATION

If Headquarters is also being used, assign the HQID value to the Tender records at the store. Follow these steps to complete this task:

1. Open Headquarters Administrator and connect to the database by clicking File and then Connect.

Note Make a backup of your database by clicking Database and then Backup.

1. Open a new query window by clicking Query, and then New, and enter the following:

SELECT ID, Description FROM Tender

1. Run the statement by clicking Run and print the results by clicking File and then Print.

1. At each store, assign these ID's to the appropriate tender using Administrator. The statements are:

UPDATE Tender set HQID = X where Description = 'Y'

Note X is the value of the ID column at HQ Note Y is the name of the tender