Is there a way to filter when running a report for all customers that end with certain letters? Ex all customers ending in CA?

reports, filters

Rookie Asked on July 28, 2020 in How To's.
Add Comment
5 Answer(s)

Would a Saved Search be acceptable for what you’re looking to get from the results?

Intermediate Answered on July 28, 2020.
Add Comment

Customers are always being added and would always have the same ending but not the same beginning EX:  SDCA or CCCA.  Need to be able to run report to filter on ??CA.

Not sure if this answers your question.  Thanks

Rookie Answered on July 28, 2020.
Add Comment

Hi,

Apologies – I am asking do you need a Report or would a Saved Search be acceptable?

Thanks,

Chris

Intermediate Answered on July 29, 2020.
Add Comment

Yes wanted to run a report to show all sales to customers ending in XXCA.

Thanks

Rookie Answered on July 29, 2020.
Add Comment

I had another look at this and the only way to achieve this really is with a stored custom field on the Customer to determine whether it’s one of the ones you want to include. Once you have that, you can add the Report filter.

If you could possibly do it with Saved Searches or SuiteAnalytics then it is much easier to do it completely within the criteria.

Intermediate Answered on July 29, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor