Production Ticket(ST) #12159
OROMEO - Why 2 SKU missing ya
1) Check the product and customer price code.
2) Update all the customer price code.
Root cause: Customer price code not same as product price code.
None
Description
Double choc n berries still tiada dalam sku stock count
Why 2 SKU missing ya
All this chain store missing these 2 SKUs
History
#1 Updated by Rashdan Hussin 3 months ago
- Status changed from Assigned To to Support In Progress
select * from customer where org_id = 'OROMEO' order by updated_date desc
select * from mst_price_code where org_id = 'OROMEO'
select * from customer where org_id = 'OROMEO' and price_id <> '8AF04032-222F-44CE-8BD6-F263A3272CE6'
--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'
--select * into DMS_Ecosystem_Backup_Table.dbo._customer_20240705 from DMS_EcoSystem.dbo.customer
select * from product_item a
inner join mst_product_price b on b.item_id = a.item_id and b.org_id = 'OROMEO'
inner join mst_price_code c on c.price_id = b.price_code_id and c.org_id = 'OROMEO'
where not exists (select 1 from mst_product_price x where a.org_id = 'OROMEO' and x.item_id = a.item_id and x.price_code_id = '8AF04032-222F-44CE-8BD6-F263A3272CE6')
and a.org_id = 'OROMEO'
#2 Updated by Rashdan Hussin 3 months ago
- Status changed from Support In Progress to Pending Client Verification
- % Done changed from 0 to 90
- Actual Initial Response set to 04/07/2024
- Resolution updated (diff)
#3 Updated by Rashdan Hussin 3 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100