Datanory Production » Datanory - GOLDCREST

select * from txn_invoice_history_header where invoice_no= 'inwwx001398-240530'
select a.at_date,* from txn_invoice_history_header_at a where invoice_no= 'inwwx001398-240530' order by a.at_date desc

- In mobile db, INWWX001398-240530 got double. INWWX001399 skipped.
- Got different with product price.

select * from member where member_cd = 'wwx'

select * from txn_invoice_history_header where invoice_no like '%INWWX001398%'
select * from txn_invoice_history_header_at where invoice_no like '%INWWX001398%'
select * from di_txn_invoice_history where invoice_no like '%INWWX001398%'

select * from txn_invoice_history_header where invoice_no like '%INWWX001399%'
select * from txn_invoice_history_header_at where invoice_no like '%INWWX001399%'
select * from di_txn_invoice_history where invoice_no like '%INWWX001399%'

select * from txn_invoice_history_header where member_id = 'dc954dfdc1db4e2aaf9d2759a1522725' order by invoice_no desc

select * from txn_sales_order_header where ord_hdr_id = 'afb8ee3e-4b16-4602-a230-e25fad8ad77f'
select * from txn_sales_order_details where ord_hdr_id = 'afb8ee3e-4b16-4602-a230-e25fad8ad77f'

select * from txn_mobile_collection_invoice where inv_id = '8faae839-8343-428f-871b-edc6f31d0fb9'

select * from sync_mobile_activity_log where member_id = 'dc954dfdc1db4e2aaf9d2759a1522725' and action_type = 'Upload' order by created_date desc

--User create invoice on 30/5, but upload on 31/5

we were able to replicate the issue in a trial.
User: WWX
Customer Code: 302E009 - EXPRESS MINI MARKET - 1 WWX-2
Steps to replicate the issue:
Check in at the outlet.
Create a sales order — an invoice is generated (Van sales).
Click on "Preview Invoice" and then click "Confirm".
Go back and click "Save" and preview the receipt again, then click "Confirm".
Check the collection module.
When the transaction and mobile database are uploaded and downloaded again, the duplicate invoices are no longer present under collection module. However, upon checking the mobile database, we found that invoices were duplicated and the running numbers were skipped. Please refer to the attached video and files for further reference.

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