Production Ticket(ST) #10992
YUENTUNG - Was issue few invoice for customer and suddenly can’t search any product
1) Check the relation between customer and SKU which is price_code.
2) We have revert the customer price code for all according to previous setup.
3) Advise YT to setup the product list and price for the new price code in Datanory product import module.
Root cause: They create new price code and setup for customer only, not for product as well. So, the price code for product not relate to the customer.
None
Description
- Was issue few invoice for customer and suddenly can’t search any product
- Now product also lost???
History
#1 Updated by Rashdan Hussin 7 months ago
- File WhatsApp Video 2024-02-19 at 19.07.20.mp4 WhatsApp Video 2024-02-19 at 19.07.20.mp4 added
- Status changed from Assigned To to Support In Progress
#2 Updated by Rashdan Hussin 7 months ago
- File YT_Master_Data_Issue_NewDB.xlsx YT_Master_Data_Issue_NewDB.xlsx added
- Status changed from Support In Progress to Ticket Resolved
- % Done changed from 0 to 100
- Esclation Time set to 20/02/2024
- Actual Initial Response set to 20/02/2024
- Resolution updated (diff)
select * from product_item where org_id = 'yuentung'
select * from mst_product_price where org_id = 'yuentung'
select * from mst_price_code where org_id = 'yuentung'
select a.item_code, b.price_code_id, c.price_code from product_item a
inner join mst_product_price b on a.item_id = b.item_id
inner join mst_price_code c on b.price_code_id = c.price_id
where a.org_id = 'yuentung'
select * from customer where org_id = 'yuentung'
select a.customer_code, b.price_code from customer a
inner join mst_price_code b on a.price_id = b.price_id
where a.org_id = 'yuentung'