Project

General

Profile

Production Ticket(ST) #11370

Sales Order Module & Invoice Module Optimization

Added by Muhammad Arif 6 months ago. Updated 4 months ago.

Status:
Ticket Resolved
Priority:
P2 - High
Assignee:
Muhammad Arif
Start date:
27/03/2024
Due date:
30/04/2024
% Done:

0%

Estimated time:
Job Remark:
Ticket Logged Date:
Ticket No.:
Related Ticket ID:
Type:
SLA Initial Response:
27/03/2024
SLA Delivery:
28/03/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
27/03/2024
Resolution:

solution for workaround: index, add SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED, housekeep data and shrink db

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

None

Description

Sales Order Module & Invoice Module take long time to load. Please help to optimize

History

#1 Updated by Muhammad Arif 6 months ago

  • Status changed from Assigned To to Support In Progress

#2 Updated by Muhammad Arif 6 months ago

  • Status changed from Support In Progress to Pending Client Verification
  • Resolution updated (diff)

#3 Updated by Muhammad Arif 6 months ago

  • Status changed from Pending Client Verification to Support In Progress

Update: 1st April 2024 - after discussion with project team, product team and MC, we will add checking for SO/invoice status and order/invoice date. from this new checking, we will display the promotion based on status and date for SO/invoice. If SO/invoice is pending then show all active promotion, the promotion must be active during the SO/Invoice is created.

#4 Updated by Muhammad Arif 6 months ago

  • Due date changed from 28/03/2024 to 03/04/2024
  • Status changed from Support In Progress to On-Hold

Update 2nd April 2024: after modified SO promotion SP, find out that web portal didnt pass the promotion ID. need advise from MC.
Update 3rd April 2024: after discussion with MC, project and product team, will modify the SO promotion SP to get the promotion ID from SO/invoice promo table. Tested fine by Boon and Arif. Current task, to modify SP for promotion list. will on hold this task due to avoid any issue during project team do demo at suntory.

#5 Updated by Muhammed Azhar Mohamed Maideen 6 months ago

  • Due date changed from 03/04/2024 to 08/04/2024

#6 Updated by Muhammad Arif 6 months ago

  • Due date changed from 08/04/2024 to 12/04/2024
  • Status changed from On-Hold to Support In Progress

modified SP [web_spTransactionPromotionListByOutlet_20240402_v2] by add status filtering, if SO pending, show all promotion that tied to customer branch. If SO approved, will show selected promotion only. still testing

#7 Updated by Muhammad Arif 5 months ago

  • Due date changed from 12/04/2024 to 30/04/2024

continue on 24 April 2024 - after UAT signed off

#8 Updated by Muhammad Arif 5 months ago

  • Status changed from Support In Progress to On-Hold

#9 Updated by Muhammad Arif 4 months ago

  • Status changed from On-Hold to Support In Progress

#10 Updated by Muhammad Arif 4 months ago

  • Status changed from Support In Progress to Ticket Resolved

Also available in: Atom PDF