CRM Dashboard "My Customer Invoices Overdue" displays incorrect data

Owned by Beth Blok (Unlicensed)
Jan 16, 2018
1 min read

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

SQL skills are required

A sound knowledge of SQL Management Studio is required to complete this task.



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.