POS MANUAL
From SPGC Document Wiki
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