Invoice Status Transition Issue: from overdue to view
Description
Environment
None
QA Notes
None
Attachments
3
Activity
Show:
Lourdes Munoz
made 3 changes13 hours ago
Summary
Invoice Status Transition Issue
Invoice Status Transition Issue: from overdue to view
Description
|*BUG REPORTED DETAILS:*
There is an issue where the invoice does not transition to “Overdue” status as expected. E.g. there are multiple invoices that expired March 25 and still status is viewed or sent. Action: Please investigate and resolve the issue.|
!image-20250404-133019.png|width=395,height=387,alt="image-20250404-133019.png"!
Scheduled task 6pm El Salvador (medianoche UTC) - some invoices haven’t changed status.
*Steps:*
# Abilio needs to run the scheduled task manually in local to see what happens and replicate the error. MIGHT NOT BE ABLE AS WE HAVE JUST GONE THROUGH INVOICING AND MIGHT NOT BE ANY OVERDUE ONES.
# Create an invoice with due date tomorrow and send via UI → that generates an email → then change the due date to TODAY in the database → then run the scheduled task and the invoice status should have changed to overdue → then go to the email that was generated when you clicked sent and click on the link of the email to be able to see the invoice. This one should not change the status to ‘view’, after you open it via link, should always be ‘overdue’. (because the workflow doesn’t go ever from ‘overdue to view’, if it does, then there is an error).
# If the status changes from overdue to view → Abilio would need to go to “invoicestatusrules.cfc” and verify that the rules for overdue are executing correctly. Below:
!image-20250404-133635.png|width=931,height=470,alt="image-20250404-133635.png"!
!image-20250404-133720.png|width=1152,height=611,alt="image-20250404-133720.png"!
# Check the code to be executing the workflow rules correctly and if not, fix it to match the workflow design.
Description
|*BUG REPORTED DETAILS:*
There is an issue where the invoice does not transition to “Overdue” status as expected. E.g. there are multiple invoices that expired March 25 and still status is viewed or sent. Action: Please investigate and resolve the issue.|
!image-20250404-133019.png|width=395,height=387,alt="image-20250404-133019.png"!
Scheduled task 6pm El Salvador (medianoche UTC) - some invoices haven’t changed status.
*Steps:*
# Abilio needs to run the scheduled task manually in local to see what happens and replicate the error.
# Create an invoice with due date tomorrow and send via UI → that generates an email → then change the due date to TODAY → then run the scheduled task and the invoice status should have changed to overdue → then go to the email that was generated when you clicked sent and click on the link of the email to be able to see the invoice. This one should not change the status to ‘view’, but be always ‘overdue’. (because the workflow doesn’t go ever from overdue to view, if it does, then there is an error).
# If the status changes to view → Abilio would need to go to “invoicestatusrules.cfc” and verify that the rules for overdue are executing correctly. Below:
!image-20250404-133635.png|width=931,height=470,alt="image-20250404-133635.png"!
!image-20250404-133720.png|width=1152,height=611,alt="image-20250404-133720.png"!
Lourdes Munoz
updated the description14 hours ago|There is an issue where the invoice does not transition to “Overdue” status as expected. E.g. there are multiple invoices that expired March 25 and still status is viewed or sent. Action: Please investigate and resolve the issue.|
Scheduled task 6pm El Salvador (medianoche UTC) - some invoices haven’t changed status. Requested example of invoices to Jorge and Luis.
Steps:
# Abilio needs to run the scheduled task manually in local to see what happens and replicate the error.
Lourdes Munoz
made 3 changes3 days ago
Remaining Estimate
0h
6h
Original estimate
0h
6h
Parent
None
TMX-1044
Lourdes Munoz
created the Issue3 days agoPinned fields
Click on the next to a field label to start pinning.
Details
Assignee
Abilio PosadaAbilio PosadaReporter
Lourdes MunozLourdes MunozOriginal estimate
Time tracking
No time logged6h remainingParent
Components
Sprint
Priority
Major
Details
Details
Assignee
Abilio Posada
Abilio PosadaReporter
Lourdes Munoz
Lourdes MunozOriginal estimate
Time tracking
No time logged6h remaining
Parent
Components
Sprint
Priority
Sentry
Linked Issues
Sentry
Linked Issues
Sentry
Linked Issues
Created 3 days ago
Updated 13 hours ago
BUG REPORTED DETAILS:
There is an issue where the invoice does not transition to “Overdue” status as expected. E.g. there are multiple invoices that expired March 25 and still status is viewed or sent. Action: Please investigate and resolve the issue.
Scheduled task 6pm El Salvador (medianoche UTC) - some invoices haven’t changed status.
Steps:
Abilio needs to run the scheduled task manually in local to see what happens and replicate the error. MIGHT NOT BE ABLE AS WE HAVE JUST GONE THROUGH INVOICING AND MIGHT NOT BE ANY OVERDUE ONES.
Create an invoice with due date tomorrow and send via UI → that generates an email → then change the due date to TODAY in the database → then run the scheduled task and the invoice status should have changed to overdue → then go to the email that was generated when you clicked sent and click on the link of the email to be able to see the invoice. This one should not change the status to ‘view’, after you open it via link, should always be ‘overdue’. (because the workflow doesn’t go ever from ‘overdue to view’, if it does, then there is an error).
If the status changes from overdue to view → Abilio would need to go to “invoicestatusrules.cfc” and verify that the rules for overdue are executing correctly. Below:
Check the code to be executing the workflow rules correctly and if not, fix it to match the workflow design.