Production Ticket(ST) #11846
DailyFresh- KUA04 Stock Ballance semalam tiada dalam stock Hari ini
1) Requested user to upload database
2) simulate the database
Root cause- User Operational
None
Description
Hi Technical Team. Please advice for this issue
History
#1 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- File WhatsApp Audio 2024-05-28 at 14.49.24_e2bbf05e.opus WhatsApp Audio 2024-05-28 at 14.49.24_e2bbf05e.opus added
- Status changed from Support In Progress to Pending Client Feedback
As I checked , User will upload database tomorrow
#3 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Status changed from Pending Client Feedback to Support In Progress
SELECT t.created_date,t.opening_qty,t.stock_balance_qty,t.van_in_qty,t.van_out_qty, p.item_name,*
FROM txn_mobile_eod t
INNER JOIN product_item p ON t.product_id = p.item_id
WHERE t.member_id = 'F7467CEA-63B6-4DD2-8463-91DA1DBC116F'
AND t.created_date BETWEEN '2024-05-27' AND '2024-05-28'
ORDER BY t.created_date DESC;
-- as I checked in the database, there is no EOD balance on 28th of may 2024 the latest one os on 29th may
#4 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Status changed from Support In Progress to Pending Client Feedback
hi @~NanaAzira , noted on this escalation we will check on this. thank you
#5 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Status changed from Pending Client Feedback to Ticket Resolved
- Type set to Support Request
- Actual Initial Response set to 30/05/2024
- Resolution updated (diff)
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-05-28 00:00:00.000'
where
a.eod_date ='2024-05-27 00:00:00.000'
and a.stock_type ='Good'
and a.member_id = 'F7467CEA-63B6-4DD2-8463-91DA1DBC116F'
and a.stock_balance_qty <> b.opening_qty
#8 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
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-05-28 00:00:00.000'
where
a.eod_date ='2024-05-27 00:00:00.000'
and a.stock_type ='Good'
and a.member_id = 'F7467CEA-63B6-4DD2-8463-91DA1DBC116F'
and a.stock_balance_qty <> b.opening_qty