Production Ticket(ST) #11918
KYMMSENG - face to same issue, missing disc amount
Escalate to level 3
Root Cause:
Based on technical feedback on this issue is due to the integration engine bug, MCC support team had regenarte the correct file and send PD (Pending PD validation), also latest version will be deploy on 5th June to resolve the problem permanentaly
None
Description
face to same issue, missing disc amount
Hi @Arif MCC @Rashdan Hussin the same issue happened for these yesterday invoice, please help to check and if necessary back up and run the update script
History
#1 Updated by Rashdan Hussin 4 months ago
- Status changed from Assigned To to Support In Progress
--//-----------------------------------------check invoices that having promo issues ----------------------------------------------------------------------------------------//
select ih.invoice_no as invoice_no, Max(ih.currency_value) as invoice_total, Max(x.order_mobile_net_amount) as mobile_total, Max(x.total_promo_disc) as mobile_promo_disc,
Max(ih.currency_value) - Max(x.order_mobile_net_amount) as invoice_diff
FROM txn_invoice_history_header ih
INNER JOIN (
SELECT h.ord_hdr_id, h.order_mobile_net_amount, sum(d.mobile_product_total_disc) as total_promo_disc
FROM txn_sales_order_details d
JOIN txn_sales_order_header h ON h.ord_hdr_id = d.ord_hdr_id
WHERE d.web_product_total_disc < d.mobile_product_total_disc
AND d.web_product_total_disc = 0
AND h.status = 'Approved'
GROUP BY h.ord_hdr_id, h.order_mobile_net_amount
) x ON x.ord_hdr_id = ih.sales_order_id group by ih.invoice_no
select * from txn_invoice_history_header where invoice_no = 'INKSMS001131-240604'
select * from txn_invoice_history_header_at where invoice_no = 'INKSMS001131-240604' order by at_date
select * from txn_invoice_history_detail where sales_order_id = '7cee1bff-f731-438f-bd43-11c8a21a19db'
select * from txn_invoice_history_detail_at where sales_order_id = '7cee1bff-f731-438f-bd43-11c8a21a19db' order by at_date
select * from txn_sales_order_header where ord_hdr_id = '7cee1bff-f731-438f-bd43-11c8a21a19db'
select * from txn_sales_order_header_at where ord_hdr_id = '7cee1bff-f731-438f-bd43-11c8a21a19db' order by at_date
select * from txn_sales_order_details where ord_hdr_id = '7cee1bff-f731-438f-bd43-11c8a21a19db'
select * from txn_sales_order_details_at where ord_hdr_id = '7cee1bff-f731-438f-bd43-11c8a21a19db' order by at_date
select * from di_mobile_txn_sales_orders where sales_orders_id = '7cee1bff-f731-438f-bd43-11c8a21a19db'
#2 Updated by Rashdan Hussin 4 months ago
- Status changed from Support In Progress to Escalated to Level 3
- Resolution updated (diff)
- Need to get update from tech team
#3 Updated by Rashdan Hussin 3 months ago
- Status changed from Escalated to Level 3 to Pending Client Verification
- % Done changed from 0 to 90
- Actual Initial Response set to 04/06/2024
- Resolution updated (diff)
#4 Updated by Rashdan Hussin 3 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100