Project

General

Profile

Production Ticket(ST) #11213

GOLDCREST- inv should be under Shah Idi, why change to amother customer in autocount ya?

Added by Rashdan Hussin 6 months ago. Updated 6 months ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Muhammed Azhar Mohamed Maideen
Start date:
14/03/2024
Due date:
20/03/2024
% Done:

0%

Estimated time:
Spent time:
2.00 h
Job Remark:
Ticket Logged Date:
14/03/2024
Ticket No.:
Related Ticket ID:
Type:
User Enquiry & Clarification
SLA Initial Response:
14/03/2024
SLA Delivery:
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
16/03/2024
Resolution:

the customer code '302S/159' should correspond to 'Sinar Kifarah Global S/B - 5WWX-2', while '302S/162' should correspond to 'Shah Idi Jaya Enterprise-5WWX-2'
Admmin assigned code incorrect
Root Cause- user operational

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

None

Description

inv should be under Shah Idi, why change to amother customer in autocount ya?

4149d3f3-3d8e-4bdd-a180-ce457862f406.jpg (69.1 KB) 4149d3f3-3d8e-4bdd-a180-ce457862f406.jpg Rashdan Hussin, 14/03/2024 05:14 PM
2bf6fd37-ff48-4e2b-9561-75ae969dd784.jpg (178 KB) 2bf6fd37-ff48-4e2b-9561-75ae969dd784.jpg Rashdan Hussin, 14/03/2024 05:14 PM

History

#1 Updated by Rashdan Hussin 6 months ago

  • Assignee changed from Rashdan Hussin to Muhammed Azhar Mohamed Maideen

#2 Updated by Muhammed Azhar Mohamed Maideen 6 months ago

  • Project changed from Datanory Production to Datanory - GOLDCREST

#3 Updated by Muhammed Azhar Mohamed Maideen 6 months ago

  • Status changed from Assigned To to Support In Progress

#4 Updated by Muhammed Azhar Mohamed Maideen 6 months ago

  • Status changed from Support In Progress to Ticket Resolved
  • Type set to User Enquiry & Clarification
  • Actual Initial Response set to 16/03/2024
  • Resolution updated (diff)

select * from txn_mobile_header where txn_id = '89b13fa9-73d5-4154-bc92-1314b0820f3f'

--select * from member where member_id= 'dc954dfdc1db4e2aaf9d2759a1522725'

select * from di_mobile_txn_salesman_route where transaction_id = '89b13fa9-73d5-4154-bc92-1314b0820f3f'

select * from di_mobile_txn_salesman_route_at where transaction_id = '89b13fa9-73d5-4154-bc92-1314b0820f3f'

select * from customer where customer_id= '22361f58-d7c4-4050-ab17-212018593906'

select * from customer where customer_id ='22361f58-d7c4-4050-ab17-212018593906';

SELECT 

b.customer_code,
b.customer_name,   *

FROM 

txn_invoice_history_header a

INNER JOIN 

customer b ON a.customer_id = b.customer_id

WHERE 

a.org_id ='goldcrest'
AND invoice_no='INWWX000271-240223'
order by a.created_date desc

-- THIS INVOICE IS SUPPOSE TO BE SYAH IDI BUT WHY IN THE SINAR KIFAYAH

select * from txn_mobile_collection_invoice_at where inv_id= '9b17d1c1-fe93-4be8-885f-f50b00737d3a' -- no collection

SELECT * FROM CUSTOMER WHERE customer_name LIKE '%Sinar Kifarah Global S/B - 5WWX-2%' -- CUSTOMER CODE IS 302S/159

SELECT * FROM mst_customer_contact_address_at where customer_id= '22361f58-d7c4-4050-ab17-212018593906'

SELECT * FROM CUSTOMER WHERE customer_name LIKE '%Shah Idi Jaya Enterprise-5WWX-2%' -- CUSTOMER CODE IS 302S/162

-- in datanory is sinar kifarah

-- but in receipt is Syah Idi

-- but in auto count is Syah Idi

-- actual is suppose to be syahID 

select * from  txn_invoice_history_header where invoice_no ='INWWX000271-240223'
select * from di_mobile_txn_collection_invoices where invoice_id = '9b17d1c1-fe93-4be8-885f-f50b00737d3a'
-- no collection has been made
select * from di_txn_invoice_history where invoice_id = '9b17d1c1-fe93-4be8-885f-f50b00737d3a'
select * from di_mobile_txn where transaction_id= '89b13fa9-73d5-4154-bc92-1314b0820f3f'
select  * from txn_mobile_header where txn_id= '89b13fa9-73d5-4154-bc92-1314b0820f3f'
-- why the status is in pending ??
select * from  di_mobile_txn_sales_orders where transaction_id= '89b13fa9-73d5-4154-bc92-1314b0820f3f'
select * from  txn_sales_order_header where ord_hdr_id= 'b55511a8-104f-446d-b927-db6a03621dff'
select * from txn_sales_order_details where ord_hdr_id= 'b55511a8-104f-446d-b927-db6a03621dff'
select * from customer_at a where customer_id ='22361f58-d7c4-4050-ab17-212018593906' order by a.at_date

select * from txn_invoice_history_header where invoice_no ='INWWX000271-240223'

select * into DMS_EcoSystem_backup_table.dbo._txn_invoice_history_header_Azhar20240316

from DMS_EcoSystem.dbo.txn_invoice_history_header

select * from txn_invoice_history_header where invoice_no ='INWWX000271-240223'

-- Update customer_id

UPDATE txn_invoice_history_header

SET customer_id = '78046D08BCEB4FEEA3DFFA7F9E7CD4F6'

WHERE customer_id = '22361f58-d7c4-4050-ab17-212018593906'

and invoice_id= '9b17d1c1-fe93-4be8-885f-f50b00737d3a';

Also available in: Atom PDF