Project

General

Profile

Production Ticket(ST) #12015

DAILYFRESH - This is the report I pulled as of 12/6/24. first report at 9am, second report at 2pm. Can I know why the same report is just different time but different figure??

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

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

100%

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:
14/06/2024
Resolution:

1) Ask user to provide the file that she use to compare both report.

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

None


Description



Sales Quantity by item report.

History

#1 Updated by Muhammed Azhar Mohamed Maideen 3 months ago

  • Assignee changed from Muhammed Azhar Mohamed Maideen to Muhammad Arif

hi arif

this report sales quantity by item report
User found that there is discrepancy value between 9 am and 2pm on 13/06/2024

could not further check due to time constraint need assist on this ticket

SELECT *
FROM sync_mobile_activity_log
WHERE member_id = '224D083F-76BA-49E8-A70B-0F1C56F67E78' --TAI04
AND created_date >= '2024-06-13 09:00:00'
AND created_date <= '2024-06-13 14:00:00';

SELECT *
FROM sync_mobile_activity_log
WHERE member_id = '463F5897-AE00-4F15-B89B-8CD87A189021'
AND created_date >= '2024-06-13 09:00:00'
AND created_date <= '2024-06-13 14:00:00';
SELECT * FROM MEMBER WHERE MEMBER_CD= 'TAI05'

endshift
- Handover to arif

#2 Updated by Muhammad Arif 3 months ago

  • Status changed from Assigned To to Support In Progress

#3 Updated by Muhammad Arif 3 months ago

  • Status changed from Support In Progress to Pending Client Feedback

Hi @~NanaAzira , could you please check if you have a soft copy of both figures?it may help my investigation

#4 Updated by Muhammad Arif 3 months ago

  • Assignee changed from Muhammad Arif to Rashdan Hussin

Rashdan follow up with nana

#5 Updated by Rashdan Hussin 3 months ago

  • Subject changed from Daily Fresh - This is the report I pulled as of 12/6/24. first report at 9am, second report at 2pm. Can I know why the same report is just different time but different figure?? to DAILYFRESH - This is the report I pulled as of 12/6/24. first report at 9am, second report at 2pm. Can I know why the same report is just different time but different figure??
  • Status changed from Pending Client Feedback to Ticket Resolved
  • % Done changed from 0 to 100
  • Type set to Support Request
  • Actual Initial Response set to 14/06/2024
  • Resolution updated (diff)

Also available in: Atom PDF