Production Ticket(ST) #12238
OROMEO - these 2 SKUs not in lotus's list as well
1) Check the price code for SKU and customer.
2) Found that some customer price code was changed due to customer import overwrite.
Root cause: Customer price code was overwrite.
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 2 months ago
- Assignee changed from Muhammed Azhar Mohamed Maideen to Rashdan Hussin
#2 Updated by Rashdan Hussin 2 months ago
- Subject changed from Oromeo - these 2 SKUs not in lotus's list as well. please check for user 120013 to OROMEO - these 2 SKUs not in lotus's list as well
- Status changed from Assigned To to Support In Progress
#3 Updated by Rashdan Hussin 2 months ago
- Status changed from Support In Progress to Pending Client Verification
- % Done changed from 0 to 90
- Type set to Support Request
- SLA Delivery set to 16/07/2024
- Actual Initial Response set to 15/07/2024
- Resolution updated (diff)
select * from customer where org_id = 'oromeo' and price_id <> '8AF04032-222F-44CE-8BD6-F263A3272CE6'
select * from mst_price_code where org_id = 'oromeo'
select * from customer where org_id = 'oromeo' and customer_code = 'LO1016'
select * from customer_at where org_id = 'oromeo' and customer_code = 'LO1016'
--select * into DMS_Ecosystem_Backup_Table.dbo._customer_20240715
--from DMS_EcoSystem.dbo.customer
--update customer set price_id = '8AF04032-222F-44CE-8BD6-F263A3272CE6', updated_date = getdate(), updated_by = 'Support'
--where org_id = 'oromeo' and price_id <> '8AF04032-222F-44CE-8BD6-F263A3272CE6'
#4 Updated by Rashdan Hussin 2 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100