Production Ticket(ST) #12010
Snekku- Hi @Azhar13 Why in24/012643 invoice history empty?
Resolution Done by technical team
Expected to release hot fix by end of this week
None
History
#1 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- File WhatsApp Image 2024-06-13 at 17.46.14_bed43d7b.jpg WhatsApp Image 2024-06-13 at 17.46.14_bed43d7b.jpg added
select * from txn_invoice_history_header where invoice_no ='in24/012643'
select * from txn_invoice_history_detail where invoice_id= 'F9BCD4183EA34DD8BE9B1A2CFD3535E2'
as i crosscheck i notice that one of the product is missing in the invoice history
RM0.40(20g)x30x10 SnekKu Tam Tam Crab Flv Snacks(L)
the rounding is calculate based on the document amount- subtotal
#2 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
Already asked Shu ern on this the root cause
#3 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Assignee changed from Muhammed Azhar Mohamed Maideen to Muhammad Arif
Hi arif This one has 2 issue
1) login as admin and on behalf MN5 and check the invoice history and they found out the invoice history is empty
this has to check the sp_sync_download_invoice_detail store procedure to further check.
Based on my finding I notice that login as MN5, able to see the invoice history but when we perform the onbehalf the invoice history module is empty
2) another issue is sub total and rounding number
for easy to understand :
select * from txn_invoice_history_header where invoice_no ='in24/012643'
select * from txn_invoice_history_detail where invoice_id= 'F9BCD4183EA34DD8BE9B1A2CFD3535E2'
as i crosscheck i notice that one of the product is missing in the invoice history
RM0.40(20g)x30x10 SnekKu Tam Tam Crab Flv Snacks(L)
the rounding is calculate based on the document amount- subtotal
so the missing product in the invoice list will be calculated under rounding
but as I checked with technical team Shu ern she claimed that this is by integration, or download sp,or mobile display issue
need your verification on this before I escalated completely to the L3
- Endshift
- handover to arif
#4 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
Exec sp_sync_download_invoice_detail '1','','10000','1F71FD63-5C28-41F5-B9A5-4EC485535FCF','N'
I able to capture the SP from it
need to run SP fir further checking
#5 Updated by Muhammad Arif 3 months ago
- Status changed from Assigned To to Support In Progress
#6 Updated by Muhammad Arif 3 months ago
need to further checking on the logic..current finding joining with customer table caused the issue
#7 Updated by Muhammad Arif 3 months ago
- Status changed from Support In Progress to Escalate to 2nd Level Support
#8 Updated by Muhammad Arif 3 months ago
- Status changed from Escalate to 2nd Level Support to Escalated to Level 3
#9 Updated by Muhammad Arif 3 months ago
waiting Azhar result since 28 june 2024
#10 Updated by Muhammad Arif 3 months ago
- Status changed from Escalated to Level 3 to Pending Client Feedback
- Assignee changed from Muhammad Arif to Muhammed Azhar Mohamed Maideen
#11 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
I perform the simulation on trial(Latest) and point to production server
The download time is less than 10 minutes,
But I checked the invoice history the page is still empty (in24/012643)--> UNDER CUSTOMER 5P502
as I checked in random customer under MN5 there invoice history has been displayed. and some are not ex: 23/025268
This is my finding so far
#12 Updated by Muhammed Azhar Mohamed Maideen 2 months ago
Clickup
hi @Shu Ern ,
I performed the simulation on the trial version (Latest) and pointed it to the production server. The download time was less than 10 minutes. However, I checked the invoice history page and it is still empty for invoice IN24/012643 under customer 5P502.
I also checked random customers under MN5. For some, the invoice history is displayed, but for others, like invoice 23/025268, it is not. This is my finding so far.
I have been asked about when the deployment to production will happen. You mentioned that since the performance is too slow for Snekku to download all details, we are holding this until the full production deployment next week.
#13 Updated by Muhammed Azhar Mohamed Maideen about 2 months ago
- Status changed from Pending Client Feedback to Ticket Resolved
- Type set to Support Request
- Actual Initial Response set to 27/06/2024
- Resolution updated (diff)