Datanory Production » Datanory - SNEKKU

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 ='snekku'  
    AND  b.customer_code like'5l019'  

order by a.created_date desc

select * from member where member_id= '054e3f6fc4bb4bbf98f791a6db0f54b4'
 select * from stg_accounting_import_credit_note where DOC_NO= 'CN24/002144' order by CREATED_DATE desc
 -- in staging it is showing 32.95 which is correct 
 --2024-03-26 17:08:23.130 --> this is the last timing where the value was 32.85 then it changes to 32.95

select * from txn_credit_note_history_header where customer_id= 'E323226871FE49B4AE4B0D2AF3221D98' order by created_date desc
 -- in currency_value it shows 32.85
    select * from txn_credit_note_history_detail where credit_note_id= '22FBDDB3D76E4B4BAE1C6994A6DF68B6' order by created_date desc

select s.BALANCE, s.DOC_NO
    from stg_accounting_import_credit_note s
    INNER JOIN sync_integration_token t ON t.token_id = s.TOKEN_ID
    inner join txn_credit_note_history_header h on h.credit_note_no = s.DOC_NO
    WHERE s.TOKEN_ID = 'BC9F3913-8194-46D7-BB17-01C72B58E58B' AND s.PROCESS_ID = '831780a8-7d11-440d-a751-463078f6257ff' and h.credit_note_balance <> cast(s.BALANCE as decimal(18,2)) and s.DOC_NO= 'CN24/002144'

-- at table is  32.85
select * from txn_credit_note_history_header_at where credit_note_no like  'CN24/002144' order by created_date desc
-- the currency value the value is 32.85

Client Reply:
hi @~Leewei as we check on this escalation credit note with the number CN24/002144 , we noticed that there have been some changes made after 2024-03-26 17:08:23.130. Specifically, the value was changed to 32.95 by *2024-03-26 18:10:35.220*Could you kindly check from your end whether any changes were made within that specified timeframe? Thank you for your assistance.

select * from txn_credit_note_history_header where credit_note_no ='CN24/002144'
select * from txn_credit_note_history_detail where credit_note_id ='22FBDDB3D76E4B4BAE1C6994A6DF68B6' and credit_note_detail_id ='AE3D2EE8CFDB475689F1653A56CC2C07'

-- Back up txn_credit_note_history_header_16042024_
select * into DMS_EcoSystem_backup_table.dbo.txn_credit_note_history_header_16042024_
from DMS_EcoSystem.dbo.txn_credit_note_history_header
-- Back up txn_credit_note_history_detail_16042024
select * into DMS_EcoSystem_backup_table.dbo.txn_credit_note_history_detail_16042024
from DMS_EcoSystem.dbo.txn_credit_note_history_detail

--update txn_credit_note_history_header set currency_value='32.95' where credit_note_no = 'CN24/002144'
--update txn_credit_note_history_detail set line_total='3.35' where credit_note_id ='22FBDDB3D76E4B4BAE1C6994A6DF68B6' and credit_note_detail_id ='AE3D2EE8CFDB475689F1653A56CC2C07'
--update txn_credit_note_history_detail set price='3.35' where credit_note_id ='22FBDDB3D76E4B4BAE1C6994A6DF68B6' and credit_note_detail_id ='AE3D2EE8CFDB475689F1653A56CC2C07'
--update txn_credit_note_history_detail set amount='3.35', mprice='3.35' where credit_note_id ='22FBDDB3D76E4B4BAE1C6994A6DF68B6' and credit_note_detail_id ='AE3D2EE8CFDB475689F1653A56CC2C07'

----AE3D2EE8CFDB475689F1653A56CC2C07
--mprice
--line total
--price
--amount