Datanory Production » Datanory - GOLDCREST

select * from member where member_cd= 'mcj'
select a.eod_id,a.eod_date,b.eod_date,a.product_id,pro.item_name,a.stock_balance_qty,b.opening_qty, b.van_in_qty,b.van_out_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-05-30 00:00:00.000'
inner join product_item pro on a.product_id=pro.item_id
--inner join warehouse_inventory_detail inv on a.product_id=inv.item_id
where
a.eod_date ='2024-05-30 00:00:00.000'
and a.stock_type ='Good'
and a.member_id = '2c9e40b5f5904775b71192b8fd8b71ad'
and a.stock_balance_qty <> b.opening_qty

as I simulate the issue the opening balance is not tally as closing stock previous day.
this issue was happen previously http://124.217.245.100:90/redmine/issues/11539

The way I simulate , open the eod summary, scroll until bottom and can see the button confirm, request user to click 'confirm', once user click 'confirm', application will automatically closed. user need to open the application again, and check the summary. stock balance already  tally already

Rashdan to perform simulation, see whether can approve van receive 2 times or not (try to double click or etc)

Testing Finding: Version 4.2.0-trail.2--> latest version

currently I was doing testing in latest trail environment based on my testing the opening today(16/07/2024) and for the next day (17/07 manually changed the time in the mobile.

rg_id= Goldcrest

User MCJ

1) perform vangood request:

SKU

250-BC01

250-LC01

2) Approve in the web portal

VQMCJ000021-240716

Perform Full download again

) got to van good receive

warehouse MCJ

• click approve twice instantly

change the date In mobile to the next day

Found that the stocks are tally.