Project

General

Profile

Production Ticket(ST) #12269

KYMMSENG - invoice INKSMS002996-240719 is tag to a 8% promotion when upload from mobile, but when view in web, the promotion is not qualified

Added by Rashdan Hussin 2 months ago. Updated about 2 months ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Rashdan Hussin
Start date:
21/07/2024
Due date:
23/07/2024
% Done:

50%

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

1) Check the transaction details in db and run profiler.
2) Simulate the issue and can replicate.
3) Escalate to level 3. https://app.clickup.com/t/9018039480/TK-849

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

None

Description

Hi Team, as of my checking, the invoice INKSMS002996-240719 is tag to a 8% promotion when upload from mobile, but when view in web, the promotion is not qualified.

In web, there is no 8% promotion discount

but when salesman upload, the promotion is qualified

might need to have a look on it why salesman can apply the promotion in mobile but at the meantime web shows that it does not qualified for the promotion

d1aad641-7aaa-480b-82db-b60641fb98da.jpg (90.5 KB) d1aad641-7aaa-480b-82db-b60641fb98da.jpg Rashdan Hussin, 21/07/2024 10:45 AM
5876c115-c81e-43c3-a67d-d3d8107ead4f.jpg (145 KB) 5876c115-c81e-43c3-a67d-d3d8107ead4f.jpg Rashdan Hussin, 21/07/2024 10:46 AM
Screenshot_20240725_022614_Datanory.jpg (277 KB) Screenshot_20240725_022614_Datanory.jpg Rashdan Hussin, 25/07/2024 02:27 AM
aa1a1d00-0ac5-4092-b83b-08b05df3042a.jpg (54.7 KB) aa1a1d00-0ac5-4092-b83b-08b05df3042a.jpg Rashdan Hussin, 25/07/2024 02:27 AM
9674555d-ba99-4966-866b-97c9f26082f6.jpg (56.6 KB) 9674555d-ba99-4966-866b-97c9f26082f6.jpg Rashdan Hussin, 25/07/2024 02:27 AM
3cf094ef-8f2d-488d-89d0-cd8d097338f5.jpg (65.3 KB) 3cf094ef-8f2d-488d-89d0-cd8d097338f5.jpg Rashdan Hussin, 25/07/2024 02:27 AM

History

#1 Updated by Rashdan Hussin 2 months ago

  • Status changed from Assigned To to Support In Progress

[12:01, 20/07/2024] Rashdan Hussin: Based on checking, the product should qualified for the promo. When run the sp also get the result where it get 8% benefit. But in web it doesnt show the value
[12:02, 20/07/2024] Rashdan Hussin: I need to simulate this case and update my finding

#3 Updated by Rashdan Hussin 2 months ago

select * from di_mobile_txn_sales_orders where sales_orders_id = '9bc17eeb-842e-4cbd-8ea9-fb8fec04d988' and product_id = 'F6C9AF61163142719AB02CA9536520B5'

select * from txn_sales_order_header where ord_hdr_id = '9bc17eeb-842e-4cbd-8ea9-fb8fec04d988'

select * from txn_sales_order_details where ord_hdr_id = '9bc17eeb-842e-4cbd-8ea9-fb8fec04d988'
select * from txn_sales_order_details_at where ord_hdr_id = '9bc17eeb-842e-4cbd-8ea9-fb8fec04d988' and product_id = 'F6C9AF61163142719AB02CA9536520B5' order by at_date

select * from txn_invoice_history_header where invoice_no = 'INKSMS002996-240719'

select * from txn_invoice_history_detail where invoice_id = 'BC680D2185E24BF5B217B51451E2F3C7'

select * from mobile_promotion_header where promotion_id = '4261e6cb7a4a435385b7ed4c1ed4df05'
select * from mobile_promotion_header_at where promotion_id = '4261e6cb7a4a435385b7ed4c1ed4df05' order by at_date

select * from mobile_promotion_benefit where benefit_id = '3176772374cd4606b00cadd4106d913c'
select * from mobile_promotion_benefit_at where benefit_id = '3176772374cd4606b00cadd4106d913c' order by at_date

select * from mobile_promotion_benefit_qualifier where product_id = 'F6C9AF61163142719AB02CA9536520B5'

select * from mobile_promotion_product_qualifier where promotion_id = '4261e6cb7a4a435385b7ed4c1ed4df05'
select * from mobile_promotion_product_qualifier_at where promotion_id = '4261e6cb7a4a435385b7ed4c1ed4df05' order by at_date

select * from MST_PROMOTION where id = '4261e6cb7a4a435385b7ed4c1ed4df05'

select * from promotion

select * from product_item where item_id = 'F6C9AF61163142719AB02CA9536520B5'

#4 Updated by Rashdan Hussin 2 months ago

exec sp_executesql N' exec web_spTxnSalesOrderApprovalMasterDataRetriveList @member_id,@org_id,@hdr_id, @type,@tenant_id',N'@member_id nvarchar(14),@org_id nvarchar(8),@hdr_id nvarchar(36),@type nvarchar(10),@tenant_id nvarchar(7)',@member_id=N'KYMMSENG-admin',@org_id=N'KYMMSENG',@hdr_id=N'9bc17eeb-842e-4cbd-8ea9-fb8fec04d988',@type=N'SalesOrder',@tenant_id=N'SUNTORY'

exec sp_executesql N'SELECT * FROM txn_invoice_history_header WHERE sales_order_id= @sales_order_id_8a69d2ca240b45d987b082bf268864c1 AND org_id= @org_id_8a69d2ca240b45d987b082bf268864c1 ',N'@sales_order_id_8a69d2ca240b45d987b082bf268864c1 nvarchar(36),@org_id_8a69d2ca240b45d987b082bf268864c1 nvarchar(8)',@sales_order_id_8a69d2ca240b45d987b082bf268864c1=N'9bc17eeb-842e-4cbd-8ea9-fb8fec04d988',@org_id_8a69d2ca240b45d987b082bf268864c1=N'KYMMSENG'

exec sp_executesql N'SELECT * FROM txn_sales_order_approval_history WHERE order_id= @order_id_d3184c66ced341b1828b0540273408bc AND org_id= @org_id_d3184c66ced341b1828b0540273408bc ',N'@order_id_d3184c66ced341b1828b0540273408bc nvarchar(36),@org_id_d3184c66ced341b1828b0540273408bc nvarchar(8)',@order_id_d3184c66ced341b1828b0540273408bc=N'9bc17eeb-842e-4cbd-8ea9-fb8fec04d988',@org_id_d3184c66ced341b1828b0540273408bc=N'KYMMSENG'

exec sp_executesql N' exec sp_get_sales_order_promotion_benefit_bracket @hdr_id , @member_id, @promotion_id ',N'@hdr_id nvarchar(36),@member_id nvarchar(14),@promotion_id nvarchar(4000)',@hdr_id=N'9bc17eeb-842e-4cbd-8ea9-fb8fec04d988',@member_id=N'KYMMSENG-admin',@promotion_id=N''

exec sp_executesql N' exec sp_get_sales_order_promotion_benefit_qualifier @hdr_id, @promotion_id',N'@hdr_id nvarchar(36),@promotion_id nvarchar(4000)',@hdr_id=N'9bc17eeb-842e-4cbd-8ea9-fb8fec04d988',@promotion_id=N''

exec sp_executesql N' exec sp_get_sales_order_promotion_order_qualifier @hdr_id , @member_id, @promotion_id ',N'@hdr_id nvarchar(36),@member_id nvarchar(14),@promotion_id nvarchar(4000)',@hdr_id=N'9bc17eeb-842e-4cbd-8ea9-fb8fec04d988',@member_id=N'KYMMSENG-admin',@promotion_id=N''

exec sp_executesql N' exec sp_get_sales_order_promotion_product_qualifier @hdr_id, @member_id, @promotion_id ',N'@hdr_id nvarchar(36),@member_id nvarchar(14),@promotion_id nvarchar(4000)',@hdr_id=N'9bc17eeb-842e-4cbd-8ea9-fb8fec04d988',@member_id=N'KYMMSENG-admin',@promotion_id=N''

exec sp_executesql N' exec sp_get_sales_order_promotion_benefit @hdr_id,@mechanic_type, @promotion_id',N'@hdr_id nvarchar(36),@mechanic_type nvarchar(4000),@promotion_id nvarchar(4000)',@hdr_id=N'9bc17eeb-842e-4cbd-8ea9-fb8fec04d988',@mechanic_type=N'',@promotion_id=N''

exec sp_executesql N'web_spTransactionPromotionListByOutlet @transaction_type, @transaction_id, @customer_id, @transaction_date',N'@transaction_type nvarchar(10),@transaction_id nvarchar(36),@customer_id nvarchar(36),@transaction_date nvarchar(10)',@transaction_type=N'SalesOrder',@transaction_id=N'9bc17eeb-842e-4cbd-8ea9-fb8fec04d988',@customer_id=N'832cfd31-09db-4f05-998c-e3bf471cd506',@transaction_date=N'2024-07-18'

exec sp_executesql N' exec sp_get_txn_sales_order_promotion_list @hdr_id, @type, @promotion_id',N'@hdr_id nvarchar(36),@type nvarchar(19),@promotion_id nvarchar(4000)',@hdr_id=N'9bc17eeb-842e-4cbd-8ea9-fb8fec04d988',@type=N'Percentage_Discount',@promotion_id=N''

#5 Updated by Rashdan Hussin 2 months ago

  • Assignee changed from Rashdan Hussin to Muhammed Azhar Mohamed Maideen

#6 Updated by Rashdan Hussin 2 months ago

- Need to simulate by create sales order for product that qualified for 2 promotions.
- After upload, check on the web whether the product get both promotion value or not.
- Use suntory preprod to simulate this.

#7 Updated by Rashdan Hussin 2 months ago

Testing finding:
- test using suntory preprod
- create sales order for product 14008193, take promotion TBGT07CCLRTD001 and TBGT07CHJE000001
- upload transaction and check in sales order approval
- found that the product gets both promotion value in mobile, but in web gets only one promotion value
- value in database di, header and details show as mobile value

Sample data:
- org: kymmseng
- user: sr01
- customer: SMY10000851, NT YEN PLUS SDNBHD
- sales order no: SOSR01000531-240724
- product: 14008193, RIB MOB REG JELLY DRINK 160ML CBI 2.0-24
- quantity: 1 car
- promotion: TBGT07CCLRTD001, [TMCD] TM COMBO DEAL CC LEMON & RTD - JULY 24 and TBGT07CHJE000001, [MONTHLY] TRADE BULLETIN GT- CHEERPACK/JELLY

select * from di_mobile_txn_sales_orders where doc_no = 'SOSR01000531-240724'
select * from txn_sales_order_header where ord_hdr_id = '41202809-e9b9-4394-af15-11eb8ccf98a6'
select * from txn_sales_order_details where ord_hdr_id = '41202809-e9b9-4394-af15-11eb8ccf98a6'

#8 Updated by Rashdan Hussin 2 months ago

Another testing:
- test using suntory preprod
- create sales order for product 14006931, take promotion TB05PETALL0001 and TBGT07CCLRTD001
- upload transaction and check in sales order approval
- found that the product gets both promotion value in mobile and web
- no issue

Sample data:
- org: kymmseng
- user: sr01
- customer: SMY10000851, NT YEN PLUS SDNBHD
- sales order no: SOSR01000530-240724
- product: 14006931, Ribena PET 450ml 100% Strawberry
- quantity: 2 car
- promotion: TB05PETALL0001, [MONTHLY] TRADE BULLETIN - PET ALL and TBGT07CCLRTD001, [TMCD] TM COMBO DEAL CC LEMON & RTD - JULY 24

#9 Updated by Rashdan Hussin 2 months ago

  • Status changed from Support In Progress to Escalated to Level 3
  • Assignee changed from Muhammad Arif to Rashdan Hussin
  • % Done changed from 0 to 50
  • Actual Initial Response set to 20/07/2024
  • Resolution updated (diff)

#10 Updated by Rashdan Hussin about 2 months ago

  • Status changed from Escalated to Level 3 to Pending Client Verification

#11 Updated by Rashdan Hussin about 2 months ago

  • Status changed from Pending Client Verification to Ticket Resolved

Also available in: Atom PDF