Datanory Production » Datanory - GOLDCREST

select a.eod_date,b.eod_date,a.product_id, a.stock_balance_qty,b.opening_qty from txn_mobile_eod a
inner join txn_mobile_eod b on a.stock_type = b.stock_type and a.product_id = b.product_id and a.member_id = b.member_id and a.org_id = b.org_id and b.eod_date ='2024-06-04 00:00:00.000'
where
a.eod_date ='2024-06-01 00:00:00.000'
and a.stock_type ='Good'
and a.member_id = '2c9e40b5f5904775b71192b8fd8b71ad'
and b.product_id= '90A996A05BCC459D921AB379F6DEB7EF'
--and a.stock_balance_qty <> b.opening_qty

select * from txn_mobile_van_inventory_header where salesman_id = '2c9e40b5f5904775b71192b8fd8b71ad' and stock_type= 'good' order by created_date desc
select * from txn_mobile_van_inventory_detail where van_inventory_hdr_id= 'df6dec66-2a33-4cfd-95e6-c9743da0ebd2' and item_id= '90A996A05BCC459D921AB379F6DEB7EF' -- 2024-06-04 06:16:10.000
select * from txn_mobile_van_inventory_detail where van_inventory_hdr_id= '3e1a9eb9-076a-4d36-8a43-9b3e9b0990b9' and item_id= '90A996A05BCC459D921AB379F6DEB7EF'-- 2024-06-01 06:19:50.000

select * from di_mobile_txn_eod where product_id='90A996A05BCC459D921AB379F6DEB7EF' and eod_date='2024-06-04 00:00:00.000' and stock_type= 'good'order by created_date desc --and eod_id='DDCE6C1A-72E6-4DA5-B9A6-D8147FBAD48310c19d6e-d962-4a54-932e-114207ce5ae520240527Bad'

select a.at_date,a.at_type, * from txn_mobile_eod_at a where product_id='90A996A05BCC459D921AB379F6DEB7EF' and eod_date='2024-06-01 00:00:00.000' and stock_type= 'good' order by a.at_date desc --and eod_id='DDCE6C1A-72E6-4DA5-B9A6-D8147FBAD48310c19d6e-d962-4a54-932e-114207ce5ae520240527Bad'

select a.at_date,a.at_type, * from txn_mobile_eod_at a where product_id='90A996A05BCC459D921AB379F6DEB7EF' and eod_date='2024-06-04 00:00:00.000' and stock_type= 'good' order by a.at_date desc --and eod_id='DDCE6C1A-72E6-4DA5-B9A6-D8147FBAD48310c19d6e-d962-4a54-932e-114207ce5ae520240527Bad'

For this case we have to do test case for this