|
|
| Line 7: |
Line 7: |
| | 2. Close the POS app/window | | 2. Close the POS app/window |
| | 3. Go to SQLYOG → myiposdata | | 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.
| |
| − | 2. Close the iPos terminal on web browser.
| |
| − | 3. 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
| |
| − |
| |
| − |
| |
| − | RECEIPT COMPUTATIONS
| |
| − |
| |
| − | Less 12% Vat = Amount sale - (Amount sales / 1.12)
| |
| − | 20% Senior Discount = Subtotal x 0.20%
| |
| − |
| |
| − |
| |
| − | TOTAL AMOUNT DOESN'T MATCH serve_logs
| |
| − |
| |
| − | 1. Open SQLYOG open 1p connection → iposdata → tbl_tenderdetails
| |
| − | 2. Open connection 202.2.2.52 →epp → serve_logs
| |
| − | 3. Match tbl_tenderdetails from serve_logs (52)
| |
| − |
| |
| − | NOTE: EPP (db on 202.2.2.52) should not contain employees from OMNM and ESSI
| |
| − |
| |
| − | NEW CORPORATE ACCOUNT FROM SAP
| |
| − |
| |
| − | 1. Get and open the excel/xls file from SAP
| |
| − | 2. Open 202.2.2.52 db connection → iposmsdb → tblcorpace
| |
| − | 2.1 Copy row header from tblcorpace
| |
| − | 2.2 Create new sheet from the opened excel file and past the copied row
| |
| − | 3. Match and change the row accordinly on the new sheet that was created.
| |
| − | 4. Open Navicat go to 202.2.2.52 db connection → iposmsdb → tblcorpacc
| |
| − | 5. Right click tblcorpace then import wizard.
| |
