Datanory Production » Datanory - GOLDCREST

hi @~Suzanne as we check from our side , we found transactions for both customer outlets are made. Could you please verify which customer account is the correct one?

For the first account, there are three sales orders:

SOWWX000622-240322
SOWWX000024-240202
SOWWX000269-240224
For the second account, there is one transaction:

SOWWX001637-240628
Please verify from your side so that we can proceed with further checks on this escalation.

Thank you.

select c.created_date,c.created_by, c.updated_by,* from customer c where customer_code= '302P/323' order by c.created_date desc --44a99c6c-7554-4e78-9d24-b240edf438f9
--. the latest customer created by Goldcrest on 1 july
-- existing customer code is created by integration API on 7/11/2023

select * from txn_sales_order_header where customer_id= '44a99c6c-7554-4e78-9d24-b240edf438f9' -- one transaction has been made BY wwx--> 302P/323
select * from txn_sales_order_header where customer_id= 'CB26C4F6A82646B2ACBAE66F93868E0D'--> three Transaction has been made BY WWX --> 302P/323
select * from member where member_id='dc954dfdc1db4e2aaf9d2759a1522725'
-- Transaction made by WWX
select * from txn_sales_order_header where customer_id= '5B12ED6F8E8F4C06B196F23526611615'--> Four Transaction has been made BY WWX--> 302A/205

Hi rashdan regarding this issue waiting for customer feedback Which account is correct

302P/323 on April change code to 302A/205 bcoz change name and new owner

select a.created_date as 'Create customer Date',so.order_no,a.created_by,a.customer_code,a.customer_code, a.updated_by, a.updated_date from customer a
inner join txn_sales_order_header so on a.customer_id= so.customer_id
where a.customer_id= '44a99c6c-7554-4e78-9d24-b240edf438f9' --order by a.at_date desc --> this is created on 1/07/2024

select a.created_date as 'Create customer Date', so.order_no,a.created_by,a.customer_code,a.customer_code, a.updated_by,a.created_date, a.updated_date from customer a
inner join txn_sales_order_header so on a.customer_id= so.customer_id
where a.customer_id= 'CB26C4F6A82646B2ACBAE66F93868E0D' --order by a.at_date desc--> 7/11/23

Hi @~Suzanne , as per our discussion, for the next master data update (customer & Route planning), please help to informed me earlier. so we can set time to do it together via Teams call.