Datanory Production » Datanory - GOLDCREST

Already asked the customer What is the main concern regarding this escalation.
Waiting to customer to give feedback

Hi, pls check, WWX started use mobile app in Feb 2024, how come this invoice and CN in mobile app? This issue showing again and again...

--IN/KL/2309/018--
-- customer
select * from customer where customer_code like'%305a/005%'
-- customer to user relation
select * from customer_to_user_relation where customer_id= '815F7D060533408DAFFBAB77C7E4FC2C' order by updated_date desc
select * from member where member_id in ('0d5eda133f2946f1aef06803ac753cc9',
'2c9e40b5f5904775b71192b8fd8b71ad',
'dc954dfdc1db4e2aaf9d2759a1522725')
-- this customer assigned to TCW,MCJ,WWX
-- invoice history
select created_by,created_date,updated_by,updated_date,* from txn_invoice_history_header where invoice_no like 'IN/KL/2309/018' and org_id= 'goldcrest' -- created and updated by integration
select a.at_date, a.at_type,a.at_date,a.updated_by,a.created_by,* from txn_invoice_history_header_at a where invoice_id= '965B1EDB516E4B07AAD439FEE8908CF3' order by a.at_date desc
select * from txn_invoice_history_detail where invoice_id='965B1EDB516E4B07AAD439FEE8908CF3'
-- invoice created by integration
-- why it change to 412.80 again instead of 402.80?
-- this invoice is assigned to TCW not WWX
select * from txn_mobile_collection_invoice where inv_id= '965B1EDB516E4B07AAD439FEE8908CF3'
select a.at_date,a.at_type,a.created_by,a.created_date,a.updated_by,a.updated_date,* from txn_mobile_collection_invoice_at a where inv_id= '965B1EDB516E4B07AAD439FEE8908CF3' order by a.at_date desc

-- status pending
-- this

select * from di_mobile_txn_collection_header where collection_id='d489f5c6-f608-4558-a1bc-f7ccb2f79f10'
select * from txn_mobile_collection_header where col_id= 'd489f5c6-f608-4558-a1bc-f7ccb2f79f10' -- CCTCW000001-231117 status pending --user TCW
select * from txn_mobile_collection_header_at where col_id= 'd489f5c6-f608-4558-a1bc-f7ccb2f79f10' -- CCTCW000001-231117 status pending
select * from txn_mobile_collection_detail where col_id= 'd489f5c6-f608-4558-a1bc-f7ccb2f79f10' -- CCTCW000001-231117 status pending
select * from stg_accounting_import_invoice where DOC_NO= 'IN/KL/2309/018' order by created_date desc
select * from txn_mobile_collection_detail_at where col_id= 'd489f5c6-f608-4558-a1bc-f7ccb2f79f10' -- CCTCW000001-231117 status pending outstanding amount is 0

-- in di _table under collection reference id is mentioned test and created by TCW
--outstanding amount 0, bu but still show in the mobile
-- but the real concern is why it is shownin WWX user.
--------------------------------------------------------------------------------------------------------------------------------------------
select sync_date,created_by,created_date,updated_by,updated_date,* from txn_credit_note_history_header where credit_note_no= 'CNGC000001-231117'
select a.at_date,a.at_type,a.created_by,a.created_date,a.updated_by,a.updated_date,* from txn_credit_note_history_header_at a where credit_note_no= 'CNGC000001-231117' order by a.at_date desc
select a.at_date,a.at_type,a.created_by,a.updated_by,a.updated_date,* from txn_mobile_collection_detail_at a where org_id= 'goldcrest'
select updated_by,created_by,created_date,updated_date,* from txn_credit_note_history_detail where credit_note_id= '534A46CCE9834EF789A21B3F565206A6'

-- hi arif, as I checked for this, I suspect this could be testing data that is done by goldcrest since all are updated by integration and Goldcrest admin.
-- need ur verification and clarification on this ticket

https://app.clickup.com/t/86eprj3pv

IN/KL/2309/018
as checked, this is old invoice (inv date: 2023-09-13 00:00:00.000). this invoice appeared in invoice list again due to integration calculation logic caused the balance incorrect.

Hi @Mcc Jann , currently we have 1 reported issue from goldrest regarding to the invoice appeared in outstanding

Note: to call GC on next tuesday to confirm all pending inv still valid or not.
select * from txn_mobile_collection_header where status ='pending' and created_date < '2024-01-01'
CCTCW000001-231117
CCEVO000002-231119
CCEVO000001-231119
CCEVO000003-231119

Azhar to follow up with Shan You

already asked to customer either these collection are valid or not since these collection is in pending status, Hence it did not flow to autocount

waiting for customer for feedback from customer

Hi @Azhar , please do the workaround and perform testing in trial environment

https://app.clickup.com/t/86epwq9ug