There doesn’t seem to be an out-of-the-box report that meets your specific requirements. Custom development will be necessary to achieve this.
You can create a custom report using Power BI or SQL Server Reporting Services (SSRS). This allows you to pull data from the relevant tables (e.g., CustTrans and CustSettlement) and include calculated fields for the number of days late.
If this helped, please mark it as "Verified" for others facing the same issue.
Keep in mind that it is possible to mark more than one answer as verified.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.