Project

General

Profile

Production Ticket(ST) #11953

Suntory- Morning team, user report missing promotion on both SO and invoice after SO approved, please help to check all the 6th June order and I'm getting user to provide 1 SO as sample

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

Status:
Ticket Resolved
Priority:
P2 - High
Assignee:
Muhammad Arif
Start date:
07/06/2024
Due date:
08/06/2024
% Done:

0%

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

checked in the web portal

refresh the page under sales order
already fixed

root cause- bug

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

None

Description

@Rashdan Hussin MCC please log issue
The issue is SR05 based on user feedback

History

#1 Updated by Muhammed Azhar Mohamed Maideen 4 months ago

  • Assignee changed from Muhammed Azhar Mohamed Maideen to Muhammad Arif

Hi arif as we check from our side this report has been resolved previously but this is keep repeating again. developer team claim that this has been fixed and deployed previoiously in the click up

https://app.clickup.com/t/86epc33ck

SELECT c.customer_id, c.customer_name ,soh.order_status,soh.order_no, p.item_name,sod.web_product_net_amount,sod.mobile_product_total_disc,soh.order_web_net_amount, sod.web_uom1_qty,sod.web_uom2_qty,sod.web_uom3_qty, sod.mobile_uom1_qty,sod.mobile_uom2_qty,sod.mobile_uom3_qty, ihh.invoice_no,ihh.invoice_balance,ihh.currency_value,soh.order_web_discount_perc
FROM txn_sales_order_header soh
INNER JOIN txn_invoice_history_header ihh
    ON soh.ord_hdr_id = ihh.sales_order_id
inner join txn_sales_order_details sod  on soh.ord_hdr_id= sod.ord_hdr_id
inner join customer c  on c.customer_id= soh.customer_id
inner join product_item p on p.item_id= sod.product_id
--inner join mst_product_price mp on p.item_id= mp.item_id

as I checked all the details including promotion are exist in the database.
This is the ticket that previously logged;
http://124.217.245.100:90/redmine/issues/11726

#2 Updated by Muhammed Azhar Mohamed Maideen 4 months ago

  • Status changed from Assigned To to Support In Progress

#3 Updated by Muhammed Azhar Mohamed Maideen 4 months ago

  • Status changed from Support In Progress to Ticket Resolved
  • Type set to Support Request
  • Actual Initial Response set to 07/06/2024
  • Resolution updated (diff)

Also available in: Atom PDF