Production Ticket(ST) #12063
KYMMSENG - duplicate INV for this
50%
1) Check if there any duplicate invoice or SO. Found no duplication.
2) Check the sp.
3) Found that the sp have group the created and updated date for sales order details.
4) Escalate to level 3. https://app.clickup.com/t/9018039480/TK-274
Root cause: sp have group the created and updated date.
None
Description
@Cris Neoh MCC Hi, can help me check about this report ?duplicate INV for this
History
#1 Updated by Rashdan Hussin 3 months ago
- Status changed from Assigned To to Support In Progress
Hi @~ElaineKaw based on checking, we found no duplicate invoice or SO at backend. Now we are checking the reporting part. We will update you as soon as possible
#2 Updated by Rashdan Hussin 3 months ago
- Status changed from Support In Progress to Escalated to Level 3
- % Done changed from 0 to 50
- Actual Initial Response set to 20/06/2024
- Resolution updated (diff)
select a.order_no, b.ord_dtl_id, b.created_date, b.updated_date, * from txn_sales_order_header a
inner join txn_sales_order_details b on b.ord_hdr_id = a.ord_hdr_id
where a.org_id = 'kymmseng' and a.order_no = 'SOSR02000257-240618'
#3 Updated by Rashdan Hussin 3 months ago
select * from txn_sales_order_header where org_id = 'kymmseng' order by created_date desc
select * from txn_sales_order_header where ord_hdr_id = '289362c5-902f-4faa-a204-9306cce1d487'
select * from txn_sales_order_details where ord_hdr_id = '289362c5-902f-4faa-a204-9306cce1d487'
select a.order_no, b.ord_dtl_id, b.created_date, b.updated_date, * from txn_sales_order_header a
inner join txn_sales_order_details b on b.ord_hdr_id = a.ord_hdr_id
where a.org_id = 'kymmseng' and a.order_no = 'SOSR02000006-240502'
--update txn_sales_order_details set created_date = '2024-05-03 14:00:00.000' where ord_dtl_id = '87538747-7abb-4541-9a74-b5f6bf199df1'
--update txn_sales_order_details set created_date = '2024-05-02 14:55:37.000' where ord_dtl_id = '87538747-7abb-4541-9a74-b5f6bf199df1'
select * from txn_sales_order_details
select ord_hdr_id, CONVERT, CONVERT from txn_sales_order_details
group by ord_hdr_id, CONVERT, CONVERT
order by ord_hdr_id
SELECT
ord_hdr_id,
COUNT() AS duplicate_count
FROM
(
SELECT
ord_hdr_id,
CONVERT AS created_date,
CONVERT AS updated_date
FROM
txn_sales_order_details
GROUP BY
ord_hdr_id,
CONVERT,
CONVERT
) AS grouped_table
GROUP BY
ord_hdr_id
HAVING
COUNT() > 1
ORDER BY
ord_hdr_id;
#4 Updated by Rashdan Hussin 3 months ago
- Assignee changed from Rashdan Hussin to Muhammad Arif
#5 Updated by Muhammad Arif 3 months ago
- Status changed from Escalated to Level 3 to Ticket Resolved