Project

General

Profile

Production Ticket(ST) #12010

Snekku- Hi @Azhar13 Why in24/012643 invoice history empty?

Added by Muhammed Azhar Mohamed Maideen 3 months ago. Updated about 2 months ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Start date:
13/06/2024
Due date:
15/06/2024
% Done:

0%

Estimated time:
Spent time:
Job Remark:
Ticket Logged Date:
13/06/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
13/06/2024
SLA Delivery:
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
27/06/2024
Resolution:

Resolution Done by technical team

Expected to release hot fix by end of this week

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

None


History

#1 Updated by Muhammed Azhar Mohamed Maideen 3 months ago

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)

Also available in: Atom PDF