Difference between revisions of "POS MANUAL"

From SPGC Document Wiki
Jump to: navigation, search
Line 44: Line 44:
 
         3. Close the iPos terminal on web browser.
 
         3. Close the iPos terminal on web browser.
 
         4. Open database on 202.2.2.89. Remove/Delete the transaction on mybackroomserver tbl_salesinvoice
 
         4. Open database on 202.2.2.89. Remove/Delete the transaction on mybackroomserver tbl_salesinvoice
 +
 +
'''TENDER HIERARCHY
 +
'''
 +
 +
SD (salary deduction/PO on tender) → GC (gift check) → Cash

Revision as of 10:18, 16 April 2019

MAK SD POS # 1

VOID

- should be date today (advisable)
- if on previous date (not advisable):
	1. Change PC date accordinlgy to the receipt
	2. Close the POS app/window
   	3. Go to SQLYOG → myiposdata
           3.1 Backup tbl_state_(DATE TODAY) and tbl_operationdate_(DATE TODAY)
           3.2 Change the date on tbl_state
           3.3 Delete date today down to previous date of the transaction
           3.4 Change initialized value of date on the receipt

4. Open iPos System → Cashering → press F6 (VOID)

           4.1 Enter SI no. → authenticate by supervisor

5. Go to Option → Day-end Reports

           5.1 Hourly sales
           5.2 Cashier Sales with tender breakdown
           5.3 X Terminal Reading
           5.4 Z Terminal Reading

6. Close iPos System 7. Go to SQLYOG → myiposdata

           7.1 Return the current date that was changed earlier or rename the backup tbl_state(DATE TODAY) back to tbl_state.
           7.2 Return the current values that was changed earlier or rename the backup tbl_operationdate_(DATE TODAY) back to tbl_operationdate.


SERVE LOGS

 - not posting on POS Terminal (transfer to 52 → epp → serve_logs)
       1. Check on browser network.
       2. Check if query is working.
               2.2 Check if data is correct.
               2.3 if correct: Inform master data
               2.4 END
       3. Debug


MISMATCH DATA FROM TENDER AND TENDER GROUP ITEMIZED

       1. Check for transaction/SI no. on tbl_sales
       2. Check on 89 mybackroomserver tbl_salesinvoice if count is 0 on tbl_salesinvoice of the transaction/SI no.  
           2.1 If none, go to folder iPos → YYYY → MM → DD
           2.2 Look for the transaction no./ SI no. XML, then open on web browser
           2.3 Enter manually the items on tbl_sales from the XML file opened on browser.
       3. Close the iPos terminal on web browser.
       4. Open database on 202.2.2.89. Remove/Delete the transaction on mybackroomserver tbl_salesinvoice

TENDER HIERARCHY

SD (salary deduction/PO on tender) → GC (gift check) → Cash