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

Scheduled task 6pm El Salvador (medianoche UTC) - some invoices haven’t changed status.

Steps:

  1. 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.

  2. 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).

  3. 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
image-20250404-133720.png
  1. Check the code to be executing the workflow rules correctly and if not, fix it to match the workflow design.

Environment

None

QA Notes

None

Attachments

3

Activity

Show:
Lourdes Munoz
made 3 changes
13 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 changes
3 days ago
Remaining Estimate
0h
6h
Original estimate
0h
6h
Parent
None
TMX-1044
Lourdes Munoz
created the Issue3 days ago
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Original estimate

Time tracking

No time logged6h remaining

Components

Sprint

Priority

Sentry

Created 3 days ago
Updated 13 hours ago

Flag notifications