Production Ticket(ST) #10870
TSH - Hi @MCC Jann Yap, there was an issue regarding the missing data for invoice no.: INC06000335-240124 & INC06000336-240124 in Datanory.
1) Check in trial, why the invoice in DI table but not in actual table.
2) The data has to be patched in order to let it flow. Means we amend the txn number so that it can flow
Root cause: TSH user using multiple devices.
None
Description
Hi @MCC Jann Yap, there was an issue regarding the missing data for invoice no.: INC06000335-240124 & INC06000336-240124 in Datanory.
My salesman had printed and issued both invoices to our customer. Any idea to retrieve back the data?
History
#1 Updated by Rashdan Hussin 8 months ago
- Status changed from Assigned To to Support In Progress
- % Done changed from 0 to 90
- Esclation Time set to 29/01/2024
#2 Updated by Rashdan Hussin 8 months ago
- File 0c461550-0b29-4dd0-ae7b-890f7c2352ec.jpg 0c461550-0b29-4dd0-ae7b-890f7c2352ec.jpg added
- File cea4df54-67b4-4b5e-a21a-ed08cb3798fd.jpg cea4df54-67b4-4b5e-a21a-ed08cb3798fd.jpg added
- File 3db53f5b-d71b-418b-8445-28b00c914770.jpg 3db53f5b-d71b-418b-8445-28b00c914770.jpg added
- Status changed from Support In Progress to Pending Client Verification
- Actual Initial Response set to 29/01/2024
- Resolution updated (diff)
Script from Jann:
select * from txn_invoice_history_header where invoice_no = 'INC06000335-240124'
select * from di_txn_invoice_history where invoice_no = 'INC06000335-240124'
select * from txn_invoice_history_header where org_id= 'A000003' and
convert(date, invoice_date) = '2023-11-28' and member_id = '64BA7741-D802-4F7B-88A3-205F5762EA1D'
select * from txn_credit_note_history_header where org_id= 'A000003' and
convert(date, credit_note_date) = '2023-11-28' and member_id = '64BA7741-D802-4F7B-88A3-205F5762EA1D'
select * from txn_mobile_collection_header where org_id= 'A000003' and convert(date, created_date) = '2023-11-28'
and txn_id in (select txn_id from txn_mobile_header where salesman_id = '64BA7741-D802-4F7B-88A3-205F5762EA1D')
#3 Updated by Rashdan Hussin 7 months ago
- Status changed from Pending Client Verification to Ticket Resolved