Datanory Production » Datanory - GOLDCREST

Invoice-INWWV000005-240130 This invoice was not at autocount and but in datanory side the syncdate was null this is because the the collection was tied to this collection number CCWWV000125-240627 But I noticed inthe autocount audit trail the invoice was deleted by admin

----
And the customer is why the inv number and collection number start from 5 and invoice start from 6 not one INWWV000001-4

select * from txn_invoice_history_header where invoice_no like'%INWWV00000%' order by created_date desc
select a.sync_date,a.created_date,a.at_date,a.created_by,updated_by,a.invoice_status,* from txn_invoice_history_header_at a where invoice_no= 'INWWV000005-240130' order by a.at_date desc

2024-01-30 15:05:41.040--> in this dattime the invoice status== auto approve 
-----

for the invoice we notice that
RM6769 - jan 2024--> MCC mobile
AMN-L22 (huawei) - dec 2023
QC_Reference_Phone (qualcomm reference phone) - dec 2023 this device has been used

select * from txn_mobile_header where txn_id in (

--3.2.14.1

'240fd796-d278-42b3-9156-ff4d2a5454f7',
'a5ab4243-2514-4707-8faa-95d3089ca9ef',
'848a7544-9160-4779-8068-68830b9e9840',
'e9388cd4-5701-4581-af16-7fd8a3dbd376',
'8e2cc051-cc9b-4f6a-aab3-bf914f2b9f66')

select * from member where login_id = 'wwv'

select * from txn_invoice_history_header where created_by = '3285f21092ff4c4aa4b8cac31c1fcdbc' order by invoice_no
select * from di_txn_invoice_history where created_by = '3285f21092ff4c4aa4b8cac31c1fcdbc' order by invoice_no
select * from sync_mobile_token where member_id = '3285f21092ff4c4aa4b8cac31c1fcdbc' and created_date <='2024-02-01 00:00:00.000' and (version = '3.2.14.1' or version = '3.2.9.26')

hi arif Already attached the missing invoice and collection in the collection here.
have to wait verification vfrom their side to proceed further. if they claim that these invoice are not made by them . this has to delete them

and ask jann for the reply to the customer.

i Have attached the script to retreive the collection and invoice for WWV user

cancelled invoice

--> INWWV000001-231213
-->INWWV000002-231214
-->INWWV000003-231214

-- DELETED INVOICE (according to Autocount -->tools-->audit trail )
-->INWWV000004-240130
-->INWWV000005-240130

cancelled Collection
-->CCWWV000001-231213
-->CCWWV000002-231214
-->CCWWV000003-

http://124.217.245.100:90/redmine/issues/12131--> this is the ticket that related to this issue.

Based on the screenshot they send there are the invoice that has been found but others they are not able to find

302A/187 please check what happen for this INWWV000005-240130, salesman didn't issue this invoice, start use mobile on June 2024
-- Suzanne Goldcrest
For this case: the invoice INWWV000005-240130 this invoice initially was sync where but I could not found in the autocount
as this invoice with tie with the collection :

Here is the query 
select  * from txn_mobile_collection_header where col_no= 'CCWWV000125-240627'
select * from txn_mobile_collection_invoice where col_id= '80b004e6-c1e5-415f-a8d3-dac2ffb9458e'
select * from txn_invoice_history_header where invoice_id= '708d3eed-500f-4838-aa22-eeacb1dca9be'
select a.at_date,a.at_type,a.updated_date,a.updated_by,* from txn_invoice_history_header_at a where invoice_id= '708d3eed-500f-4838-aa22-eeacb1dca9be' order by a.at_date desc

but as I checked in the Autocount the particular invoice was deleted ( as I attached the image below)

-----
select a.at_date,a.at_type,a.updated_date,a.updated_by,invoice_status,* from txn_invoice_history_header_at a where invoice_id= '708d3eed-500f-4838-aa22-eeacb1dca9be' order by a.at_date desc

--> as I Checked in the at_table the status was Auto-approved before the patch was done. I suspect the delete did not reflected in the datanory

Need your assistance on this ticket to futher check on this to find the root cause.

[11:44 am, 09/07/2024] Arif Ibrahim: Hi Charlene
[11:46 am, 09/07/2024] Arif Ibrahim: regarding to this issue, upon checking we find out that these were the test data we migrated from trial environment. we shall remove the txn.
[11:46 am, 09/07/2024] Arif Ibrahim: INWWV000001-231213
INWWV000002-231214
INWWV000003-231214
INWWV000004-240130
INWWV000005-240130

CCWWV000001-231213
CCWWV000002-231214
CCWWV000004-240130
CCWWV000003-240130
[11:46 am, 09/07/2024] Arif Ibrahim: above is the list of txn we want to romove. kindly help to verify before we proceed to remove

hi @⁨~Suzanne⁩ , the collection and invoices are already disappeared please and check and verify and let us know if the problem is still persist. thank you

Customer was claimed the cancelled invoice appears in the mobile as we check from our side, there is only one Invoice.

hi arif

This ticket need to follow up since then the ticket already closed. Today I al ready follow up with customer