Project

General

Profile

Production Ticket(ST) #11604

can help to delete credit note for this 3 acc?

Added by Muhammad Arif 5 months ago. Updated 4 months ago.

Status:
Ticket Resolved
Priority:
P2 - High
Assignee:
Muhammad Arif
Start date:
02/05/2024
Due date:
03/05/2024
% Done:

100%

Estimated time:
Job Remark:
Ticket Logged Date:
Ticket No.:
Related Ticket ID:
Type:
SLA Initial Response:
02/05/2024
SLA Delivery:
03/05/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
02/05/2024
Resolution:

refer ticket update

Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:

None

Description



3.jpg (42.7 KB) 3.jpg Muhammad Arif, 02/05/2024 10:19 AM
2.jpg (43.9 KB) 2.jpg Muhammad Arif, 02/05/2024 10:19 AM
1.jpg (42.8 KB) 1.jpg Muhammad Arif, 02/05/2024 10:19 AM

History

#1 Updated by Muhammad Arif 5 months ago

  • Status changed from Assigned To to Support In Progress

#2 Updated by Muhammad Arif 5 months ago

  • Status changed from Support In Progress to Pending Client Verification
  • % Done changed from 0 to 100
  • Resolution updated (diff)

select * into dms_ecosystem_backup_Table.dbo.txn_credit_note_history_header_20240502 from txn_credit_note_history_header
select * into dms_ecosystem_backup_Table.dbo.txn_credit_note_history_detail_20240502 from txn_credit_note_history_detail

select * from txn_credit_note_history_header where customer_id='5F60AAF051ED42188207262D12E9FE4D'
select * from txn_credit_note_history_header where customer_id='91913643086348B0A2E3C2A5C8BACB47'
select * from txn_credit_note_history_header where customer_id='9F092301B695437D8877303B748DEC4A'

select * from txn_credit_note_history_detail where credit_note_id='c3e4beeb-f8c7-4c57-81d5-a6c3c384dd38'
select * from txn_credit_note_history_detail where credit_note_id='3a20824e-0e2e-4452-a185-0e54c9b93e49'
select * from txn_credit_note_history_detail where credit_note_id='623115c0-8c39-401b-94d5-cf1f0112047d'
select * from txn_credit_note_history_detail where credit_note_id='7351df5a-d388-4d12-90d1-857ae1fe7a99'

--delete from txn_credit_note_history_header where customer_id='5F60AAF051ED42188207262D12E9FE4D'
--delete from txn_credit_note_history_header where customer_id='91913643086348B0A2E3C2A5C8BACB47'
--delete from txn_credit_note_history_header where customer_id='9F092301B695437D8877303B748DEC4A'

--delete from txn_credit_note_history_detail where credit_note_id='c3e4beeb-f8c7-4c57-81d5-a6c3c384dd38'
--delete from txn_credit_note_history_detail where credit_note_id='3a20824e-0e2e-4452-a185-0e54c9b93e49'
--delete from txn_credit_note_history_detail where credit_note_id='623115c0-8c39-401b-94d5-cf1f0112047d'
--delete from txn_credit_note_history_detail where credit_note_id='7351df5a-d388-4d12-90d1-857ae1fe7a99'

#3 Updated by Muhammad Arif 4 months ago

  • Status changed from Pending Client Verification to Ticket Resolved

Also available in: Atom PDF