Production Ticket(ST) #11157
Goldcrest- hi may i ask for this customer, invoice got reflect to autocount, but collection didnt even in datanory, can help me check why this happen？
this escalation assisted by arif and chong this root cause there is calculation is incorrect in cancel collection part that is the root cause that the data is not able to insert in actual data
already patched data where it was stucked in di table and there is no presence in actual data
---
This issue happen because there is an error while the engine doing the collection calculation on invoice that have cancel amount before. The error is the engine include the cancel amount in calculation.
Currently we already correct the amount and our tech team is working on fixing the calculation
Root cause- incorrect calcutation on cancel calculation
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 7 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Muhammed Azhar Mohamed Maideen 7 months ago
- File Goldcrest_finding_Today.txt Goldcrest_finding_Today.txt added
- File WhatsApp Image 2024-03-09 at 15.07.02_a5f7c252.jpg WhatsApp Image 2024-03-09 at 15.07.02_a5f7c252.jpg added
- Due date changed from 10/03/2024 to 11/03/2024
- Status changed from Support In Progress to Pending Client Feedback
hi sorry to disturb weekend, the invoice total amt is RM116, but customer do paid part payment RM60 before that, so the balance unpaid amount wil be RM56
within this week, the customer pay the balance outstanding RM56, thats y you can see the unpaid amount become zero, as salesman done the collection transaction of this RM56, but now the issue is this RM56 didnt show in the autocount
-- I was Pm with customer
--
Findings customer said in autocount; the outstanding amount should be Rm 56 . So customer will give be check and verify again with admin on monday and that client will be update back on Monday to me> I Have attached a script on how I stimulate this issue.
#3 Updated by Muhammed Azhar Mohamed Maideen 6 months ago
- Project changed from Datanory Production to Datanory - GOLDCREST
#4 Updated by Muhammed Azhar Mohamed Maideen 6 months ago
- Status changed from Pending Client Feedback to Support In Progress
#5 Updated by Muhammed Azhar Mohamed Maideen 6 months ago
- Status changed from Support In Progress to Pending Client Verification
- Resolution updated (diff)
-- after patched the data
select * from DMS_EcoSystem.dbo.txn_mobile_collection_invoice where inv_id='d6be9ff8-da3c-408f-ba07-c46ea1670f2a'order by created_date
-- before patched the data
select * from DMS_Ecosystem_Backup_Table.dbo.txn_mobile_collection_invoice_20240317 where inv_id='d6be9ff8-da3c-408f-ba07-c46ea1670f2a'order by created_date
#6 Updated by Muhammed Azhar Mohamed Maideen 6 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- Type set to Support Request
- Actual Initial Response set to 18/03/2024
- Resolution updated (diff)