Production Ticket(ST) #11441
GOLDCREST - can help us check this invoice was manually cancel in out autocount, but still showing in mobile?
1) Escalated to L3 for further checking
2) Release new version, 3.2.20.2
3) Cater the cancelled invoice/CN/Collection when integrate the "Cancel" status update from Autocount
Root cause: currently the cancellation done in autocount will not be reflected in the Datanory as we did not integrated back the status from the Autocount to Datanory when there is changes, need to manual update the status for both side
None
History
#1 Updated by Muhammed Azhar Mohamed Maideen 6 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Muhammed Azhar Mohamed Maideen 6 months ago
- Status changed from Support In Progress to Escalated to Level 3
- Resolution updated (diff)
BAsed on my checking in the autocount the status is cancelled
select * from iv where Docno= 'IN/KL/2206/015'
I notices that the last modified date is 2022-07-01 15:42: and canceled is true.
Based on the explanation given by shan you, based on the current integration logic it will not picked the cancelled status and integrate back to datanory
so Miss Jann pm me the click up link as they will study further on this
#3 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
As I check with shan you the work on this task will be started by today and expected to deploy by tomorrow
#5 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
- Due date changed from 15/04/2024 to 22/04/2024
#6 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
As I Checked with tech team this issue will be solved by tomorrow
Have to follow up tomorrow(24/04/2024) again with tech team
#7 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
The deployment expected today
#8 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
As I checked with shan you His side is ook the mobile side there are some fixed as mean made
Mean while I have been asked to do patching for the invoice IN/kl/2206/015
Need advise from Afiq or Arif for this tomorrow
#9 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
select *
--i.invoice_id
-- , i.customer_id
-- , i.currency_value, i.invoice_balance, 'Active' as status
-- , c.customer_code
-- , i.invoice_date, i.invoice_no, i.discount1, i.order_web_total_discount_amount, i.perpetual_discount_amount
from txn_invoice_history_header i
inner join customer c on c.customer_id = i.customer_id
left join customer mc on mc.customer_id = c.master_account
where invoice_no = 'IN/kl/2206/015'
HI rashdan I able to check in the Stored Procedure_ SP_sync_download Invoice As I check with Arif, He will discuss with technical team further on this ticket.
#10 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
- Assignee changed from Muhammed Azhar Mohamed Maideen to Rashdan Hussin
#11 Updated by Rashdan Hussin 5 months ago
- Subject changed from Goldcrest- can help us check this invoice was manually cancel in out autocount, but still showing in mobile? to GOLDCREST - can help us check this invoice was manually cancel in out autocount, but still showing in mobile?
- Due date changed from 22/04/2024 to 27/04/2024
- Status changed from Escalated to Level 3 to Pending Client Verification
- % Done changed from 0 to 90
- Type set to Support Request
- SLA Delivery set to 27/04/2024
- Actual Initial Response set to 12/04/2024
- Resolution updated (diff)
Currently mobile does not check the approval status so if its cancelled it will still show. Shu ern planning to change this in mobile, but i got tell Azhar for temporary workaround can just set all cancelled invoice balance to 0
select * from txn_invoice_history_header where invoice_no = 'IN/KL/2206/015'
--update txn_invoice_history_header set invoice_balance = '0', updated_date = GETDATE, updated_by = 'Support'
--where invoice_no = 'IN/KL/2206/015'
#12 Updated by Rashdan Hussin 5 months ago
- although cancelled status is updated, but the cancelled status is not update in mobile at the moment, as the invoices downloaded is active by default and not cancelled
- meaning previously downloaded invoices will not be updated
- for workaround i need to patch the invoice balance become 0
--update txn_invoice_history_header set invoice_balance = '0', updated_date = GETDATE, updated_by = 'Support'
--where org_id = 'goldcrest'
--and updated_by = 'INTEGRATION_API'
--and invoice_status = 'Cancelled'
--and invoice_balance <> '0'
#13 Updated by Rashdan Hussin 5 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100