Datanory Production » Datanory - GOLDCREST

As I checked in the DMS database and Mobile database there are 15 transaction that is made on 28 of june. We notice that in the mobile display there is only.

INWWX001635-240628--> this invoice is missing in the mobile display and As I check the invoice status is auto approved and not been cancelled.

As I download back, this invoice can be found in the invoice history details

Already asked shu ern on this waiting for her feedback

select * from member where member_id= '2c9e40b5f5904775b71192b8fd8b71ad'--mcj
select * from member where member_id= 'dc954dfdc1db4e2aaf9d2759a1522725'-- wwx
select * from customer where customer_id= '44a99c6c-7554-4e78-9d24-b240edf438f9'
select a.created_date,a.at_date, a.updated_date,* from customer_at a where customer_id= '44a99c6c-7554-4e78-9d24-b240edf438f9' order by a.at_date desc
select * from customer where customer_code like '302P/323' and org_id= 'goldcrest'
select * from customer_to_user_relation where customer_id= '44a99c6c-7554-4e78-9d24-b240edf438f9'

select * from di_mobile_txn_check_in where transaction_id= '16e2afe2-a08b-48b7-b28b-180903bca086'
select * from txn_mobile_header where txn_id= '16e2afe2-a08b-48b7-b28b-180903bca086'
select * from txn_sales_order_header where ord_hdr_id= '1f91d415-04bd-4507-9fec-8cb1b9987904'
SELECT invoice_status,sync_date,created_date,updated_by,created_by,*
FROM txn_invoice_history_header where org_id= 'goldcrest' and invoice_no like '%Inwwx001635%'

select * from customer where customer_id= '44a99c6c-7554-4e78-9d24-b240edf438f9'
-- as I check the customer number is same but the CODE is different
-- in mobile database-->NC000823
-- in DMS--> is 302P/323
------------------------------------------------------------------

SELECT invoice_status, sync_date,created_date,*
FROM txn_invoice_history_header
WHERE org_id = 'goldcrest'
AND (
invoice_no LIKE '%Inwwx001632%' OR
invoice_no LIKE '%Inwwx001633%' OR
invoice_no LIKE '%Inwwx001634%' OR
invoice_no LIKE '%Inwwx001635%' OR
invoice_no LIKE '%Inwwx001636%' OR
invoice_no LIKE '%Inwwx001637%' OR
invoice_no LIKE '%Inwwx001638%' OR
invoice_no LIKE '%Inwwx001639%' OR
invoice_no LIKE '%Inwwx001640%' OR
invoice_no LIKE '%Inwwx001641%' OR
invoice_no LIKE '%Inwwx001642%' OR
invoice_no LIKE '%Inwwx001643%' OR
invoice_no LIKE '%Inwwx001644%' OR
invoice_no LIKE '%Inwwx001645%' OR
invoice_no LIKE '%Inwwx001646%'
)