Resolving a till showing imbalance

Overview

You face a problem where a till is showing an imbalance because of a visa card transaction that has not been processed. And the Z read report shows a different count of transactions than the till report. 

Information

The issue is most probably caused due to an external service on the response or an incorrect entry. In order to get the imbalance resolved, the data posted transaction will have to be corrected. 

Raise a support ticket explaining your problem and mentioning the following details and the Prologic support team will be happy to help you;

• Till number
• Transaction ID
• Date of transaction
• The discrepancy amount (Imbalance) 

<supportagent>

In order to proceed with the correction, follow these steps;

1. Run the query to find discrepancies
2. Confirm for any discrepancies for VISAS
3. Find the document that needs to be voided
4. Fix the imbalance
5. Validate the fix

Refer to the article Till processing crashed leaving a wrong balance for more information on finding the till imbalance and confirming any discrepancies. 

And use the following query to update the till balance and remove the discrepancies.

Note: Remember to change the values to align with the customer information for all the queries.

update pos_grp_ftrans set ftras_count = 1, ftrans_ffamount = 117, ftrans_famount = 177 where
shop_num = 70001 and in_date = '19-MAY-21' and till_num = 20 and ftrans_pay_type like
'CARD' and ftrans_type='S' and pos_pay_type = 'VISAS' and pos_ftrans_num = 199171;

update pos_grp_ftrans set ftras_count = 1, ftrans_ffamount = 117, ftrans_famount = 177 where
shop_num = 70001 and in_date = '19-MAY-21' and till_num = 20 and ftrans_pay_type like
'CARD' and ftrans_type='B' and pos_pay_type = 'SVISAS' and pos_ftrans_num = 199174;

update pos_ftrans@s001 set ftrans_count = 1, ftrans_ffamount = 117, ftrans_famount = 117 where
in_date = '19-MAY-21' and till_num = 20 and ftrans_pay_type like 'CARD' and ftrans_type = 'S' 
and pos_pay_type = 'VISAS' and pos_ftrans_num = 199171;

update pos_ftrans@s001 set ftrans_count = 1, ftrans_ffamount = 117, ftrans_famount = 117 where
in_date = '19-MAY-21' and till_num = 20 and ftrans_pay_type like 'CARD' and ftrans_type = 'B' 
and pos_pay_type = 'SVISAS' and pos_ftrans_num = 199174;

commit

</supportagent>

Back to top