Difference between revisions of "POS MANUAL"

Revision as of 08:50, 26 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

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.