Production Ticket(ST) #11946
Suntory- Hi Team, please help to look into this credit note CNKSMS000008-240528, the return qty is 79 CTN but amount is 0
0%
root cause: recalculate issue during approval
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Project changed from Datanory to Datanory - SUNTORY
#2 Updated by Muhammad Arif 4 months ago
- Status changed from Assigned To to Support In Progress
#3 Updated by Muhammad Arif 4 months ago
- Status changed from Support In Progress to Pending Client Feedback
this is auto calculate issue. but currently cant be replicate. hence for this CN, we need to patch
#4 Updated by Muhammad Arif 4 months ago
- Due date changed from 07/06/2024 to 11/06/2024
- Status changed from Pending Client Feedback to Pending Client Verification
- SLA Delivery set to 11/06/2024
- Actual Initial Response set to 06/06/2024
- Resolution updated (diff)
select * from txn_credit_note_history_header where credit_note_no like 'CNKSMS000008%'
select * from txn_credit_note_history_detail where credit_note_id='3617F860BFD849EB87E18FB9E5CE61F3'
--update txn_credit_note_history_header set currency_value='2267.30',credit_note_balance='2267.30' where credit_note_no like 'CNKSMS000008%'
--update txn_credit_note_history_detail set amount='2267.30' where credit_note_id='3617F860BFD849EB87E18FB9E5CE61F3'
--update txn_credit_note_history_detail set line_total='2267.30' where credit_note_id='3617F860BFD849EB87E18FB9E5CE61F3'
select * from txn_credit_note_history_header where credit_note_no like 'CNKSMS000007%'
select * from txn_credit_note_history_detail where credit_note_id='99886529E24548E2B3B913D6E33C04E6'
select 28.70 * 79
#5 Updated by Muhammad Arif 4 months ago
- Status changed from Pending Client Verification to Ticket Resolved