CRM Dashboard My Customers sales for Sales This Month are incorrect - 7.01.00, 7.02.00 and 7.02.01

Owned by Beth Blok (Unlicensed)
Last updated: Feb 26, 2020
1 min read

Problem

The figure displayed in Sales This Month are for the first month of the year not the current logged in month.  In the screen shot, the Sales This Month are in respect of July 19 not February 2020.

Correct results after applying the updated stored procedure

Solution

SQL skills required

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

Corrected stored procedure is attached.  Download and run the SQL script to correct the results returned.