CRM Dashboard "My Customer Invoices Overdue" displays incorrect data

Problem

The list of transactions should be the debtor transactions which are not fully paid and the Due Date is older than the current operating date.  Currently it displays transactions where the period number of the DB_Trans.TranDate is > 0.

Solution

The two stored procedures to be modify are:

• usp_JIWA_Dashboard_Indicator_CRM_MyDebtorInvoicesOverdue

• usp_JIWA_NavigationList_MyDebtorInvoicesOverdue

The issue has been logged for correction in 7.01.01.00.  This script corrects these stored procedures for 7.00.175 and 7.01.00 databases.  Download and apply to the database.

Open

Related articles