Difference between revisions of "POS MANUAL"
From SPGC Document Wiki
| Line 40: | Line 40: | ||
1. Check for transaction/SI no. on tbl_sales | 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. 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 | tbl_salesinvoice | ||
Revision as of 10:12, 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
