Solved

Where to find "YTD Sales vs Quota" and input Quota? Key Customer Growth?

  • 16 August 2021
  • 4 replies
  • 197 views

Userlevel 4
Badge

In the Sales Manager Dashboard there is a “YTD Sales vs Quota” box.  Where do we input "Quotas"?  And the YTD sales is blank.  Can someone direct me where to input the Quotas and how to get the YTD sales to show up?  

 

Also, the Key Customer Growth box is also blank.  Where do we input data or make selections so we can use this display?

 

Thank you for your help. 

 

 

icon

Best answer by TimRodman 16 August 2021, 15:46

View original

4 replies

Userlevel 5
Badge +2

Hi @dougmcbride79,

Here’s what the YTD SALES VS QUOTA Widget looks like on the Sales Manager (DB000011) Dashboard in my SalesDemo environment (1st screenshot):

 

If I click on YTD SALES VS QUOTA in the screenshot above, it drills down to the underlying Generic Inquiry (2nd screenshot). If I edit that Generic Inquiry, I can see how the fields are being calculated on the RESULTS GRID tab of the Generic Inquiry (SM208000) screen (3rd screenshot):

 

As you can see from the math in the 3rd screenshot, the 6,000,000 in Annual Quota calculates as 4,000,000 in YTD Quota because I’m running this in August 2021 and, following the math in the 3rd screenshot, 6,000,000 * 8 / 12 = 4,000,000.

 

Where does the 6,000,000 come from? [CSAnswers.Value]. Where does [CSAnswers.Value] come from? It comes from an Attribute on the Employees (EP203000) screen. On that screen, there are two things to point out. First, the Employee gets linked to the Salesperson using the Salesperson field on the GENERAL INFO tab (4th screenshot). Second, the Sales Goal - Yearly Attribute on the ATTRIBUTES tab is where the 6,000,000 value is stored (5th screenshot):

 

Where does the YTD Sales value in the 1st screenshot come from? The underlying Generic Inquiry is getting the data from the DOCUMENT DETAILS tab on the Invoices and Memos (AR301000) screen where it’s totaling the Amount field for all Invoice Lines where the Salesperson ID field matches:

 

Userlevel 4
Badge

Tim: Thank you.  In my case the dashboard widget is present, but the underlying fields are not present.  Could it be that the underlying logic / fields were never built or installed in my instance? Please see below.  

 

 

Userlevel 5
Badge +2

Correct. Many people consider the Dashboards to be “out-of-the-box Dashboards”, but, in my opinion, they are “Demo Dashboards” which rely on the demo data such as an attribute in this case.

Userlevel 4
Badge

Thank you

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved