Thursday, July 11, 2019

Use Custom Field to Create Sales vs Expected Customer Sales Report

To create a custom field on Customer records to show the target sales per Customer:


1. Navigate to Setup > Customization > Entity Fields > New
2. Provide the Label
3. Set the Type to Currency & Store Value = enable.
4. On Applies To > select the Customer
5. On Display tab > select Subtab to Main
6. Click Save & Apply to Forms

This field can now be populated with the target amount of sales coming from this Customer.

This information now can be sourced into reports. If you run a report like Sales by Customer (Navigate to Reports > Sales > Sales by Customer) pull the custom field under Customer/Project folder.  By doing this you can compare the Actual Sales vs. the Target Sales per Customer.



No comments:

Post a Comment