I've been asked to show the Current YTD and Previo...
# suiteanalytics
m
I've been asked to show the Current YTD and Previous YTD sales on a customer record in the primary information area. I've created two saved searches that accomplish this. On the customer record, I've created two custom fields that in the Validation & Defaulting section call the respective saved search for each field dynamically based on the customer internal id. Unfortunately this adds 2 to 3 seconds to the page load for the customer record. What maybe another way to do this to reduce the performance hit? Criteria: Type is any of Invoice, Credit Memo, Cash Sale Main Line is false Date Created is within this fiscal year Tax Line is false Shipping Line is false Item : Type is Assembly Results: Amount Sum Filter Customer Internal ID