Problem:
Ticket Example:
[#66439] [HIGH][SR1][Transactions amount not tally - EInvoice Portal (Sept 2025)] : Qube POS Helpdesk
Amount From FPOS Receipt: RM16.90
Amount From E-Invoice Portal: RM5.50
Solution:
1) Rescan Back Item shown in E-Invoice Portal (RM5.50) via Backend (Remember do not enable E-Invoice Setting while rescan at Backend PC).
2) Then EOD as that date doing transaction (Example here is 02/09/2025)
3) After rescan, Edit the details as below in SQL Explorer to merge the items and amounts into the Receipt stored in FPOS:
- For POS_SALES, the total sales amount will be both receipt's amount
(So for example here: It will become 16.90 + 5.50 = 22.40)
SALES_QTY 7+1 = 8
SALES_GROSS = 16.90 + 5.50 = 22.40
SALES_NETSALES = 16.90 + 5.50 = 22.40
SALES_PAID = 16.90 + 5.50 = 22.40
4) For POS_SALESDTL, the item sequence should have 2 receipt's item listed. Where SDTL_SEQNO=1 is the item scanned in E-Invoice Portal, While SDTL_SEQNO = 2 to 4 is the item scanned from FPOS Receipt.
5) For POS_PAYMENT, the PYMT_SEQNO = 2 we put the amount paid for the Receipt in E-Invoice Portal.
PYMT_SEQNO='2'
PYMT_PAYBYCODE='CS'
PYMT_PAYBYCODEDESC='CASH'
PYMT_PAYAMT='5.5'
PYMT_ACTPAID='5.5'
PYMT_MASCODE='CASH'
